CLASSIFICACIÓ 10K: ABSOLUT FEMENÍ

SELECT historic.nom AS sujeto, historic.dni AS doc, historic.sexe AS sex1, historic.categoria AS cate, corredors.email AS correu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=141 AND dni=doc ),0) AS dotze, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=142 AND dni=doc ),0) AS tretze, SUM(historic.puntsgen) AS punts, SUM(historic.empat) AS desempat FROM historic JOIN corredors ON historic.dni = corredors.dni WHERE historic.sexe="F" GROUP BY historic.dni ORDER BY punts DESC, desempat ASC;

* Per a la classificació final puntuen les 10 millors curses i s’haurà de participar a un mínim de 4 curses per a puntuar.

-F- = Finisher (ha fet totes les curses de la temporada).

Pos Nom Cat.  L'AmpollaMóra
la Nova
L'AldeaDeltebreEl Perelló
Cursa d'Or
La Sénia
Cursa d'Or
CamarlesJesúsTortosa
Cursa d'Or
Santa
Bàrbara
AmpostaGandesaSt Jaume
Enveja
Cursa d'Or
Total Punts*
1 PARÍS SANTOS, NÚRIA SEN F859311593000000000 386 386
2 BONET FRANCH, THAIS (A) VE2 F68799385000000000 325 325
3 BATALLA DOMINGUEZ, SITA MA1 F63717971000000000 284 284
4 SEGURA RIUS, ELENA MA1 F61677370000000000 271 271
5 PÉREZ CARCELLE , PAULA VE2 F59697069000000000 267 267
6 PEPIOL ARGENTÓ, LAURA VE2 F79010379000000000 261  
7 RUIZ FERNANDEZ, MERCHE MA2 F56636661000000000 246 246
8 SANCHEZ IGLESIAS, MARI VE1 F6270690000000000 201  
9 GILABERT PITARCH, MARIA JOSE VE2 F0596357000000000 179  
10 CID MIRÓ, MÒNICA VE1 F5062058000000000 170  
11 BUTNARU BUTNARU , CATIA VE1 F4706050000000000 157  
12 REBULL DE LA VEGA, ANNA S23 F708500000000000 155  
13 FABREGAT BERENGUÉ, ALBA (A) SEN F4154059000000000 154  
14 ACCENSI PELLISA, NEREA S23 F730075000000000 148  
15 GARGALLO AYZA, LAURA (A) VE1 F075073000000000 148  
16 PANISELLO RODRIGUEZ, SONIA VE2 F4305946000000000 148  
17 EGYED, PATRICIA SEN F3655540000000000 145  
18 BADEA, ANDREEA VE1 F660710000000000 137  
19 SEGARRA ALBALAT , LLEDÓ SEN F670068000000000 135  
20 ROMANI GUART, MONTSE VE2 F646800000000000 132  
21 VINAIXA REY, MONTSERRAT VE1 F065064000000000 129  
22 MONSERRAT MONTAGUT, SÍLVIA (A) VE2 F600670000000000 127  
23 BORRULL SEGUIN, ALEXANDRA SEN F580060000000000 118  
24 CASANOVA FUMADÓ, LAURA SEN F540063000000000 117  
25 SEGURA UNIÓ, MÒNICA VE2 F053640000000000 117  
26 GÓMEZ MARTINEZ, MARIA CARMEN MA1 F056610000000000 117  
27 VIDIELLA PIÑOL, SANDRA SEN F115000000000000 115  
28 MUNTÉ CARRASCO, MARTA SEN F000115000000000 115  
29 ABELLA GUZMAN, LAURA VE1 F011500000000000 115  
30 HERRERO VAZQUEZ, LAURA VE1 F005852000000000 110  
31 SALCEDO PERIS, SUSANA VE1 F456000000000000 105  
32 AVALOS, ERIKA VE2 F103000000000000 103  
33 GIMÉNEZ FERRERES, CLÀUDIA VE1 F000103000000000 103  
34 RODRÍGUEZ PUEYO, ANNA SEN F93000000000000 93  
35 BOU RAMBLA, TERESA MA1 F460044000000000 90  
36 CONTRERAS GÓMEZ, LAURA VE2 F00850000000000 85  
37 LANDACHE, CRIS VE2 F75000000000000 75  
38 MIRAVALLS VALLS, LAIA [A] S23 F00750000000000 75  
39 JOVÉ PONS, NÚRIA VE1 F07300000000000 73  
40 MESTRE MOMPEL, AIDA SEN F71000000000000 71  
41 COLI FERRAGUT, CRISTINA SEN F69000000000000 69  
42 ESPAÑA, MIREIA SEN F00680000000000 68  
43 ORTÍN QUERAL, ARIADNA S23 F00067000000000 67  
44 ALARCÓN LLAMOSÍ, SÍLVIA VE1 F00066000000000 66  
45 FERNÁNDEZ PONFERRADA , JENNIFER SEN F06600000000000 66  
46 SOLÉ MARTÍNEZ, DAISY SEN F65000000000000 65  
47 LUNA PEIRO, AMPARO SEN F00065000000000 65  
48 VERNET BOQUERA, M CRISTINA VE1 F00650000000000 65  
49 MASIP, MERITXELL VE1 F06400000000000 64  
50 BAIGES GIRALT, MARINA VE2 F00062000000000 62  
51 FORASTERO ROYO, SONIA SEN F00620000000000 62  
52 OLTRA GONZÁLEZ, NÚRIA VE1 F06100000000000 61  
53 CAMBRA VERNET, NÚRIA SEN F05800000000000 58  
54 VENTURA QUERAL, JOANNA SEN F57000000000000 57  
55 PUELL GRAU, AGNÈS SEN F05700000000000 57  
56 GARCIA AMELA, BELEN VE2 F00570000000000 57  
57 FORNER ROCA, ROSATE MA1 F00056000000000 56  
58 ROIG MESTRE , MARI CARMEN VE2 F00560000000000 56  
59 SOLÉ ARTIGAU, BEATRIZ VE2 F55000000000000 55  
60 BALU, IASMINA SEN F00055000000000 55  
61 SAURAS FERNANDEZ, MARIA SEN F00550000000000 55  
62 SÁNCHEZ BADIA, ANA SEN F00054000000000 54  
63 PUIG, NEREA SEN F53000000000000 53  
64 POPESCU, CRISTINA SEN F00053000000000 53  
65 GÚNERA , ZENAYDA VE1 F00530000000000 53  
66 MASIA FUMADO, MIRIAM VE1 F52000000000000 52  
67 ZARAGOZA MIGUEL, IMMACULADA SEN F00520000000000 52  
68 CUGAT GUERRERO, MARTA VE2 F51000000000000 51  
69 BUSU, ANA VE1 F00051000000000 51  
70 GARCIA ALTADILL, ANGELS VE2 F49000000000000 49  
71 SEGURA ESTUPIÑÁ , ESTER VE2 F00049000000000 49  
72 LÁZARO GOTOR, BLANCA SEN F48000000000000 48  
73 RUBIO MARTINEZ , BEATRIZ SEN F00048000000000 48  
74 PAPASEIT ROVIRA, FOIX SEN F00047000000000 47  
75 ESPARZA TORRES, ANA [A] SEN F00045000000000 45  
76 AYUSO MOLINA, LUCIA SEN F44000000000000 44  
77 VALLDEPEREZ, ARES SEN F00043000000000 43  
78 ROS DEPORTOS, MONTSERRAT MA1 F42000000000000 42  
79 PRATS DALMAU, AINA SEN F00042000000000 42  
80 ROSELL, MIREIA SEN F00041000000000 41  
81 BRU ALVAREZ, DOLORS VE1 F40000000000000 40  
82 ALTAVA COMÍ, CINTA S23 F00040000000000 40  
83 GARCIA ALTADILL, NURIA VE2 F39000000000000 39  
84 PITART MONLLAÓ, AINHOA PITART MONLLAÓ S23 F00039000000000 39  
85 QUERAL NAVARRO, CAMERON SEN F38000000000000 38  
86 GUARDIA GONZALEZ, MARIONA SEN F00038000000000 38  
87 SAMARRA CALERO, LAURA SEN F37000000000000 37  
88 TARTERA PAPASEIT , MERCE VE1 F35000000000000 35  
89 RODRÍGUEZ HERRERA, MARIA SEN F34000000000000 34  
90 MALVACHE, JULIETTE VE1 F33000000000000 33  
91 MUÑOZ RUBIO, ISABEL SEN F32000000000000 32  

* Per a la classificació final puntuen les 10 millors curses i s’haurà de participar a un mínim de 4 curses per a puntuar.

-F- = Finisher (ha fet totes les curses de la temporada).




Amb el suport de:


comunicar incidències sobre les classificacions.
Per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.