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 115103103103103103103103 836 542
3 GIMÉNEZ FERRERES, CLÀUDIA 10311508509393115 604 519
4 JULVE CORNELLES, RAQUEL 0007593757985 407 407
5 AGUILÀ CUBELLS, ANNA 7979790856700 389 389
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 RODRIGUEZ SALVADO, ANNA 000000093 93 93
13 SANCHEZ, JEANNE 093000000 93 93
14 MAURI GINOVART, NEUS 000008500 85 85
15 MASIA ADELL, ALBA 000000850 85 85
16 SAMARRA CAMPOY, SANDRA 008500000 85 85
17 FORCADELL MONTSERRAT, JESSICA 850000000 85 85
18 CRUZ TOMÀS, HERENIA 000007900 79 79
19 VILLAR SALDAÑA, OLGA 000790000 79 79
20 MONTOYA CUGAT, MINERVA 000000079 79 79
21 VIUDEZ SORIA, NEREA 000000750 75 75
22 COTAINA GILABERT, ELISABET 075000000 75 75
23 CARTOIXÀ BENAIGES, CINTA 750000000 75 75
24 ANTO ROMEU, ELI 007300000 73 73
25 PÉREZ MÁRQUEZ, JÉSSICA 073000000 73 73
26 GONZÀLEZ GARRIGA, ARIADNA 730000000 73 73
27 LÓPEZ MATA, MONTSERRAT 000007100 71 71
28 HARBUZ, ANCUTA 000710000 71 71
29 CARLES BERTOMEU, RAQUEL 000000710 71 71
30 BLANCH RUBERT, NOELIA 000007000 70 70
31 CASANOVA FUMADÓ, LAURA 000690000 69 69
32 GAMBIN CARRANDE, ELISABET 000006900 69 69
33 CURTO QUERAL, NEUS 000000690 69 69
34 MARTÍNEZ METZMEIER, CLOE 000680000 68 68
35 MONCADA SANZ, SONIA 000006800 68 68
36 GASHI, MIRJETA 000670000 67 67
37 ARCE RECATALA, CRISTINA 000006600 66 66
38 CURTO QUERALT, NEUS 000650000 65 65
39 TRIGO ALEIXENDRI, ANA 000006500 65 65




Amb el suport de: