Unknown column 'MPRICE.mprice' in 'order clause'
SELECT a_burning.name_en as name, a_burning.longname_en as descr, a_burning.sku, a_burning.price AS mprice, GROUP_CONCAT(a_pics_products.filename) AS images FROM a_burning LEFT JOIN a_pics_products ON (a_pics_products.itemid = a_burning.id AND a_pics_products.ismain = 1 AND a_pics_products.section = 5) WHERE a_burning.isvisible = 1 AND a_burning.tourdate >= DATE(NOW()) GROUP BY a_burning.sku ORDER BY MPRICE.mprice DESC