FRA Junior Uphill Championship - 2017

Sponsored by Pete Bland Sports and Walsh Shoes
Pete Bland Sports Walsh

MySQL error 1054

Unknown column 'PMEtable0.' in 'order clause'

phpMyEdit error: invalid SQL query


SELECT CONCAT("<!-- ",points5,"--><span style=\"padding: 2px 6px 2px 6px; background-color:", IF(points5 = 50,"#FFD700",IF(points5 = 48,"#C0C0C0",IF(points5 = 47,"#CD853F","white"))), "\">", IF(points5 = 50,"1",IF(points5 = 48,"2",IF(points5 = 47,"3","0"))), "</span>") AS `qf0`,`PMEtable0`.`agegrp` AS `qf1`,CONCAT(forename," ",surname) AS `qf2`,`PMEjoin3`.`club` AS `qf3`,`PMEtable0`.`clubid5` AS `qf3_idx` FROM `FRAJunior17` AS `PMEtable0` LEFT OUTER JOIN `FRAJuniorClub17` AS `PMEjoin3` ON (`PMEjoin3`.`id` = `PMEtable0`.`clubid5`) WHERE (points5 >= 47) ORDER BY `PMEtable0`.``,CONCAT(forename," ",surname),`PMEtable0`.`agegrp` DESC,CONCAT("<!-- ",points5,"--><span style=\"padding: 2px 6px 2px 6px; background-color:", IF(points5 = 50,"#FFD700",IF(points5 = 48,"#C0C0C0",IF(points5 = 47,"#CD853F","white"))), "\">", IF(points5 = 50,"1",IF(points5 = 48,"2",IF(points5 = 47,"3","0"))), "</span>") DESC
Position Age Group Name Club