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 5
SELECT 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