Unknown column 'MPRICE.mprice' in 'order clause'
SELECT a_tours.name_en as name, a_tours.longname_en as descr, a_tours.sku, a_tours.price AS mprice, GROUP_CONCAT(a_pics_products.filename) AS images FROM a_tours LEFT JOIN a_pics_products ON (a_pics_products.itemid = a_tours.id AND a_pics_products.ismain = 1 AND a_pics_products.section = 6) WHERE a_tours.isvisible = 1 GROUP BY a_tours.sku ORDER BY MPRICE.mprice DESC LIMIT 0,10