select id,style,description,price,in_stock,image1,image2,IF(image3 != '','Y','X') as 'Img1' from products where status=1 and FIND_IN_SET('1',Webcats) and image_exist = 'Yes' and category in ('119','121','113') AND ( style LIKE 'RKS%' OR style LIKE 'RKSB%' OR style LIKE 'SRS%' OR style LIKE 'SRSB%' OR style LIKE 'SEMIR%' ) group by style order by Img1 desc,in_stock desc limit 0,50

Filter by:

Sort: