"SELECT TOP 200 A.idProduct, A.sku, A.description,A.price, A.listHidden, A.listPrice, A.serviceSpec, A.bToBPrice,A.smallImageUrl, A.noprices, A.stock, A.noStock, A.pcprod_HideBTOPrice,A.pcProd_BackOrder, A.FormQuantity, A.pcProd_BackOrder, A.pcProd_BTODefaultPrice,cast(A.sDesc as varchar(8000)) sDesc FROM products A  WHERE idProduct IN ( SELECT TOP 200 idProductFROM categories_products, categories WHERE idProduct = A.idProduct AND((A.serviceSpec<>0 AND A.pcProd_BTODefaultPrice>=0 And A.pcProd_BTODefaultPrice<=999999999)OR (A.serviceSpec=0 AND A.configOnly=0 AND A.price>=0 AndA.price<=999999999)) AND A.active=-1 AND A.removed=0 ANDcategories.idCategory=categories_products.idCategory AND categories.iBTOhide=0AND categories.pccats_RetailHide=0 AND idSupplier=10 AND (stock>0 ORnoStock<>0) AND ((((content1 LIKE 'blue bead') OR (content2 LIKE 'bluebead') OR (content3 LIKE 'blue bead')) OR ((content1 LIKE '%[^a-zA-z0-9]bluebead[^a-zA-z0-9]%') OR (content2 LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%') OR(content3 LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%')) OR ((content1 LIKE 'bluebead[^a-zA-z0-9]%') OR (content2 LIKE 'blue bead[^a-zA-z0-9]%') OR (content3LIKE 'blue bead[^a-zA-z0-9]%')) OR ((content1 LIKE '%[^a-zA-z0-9]blue bead') OR(content2 LIKE '%[^a-zA-z0-9]blue bead') OR (content3 LIKE '%[^a-zA-z0-9]bluebead'))) OR ((A.description LIKE 'blue bead' OR A.description LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR  A.description LIKE 'blue bead[^a-zA-z0-9]%'OR  A.description LIKE '%[^a-zA-z0-9]bluebead') OR (A.sDesc LIKE 'blue bead' OR A.sDesc LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR  A.sDesc LIKE 'blue bead[^a-zA-z0-9]%' OR  A.sDesc LIKE '%[^a-zA-z0-9]blue bead') OR(SKU LIKE 'blue bead' OR  SKU LIKE'%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR SKU LIKE 'blue bead[^a-zA-z0-9]%' OR SKU LIKE '%[^a-zA-z0-9]blue bead'))) ORDER BY A.sku ASC, A.idproductDESC"