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 1031151151151151151150 793 575
2 GALVE CURTO, LUCI 11510310310310301030 630 527
3 GONZÁLEZ TEJERO, ANA 938593085000 356 356
4 HERNANDEZ HERRERO, MARTA 09300930930 279 279
5 SALES SOLER, PILAR 7979000000 158 158
6 NOGALES FORTUM, TERE 0007370000 143 143
7 BONFILL VIÑA, JOSEFA 0000010300 103 103
8 BAGES BANEGAS, SANDRA 000930000 93 93
9 MASIP SABATÉ, MAITE 000009300 93 93
10 FERRET MIRALLES, NURIA 000850000 85 85
11 CAMPOY BENAIGES, SOL 008500000 85 85
12 AGRAMUNT FABRA, SANDRA 000000850 85 85
13 CUGAT ADELL, MAR 850000000 85 85
14 RECIO PRIETO, EMILIA RECIO PRIETO 000008500 85 85
15 AGUEYO BENITO, MILA 000079000 79 79
16 RAMIREZ TORTOSA, NURI 000790000 79 79
17 SEGURA ESTUPIÑÁ , ESTER 000075000 75 75
18 ARASA CID, EUGÈNIA 000750000 75 75
19 SCIORA, CORINNE 075000000 75 75
20 VILANOVA RODRIGUEZ, SONIA 750000000 75 75
21 FUSTER MONTERDE, ELVIRA 000073000 73 73
22 GARCIA AMELA, BELEN 000071000 71 71




Amb el suport de: