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