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 BRULL ALBIOL, GINA 001151151151151150 575 575
2 SUBIRATS ABELLA, ANNA 1151031031031031031030 733 527
3 GIMÉNEZ FERRERES, CLÀUDIA 103115085093930 489 489
4 AGUILÀ CUBELLS, ANNA 7979790856700 389 389
5 JULVE CORNELLES, RAQUEL 000759375790 322 322
6 VALMAÑA CALBET, CINTA 08575700000 230 230
7 BUERA ALBALAT, ANDREA 00073073730 219 219
8 POUS CID, SANDRA 0006600700 136 136
9 ROSA PINEDA, NAGORE 000930000 93 93
10 CASTELBLANQUE SOLER, AIDA 930000000 93 93
11 HOMEDES NADAL , ESMERALDA 009300000 93 93
12 SANCHEZ, JEANNE 093000000 93 93
13 MAURI GINOVART, NEUS 000008500 85 85
14 MASIA ADELL, ALBA 000000850 85 85
15 SAMARRA CAMPOY, SANDRA 008500000 85 85
16 FORCADELL MONTSERRAT, JESSICA 850000000 85 85
17 CRUZ TOMÀS, HERENIA 000007900 79 79
18 VILLAR SALDAÑA, OLGA 000790000 79 79
19 VIUDEZ SORIA, NEREA 000000750 75 75
20 COTAINA GILABERT, ELISABET 075000000 75 75
21 CARTOIXÀ BENAIGES, CINTA 750000000 75 75
22 ANTO ROMEU, ELI 007300000 73 73
23 PÉREZ MÁRQUEZ, JÉSSICA 073000000 73 73
24 GONZÀLEZ GARRIGA, ARIADNA 730000000 73 73
25 LÓPEZ MATA, MONTSERRAT 000007100 71 71
26 HARBUZ, ANCUTA 000710000 71 71
27 CARLES BERTOMEU, RAQUEL 000000710 71 71
28 BLANCH RUBERT, NOELIA 000007000 70 70
29 CASANOVA FUMADÓ, LAURA 000690000 69 69
30 GAMBIN CARRANDE, ELISABET 000006900 69 69
31 CURTO QUERAL, NEUS 000000690 69 69
32 MARTÍNEZ METZMEIER, CLOE 000680000 68 68
33 MONCADA SANZ, SONIA 000006800 68 68
34 GASHI, MIRJETA 000670000 67 67
35 ARCE RECATALA, CRISTINA 000006600 66 66
36 CURTO QUERALT, NEUS 000650000 65 65
37 TRIGO ALEIXENDRI, ANA 000006500 65 65




Amb el suport de: