Fatal error: MYSQL ERR #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY prod_id
ORDER BY prod_sell_price ASC' at line 5SELECT prod_id, prod_name_lg1, prod_seo_url_lg1, prod_image, prod_add_time, prod_full_price, prod_sell_price, prod_stock
FROM site_products
LEFT JOIN site_products_materials ON pm_id_prod=prod_id
WHERE prod_status=1 AND prod_deleted=0 AND prod_image IS NOT NULL AND prod_id_cat=
GROUP BY prod_id
ORDER BY prod_sell_price ASC
in /home/carmen84/public_html/engine/include/classes/class.mysql.php on line 252