s=Select i.itemID, i.item_name, img.imageID, i.page_order From product_items i
Left Join product_images img on img.itemID=i.itemID
Where i.clientID=41
And img.blnMain=1 and i.blnActive=1
And i.catID in (Select catID from product_cat where cat_name like 'Enzoani ') Order by page_order
