select top #_maxItems# sku, skuDesc, skuid, mfr_name, packSizeDesc from tbl_prd_skus sku inner join tblmanufacturers mfr on mfr.mfr_id = sku.mfrid where sku.ownerid = and sku.fsl_tablecode = and ( ( sku.sku like or sku.skudesc like or mfr.mfr_name like ) and 1 = 1 ) and (sku.sku like or sku.skuDesc like ) and sku.crmActive = 'Y' and sku.inactive = 0 order by mfr_name, sku #_data#