54 q=select count(distinct ItemNo) as NumberItems, L3_NotUsed from inventory where Category = 'Additives*' AND L2_SubCategory LIKE 'Water Clarifying%' and CB2_AL NOT LIKE '' and M0_WholesalePrice >0 and L3_NotUsed not like '' group by L3_NotUsed order by L3_NotUsed, nr=1, filter=CB2_AL NOT LIKE '' and M0_WholesalePrice >0, qk=, Q==0 54 q=select count(distinct ItemNo) as NumberItems, CB6_NewItem from inventory where Category = 'Additives*' AND L2_SubCategory LIKE 'Water Clarifying%' and CB2_AL NOT LIKE '' and M0_WholesalePrice >0 and CB6_NewItem not like '' group by CB6_NewItem order by CB6_NewItem, nr=0, filter=CB2_AL NOT LIKE '' and M0_WholesalePrice >0, qk=, Q==0 54 q=select count(distinct ItemNo) as NumberItems, CB5_OnSale from inventory where Category = 'Additives*' AND L2_SubCategory LIKE 'Water Clarifying%' and CB2_AL NOT LIKE '' and M0_WholesalePrice >0 and CB5_OnSale not like '' group by CB5_OnSale order by CB5_OnSale, nr=0, filter=CB2_AL NOT LIKE '' and M0_WholesalePrice >0, qk=, Q==0 54 q=select count(distinct ItemNo) as NumberItems, CB8_ClearanceItem from inventory where Category = 'Additives*' AND L2_SubCategory LIKE 'Water Clarifying%' and CB2_AL NOT LIKE '' and M0_WholesalePrice >0 and CB8_ClearanceItem not like '' group by CB8_ClearanceItem order by CB8_ClearanceItem, nr=0, filter=CB2_AL NOT LIKE '' and M0_WholesalePrice >0, qk=, Q==0
