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