FRA Junior Championship 2009 - U12 Girls Points
1
2
Page: 1 of 2 Records: 37
Forename
Surname
Club
Age Group
Place
4 from 6
Stair
Mytholmroyd
Shutlingsloe
Ambleside
Darwen
Carlton Bank
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.foursix 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.club AS qf3,PMEtable0.agegrp AS qf4,PMEtable0.agegrp AS qf4_idx,CONCAT("<!-- ",position,"--><span style=\"padding: 2px 6px 2px 6px; background-color:", IF(position = 1,"#FFD700",IF(position = 2,"#C0C0C0",IF(position = 3,"#CD853F","white"))), "\">", position, "</span>") AS qf5,PMEtable0.foursix AS qf6,PMEtable0.points1 AS qf8,PMEtable0.points2 AS qf10,PMEtable0.points3 AS qf12,PMEtable0.points4 AS qf14,PMEtable0.points5 AS qf16,PMEtable0.points6 AS qf18 FROM FRAJuniorPoints09 AS PMEtable0 WHERE (agegrp = "U12G" and racesentered > 0) ORDER BY PMEtable0.,PMEtable0.foursix DESC,PMEtable0.surname,PMEtable0.forename LIMIT 0,20