Execute Error: Unknown column 'rank_2017' in 'order clause' in SELECT ps.*,c.city_name,c.citycode FROM ewportal__preschoolsurvey_2016 ps LEFT JOIN ewportal__city c ON (ps.id_city=c.id_city) WHERE 1 ORDER BY c.city_name ASC,id_school_type ASC,rank_2017 ASC
First Error: Unknown column 'rank_2017' in 'order clause'