Area Fell Race Grand Prix 2010 - Junior Ladies

Page: 1 of 1  Records: 3

MySQL error 1054

Unknown column 'PMEtable0.clubid' in 'field list'

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`.`surname`,`PMEtable0`.`forename` LIMIT 0,20
Forename Surname Club Age Group Place Score No. Races Award