Лидеры продаж
MySQL server has gone away
SELECT t1.*, t3.thumbnail FROM SC_products t1 LEFT JOIN SC_product_list_item t2 ON t1.productID=t2.productID LEFT JOIN SC_product_pictures t3 ON t1.default_picture=t3.photoID WHERE t2.list_id='new' ORDER BY t2.priority ASC
SELECT t1.*, t3.thumbnail FROM SC_products t1 LEFT JOIN SC_product_list_item t2 ON t1.productID=t2.productID LEFT JOIN SC_product_pictures t3 ON t1.default_picture=t3.photoID WHERE t2.list_id='new' ORDER BY t2.priority ASC