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 M11507911567000 376 376
2 GARCIA REDONDO, DOMINGO VE2 M7975715975000 359 359
3 SANAHUJA BARRANCO, JOSEP RAMON VE2 M01037575103000 356 356
4 CAMPOY LOZANO, JUAN VE1 M7144686370000 316 316
5 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M6364635557000 302 302
6 RIERA I CAIRE, XAVIER S18 M757306771000 286 286
7 MACHI CABALLE, OMAR SEN M93930930000 279 279
8 SEDIKI AIT SILARBI, HAKIM VE2 M5856614856000 279 279
9 FUCHO PASCUAL, FELIP MA1 M706905865000 262 262
10 ESTORACH SOL, OSCAR SEN M103850690000 257 257
11 BERTOMEU BAILE, DAVID VE2 M676805660000 251 251
12 MARGALEF BORRELL, JOSEP MA1 M5250514349000 245 245
13 ORTEGA BLANCO, JAIME VE1 M626162570000 242 242
14 GALARZA SANCHEZ, ALEJANDRO VE2 M5446523250000 234 234
15 ALMENDROS RODA, IGNASI VE2 M665164520000 233 233
16 MARTÍ JOVE, JOSEP MA1 M5045533648000 232 232
17 FUMADO GISBERT, ORIOL S18 M054566058000 228 228
18 LUQUE LLUCH, OLIVER VE1 M656057450000 227 227
19 BALAGUE BELTRAN, JOAQUIN VE1 M575558500000 220 220
20 RODRIGUEZ SUBIRATS, DAVID VE1 M73006569000 207 207
21 ROCA REY, ROGER SEN M514954400000 194 194
22 JIMÉNEZ BRANERA , DANI SEN M00666262000 190 190
23 RODA SALES, DAVID VE1 M0007993000 172 172
24 GONZALEZ REVERTER, RAMON MA1 M55004755000 157 157
25 BLANCH ALSO, ARNAU S18 M0790073000 152 152
26 GOMEZ AUSACH, ANDREU SEN M6867000000 135 135
27 LLUCH ARBONA, FRANCESC VE1 M6406500000 129 129
28 MARTOS MARTI, ANGEL VE1 M0006163000 124 124
29 ALONSO QUESADA, OSCAR VE2 M0650059000 124 124
30 ABAGHAD, YOUSSEF S23 M0115000000 115 115
31 ULLAH, AHSAN VE1 M0000115000 115 115
32 MAIJÓ FRIGOLA, ÀDAM S23 M0011500000 115 115
33 BERTOMEU CASANOVA, AARON SEN M5657000000 113 113
34 GABALDA FERRE, ELOI SEN M0059540000 113 113
35 PEDROL PASCUAL, OSCAR S23 M0620460000 108 108
36 RIBES SERRA, JOSEP MARIA VE2 M0530053000 106 106
37 REMOLINA RALLO, FERRAN SEN M0001030000 103 103
38 CARMONA PARADA, FRANCESC VE1 M0010300000 103 103
39 CUBELLS I CUBELLS, HERIBERT SEN M009300000 93 93
40 GARRIGUES MONLEON , VICENTE VE1 M000850000 85 85
41 COLI MUNAR, PERE S23 M850000000 85 85
42 LOPEZ GIL, DENIS VE1 M000085000 85 85
43 BENAIGES MARGALEF, JOSEP VE1 M008500000 85 85
44 VALLESPI DE LA CRUZ, JORDI VE1 M000079000 79 79
45 LÓPEZ SANZ , IKER VE1 M000730000 73 73
46 LEANDRO QUERO, JORDI VE1 M007300000 73 73
47 GARCÍA ANTA , JESUS VE1 M000710000 71 71
48 PAGA MARGALEF, JOAN PERE VE1 M071000000 71 71
49 DELGADO ARAGONESES, VÍCTOR VE1 M000700000 70 70
50 CASAS CABRERA, PACO SEN M070000000 70 70
51 ESPINOSA CALLAU, CARLOS S18 M007000000 70 70
52 CÁCERES AZNAR, KARIM SEN M690000000 69 69
53 VALENCIA, MANUEL VE2 M006900000 69 69
54 ROYO GUILLEM, ANDREU VE1 M000680000 68 68
55 PRINCEP CARDONA, JESUS VE1 M000068000 68 68
56 CAPTARI, FABIAN ESTEBAN S23 M006700000 67 67
57 DEL VALLE PUIG, ADRIA SEN M000660000 66 66
58 ASMOUH, MOHAMED S18 M066000000 66 66
59 PRADES NADAL, MARC S18 M000066000 66 66
60 BELTRAN ARQUES, JUAN FRANCISCO VE2 M000640000 64 64
61 AFSFAS, MOHAMED S18 M000064000 64 64
62 HAMDOUNI, AYOUB S23 M063000000 63 63
63 LLUIS LLANSAMA, ANTONIO VE1 M610000000 61 61
64 PRADES NADAL, PAU S18 M000061000 61 61
65 FERRE FOLCH, DAVID VE2 M600000000 60 60
66 MAIJÓ FRIGOLA, ABEL SEN M006000000 60 60
67 ARASA FORNOS, OSCAR VE2 M0350250000 60 60
68 ALMENDROS GARCIA, FERRAN S18 M059000000 59 59
69 PALMER FERRER, PERE VE2 M590000000 59 59
70 CURTO GARCIN, CARLOS SEN M058000000 58 58
71 FANDOS COLOMINES, FELIP VE1 M005500000 55 55
72 GONZÁLEZ CABALLERO, DAVID SEN M000054000 54 54
73 ESPINOSA VILLAR, BORJA VE1 M000530000 53 53
74 VECIANA CARBONELL, JOSEP VE1 M530000000 53 53
75 PRATS TACHÉ, PERE MA1 M052000000 52 52
76 FONOLLOSA AULADELL, XAVIER SEN M000052000 52 52
77 BONFILL SEGURA, MIQUEL ANGEL VE2 M000510000 51 51
78 MARTÍN DOMENECH, JOAN S18 M000051000 51 51
79 GERARD, DUBENT MA2 M005000000 50 50
80 CASTELLS CASANOVA, JOEL SEN M000490000 49 49
81 SAMPER BRUNO, ALBERT VE1 M490000000 49 49
82 SOTO PAREDES, DANIEL VE1 M048000000 48 48
83 GARRIGA SANZ, ANTONI VE1 M480000000 48 48
84 MARTINEZ DE LEON, ORIOL VE1 M047000000 47 47
85 SOLÉ SUBIRATS, JULI VE2 M470000000 47 47
86 BUERA REBULLIDA , JOSEP MIQUEL VE1 M000440000 44 44
87 BALLESTE SCIORA, ALEX S18 M043000000 43 43
88 NAVARRO PUIG, GUILLEM MA1 M000420000 42 42
89 COTAINA CABALLE, JAVIER MA1 M042000000 42 42
90 DURAN PINO, RAFEL VE2 M000410000 41 41
91 DUSSARRAT, ROBIN SEN M041000000 41 41
92 MUR BAGES, JOAN RAMON MA1 M040000000 40 40
93 FRANCH FRANCH, JOAN MARTI SEN M000390000 39 39
94 GARBI HUERGA, CARLOS TOMÁS VE1 M039000000 39 39
95 BELTRAN, MANEL SEN M000380000 38 38
96 PAGA FABRA, AGUSTI SEN M038000000 38 38
97 ESPINOSA ZAVALETA, EDGAR RICARDO VE2 M000370000 37 37
98 DUBENT, GERARD MA2 M037000000 37 37
99 GONZÁLEZ MARCOS, DANIEL VE1 M036000000 36 36
100 MAURI HIERRO, DAVID VE1 M000350000 35 35
101 IGLESIAS MESTRES, JAUME VE2 M000340000 34 34
102 ALSO GAS, LLORENS MA1 M000330000 33 33
103 DELGADO, FRANCESC VE1 M000310000 31 31
104 ROMANÍ ALSO, DAVID VE1 M000300000 30 30
105 PALLARES PEREZ, PAU S18 M000290000 29 29
106 GÓMEZ, JOSE ANTONIO VE2 M000280000 28 28
107 SABORIDO ESCURRIOLA, EDUARD VE1 M000270000 27 27
108 SANTISTEBAN RONCERO, TONI VE2 M000260000 26 26




Amb el suport de: