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 tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, 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, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 MAS CACERES, LLUISMA 1031039311510393115000 725 725
2 ALEMANY SEBASTIA , SAMUEL 79937593937571000 579 579
3 ORTÍN FONT, XAVIER 75858585797385000 567 567
4 OLIVA SIMÓ, JUAN JOSÉ 57586669676467000 448 448
5 COLOMINES CUADRAD, JAUME 7379717175710000 440 440
6 CASTELLS LOPEZ, RAMON 58576463636166000 432 432
7 ABAGHAD, YOUSSEF 11511500115850000 430 430
8 SOTA MARTÍ, JORDI 6665636766630000 390 390
9 CURTO I GILABERT, DAVID 53525457615455000 386 386
10 GOMBAU MURRIA, ELISEU 54455855565760000 385 385
11 ALABART ALCOBER, JOSEP MARIA 0595966656068000 377 377
12 SALES FERRE, ENRIC 610687368690000 339 339
13 PELLICER MARTINEZ, DANI 35405156524650000 330 330
14 SOWE , MUSA 07100857993000 328 328
15 ZARAGOZA VALLDEPEREZ, RAMON 40365244514252000 317 317
16 RIERA I CAIRE, ALBERT 606806259062000 311 311
17 ULLDEMOLINS TODÓ, ALFONS 5139060545054000 308 308
18 PAGA MARGALEF, JOAN PERE 5046535805147000 305 305
19 LLUIS LLANSAMA, GABRIEL 46344846424543000 304 304
20 VALENCIA, MANUEL 004459605965000 287 287
21 QUERAL FORCADELL, XAVI 070103001030000 276 276
22 PRINCEP CARDONA, JESUS 65660707000000 271 271
23 MONTERO PÈREZ, JOSEP MARIA 00065646569000 263 263
24 AVINYO ARASA, PAU 444157005359000 254 254
25 VALLESPI DE LA CRUZ, JORDI 05562640064000 245 245
26 PLA ALONSO, SERGI 334855534900000 238 238
27 RODRIGUEZ SUBIRATS, DAVID 00560574363000 219 219
28 MAIJÓ FRIGOLA, ÀDAM 00000115103000 218 218
29 FATHI, ALI 0073007075000 218 218
30 VIUDEZ TOMÀS, MARTÍ 0757068020000 215 215
31 ADAM CHAVARRIA, CARLOS 0696900073000 211 211
32 MARGALEF JORNET, PERE 6461007100000 196 196
33 SANCHO JOSE, VICTOR 2303735243737000 193 193
34 GONZALEZ GILABERT, OCTAVI 00494746480000 190 190
35 FUCHO PASCUAL, FELIP 022042384442000 188 188
36 ALIMBAU REVERTE, MIQUEL 04246514100000 180 180
37 GAIC, ROBERT DAVID 2515432432039000 178 178
38 SOTOMAYOR DUQUE, XAVI 22745505000000 174 174
39 LLEIXÀ CHAVARRIA, JOSEP 018424820041000 169 169
40 DELLA CALLEN, JUAN JOSE 272531003946000 168 168
41 MONTESÓ JIMENEZ, DAVID 342434363600000 164 164
42 ROMEU ESQUERRÉ, FERNANDO 2426400102531000 156 156
43 ALMENDROS RODA, IGNASI 021323430038000 155 155
44 OLIVA SORIA, ANTONIO 45432137000000 146 146
45 LEON MORA, AUGUSTO LEO 1214262223535000 146 146
46 PELEGRIN SANCHEZ, JOAN CARLES 1362828222622000 145 145
47 RUIZ SERRANO, JUSTINO 18162725151627000 144 144
48 TRESO MASCARELL, MARC 707300000000 143 143
49 MARTOS MARTI, ANGEL 03241293500000 137 137
50 QUERALT ROIG, DANI 36280383400000 136 136
51 PONS TOMÀS, RAMON 716400000000 135 135
52 SORIANO LÓPEZ, MARTÍ 067000680000 135 135
53 FORTUÑO NAVARRO, JOSE LUIS 221917193834000 131 131
54 GRUESO OTALO, ANTONIO 680000058000 126 126
55 SEBASTIA VALLDEPEREZ, JORDI 10730393700000 123 123
56 CID ESPUNY, JOSEP LLUIS 2217018161732000 122 122
57 FERNANDO ROYAL, JOSEP ENRIC 31002729320000 119 119
58 ESPANYA SERRET, MARCEL 000062550000 117 117
59 PLA SEGURA, EDU 001150000000 115 115
60 MARGALEF BENAIGES, PAU 000540061000 115 115
61 CÓZAR TORÁN, PEDRO 555400000000 109 109
62 SOLE CRESPI, JOSEP 000053560000 109 109
63 MORENO GALLARDO, JOSE LUIS 000055490000 104 104
64 SERRET ROIG, ADRIA 35241521360000 104 104
65 GUTIERREZ GARCIA, CRISTIAN 000103000000 103 103
66 REDÓ VIUDEZ, CARLOS 056000470000 103 103
67 MARTIN ARASA, JOSEP 29002131210000 102 102
68 SEDIKI AIT SILARBI, HAKIM 511181462917000 100 100
69 LLEIXA GUARRO, IVAN 490500000000 99 99
70 VALDIVIAS AHUMADA, OSCAR 6851393024000 95 95
71 MARTOS MARTI, JOAN 93000000000 93 93
72 GARCIA SUAREZ, JULIO CESAR 000040048000 88 88
73 RIPOLL BENAIGES, FERRAN 430043000000 86 86
74 RIBES SERRA, JOSEP MARIA 83256131912000 86 86
75 MONTEVERDE GRAU, GERARD 85000000000 85 85
76 GRAU SANZ, MAX 380004700000 85 85
77 FERRÉ, ARNAU CASACUBERTA FERRÉ 033052000000 85 85
78 MESTRE QUEROL, ALBERT 00790000000 79 79
79 DURA CREMADES, RICARDO 00079000000 79 79
80 DE TORRES BURGOS, FERRAN 00000079000 79 79
81 GARCIA SANGÜESA, DAMIÀ 393700000000 76 76
82 FIBLA REVERTER, HERMINI 00170122225000 76 76
83 ALSO SELMA, MIQUEL 00075000000 75 75
84 VIDIELLA CURTO, SERGI 1929000270000 75 75
85 GOMEZ RODRIGUEZ, ERIC 000004133000 74 74
86 ARAGON MORA , FELIP 2100002429000 74 74
87 BALASTEGUI CONTRERAS, FRANCISCO 00007300000 73 73
88 GRATOVIL PEREZ, ENRIC 000002845000 73 73
89 LLUCH ARBONA, DAVID 031000400000 71 71
90 CASTELLS BARRACHINA, BLAY 00000070000 70 70
91 BELLART SANS, MIQUEL 69000000000 69 69
92 GARCIA REDONDO, DOMINGO 00006900000 69 69
93 ESTORACH SOL, OSCAR 67000000000 67 67
94 VILAR ALCÁZAR, DAVID 00000670000 67 67
95 GUIMERA FIBLA, CHRISTIAN 00670000000 67 67
96 DELLA CALLEN, CARLOS 000003136000 67 67
97 CAPELL BUENDIA, ANTONI 00000660000 66 66
98 LUQUE LLUCH, OLIVER 2221272021000 66 66
99 MARGALEF BORRELL, JOSEP 2281621323000 66 66
100 NOU CASTELL, RAMON 00650000000 65 65
101 MARINE OLLE, PACO 003332000000 65 65
102 ALBESA ABADAL, ANDRES 63000000000 63 63
103 RAMOS ALFONSO, ANTONIO 06300000000 63 63
104 MARIN MARIN, DANIEL 62000000000 62 62
105 SUÑER CARLES, PAU 06200000000 62 62
106 SANS GRAU, DAVID 00000620000 62 62
107 CID MESEGUER, SIMON 323000000000 62 62
108 ABAT BARRERA, IVAN 00610000000 61 61
109 SERRA BENEDICTO, JOAN 00061000000 61 61
110 GAS PANISELLO, DAVID 06000000000 60 60
111 CASADO, ALEX 00600000000 60 60
112 GIMENEZ BELLOBI, JORDI 59000000000 59 59
113 FOLCH GOMIS, ALEIX 00005800000 58 58
114 ROYO GUILLEM, ANDREU 00000580000 58 58
115 MATHEU GAS, XAVI 00000057000 57 57
116 BELTRAN MARTINEZ-AGUADO, RAMON 56000000000 56 56
117 RUBIO DIAZ, MARC 00000056000 56 56
118 DOMINGUEZ ARASA, JOSEP 05300000000 53 53
119 OLLE CAMPAMA, FRANCESC 00000053000 53 53
120 CID MARTI, JORDI 52000000000 52 52
121 BUERA REBULLIDA , JOSEP MIQUEL 00000520000 52 52
122 ESCUDERO COROMINES, DANI 05100000000 51 51
123 ALBACAR GARCIA, MARCEL 00000051000 51 51
124 DUEÑAS RODRIGUEZ, ALBERTO 05000000000 50 50
125 SABORIDO ESCURRIOLA, EDUARD 04900000000 49 49
126 FIGUERAS MONER, RAMON 00049000000 49 49
127 FRANCH MARRO, XAVIER 00000049000 49 49
128 ASÍN QUEROL, JAVI 48000000000 48 48
129 ROMERO BELTRAN, ANTONIO 00004800000 48 48
130 LOPEZ GIL, DENIS 47000000000 47 47
131 FERNANDEZ FUERTES, ALEX 04700000000 47 47
132 SANCHEZ LLOPIS, ROBERTO 00470000000 47 47
133 CABRERA CABALLÉ, MARCOS 7131300014000 47 47
134 SABATER, JOSEP MARIA 00004500000 45 45
135 LECOMMANDOUX, DANIEL 00045000000 45 45
136 VENTURA CASTELLS, JOAN 04400000000 44 44
137 CAPARRÓS APARICIO, ORIOL 00004400000 44 44
138 BUSTINDUY CASTILLO, IVÁN 00000044000 44 44
139 MOTES MARTINEZ, LUIS 00004300000 43 43
140 BALAGUE BELTRAN, JOAQUIN 140290000000 43 43
141 MORILLO PORRAS, DAVID 22390000000 43 43
142 MORENO GARCIA, JUAN 42000000000 42 42
143 MORILLO PORRAS, JUAN ANTONIO 22380000000 42 42
144 TONDA SALVADO, MANEL 41000000000 41 41
145 GALVE TORRES, JOAN CARLES 00041000000 41 41
146 RODES HORTA, GERARD 00040000000 40 40
147 ALEIXENDRI ARRIBA, RAMON 00000040000 40 40
148 GOMEZ AUSACH, ANDREU 00003900000 39 39
149 KLESHNIN, VOVOL 03800000000 38 38
150 CUGAT MULET, JAUME 22000340000 38 38
151 MARTI GUARI, DAVID 2001001115000 38 38
152 ESQUERRE, EROS 37000000000 37 37
153 MARZA PLA, XAVI 00360000000 36 36
154 CALDUCH GARCIA, JUAN 03500000000 35 35
155 BROUGHTON, JIM 2238479000 35 35
156 BERTOMEU CURTO, JOEL 00003300000 33 33
157 LLITRÀ VIRGILI, ESTEVE 00000330000 33 33
158 BELDA SÁNCHEZ, AGUSTÍ 00033000000 33 33
159 ALONSO QUESADA, OSCAR 30000200000 32 32
160 JUANPERE POBLET, MANEL 00031000000 31 31
161 MARGALEF LLAO, TIBURCI ANDREU 00030000000 30 30
162 BORRAS MARTINEZ, GERARD 00000030000 30 30
163 SANS FERRER, ALBERT 00200028000 30 30
164 SUBIRATS CID, JORDI 92070120000 30 30
165 BRET GALI , JORDI 22222218000 30 30
166 SORIANO LOPEZ, ANTONIO 28000000000 28 28
167 VALMAÑA, ELOY 00002800000 28 28
168 ALBA RODRIGUEZ, TONI 26000020000 28 28
169 FANDOS COLOMINES, FELIP 00022816000 28 28
170 DURA CONDE, RAUL 00002700000 27 27
171 FERRE BALSELLS, RAMON 00002600000 26 26
172 ALFONSO GOMEZ, SANTIAGO 00026000000 26 26
173 ADAM CHAVARRIA, FERRAN 00000026000 26 26
174 PONS URQUIZU, JOSE MARIA 00600020000 26 26
175 BERTOMEU BAILE, DAVID 00002500000 25 25
176 FUMADO CASANOVA, JUAN JOSE 02032513000 25 25
177 ROMERO VILLANUEVA, JUAN CARLOS 02300000000 23 23
178 HERNÁNDEZ CARPIO, ALEJANDRO 00002300000 23 23
179 RIBAS BEL, ALBERT 00230000000 23 23
180 RIBER CHALER, EDGAR 00000230000 23 23
181 VERNET FALCÓ, IGNASI 00023000000 23 23
182 SUOMINEN, IRRON 00220000000 22 22
183 AGUILAR BONAVIDA, ESTEVE 20000000000 20 20
184 CABRÉ, MARIÀ 02000000000 20 20
185 VACHERESSE ORTIZ, STEPHANE 00200000000 20 20
186 DOMENECH QUEROL, AITOR 00020000000 20 20
187 PEREZ FRANCH, JOAN 01900000000 19 19
188 FRANCH PINYOL, NARCIS 00019000000 19 19
189 REYES CUBELLS, MARC 00000019000 19 19
190 REVERTER BULLON, JOSE MIGUEL 40100230000 19 19
191 GALARZA SANCHEZ, ALEJANDRO 2225242000 19 19
192 CASTEJON, JOSE 00001800000 18 18
193 TORRENT NAVARRO, ENRIC 00000180000 18 18
194 TOMÀS GINÉ, GUILLEM 02140200000 18 18
195 CASTELLS FABRA, LLUIS 2222226000 18 18
196 CAMACHO TEVAS, JOSEP 17000000000 17 17
197 CID CLUA, JAUME 00001700000 17 17
198 CHAVARRIA GARCIA, PERE 16000000000 16 16
199 CIFRE SOSPEDRA, JOSE ANGEL 00160000000 16 16
200 HERNANDEZ RODRIGUEZ, CARLOS 2202028000 16 16
201 CHAVARRIA GARCIA, ENRIC 15000000000 15 15
202 CARLES PERIS, JOSEP 00000150000 15 15
203 FIBLA REVERTER, ANTONI 00150000000 15 15
204 NIVERA TORRES, MARC 00001400000 14 14
205 CÁCERES AZNAR, KARIM 00000140000 14 14
206 GARCIA DRAGO, JOSEP 20110000000 13 13
207 CAMACHO MARGALEF, DAVID 01200000000 12 12
208 CURTO BAIGES, ALBERT 00120000000 12 12
209 PELLICER DIAZ, JOSEP JOAQUIM 11000000000 11 11
210 MARÍN GIMÉNEZ, FERNANDO 00001100000 11 11
211 AZNAR RUIZ, CHRISTIAN 00011000000 11 11
212 LANGE EBRI, ARTURO 00000011000 11 11
213 SOTO PAREDES, DANIEL 01000000000 10 10
214 CORRALES ARNAU, RAFEL 00000100000 10 10
215 MASOLLER ARIAS, FRANCESC 00000010000 10 10
216 ALIAU PONS, JOAN JOSEP 2222020000 10 10
217 CURTO IBAÑEZ, ADRIA 0900000000 9 9
218 VAQUERIZO RODRIGUEZ, EDUARDO 0000090000 9 9
219 TORRENT OLLÉ, JORDI 0090000000 9 9
220 LOPEZ MORENO, CRISTIAN 0009000000 9 9
221 RODA MARTINEZ, SANTIAGO DAVID 0000800000 8 8
222 BELTRAN SUBIRATS, JOSEP MARIA 0222200000 8 8
223 MILLAN MASDEU, JOAN IGNASI 2220002000 8 8
224 ESPANYA FORCADELL, ANTONI 0070000000 7 7
225 ALEIXANDRI AUDÍ , JOSEP RAMON 0000007000 7 7
226 TORRES BERTOMEU, JOSEP 0000060000 6 6
227 MARGALEF PELEGRIN, JOSEP 2000220000 6 6
228 TOMÀS TORRES, ISMAEL 0202200000 6 6
229 TORRES , JORGE 0000500000 5 5
230 CANO LEON, RICARDO 0000005000 5 5
231 MARINAS VALLS, IVAN 0400000000 4 4
232 ALBESA RUBIO, XAVIER 0040000000 4 4
233 SERRAL ZARAGOZA, JOAN 0004000000 4 4
234 BORUP, SINE 0000004000 4 4
235 CAÑÍS SÁNCHEZ, DANIEL 2200000000 4 4
236 SERRET GOMEZ, JUAN CARLOS 0220000000 4 4
237 FOLCH, JOSEP MARIA 0002200000 4 4
238 PÉREZ SANZ, RAÚL 0000022000 4 4
239 ALÚTIZ ESPAÑA, XAVIER 0000300000 3 3
240 NIELSEN, MICHKEL 0000003000 3 3
241 NEBREDA PERELLO, ANGEL 2000000000 2 2
242 JIMÉNEZ CATALÁ, ANDREU 0000200000 2 2
243 FONOLLOSA AULADELL, XAVIER 0200000000 2 2
244 GRANGÉ GALINDO, JOSEP LLUIS 2000000000 2 2
245 ESPINOSA VILLAR, JOSE MANUEL 2000000000 2 2
246 ARASA ARASA, JUAN JOSE 0000200000 2 2
247 TERAN GOMEZ, JOAN 2000000000 2 2
248 VILLARES FERNÁNDEZ, MARTÍN 0000020000 2 2
249 ALVAREZ GUTIERREZ, RUBEN 0200000000 2 2
250 FORCADELL, DANI 0000200000 2 2
251 CASTAÑO DE LA ASUNCION, JUAN CARLOS 0200000000 2 2
252 VENTURA GILABERT, SERGI 2000000000 2 2
253 CLUA GAYA, MARC 0000020000 2 2
254 CUGAT TOMAS, CLAUDIO 0000020000 2 2
255 MONTOYA LECEGUI, SANTI 0200000000 2 2
256 ROCA ALGUERÓ, JOAN 0000200000 2 2
257 PONS ALEMAN, ALEX 0020000000 2 2
258 KONFIDERA, RUDSON 2000000000 2 2
259 TIRON CAMISON, JAUME 0000020000 2 2
260 ALBESA ARASA, JOAN 2000000000 2 2
261 TAIDLER, FLORIN 0000020000 2 2
262 FERRÁNDIZ LARRAMONA, JAVIER 0000200000 2 2
263 PRADES PRADES, JOSEP M. 0200000000 2 2
264 VARELA, JOSEP MANEL 0000200000 2 2
265 DELGADO, FRANCESC 2000000000 2 2
266 SERRET ABELLA, ELOI 0200000000 2 2
267 CHAVARRIA ARAGONES, JOAN 0000200000 2 2
268 RAMON FARGA, ÀNGEL 2000000000 2 2
269 SERRANO JURADO, DANIEL 0200000000 2 2
270 AZNAR LOPEZ, FRANCISCO JOSE 0000020000 2 2
271 GOMBAU SOLÉ, CARLOS 0020000000 2 2
272 SEGARRA VICENTE, ALEXANDRE 2000000000 2 2
273 TAFALLA ANDREU, QUIM 0000200000 2 2
274 GRAU ROCA, ÀLEX 0002000000 2 2
275 CARTES REVERTÉ, TONI 2000000000 2 2
276 SOMMES, ANDREAS 0200000000 2 2
277 ROSELLO CASTELLS, ORIOL 0000020000 2 2
278 ALBILLOS BLANCO, JOSÉ LUÍS 2000000000 2 2
279 PELLICER ABELLANEDA, DANIEL 0200000000 2 2
280 ESPINOSA ZAVALETA, EDGAR RICARDO 0000020000 2 2
281 NAUMBURGER, KLAUS 0200000000 2 2
282 ALVENTOSA LARA, RAFAEL 0200000000 2 2
283 FRANCH BONET, ROSANA 0200000000 2 2
284 MONFORTE GARGALLO, PACO 0002000000 2 2
285 CASANOVA BORRAS, CARLES 0000002000 2 2