select * from products where (name like '%lawn suits%' or sku like '%lawn suits%' or topMaterial like '%lawn suits%' or category like '%lawn suits%' or sizes like '%lawn suits%' or style like '%lawn suits%' or brand like '%lawn suits%') and showOnWeb=1 and live=1 and approved=1 and images>0 and (stock>0 or availableOnDemand=1) order by id desc

No item under this crieteria.