CLASSIFICACIÓ 10K: VETERÀ-1 FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntscat FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntscat FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic WHERE categoria="VE1 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 BONET MONTAGUT, MARIA JOSÉ 93103757900 350 350
2 GIMÉNEZ FERRERES, CLÀUDIA 0010311500 218 218
3 MESEGUER CARBÓ, LINA 1031150000 218 218
4 BUTLER, JOANNA 115093000 208 208
5 CALLARISA BEL, CELIA 00115000 115 115
6 ESTORACH ARASA, MIRIAM 00010300 103 103
7 ROMANI GUART, MONTSE 0009300 93 93
8 PRINCEP COLOMÉ, ALEXANDRA 0085000 85 85
9 RUIZ MARTINEZ, VANESSA 0008500 85 85
10 TOMAS LORENZ, ROSA 0079000 79 79
11 PRATS SERRAT, ESTELA 0007500 75 75
12 ALCANAR QUERALT, LORENA 0073000 73 73
13 BLASQUIZ LOPEZ, CRISTINA 0071000 71 71




Amb el suport de:

comunicar incidències sobre les classificacions.
Recorda que per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.