-

select i.* , ii.image_name FROM items AS i JOIN items_to_categories AS i2c ON ( i2c.items_id = i.id ) LEFT JOIN items_images AS ii ON ( ii.items_id = i.id AND primary_img = '1' ) WHERE i2c.categories_id = 4 AND i.status_product_page = '1' GROUP BY i.id order by i.sort_order ASC

[TEP STOP]