CLASSIFICACIÓ 10K: ABSOLUT MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, 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, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SOWE, MUSA VE1 M115937911500 402 402
2 DE TORRES BURGOS, FERRAN VE2 M103857510300 366 366
3 SALES FERRE, ENRIC SEN M8573687900 305 305
4 CURTO I GILABERT, DAVID VE2 M6563576000 245 245
5 PUENTES GARCÍA, LUIS FCO VE2 M937969000 241 241
6 VIUDEZ TOMÀS, MARTÍ VE1 M697509300 237 237
7 LLUIS LLANSAMA, GABRIEL VE2 M5561566200 234 234
8 IZQUIERDO ACON, ALEX VE1 M071718500 227 227
9 GIMENEZ BELLOBI, JORDI VE1 M6354475500 219 219
10 FATHI, ALI SEN M0115103000 218 218
11 BUTLER, JONATHAN VE1 M790677100 217 217
12 FRANCO SMEETS, CLAUDIO VE1 M716966000 206 206
13 GAIC, ROBERT DAVID SEN M5152484900 200 200
14 MARTÍNEZ RODRIGUEZ, ÁNGEL VE2 M010393000 196 196
15 MAURI BARDI, JORDI SEN M4251465100 190 190
16 PAGA MARGALEF, JOAN PERE VE1 M566459000 179 179
17 GARCIA SUAREZ, JULIO CESAR VE1 M610536300 177 177
18 GARCIA SANGÜESA, DAMIÀ VE2 M058515600 165 165
19 RUIZ SERRANO, JUSTINO MA2 M3846383900 161 161
20 FORTUÑO NAVARRO, JOSE LUIS VE2 M4144353600 156 156
21 GARCIA BALAGUE, JULI VE2 M3242373700 148 148
22 LEÓN MORA, AUGUSTO LEO VE2 M4039333400 146 146
23 MESTRE QUEROL, ALBERT VE1 M75070000 145 145
24 SABATE ROIG, ENRIC VE2 M07007000 140 140
25 FERRE VADILLO, ENRIC VE1 M041434700 131 131
26 ALBIOL CHERTA, GERARD SEN M00626800 130 130
27 LLEIXA GUARRO, IVAN VE1 M06564000 129 129
28 CASTELLS LOPEZ, RAMON VE1 M06661000 127 127
29 REDÓ VIUDEZ, CARLOS SEN M66006100 127 127
30 SANCHO JOSE, VICTOR MA1 M2538293200 124 124
31 BASSIYD, MUSTAPHA SEN M05706500 122 122
32 PARDO ARQUES, ROGER SEN M58620000 120 120
33 GOMBAU MURRIA, ELISEU SEN M60005700 117 117
34 MAIJÓ FRIGOLA, ÀDAM S23 M00115000 115 115
35 SALVATELLA ROIJALS, JOAN VE1 M06050000 110 110
36 CUGAT MULET, JAUME VE1 M57005200 109 109
37 LANGE EBRI, ARTURO MA2 M2432312200 109 109
38 VALLESPI DE LA CRUZ, JORDI VE1 M05005300 103 103
39 PELEGRIN SANCHEZ, JOAN CARLES MA1 M2027242700 98 98
40 GALIANA BARCELÓ, JOAN VE2 M48490000 97 97
41 GARBI HUERGA, CARLOS TOMÁS VE1 M037302900 96 96
42 SUBIRATS CID, JORDI VE1 M283603000 94 94
43 VALMAÑA, ELOY VE1 M04504600 91 91
44 EL JIHAOUI, AZZIZ VE1 M0085000 85 85
45 ROFES BARCELO, JOSEP MA1 M270273100 85 85
46 SOLÉ MIRALLES, DAVID VE1 M00404100 81 81
47 MONTEVERDE MAURI, MARC SEN M34470000 81 81
48 HERNANDEZ RODRIGUEZ, CARLOS MA1 M37400000 77 77
49 NAVARRO BARBERA, JORDI VE1 M0007500 75 75
50 TOMÀS BUITRAGO, AITOR SEN M0073000 73 73
51 FALGAS MORENO, ALEX VE2 M7300000 73 73
52 FORNÉ CASTELLS, XAVIER VE2 M0007300 73 73
53 RIBERA ROIG, PABLO VE1 M7000000 70 70
54 PUIG IZQUIERDO , ANTONI VE1 M0006900 69 69
55 CASTELLS FABRA, LLUIS VE1 M1620151800 69 69
56 ROYO GUILLEM, ANDREU VE1 M6800000 68 68
57 VILANOVA ARDIT, JOSEP VE1 M0680000 68 68
58 QUERAL FORCADELL, DAVID VE2 M6700000 67 67
59 NAVAS PORTELLA, VÍCTOR SEN M0006700 67 67
60 GELLIDA ALBIOL, JESÚS VE1 M0670000 67 67
61 GUIU BAGÉS, ALBERT VE2 M025222000 67 67
62 SABATE SABATE, JAVIER SEN M1521141700 67 67
63 BUERA REBULLIDA, JOSEP MIQUEL VE1 M0006600 66 66
64 SAGRISTA NOE, JOSEP SEN M0065000 65 65
65 SORIANO LÓPEZ, MARTÍ VE1 M6400000 64 64
66 DELLA CALLEN, JUAN JOSE VE1 M0006400 64 64
67 ABELLÀ RIBA, ANDREU SEN M0063000 63 63
68 BOVO, MARIO ANTONIO VE1 M6200000 62 62
69 JULIO SALES, RUBÉN S23 M0060000 60 60
70 DELLA CALLEN, CARLOS VE1 M5900000 59 59
71 GARCIA LOPEZ, JUAN VE1 M0005900 59 59
72 BORRÀS CAMPS, EDUARD VE1 M0590000 59 59
73 LABERNIA FERRE, VICENT VE1 M0058000 58 58
74 ESQUERRE FERRE, ROMAN VE2 M0005800 58 58
75 REVERTER BULLON, JOSE MIGUEL VE2 M03502300 58 58
76 SABATER CABRERA, ENRIC VE2 M0560000 56 56
77 PUIG CARLES, JOSEP VE1 M0055000 55 55
78 CURTO IBAÑEZ, ADRIÀ S23 M0550000 55 55
79 ALBO GARCIA, DAVID VE1 M0054000 54 54
80 BELTRAN COLLADO, ORIOL VE1 M5400000 54 54
81 GONZALEZ GILABERT, OCTAVI SEN M0005400 54 54
82 MONTESÓ JIMENEZ, DAVID MONTESÓ JIMÉNEZ VE1 M5300000 53 53
83 MARGALEF BENAIGES, PAU VE1 M0530000 53 53
84 SEVILLANO MORAN, ENRIQUE VE2 M0052000 52 52
85 PUTAN CÓRDOBA, WILSON VE1 M5200000 52 52
86 OBIOL PEDROL, ENRIC SEN M5000000 50 50
87 GAS PANISELLO, DAVID VE2 M0005000 50 50
88 ULLDEMOLINS TODÓ, ALFONS VE1 M0049000 49 49
89 DELGADO ARAGONESES, VÍCTOR VE1 M4900000 49 49
90 REDO PRINCEP, RICARD VE2 M0004800 48 48
91 PEREZ FRANCH, JOAN VE1 M0480000 48 48
92 PELEGRIN VALLS, JONATHAN SEN M4700000 47 47
93 CASTELLS BARRACHINA, BLAY SEN M4600000 46 46
94 MIRO ANDREU, ANTONI MA1 M0045000 45 45
95 SERRET ROIG, ADRIA VE2 M4500000 45 45
96 GRAU VIDAL, ALBERTO VE1 M0004500 45 45
97 ANDREU LOPEZ, AARÓN SEN M0044000 44 44
98 CABANES CALVET, ALBERT VE2 M4400000 44 44
99 SANAHUJA MORENO, IVAN VE1 M0004400 44 44
100 GARCIA ALPAÑES, HECTOR VE1 M4300000 43 43
101 PALLARÉS MARTÍ, JOSEP MA1 M0004300 43 43
102 SANCHEZ MIRALLES, JUAN ANTONIO MA1 M0430000 43 43
103 EL AKRAA, MOHAMED S18 M0042000 42 42
104 ALSINA SALMORAL, XAVIER SEN M0004200 42 42
105 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M0041000 41 41
106 CAMACHO MARGALEF, DAVID SEN M0004000 40 40
107 FATSINI LLETI, DANIEL SEN M0039000 39 39
108 FIBLA MORENO, JOAN LLUIS SEN M3900000 39 39
109 VILLEGAS GIRALDO, BAHUER SEN M0003800 38 38
110 BEL MUÑOZ, BIEL S18 M0036000 36 36
111 MONTEVERDE, JORDI VE1 M3600000 36 36
112 CUESTA GARCIA, DANI SEN M3500000 35 35
113 CATALA BONANZA, BLAS VE1 M0003500 35 35
114 ANDUCAS PLANAS, JORDI VE2 M0034000 34 34
115 RODA CID, SERGI VE2 M0340000 34 34
116 GONZALEZ MORATALLA, ALFREDO VE1 M3300000 33 33
117 MIRALLES LLORCA, JESÚS VE1 M0003300 33 33
118 BEL PLA, RAMON VE2 M0330000 33 33
119 BORT I CORTIELLA, JOSEP JOAN VE2 M0032000 32 32
120 ESPINOSA ZAVALETA, EDGAR RICARDO MA1 M3100000 31 31
121 MIRAS ARNEDO, IBAN VE1 M0310000 31 31
122 VILLARES MUÑIZ, MARTÍ-PAU SEN M3000000 30 30
123 SANCHEZ PEREZ, JAVIER VE1 M0300000 30 30
124 SUBIRATS CID, XAVI SEN M2900000 29 29
125 MATEOS VIDAL, EDUARD SEN M0290000 29 29
126 PEIRET DE LA FUENTE, CARLES VE2 M0028000 28 28
127 DOORNBOS, ROY MA1 M0002800 28 28
128 FUMADO CASANOVA, JUAN JOSE MA1 M0280000 28 28
129 LAPUERTA CARDONA, FRANSEC S18 M0026000 26 26
130 GIMENO PUIGCERVER, MARC SEN M2600000 26 26
131 CHAVARRIA FERRÉ, DANI VE1 M0002600 26 26
132 MARGALEF CABRERA, MIGUEL SEN M0260000 26 26
133 SUBIRATS RILLO, ALBERT VE1 M0025000 25 25
134 PONS URQUIZU, JOSE MARIA MA2 M0002500 25 25
135 CID ESPUNY, JOSEP LLUIS MA1 M0002400 24 24
136 SEBASTIA VALLDEPEREZ, JORDI VE1 M0240000 24 24
137 BROUGHTON, JIM MA2 M0023000 23 23
138 MULET ROYO, JORDI SEN M2300000 23 23
139 LUQUE CRESPILLO, FRANCISCO MA1 M0230000 23 23
140 BORRAS LLOSA, ALBERT VE2 M2200000 22 22
141 ALIAU PONS, JOAN JOSEP MA1 M0220000 22 22
142 ARASA ARASA, JUAN JOSE MA1 M0021000 21 21
143 SANSALONI GILABERT, PAU SEN M2100000 21 21
144 CURTO GARCIN, CARLOS SEN M0002100 21 21
145 FERRIZ MARINÉ, ALEX VE2 M0020000 20 20
146 GALARZA SANCHEZ, ALEJANDRO VE2 M0019000 19 19
147 CLUA GAYA, MARC VE2 M1900000 19 19
148 FABRA ARQUES, CARLOS VE1 M0001900 19 19
149 ALLÓ BORT, MARC S23 M0018000 18 18
150 TORRES BERTOMEU, JOSEP VE1 M1800000 18 18
151 TOMÀS TORRES, ISMAEL MA1 M0017000 17 17
152 TOMÀS I ROIGET, ADAM VE2 M1700000 17 17
153 BELTRAN SUBIRATS, JOSEP MARIA VE2 M0016000 16 16
154 BATALLA, JOAN CARLES VE2 M1400000 14 14
155 VILLARES FERNÁNDEZ, VILLARES MA2 M1300000 13 13
156 IBAÑEZ BISMARCH, JUST SEN M1200000 12 12
157 CARMONA HERNÁNDEZ, JAVIER VE2 M1100000 11 11




Amb el suport de:

comunicar incidències sobre les classificacions.
Recorda que 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.