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. CamarlesL'AmpollaL'AldeaAmpostaDeltebre Total Punts
1 RODA SALES, DAVID VE1 M859311500 293 293
2 DUEÑAS RODRIGUEZ, ALBERTO VE1 M73759300 241 241
3 OUCHBAB, AISSA S18 M115103000 218 218
4 GARCIA REDONDO, DOMINGO VE2 M63717300 207 207
5 MIRO ANDREU, ANTONI MA1 M59677100 197 197
6 SIGÜENZA AMARO, FRANCISCO VE1 M61647000 195 195
7 MARTOS MARTI, ANGEL VE1 M56696900 194 194
8 BERTOMEU BAILE, DAVID VE2 M51666800 185 185
9 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M53626700 182 182
10 ANDREU LOPEZ, AARÓN SEN M54616500 180 180
11 RODRÍGUEZ SALVADÓ, GERARD SEN M68010300 171 171
12 LUQUE LLUCH, OLIVER VE1 M40575900 156 156
13 SEDIKI AIT SILARBI, HAKIM VE2 M36565800 150 150
14 SABORIDO ESCURRIOLA, GENÍS SEN M6707900 146 146
15 ULLDEMOLINS TODÓ, ALFONS VE1 M6507500 140 140
16 GALARZA SANCHEZ, ALEJANDRO VE2 M35485600 139 139
17 LEON PORTES, JOSE LUIS S23 M6473000 137 137
18 BROUGHTON, JIM MA2 M29505400 133 133
19 MARTÍ JOVE, JOSEP MA2 M33455300 131 131
20 RODRIGUEZ GAS, XIMO VE2 M5868000 126 126
21 GABALDA FERRE, ELOI SEN M6006200 122 122
22 AVINYO ARASA, PAU SEN M0596300 122 122
23 LEÓN CORDOVA, EZEQUIEL S18 M24415500 120 120
24 CABALLÉ ANDREU, ENRIC VE1 M0115000 115 115
25 MUR BAGES, JOAN RAMON MA1 M25404900 114 114
26 FRANCH FRANCH, JOAN MARTI SEN M5060000 110 110
27 MONTSERRAT AGUILÓ, ÒSCAR SEN M1030000 103 103
28 ANDREU FERRANDO, XAVIER MA1 M4206000 102 102
29 GONZALEZ REVERTER, RAMON MA1 M4405700 101 101
30 MONLLAO FERRE, PAU SEN M5542000 97 97
31 BONELL GONZALEZ, JOAN VE1 M0445100 95 95
32 ABAGHAD, YOUSSEF SEN M930000 93 93
33 GIL ANTEQUERA, PABLO VE1 M085000 85 85
34 BLANCH BAIGET, JUAN CARLOS SEN M008500 85 85
35 RENALES PRIETO, ALEJANDRO SEN M790000 79 79
36 ALBIOL CHERTA, GERARD SEN M079000 79 79
37 MARTOS MARTI, JOAN VE1 M750000 75 75
38 MOSEGUI TORA, RAFEL VE1 M710000 71 71
39 ARIAS NOGUÉS, ROBERT SEN M700000 70 70
40 BERTOMEU BELLES, CRISTIAN VE1 M070000 70 70
41 SABATÉ MASIP , ADRIÀ VE1 M690000 69 69
42 ALIAU BERTOMEU, JORDI S23 M660000 66 66
43 MARTORELL RUBIO, DANI S18 M006600 66 66
44 EL HAKRAA, MOHAMED S18 M065000 65 65
45 JIMÉNEZ MUR, PERE JOSEP MA1 M006400 64 64
46 CURTO GARCIN, CARLOS SEN M063000 63 63
47 PUIG AGUILO, VICENT SEN M620000 62 62
48 BUERA GILABERT, PAU SEN M006100 61 61
49 VALLESPI GORRITA, JOAN ( X) S18 M058000 58 58
50 GONZÁLEZ CABALLERO, DAVID SEN M570000 57 57
51 GONZÁLEZ PILA , DANIEL VE1 M055000 55 55
52 ALBESA HUERTAS, HILARI SEN M054000 54 54
53 GUIJARRO ÁLVAREZ, SERGIO SEN M053000 53 53
54 GARCIA CERVETO, CARLES SEN M520000 52 52
55 ARASA ARASA, JUAN JOSE MA1 M052000 52 52
56 CERVELLERA SECH, JORDI SEN M005200 52 52
57 BENEDETTI, ALESSANDRO VE1 M051000 51 51
58 SEDIKI NOGALES, ISAAC S18 M005000 50 50
59 BUERA FRANCH, MIQUEL S18 M490000 49 49
60 CID ESPUNY, JOSEP LLUIS MA1 M049000 49 49
61 BUERA REBULLIDA, JOSEP MIQUEL VE1 M480000 48 48
62 AGRAMUNT NAVARRO, ALVARO VE2 M470000 47 47
63 GALVE CURTO, FERNANDO VE2 M047000 47 47
64 MBALLOW, OUSMAN S18 M460000 46 46
65 FORES BAYO, JOAQUIM VE2 M046000 46 46
66 MAURI BONET , JORDI S18 M450000 45 45
67 AYET SALES, DAVID VE2 M430000 43 43
68 CABRERA CABALLÉ, MARCOS VE2 M043000 43 43
69 MARTÍN DOMENECH, JOAN S23 M410000 41 41
70 TORRES , JORGE VE2 M390000 39 39
71 ZAMORA ROS, DAVID VE2 M039000 39 39
72 FERRE VADILLO, ENRIC VE1 M380000 38 38
73 PAGÀ SORRIBES, FRANCESC VE1 M370000 37 37
74 MAURI HIERRO, DAVID VE1 M340000 34 34
75 ALIAU BERTOMEU, JOAN S18 M320000 32 32
76 ALSO GAS, LLORENS MA1 M310000 31 31
77 SERRA ZARAGOZA, PAU S18 M300000 30 30
78 DAUDEN MORENO, MIGUEL SEN M280000 28 28
79 MARGALEF PELEGRIN, JOSEP VE1 M270000 27 27
80 FARRÉ GARCIA, JORDI VE1 M260000 26 26




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.