select id,style,description,price,in_stock,image1,image2,IF(image3 != '','Y','X') as 'Img1' from products where status=1 and image1!='' group by style order by Img1 desc,in_stock desc limit 0,50

Filter by:

Sort: