Area Fell Race Grand Prix 2010 - Junior Ladies
1
Page: 1 of 1 Records: 3
Forename
Surname
Club
Age Group
Place
Score
No. Races
Award
MySQL error 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PMEtable0.agscore DESC,PMEtable0.surname,PMEtable0.forename LIMIT 0,20' at line 2
phpMyEdit error: invalid SQL query
SELECT PMEtable0.id AS qf0,PMEtable0.forename AS qf1,PMEtable0.surname AS qf2,PMEtable0.clubid AS qf3,PMEtable0.clubid AS qf3_idx,PMEtable0.agegrp AS qf4,CONCAT("<!-- ",agposition,"--><span style=\"padding: 2px 6px 2px 6px; background-color:", IF(agposition = 1,"#FFD700",IF(agposition = 2,"#C0C0C0",IF(agposition = 3,"#CD853F","white"))), "\">", agposition, "</span>") AS qf5,PMEtable0.agscore AS qf6,PMEtable0.racesentered AS qf7,PMEtable0.award AS qf9 FROM GP10 AS PMEtable0 WHERE (agegrp = "LJUN" and racesentered > 0) ORDER BY PMEtable0.,PMEtable0.agscore DESC,PMEtable0.surname,PMEtable0.forename LIMIT 0,20