SELECT products_id, products_name, products_subname, products_fabric, products_url, products_url_title, products_image, products_price, products_flip_image, products_tax_class_id, specials_new_products_price, final_price FROM ( SELECT p.products_id, pd.products_name, pd.products_subname, pd.products_fabric, pd.products_url, pd.products_url_title, p.products_image, p.products_price, o.order_num, p.products_flip_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS final_price FROM aw08_products_description pd, aw08_products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_order o ON o.products_id = p.products_id AND o.cpath = '613', aw08_products_to_categories p2c WHERE p.products_status = '1' AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = '1' AND p2c.categories_id = '613' ) t GROUP BY pd.products_name ORDER BY order_num ASC, products_name ASC, products_subname ASC
[TEP STOP]