select *,pd.url as imageurl , ph.id as pid , pd.url as image_url, ph.url as amazon_url from tblproduct ph join tblproductpictures pd on ph.id=pd.prodid where ph.status!='N' AND ph.cat_id=31 group by ph.id order by ph.display_order asc, ph.id desc limit 0, 8select *,pd.url as imageurl , ph.id as pid , pd.url as image_url, ph.url as amazon_url from tblproduct ph join tblproductpictures pd on ph.id=pd.prodid where ph.status!='N' AND ph.cat_id=32 group by ph.id order by ph.display_order asc, ph.id desc limit 0, 8