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 M11507911567115850 576 509
2 SANAHUJA BARRANCO, JOSEP RAMON VE2 M01037575103103930 552 477
3 GARCIA REDONDO, DOMINGO VE2 M797571597575750 509 379
4 RIERA I CAIRE, XAVIER S18 M75730677164710 421 357
5 CAMPOY LOZANO, JUAN VE1 M714468637070730 459 352
6 RODA SALES, DAVID VE1 M000799393790 344 344
7 FUCHO PASCUAL, FELIP MA1 M70690586566650 393 335
8 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M636463555760630 425 313
9 ORTEGA BLANCO, JAIME VE1 M62616257062640 368 311
10 BERTOMEU BAILE, DAVID VE2 M67680566057520 360 308
11 FUMADO GISBERT, ORIOL S18 M05456605863660 357 303
12 MACHI CABALLE, OMAR SEN M93930930000 279 279
13 SEDIKI AIT SILARBI, HAKIM VE2 M5856614856000 279 279
14 RODRIGUEZ SUBIRATS, DAVID VE1 M730065697100 278 278
15 BALAGUE BELTRAN, JOAQUIN VE1 M57555850049570 326 277
16 GONZALEZ REVERTER, RAMON MA1 M5500475554590 270 270
17 MARTOS MARTI, ANGEL VE1 M000616367670 258 258
18 ESTORACH SOL, OSCAR SEN M103850690000 257 257
19 GALARZA SANCHEZ, ALEJANDRO VE2 M544652325044530 331 255
20 JIMÉNEZ BRANERA , DANI SEN M006662626100 251 251
21 MARGALEF BORRELL, JOSEP MA1 M525051434938490 332 251
22 LLUCH ARBONA, FRANCESC VE1 M640650056560 241 241
23 MARTÍ JOVE, JOSEP MA1 M504553364839450 316 241
24 ALMENDROS RODA, IGNASI VE2 M665164520000 233 233
25 BLANCH ALSO, ARNAU S18 M07900737900 231 231
26 LUQUE LLUCH, OLIVER VE1 M656057450000 227 227
27 PAGA MARGALEF, JOAN PERE VE1 M07100068690 208 208
28 CUBELLS I CUBELLS, HERIBERT SEN M00930001030 196 196
29 ROCA REY, ROGER SEN M514954400000 194 194
30 GABALDA FERRE, ELOI SEN M00595405200 165 165
31 CASTELLS CASANOVA, JOEL SEN M00049040540 143 143
32 GOMEZ AUSACH, ANDREU SEN M6867000000 135 135
33 ALONSO QUESADA, OSCAR VE2 M0650059000 124 124
34 ABAGHAD, YOUSSEF S23 M0115000000 115 115
35 OUHDADI, YASSINE SEN M0000001150 115 115
36 ULLAH, AHSAN VE1 M0000115000 115 115
37 MAIJÓ FRIGOLA, ÀDAM S23 M0011500000 115 115
38 BERTOMEU CASANOVA, AARON SEN M5657000000 113 113
39 PEDROL PASCUAL, OSCAR S23 M0620460000 108 108
40 BELTRAN, MANEL SEN M0003800700 108 108
41 RIBES SERRA, JOSEP MARIA VE2 M0530053000 106 106
42 REMOLINA RALLO, FERRAN SEN M0001030000 103 103
43 CARMONA PARADA, FRANCESC VE1 M0010300000 103 103
44 GARBI HUERGA, CARLOS TOMÁS VE1 M0390000510 90 90
45 GARRIGUES MONLEON , VICENTE VE1 M000850000 85 85
46 OURHOU OUAMOU, ILYASSE SEN M000008500 85 85
47 COLI MUNAR, PERE S23 M850000000 85 85
48 LOPEZ GIL, DENIS VE1 M000085000 85 85
49 BENAIGES MARGALEF, JOSEP VE1 M008500000 85 85
50 FRANCH FRANCH, JOAN MARTI SEN M0003900440 83 83
51 MIRAPEIX TOMAS, ORIOL MA1 M0000037460 83 83
52 VALLESPI DE LA CRUZ, JORDI VE1 M000079000 79 79
53 LÓPEZ SANZ , IKER VE1 M000730000 73 73
54 GIL ANTEQUERA, PABLO VE1 M000007300 73 73
55 LEANDRO QUERO, JORDI VE1 M007300000 73 73
56 GARCÍA ANTA , JESUS VE1 M000710000 71 71
57 DELGADO ARAGONESES, VÍCTOR VE1 M000700000 70 70
58 CASAS CABRERA, PACO SEN M070000000 70 70
59 ESPINOSA CALLAU, CARLOS S18 M007000000 70 70
60 OUCHBAB, AISSA S18 M000006900 69 69
61 CÁCERES AZNAR, KARIM SEN M690000000 69 69
62 VALENCIA, MANUEL VE2 M006900000 69 69
63 ROYO GUILLEM, ANDREU VE1 M000680000 68 68
64 BERTOMEU BELLES, CRISTIAN SEN M000000680 68 68
65 PRINCEP CARDONA, JESUS VE1 M000068000 68 68
66 CAPTARI, FABIAN ESTEBAN S23 M006700000 67 67
67 DEL VALLE PUIG, ADRIA SEN M000660000 66 66
68 ASMOUH, MOHAMED S18 M066000000 66 66
69 PRADES NADAL, MARC S18 M000066000 66 66
70 PAREDES MARTÍ, SAM SEN M000006500 65 65
71 BELTRAN ARQUES, JUAN FRANCISCO VE2 M000640000 64 64
72 AFSFAS, MOHAMED S18 M000064000 64 64
73 HAMDOUNI, AYOUB S23 M063000000 63 63
74 MIOAGA TRASCA , ROBERT S23 M000000620 62 62
75 LLUIS LLANSAMA, ANTONIO VE1 M610000000 61 61
76 PRADES NADAL, PAU S18 M000061000 61 61
77 FERRE FOLCH, DAVID VE2 M600000000 60 60
78 FRANCH VENTURA, PERE VE1 M000000600 60 60
79 MAIJÓ FRIGOLA, ABEL SEN M006000000 60 60
80 ARASA FORNOS, OSCAR VE2 M0350250000 60 60
81 SANCHO RALDA, ALFONSO VE1 M000005900 59 59
82 ALMENDROS GARCIA, FERRAN S18 M059000000 59 59
83 PALMER FERRER, PERE VE2 M590000000 59 59
84 MONTALVO SANZ, RAÚL SEN M000005800 58 58
85 CURTO GARCIN, CARLOS SEN M058000000 58 58
86 MIGUEL BARTOLOME, ALBERTO VE1 M000000580 58 58
87 ROCA AÑON, VICTOR SEN M000005500 55 55
88 LLITRÀ VIRGILI, ESTEVE MA1 M000000550 55 55
89 FANDOS COLOMINES, FELIP VE1 M005500000 55 55
90 GONZÁLEZ CABALLERO, DAVID SEN M000054000 54 54
91 ESPINOSA VILLAR, BORJA VE1 M000530000 53 53
92 ROVIRA CID, LEANDRO SEN M000005300 53 53
93 VECIANA CARBONELL, JOSEP VE1 M530000000 53 53
94 PRATS TACHÉ, PERE MA1 M052000000 52 52
95 FONOLLOSA AULADELL, XAVIER SEN M000052000 52 52
96 BONFILL SEGURA, MIQUEL ANGEL VE2 M000510000 51 51
97 PEREZ FUSTE, JORDI VE1 M000005100 51 51
98 MARTÍN DOMENECH, JOAN S18 M000051000 51 51
99 OLIVER BLANCH, OSCAR SEN M000005000 50 50
100 LEÓN MORA, AUGUSTO LEO VE2 M000000500 50 50
101 GERARD, DUBENT MA2 M005000000 50 50
102 SAMPER BRUNO, ALBERT VE1 M490000000 49 49
103 SOTO PAREDES, DANIEL VE1 M048000000 48 48
104 GARRIGA SANZ, ANTONI VE1 M480000000 48 48
105 MAIER, TONI VE1 M000000480 48 48
106 OLIVER BLANCH, SERGIO SEN M000004700 47 47
107 MARTINEZ DE LEON, ORIOL VE1 M047000000 47 47
108 SOLÉ SUBIRATS, JULI VE2 M470000000 47 47
109 CASANOVA BERTOMEU, FERRAN SEN M000000470 47 47
110 TURCAN, NICOLAE SEN M000004600 46 46
111 GARCIA BEATO, ALBERT SEN M000004500 45 45
112 BUERA REBULLIDA , JOSEP MIQUEL VE1 M000440000 44 44
113 BENEITO FAUS, RUBEN SEN M000004300 43 43
114 BALLESTE SCIORA, ALEX S18 M043000000 43 43
115 GALINDO AYORA, RUBEN VE1 M000000430 43 43
116 NAVARRO PUIG, GUILLEM MA1 M000420000 42 42
117 REDO MUSSO, ALEX SEN M000004200 42 42
118 COTAINA CABALLE, JAVIER MA1 M042000000 42 42
119 GASPARIN, MARC VE1 M000000420 42 42
120 DURAN PINO, RAFEL VE2 M000410000 41 41
121 BARBERÀ ALSO, JOAQUIM SEN M000004100 41 41
122 DUSSARRAT, ROBIN SEN M041000000 41 41
123 MUR BAGES, JOAN RAMON MA1 M040000000 40 40
124 PAGA FABRA, AGUSTI SEN M038000000 38 38
125 ESPINOSA ZAVALETA, EDGAR RICARDO VE2 M000370000 37 37
126 DUBENT, GERARD MA2 M037000000 37 37
127 MELERO CURTO, JOSEP SEN M000003600 36 36
128 GONZÁLEZ MARCOS, DANIEL VE1 M036000000 36 36
129 MAURI HIERRO, DAVID VE1 M000350000 35 35
130 PUIG VILÀS, ENRIC VE1 M000003500 35 35
131 IGLESIAS MESTRES, JAUME VE2 M000340000 34 34
132 LOMBARTE CAMBERO, JOAN S23 M000003400 34 34
133 ALSO GAS, LLORENS MA1 M000330000 33 33
134 BOIX BERENGUE, ALEIX S23 M000003300 33 33
135 ALAIXENDRI JARDÍ, MAURO VE1 M000003200 32 32
136 DELGADO, FRANCESC VE1 M000310000 31 31
137 CODORNIU CODORNIU, ADRIÀ SEN M000003100 31 31
138 ROMANÍ ALSO, DAVID VE1 M000300000 30 30
139 BARBERÀ ALSO, ANTONI SEN M000003000 30 30
140 PALLARES PEREZ, PAU S18 M000290000 29 29
141 GÓMEZ, JOSE ANTONIO VE2 M000280000 28 28
142 SABORIDO ESCURRIOLA, EDUARD VE1 M000270000 27 27
143 SANTISTEBAN RONCERO, TONI VE2 M000260000 26 26




Amb el suport de: