CLASSIFICACIÓ 10K: ABSOLUT MASCULÍ

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="M" 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 SOWE, MUSA VE1 M9311510393000000000 404 404
2 QUERAL FORCADELL, XAVI VE2 M85939385000000000 356 356
3 SALES FERRE, LLORENÇ VE1 M1030115103000000000 321  
4 ALTES, JOSEP (A) VE1 M66736663000000000 268 268
5 GUIAMET ESCODA, ALBERT (A) SEN M59666155000000000 241 241
6 RODA SALES, DAVID VE1 M7185750000000000 231  
7 BO BERTOMEU, LORENZO VE2 M52625957000000000 230 230
8 TOAPANTA ARCOS, DAVID (A) VE1 M53635553000000000 224 224
9 FORNÉ CASTELLS, XAVIER [A] MA1 M0757075000000000 220  
10 HOSTALED, JORDI SEN M6807373000000000 214  
11 DELLA CALLEN, CARLOS VE2 M42605851000000000 211 211
12 VILLAMON IZQUIERDO, PAU S18 M0716969000000000 209  
13 ULLDEMOLINS TODÓ, ALFONS VE1 M6369052000000000 184  
14 VILA CARDONA, LLUÍS SEN M5806361000000000 182  
15 FAVA BENEITO, RUBEN VE2 M21464568000000000 180 180
16 MARTÍNEZ CHICOT, PAU S23 M0645654000000000 174  
17 PAGA MARGALEF, JOAN PERE VE1 M33525133000000000 169 169
18 MOYA BELTRÁN , PAU VE1 M32494938000000000 168 168
19 MARTOS MARTI, JOAN VE1 M5106056000000000 167  
20 SERRANO MARTÍNEZ, DOMINGO (A) VE1 M3967058000000000 164  
21 CABALLER BOIX, RUBÉN VE1 M730850000000000 158  
22 GONZALEZ GILABERT, OCTAVI VE1 M5058049000000000 157  
23 CODORNIU MORENO, RAMON VE2 M20474642000000000 155 155
24 ESQUERRE FERRE, ROMAN MA1 M4857044000000000 149  
25 HERNÁNDEZ JILALA, NIZAR S18 M700710000000000 141  
26 PRADES NADAL, PAU S23 M670071000000000 138  
27 SANCHO RALDA, ALFONSO VE2 M3405348000000000 135  
28 GARCIA SUAREZ, JULIO VE2 M006566000000000 131  
29 CORONIL FONTANET, PATRICK VE1 M2455500000000000 129  
30 ALAIXENDRI JARDI, MAURO VE2 M610670000000000 128  
31 MARTINEZ MARTI, ALBERT VE2 M0444727000000000 118  
32 NACENTA MERINAS, PAU SEN M115000000000000 115  
33 DELGADO SILLERO, MIGUEL VE1 M000115000000000 115  
34 TUTUSAUS ROSELL, INDALECIO MA2 M14344025000000000 113 113
35 FARGAS NAVARRO, ARNAU SEN M010300000000000 103  
36 BRU RULLO, LLATZER SEN M495100000000000 100  
37 SANCHEZ MIRALLES, JUAN ANTONIO MA1 M1904435000000000 98  
38 VIDAL I GARRIGA, JOAN ENRIC VE2 M1240420000000000 94  
39 ANDRES , SERGIO SEN M2354116000000000 94 94
40 GAVALDA BENAIGES, SANTI VE1 M410520000000000 93  
41 ORTÍN FONT, XAVIER VE2 M079013000000000 92  
42 DOORNBOS, ROY (A) MA1 M1836037000000000 91  
43 FUMADO CASANOVA, JUAN JOSE MA2 M2323422000000000 90 90
44 PARTIDO TENA, IVAN VE2 M315300000000000 84  
45 PRADES MEJÍAS, LLUÍS VE1 M360047000000000 83  
46 PLANS FUSTE, ORIOL SEN M242390000000000 83  
47 RÁFALES BARBERAN, SERGIO SEN M79000000000000 79  
48 SALES FERRÉ, ENRIC VE1 M00079000000000 79  
49 FALGAS MORENO, ALEX VE2 M00790000000000 79  
50 GARCIA ALPAÑES, HECTOR VE2 M275000000000000 77  
51 CABRE, CARLES MA1 M004334000000000 77  
52 SABATER CABRERA, ENRIC VE2 M400036000000000 76  
53 MARTI FUSTE, JORDI VE1 M75000000000000 75  
54 AYET SALES, DAVID (A) VE2 M250480000000000 73  
55 BO PEÑA, JOEL SEN M230318000000000 71 71
56 BERBEGAL MIRANDA, DAVID VE1 M00070000000000 70  
57 ABELLÀ RIBA, ANDREU VE1 M07000000000000 70  
58 ESKI, ARMEN VE1 M69000000000000 69  
59 GUIU VILANOVA , JAUME VE1 M06800000000000 68  
60 BOLDU ROIG, ENRIC SEN M00680000000000 68  
61 BEL VIDAL, JORDI MA1 M00067000000000 67  
62 GARCIA BALAGUE, JULI VE2 M226309000000000 67 67
63 GIMÉNEZ PAGÀ, JORDI SEN M003828000000000 66  
64 BADIA CORTES, GERARD VE1 M65000000000000 65  
65 ABAGHAD AKHADDAR, YOUSSEF SEN M00065000000000 65  
66 CASTELLVI, IVAN VE2 M06500000000000 65  
67 CONSTANTIN, SOARE VE2 M228287000000000 65 65
68 VECIANA CABRE, XAVI SEN M64000000000000 64  
69 BAHIR , SOUFIANE VE1 M00064000000000 64  
70 BUENO GARCIA, FRAN VE1 M00640000000000 64  
71 CÒLERA PIÑANA, ALEIX SEN M62000000000000 62  
72 ALIAU ESMEL, JOSE MARI VE2 M00062000000000 62  
73 MARCO CASANOVAS , ROGER VE1 M00620000000000 62  
74 MAÑÉ COSTA, ANTONI VE1 M06100000000000 61  
75 SUBIRATS CID, XAVI SEN M60000000000000 60  
76 COSTES VILA, PAU SEN M00060000000000 60  
77 POZO CALLAU, JOAN SEN M00059000000000 59  
78 SANCHEZ MEDINA, DAVID SEN M05900000000000 59  
79 ACCENSI RODÉS, LLUÍS SEN M57000000000000 57  
80 MECA VENTURA, CARLOS SEN M00570000000000 57  
81 MARTINEZ PERALTA, DANIEL SEN M56000000000000 56  
82 SABATÉ PASANAU, XAVIER VE1 M05600000000000 56  
83 VECIANA CABRE, ALEIX SEN M55000000000000 55  
84 CUGAT MULET, JAUME VE1 M54000000000000 54  
85 MAURI BENAIGES, JOSEP VE1 M05400000000000 54  
86 SUBIRATS MIRALLES, MARC S23 M00540000000000 54  
87 HERNANDEZ RODRIGUEZ, CARLOS MA1 M2152710000000000 54 54
88 BAYO GODES, IVAN [A] VE2 M003517000000000 52  
89 ESPAÑA GARCÉS, FABIAN VE2 M403215000000000 51  
90 JABLONSKO, ERYK ALEKSANDER SEN M00050000000000 50  
91 CAROL MAGRIÑA, JORDI VE1 M04800000000000 48  
92 CID SOLE, OSCAR VE2 M07041000000000 48  
93 PEREZ FRANCH, JOAN VE1 M47000000000000 47  
94 BROUGHTON, JIM MA2 M216236000000000 47 47
95 ANDRÉS , ARTUR S23 M46000000000000 46  
96 REVERTER, DIDAC SEN M00046000000000 46  
97 SERRAL TOMAS, ALVARO VE2 M170029000000000 46  
98 BERTOMEU, JORDI SEN M45000000000000 45  
99 SOLÉ MIRALLES, DAVID VE1 M00045000000000 45  
100 HERNÁNDEZ , AARÓN SEN M04500000000000 45  
101 SANCHO JOSE, VICTOR (A) MA1 M229014000000000 45  
102 GILABERT, LLUC S23 M44000000000000 44  
103 BLASCO GARCIA, LLUIS S23 M43000000000000 43  
104 SAIZ VIVES, JOSE MARIA MA1 M00043000000000 43  
105 BADENAS GUINJOAN, CARLOS VE2 M04300000000000 43  
106 VILANOVA ARRUFAT, IVAN VE2 M04100000000000 41  
107 PAZ SIMÓ, JAUME SEN M00040000000000 40  
108 SABATÉ BLASCO, SANTI SEN M00039000000000 39  
109 JIMÉNEZ MUR, PERE JOSEP MA1 M03900000000000 39  
110 RUIZ SERRANO, JUSTINO (A) MA2 M325011000000000 39  
111 SERRANO SABATER, ESTANIS SEN M38000000000000 38  
112 DOMÈNECH RATÉS, DAVID VE1 M03800000000000 38  
113 LANGE EBRI, ARTURO MA2 M002612000000000 38  
114 PERALTA TORRES, UNIQ SEN M37000000000000 37  
115 ROVIRA MASIP, ALBERT SEN M03700000000000 37  
116 CARNASA FLORES, CARLES S18 M00370000000000 37  
117 FRANCO CIURANA, JOSÉ ANTONIO VE2 M013222000000000 37  
118 CALVET, PEP S23 M00360000000000 36  
119 GARCIA GARCIA, MARC VE2 M017172000000000 36  
120 CURTO GARCIN, CARLOS SEN M35000000000000 35  
121 GIRONÉS PEDROL, LLUIS VE2 M03300000000000 33  
122 MIRALLES ESTIVILL , DAVID SEN M00330000000000 33  
123 SOLÉ PÀMIES, RAMON MA1 M23100000000000 33  
124 FERRE GARCIA, MIGUEL VE2 M212190000000000 33  
125 CASANOVA BERTOMEU, FERRAN SEN M00032000000000 32  
126 CID MANGRANÉ, GERARD SEN M00031000000000 31  
127 CERVERA PERELLÓ, DAVID SEN M30000000000000 30  
128 TURCH FERRERES, ARNAU SEN M00030000000000 30  
129 CABRERA, ROBERT VE1 M29000000000000 29  
130 CAMACHO, IAN SEN M00290000000000 29  
131 ESTADELLA MARIGÓ, JAUME SEN M28000000000000 28  
132 SÁNCHEZ HERRERO, ANTONIO M MA1 M08200000000000 28  
133 GONZALEZ IGLESIAS, JAVIER (A) MA2 M26182000000000 28 28
134 CAMBEIRO CABRE, GERARD VE1 M02700000000000 27  
135 LLUIS LLANSAMA, GABRIEL (A) VE2 M26000000000000 26  
136 CÓRDOBA BOU, EDUARD SEN M00026000000000 26  
137 DÍAZ GARCIA, EMILIO MA1 M22400000000000 26  
138 MESTRE FONOLLOSA, GUILLEM S23 M00250000000000 25  
139 ANGUERA GALIANA, MANEL MA1 M20023000000000 25  
140 MIRÓ JUAN, RUBEN VE2 M00024000000000 24  
141 TORTA SIMÓ, JOAN VE2 M00240000000000 24  
142 OBIOL REVERTE, RAMON (A) VE2 M23000000000000 23  
143 ARTIGAS BELTRAN, MIQUEL VE2 M02300000000000 23  
144 MARTÍNEZ PERALTA , ORIOL SEN M22000000000000 22  
145 PERELLÓ COMPTE , OVIDI VE2 M02200000000000 22  
146 FALCO GISBERT, XAVI SEN M00021000000000 21  
147 ARIZA ALFONSO, DAVID VE1 M02100000000000 21  
148 EGYED, ÁKOS S18 M00210000000000 21  
149 JORNET MEIX, JORDI SEN M00020000000000 20  
150 CORTES PIÑOL, SANTIAGO MA1 M02000000000000 20  
151 SOLÁ MIRAVETE, MANEL MA1 M00019000000000 19  
152 JUAN MASOT , JUAN BTA MA1 M01900000000000 19  
153 PASTOR DE RAMON, JORDI SEN M00018000000000 18  
154 MIRALLES MARZA, VICTOR SEN M01800000000000 18  
155 IGLESIAS SEGURA, URIEL S23 M00162000000000 18  
156 RAMBLA CASTILLO, OSCAR VE1 M16000000000000 16  
157 BRU RULLO, SAMUEL VE1 M21400000000000 16  
158 ROBLES RUBIO, JOSÉ ELÍAS VE1 M15000000000000 15  
159 CASACUBERTA FERRÉ, ARNAU SEN M13000000000000 13  
160 PARSONS, DAVID MA2 M21100000000000 13  
161 SUBIRATS MIRALLES, PAU SEN M11000000000000 11  
162 MACHÍ ARAGONÉS , MARC SEN M10000000000000 10  
163 MONTORO FRANQUET, ANTONI VE1 M01000000000000 10  
164 LÓPEZ CALVET, MIQUEL S23 M9000000000000 9  
165 GIRONES, BRUNO MA1 M0900000000000 9  
166 CASES BLANCH, CARLES VE2 M8000000000000 8  
167 FORNÓS PANISELLO, MARC SEN M7000000000000 7  
168 GARCIA MARTÍNEZ, XAVIER SEN M6000000000000 6  
169 GARCÍA PORTA , JULIÁN VE1 M5000000000000 5  
170 BALAGUER SORRIBES, JORDI [A] SEN M0005000000000 5  
171 FABREGAT BENAIGES, JOAN VE1 M0500000000000 5  
172 MARRO CODORNIU, JORDI VE1 M0004000000000 4  
173 GAUXACHS MONSERRAT, JAVIER SEN M0003000000000 3  
174 SERRET ROIG, ADRIA MA1 M2000000000000 2  
175 GALVE, ALEIX SEN M2000000000000 2  
176 ESTORACH SANTAMARIA , ARNAU VE1 M2000000000000 2  
177 CABALLER CERVANTES, ERNEST SEN M2000000000000 2  
178 ROCA ROYO, DANIEL VE1 M2000000000000 2  
179 ROCA ROYO, JOAN VE1 M2000000000000 2  
180 ROCA OLIVER, ANTONI MA2 M2000000000000 2  
181 CAMACHO MARGALEF, DAVID VE1 M2000000000000 2  
182 SARIÓ DOMECH, SALVADOR VE1 M2000000000000 2  
183 CAPERA FERNANDEZ, ANDREU SEN M2000000000000 2  
184 ROJAS ESTEVE, JOSUÉ SEN M2000000000000 2  
185 SUBIRATS CID, JORDI VE1 M2000000000000 2  
186 FORCADELL MORALES, ALFONS VE2 M2000000000000 2  
187 GAZA BENAVENT, JAVIER SEN M2000000000000 2  
188 ORTIZ MARTÍNEZ-CANOVAS, FERRAN VE1 M0002000000000 2  
189 GARRIGA SOROLLA, XAVIER VE2 M2000000000000 2  
190 PANISELLO SEBASTIÁ, PANISEL SEN M0002000000000 2  
191 BRULL MIRAS, EDUARD VE1 M2000000000000 2  
192 FIBLA REVERTER, ANTONI MA2 M0002000000000 2  
193 LUNA OLTRA, ANTONIO MA1 M2000000000000 2  
194 ARASA PELLISA, ANGEL VE2 M2000000000000 2  
195 REDÓ CHALER, JUSTO MA2 M0002000000000 2  
196 BORRÀS ARMENOS, JOSEP MARIA MA1 M2000000000000 2  
197 OLIVERAS RODRÍGUEZ, JAVIER SEN M0002000000000 2  
198 ESKU, DANI VE2 M2000000000000 2  
199 ARIZA, NARCIS VE1 M0002000000000 2  
200 DOMENECH FONS, ARNAU S23 M0002000000000 2  
201 BALAGUÉ CHORTO, ORIOL SEN M2000000000000 2  
202 NIETO, ALEX SEN M2000000000000 2  
203 ANFRUNS ORTIZ, MARC VE2 M2000000000000 2  
204 GOMEZ MARTINEZ, JOSE LUIS VE2 M2000000000000 2  
205 MAGRAZÓ AGULLÓ, XAVIER SEN M2000000000000 2  
206 LÓPEZ CALVET, PAU SEN M2000000000000 2  

* 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.