CLASSIFICACIÓ 5K: SÈNIOR 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="SEN F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 SUBIRATS ABELLA, ANNA 115103103103103000 527 527
2 BRULL ALBIOL, GINA 00115115115000 345 345
3 AGUILÀ CUBELLS, ANNA 797979085000 322 322
4 GIMÉNEZ FERRERES, CLÀUDIA 1031150850000 303 303
5 VALMAÑA CALBET, CINTA 08575700000 230 230
6 JULVE CORNELLES, RAQUEL 0007593000 168 168
7 ROSA PINEDA, NAGORE 000930000 93 93
8 CASTELBLANQUE SOLER, AIDA 930000000 93 93
9 HOMEDES NADAL , ESMERALDA 009300000 93 93
10 SANCHEZ, JEANNE 093000000 93 93
11 SAMARRA CAMPOY, SANDRA 008500000 85 85
12 FORCADELL MONTSERRAT, JESSICA 850000000 85 85
13 VILLAR SALDAÑA, OLGA 000790000 79 79
14 COTAINA GILABERT, ELISABET 075000000 75 75
15 CARTOIXÀ BENAIGES, CINTA 750000000 75 75
16 BUERA, ANDREA 000730000 73 73
17 PÉREZ MÁRQUEZ, JÉSSICA 073000000 73 73
18 ANTO ROMEU, ELI 007300000 73 73
19 GONZÀLEZ GARRIGA, ARIADNA 730000000 73 73
20 HARBUZ, ANCUTA 000710000 71 71
21 CASANOVA FUMADÓ, LAURA 000690000 69 69
22 MARTÍNEZ METZMEIER, CLOE 000680000 68 68
23 GASHI, MIRJETA 000670000 67 67
24 POUS CID, SANDRA 000660000 66 66
25 CURTO QUERALT, NEUS 000650000 65 65




Amb el suport de: