CLASSIFICACIÓ 5K: ABSOLUT MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 TOMÀS BUITRAGO, AITOR SEN M1150791156711585115 691 545
2 SANAHUJA BARRANCO, JOSEP RAMON VE2 M01037575103103930 552 477
3 RODA SALES, DAVID VE1 M00079939379103 447 447
4 GARCIA REDONDO, DOMINGO VE2 M7975715975757593 602 412
5 CAMPOY LOZANO, JUAN VE1 M7144686370707385 544 384
6 RIERA I CAIRE, XAVIER S18 M757306771647179 500 369
7 FUCHO PASCUAL, FELIP MA1 M706905865666568 461 338
8 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M6364635557606366 491 334
9 MARTOS MARTI, ANGEL VE1 M0006163676769 327 327
10 JIMÉNEZ BRANERA , DANI SEN M0066626261073 324 324
11 ORTEGA BLANCO, JAIME VE1 M626162570626467 435 317
12 BERTOMEU BAILE, DAVID VE2 M676805660575262 422 314
13 FUMADO GISBERT, ORIOL S18 M054566058636664 421 311
14 LLUCH ARBONA, FRANCESC VE1 M6406500565658 299 299
15 SEDIKI AIT SILARBI, HAKIM VE2 M58566148560059 338 290
16 GONZALEZ REVERTER, RAMON MA1 M55004755545961 331 284
17 MACHI CABALLE, OMAR SEN M93930930000 279 279
18 RODRIGUEZ SUBIRATS, DAVID VE1 M730065697100 278 278
19 PAGA MARGALEF, JOAN PERE VE1 M071000686970 278 278
20 BALAGUE BELTRAN, JOAQUIN VE1 M57555850049570 326 277
21 GALARZA SANCHEZ, ALEJANDRO VE2 M5446523250445346 377 270
22 MARGALEF BORRELL, JOSEP MA1 M5250514349384951 383 268
23 MARTÍ JOVE, JOSEP MA1 M5045533648394550 366 261
24 ESTORACH SOL, OSCAR SEN M103850690000 257 257
25 ALMENDROS RODA, IGNASI VE2 M665164520000 233 233
26 BLANCH ALSO, ARNAU S18 M07900737900 231 231
27 LUQUE LLUCH, OLIVER VE1 M656057450000 227 227
28 GABALDA FERRE, ELOI SEN M005954052057 222 222
29 CUBELLS I CUBELLS, HERIBERT SEN M00930001030 196 196
30 ROCA REY, ROGER SEN M514954400000 194 194
31 PEDROL PASCUAL, OSCAR S23 M06204600060 168 168
32 CASTELLS CASANOVA, JOEL SEN M00049040540 143 143
33 GOMEZ AUSACH, ANDREU SEN M6867000000 135 135
34 MIRAPEIX TOMAS, ORIOL MA1 M00000374652 135 135
35 ALONSO QUESADA, OSCAR VE2 M0650059000 124 124
36 ABAGHAD, YOUSSEF S23 M0115000000 115 115
37 OUHDADI, YASSINE SEN M0000001150 115 115
38 ULLAH, AHSAN VE1 M0000115000 115 115
39 MAIJÓ FRIGOLA, ÀDAM S23 M0011500000 115 115
40 BERTOMEU CASANOVA, AARON SEN M5657000000 113 113
41 BELTRAN, MANEL SEN M0003800700 108 108
42 RIBES SERRA, JOSEP MARIA VE2 M0530053000 106 106
43 REMOLINA RALLO, FERRAN SEN M0001030000 103 103
44 CARMONA PARADA, FRANCESC VE1 M0010300000 103 103
45 DURAN PINO, RAFEL VE2 M0004100056 97 97
46 GARBI HUERGA, CARLOS TOMÁS VE1 M0390000510 90 90
47 GARRIGUES MONLEON , VICENTE VE1 M000850000 85 85
48 OURHOU OUAMOU, ILYASSE SEN M000008500 85 85
49 COLI MUNAR, PERE S23 M850000000 85 85
50 LOPEZ GIL, DENIS VE1 M000085000 85 85
51 BENAIGES MARGALEF, JOSEP VE1 M008500000 85 85
52 FRANCH FRANCH, JOAN MARTI SEN M0003900440 83 83
53 VALLESPI DE LA CRUZ, JORDI VE1 M000079000 79 79
54 PALLARES PEREZ, PAU S18 M0002900047 76 76
55 AVINYO ARASA, PAU SEN M000000075 75 75
56 LÓPEZ SANZ , IKER VE1 M000730000 73 73
57 GIL ANTEQUERA, PABLO VE1 M000007300 73 73
58 LEANDRO QUERO, JORDI VE1 M007300000 73 73
59 GARCÍA ANTA , JESUS VE1 M000710000 71 71
60 ROJAS ESTEVE, JOSUÉ SEN M000000071 71 71
61 DELGADO ARAGONESES, VÍCTOR VE1 M000700000 70 70
62 CASAS CABRERA, PACO SEN M070000000 70 70
63 ESPINOSA CALLAU, CARLOS S18 M007000000 70 70
64 OUCHBAB, AISSA S18 M000006900 69 69
65 CÁCERES AZNAR, KARIM SEN M690000000 69 69
66 VALENCIA, MANUEL VE2 M006900000 69 69
67 ROYO GUILLEM, ANDREU VE1 M000680000 68 68
68 BERTOMEU BELLES, CRISTIAN SEN M000000680 68 68
69 PRINCEP CARDONA, JESUS VE1 M000068000 68 68
70 CAPTARI, FABIAN ESTEBAN S23 M006700000 67 67
71 DEL VALLE PUIG, ADRIA SEN M000660000 66 66
72 ASMOUH, MOHAMED S18 M066000000 66 66
73 PRADES NADAL, MARC S18 M000066000 66 66
74 PAREDES MARTÍ, SAM SEN M000006500 65 65
75 CASTELLVI SORIANO, JORDI SEN M000000065 65 65
76 BELTRAN ARQUES, JUAN FRANCISCO VE2 M000640000 64 64
77 AFSFAS, MOHAMED S18 M000064000 64 64
78 HAMDOUNI, AYOUB S23 M063000000 63 63
79 BRETÓ VERGE, FRANCESC VE1 M000000063 63 63
80 MIOAGA TRASCA , ROBERT S23 M000000620 62 62
81 LLUIS LLANSAMA, ANTONIO VE1 M610000000 61 61
82 PRADES NADAL, PAU S18 M000061000 61 61
83 FERRE FOLCH, DAVID VE2 M600000000 60 60
84 FRANCH VENTURA, PERE VE1 M000000600 60 60
85 MAIJÓ FRIGOLA, ABEL SEN M006000000 60 60
86 ARASA FORNOS, OSCAR VE2 M0350250000 60 60
87 SANCHO RALDA, ALFONSO VE1 M000005900 59 59
88 ALMENDROS GARCIA, FERRAN S18 M059000000 59 59
89 PALMER FERRER, PERE VE2 M590000000 59 59
90 MONTALVO SANZ, RAÚL SEN M000005800 58 58
91 CURTO GARCIN, CARLOS SEN M058000000 58 58
92 MIGUEL BARTOLOME, ALBERTO VE1 M000000580 58 58
93 ROCA AÑON, VICTOR SEN M000005500 55 55
94 LLITRÀ VIRGILI, ESTEVE MA1 M000000550 55 55
95 FANDOS COLOMINES, FELIP VE1 M005500000 55 55
96 BESALDUCH BEL, XAVI VE1 M000000055 55 55
97 GONZÁLEZ CABALLERO, DAVID SEN M000054000 54 54
98 MORESO ABELLA , VICTOR SEN M000000054 54 54
99 ESPINOSA VILLAR, BORJA VE1 M000530000 53 53
100 ROVIRA CID, LEANDRO SEN M000005300 53 53
101 VECIANA CARBONELL, JOSEP VE1 M530000000 53 53
102 LLOSA GAS, CARLOS SEN M000000053 53 53
103 PRATS TACHÉ, PERE MA1 M052000000 52 52
104 FONOLLOSA AULADELL, XAVIER SEN M000052000 52 52
105 BONFILL SEGURA, MIQUEL ANGEL VE2 M000510000 51 51
106 PEREZ FUSTE, JORDI VE1 M000005100 51 51
107 MARTÍN DOMENECH, JOAN S18 M000051000 51 51
108 OLIVER BLANCH, OSCAR SEN M000005000 50 50
109 LEÓN MORA, AUGUSTO LEO VE2 M000000500 50 50
110 GERARD, DUBENT MA2 M005000000 50 50
111 SAMPER BRUNO, ALBERT VE1 M490000000 49 49
112 RODRÍGUEZ FUSTÉ, HILARI MA1 M000000049 49 49
113 SOTO PAREDES, DANIEL VE1 M048000000 48 48
114 GARRIGA SANZ, ANTONI VE1 M480000000 48 48
115 MAIER, TONI VE1 M000000480 48 48
116 DOSDAD CAMPOS , OSCAR VE1 M000000048 48 48
117 OLIVER BLANCH, SERGIO SEN M000004700 47 47
118 MARTINEZ DE LEON, ORIOL VE1 M047000000 47 47
119 SOLÉ SUBIRATS, JULI VE2 M470000000 47 47
120 CASANOVA BERTOMEU, FERRAN SEN M000000470 47 47
121 TURCAN, NICOLAE SEN M000004600 46 46
122 GARCIA BEATO, ALBERT SEN M000004500 45 45
123 BROUGHTON, JIM MA1 M000000045 45 45
124 BUERA REBULLIDA , JOSEP MIQUEL VE1 M000440000 44 44
125 PINEAU, ALEXANDRE VE1 M000000044 44 44
126 BENEITO FAUS, RUBEN SEN M000004300 43 43
127 BALLESTE SCIORA, ALEX S18 M043000000 43 43
128 GALINDO AYORA, RUBEN VE1 M000000430 43 43
129 MONTESÓ FALCÓ, XAVI VE1 M000000043 43 43
130 NAVARRO PUIG, GUILLEM MA1 M000420000 42 42
131 REDO MUSSO, ALEX SEN M000004200 42 42
132 COTAINA CABALLE, JAVIER MA1 M042000000 42 42
133 GASPARIN, MARC VE1 M000000420 42 42
134 BARBERÀ ALSO, JOAQUIM SEN M000004100 41 41
135 DUSSARRAT, ROBIN SEN M041000000 41 41
136 MUR BAGES, JOAN RAMON MA1 M040000000 40 40
137 PAGA FABRA, AGUSTI SEN M038000000 38 38
138 ESPINOSA ZAVALETA, EDGAR RICARDO VE2 M000370000 37 37
139 DUBENT, GERARD MA2 M037000000 37 37
140 MELERO CURTO, JOSEP SEN M000003600 36 36
141 GONZÁLEZ MARCOS, DANIEL VE1 M036000000 36 36
142 MAURI HIERRO, DAVID VE1 M000350000 35 35
143 PUIG VILÀS, ENRIC VE1 M000003500 35 35
144 IGLESIAS MESTRES, JAUME VE2 M000340000 34 34
145 LOMBARTE CAMBERO, JOAN S23 M000003400 34 34
146 ALSO GAS, LLORENS MA1 M000330000 33 33
147 BOIX BERENGUE, ALEIX S23 M000003300 33 33
148 ALAIXENDRI JARDÍ, MAURO VE1 M000003200 32 32
149 DELGADO, FRANCESC VE1 M000310000 31 31
150 CODORNIU CODORNIU, ADRIÀ SEN M000003100 31 31
151 ROMANÍ ALSO, DAVID VE1 M000300000 30 30
152 BARBERÀ ALSO, ANTONI SEN M000003000 30 30
153 GÓMEZ, JOSE ANTONIO VE2 M000280000 28 28
154 SABORIDO ESCURRIOLA, EDUARD VE1 M000270000 27 27
155 SANTISTEBAN RONCERO, TONI VE2 M000260000 26 26




Amb el suport de: