1054 - Unknown column 'GH' in 'order clause'

SELECT DISTINCT p.performance_id Array FROM aP_performance p LEFT JOIN aP_performance_registration_path prp ON prp.performance_id=p.performance_id LEFT JOIN aP_performance_deleted pdel ON p.performance_id=pdel.performance_id LEFT JOIN aP_performance_preregistration pp ON (pp.performance_id=prp.performance_id AND pp.reg_path_id=prp.reg_path_id) LEFT JOIN aP_performance_description pd ON pd.performance_id=p.performance_id LEFT JOIN aP_performance_sets s ON s.performance_id=p.performance_id LEFT JOIN aP_performance_view_counter vc ON vc.performance_id=p.performance_id LEFT JOIN aP_registrations_counter_global rcg ON rcg.performance_id=p.performance_id LEFT JOIN aP_registrations_counter rc ON (rc.performance_id=p.performance_id AND rc.reg_path_id=prp.reg_path_id) LEFT JOIN ( SELECT ppr.performance_id, ppr.price_value, ppr.price_valid_date FROM aP_performance_price_ranges ppr LEFT JOIN aP_performance_deleted pdel ON ppr.performance_id=pdel.performance_id WHERE (pdel.performance_deleted='0' or pdel.performance_id IS NULL) AND ppr.price_valid_date > now( ) GROUP BY ppr.performance_id ) AS op ON p.performance_id = op.performance_id LEFT JOIN aP_zones z ON z.zone_id=pd.state_id LEFT JOIN aP_dioceses d ON d.diocese_id=pd.diocese_id WHERE (pdel.performance_deleted='0' or pdel.performance_id IS NULL) AND p.reg_path_counter > 0 AND prp.reg_path_deleted = 0 AND p.performance_status=1 AND p.performance_lock_registration < 4 AND p.performance_date_see <= '2017-11-19 13:16:36' AND p.performance_date_from >= '2017-11-19 13:16:36' AND p.performance_date_upto >='2017-11-19 13:16:36' AND IF(p.performance_registration_mode = '0', 1 , p.performance_date_from > '2017-11-19 13:16:36') AND p.performance_date_from >='2016-11-19 00:00:00' AND p.performance_date_from <='2019-05-21 00:00:00'AND CONCAT(p.weight,DATE_FORMAT(p.performance_date_from, '%Y-%m-%d')) ORDER BY GH ASC, prp.reg_path_id ASC

[APPLICATON STOP]