select * from products where (name like '%bridal wear%' or sku like '%bridal wear%' or topMaterial like '%bridal wear%' or category like '%bridal wear%' or sizes like '%bridal wear%' or style like '%bridal wear%' or brand like '%bridal wear%') 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.