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 parentID=9) or i.catID=9) Order by page_order
