Unknown column 'MPRICE.mprice' in 'order clause'<hr>

		SELECT 
				a_burning.name_ru as name,
				a_burning.longname_ru 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