CLASSIFICACIÓ 5K: VETERÀ-2 FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="VE2 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 CÓRDOVA ANDINO , YESENIA 103115115115115000 563 563
2 GALVE CURTO, LUCI 115103103103103000 527 527
3 GONZÁLEZ TEJERO, ANA 938593085000 356 356
4 HERNANDEZ HERRERO, MARTA 0930093000 186 186
5 SALES SOLER, PILAR 7979000000 158 158
6 NOGALES FORTUM, TERE 0007370000 143 143
7 BAGES BANEGAS, SANDRA 000930000 93 93
8 FERRET MIRALLES, NURIA 000850000 85 85
9 CAMPOY BENAIGES, SOL 008500000 85 85
10 CUGAT ADELL, MAR 850000000 85 85
11 AGUEYO BENITO, MILA 000079000 79 79
12 RAMIREZ TORTOSA, NURI 000790000 79 79
13 SEGURA ESTUPIÑÁ , ESTER 000075000 75 75
14 ARASA CID, EUGÈNIA 000750000 75 75
15 SCIORA, CORINNE 075000000 75 75
16 VILANOVA RODRIGUEZ, SONIA 750000000 75 75
17 FUSTER MONTERDE, ELVIRA 000073000 73 73
18 GARCIA AMELA, BELEN 000071000 71 71




Amb el suport de: