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 dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, 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, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 FATHI, ALI SEN M851031151150000000 418 418
2 SOWE , MUSA VE1 M7993851030000000 360 360
3 ALABART ALCOBER, JOSEP MARIA VE2 M607169750000000 275 275
4 SOTA MARTÍ, JORDI VE1 M596766710000000 263 263
5 SALES FERRE, ENRIC SEN M70850930000000 248 248
6 CASTELLS LOPEZ, RAMON VE1 M475764730000000 241 241
7 CURTO I GILABERT, DAVID VE2 M495863690000000 239 239
8 OUHDADI, YASSINE SEN M115115000000000 230 230
9 PUENTES GARCÍA, LUIS FCO VE2 M07568790000000 222 222
10 GOMBAU MURRIA, ELISEU SEN M505559570000000 221 221
11 ZARAGOZA VALLDEPEREZ, RAMON VE1 M435254620000000 211 211
12 MIRO ANDREU , ANTONI MA1 M465151590000000 207 207
13 CARBÓ FRANCH, ÉRIAN S23 M314853660000000 198 198
14 JUAN-CAMPS CASTELL, AGUS VE1 M93010300000000 196 196
15 LLEIXA GUARRO, IVAN VE1 M05657670000000 180 180
16 ASÍN QUEROL, JAVI VE1 M55596500000000 179 179
17 VALLESPI DE LA CRUZ, JORDI VE1 M52635800000000 173 173
18 ALEMANY SEBASTIA , SAMUEL VE1 M7509300000000 168 168
19 ULLDEMOLINS TODÓ, ALFONS VE1 M45056560000000 157 157
20 GAUXACHS FONT, DAVID SEN M44540580000000 156 156
21 GUART AUXACHS, JOAN VE1 M124546500000000 153 153
22 COLOMINES CUADRAD, JAUME SEN M0737300000000 146 146
23 TRESO MASCARELL, MARC SEN M6907500000000 144 144
24 GINÉ CID, ALBERT VE1 M6379000000000 142 142
25 VILLAR MORERA, JOSE LUIS VE1 M174038470000000 142 142
26 LLEIXÀ CHAVARRIA, JOSEP VE2 M282535520000000 140 140
27 MONTERO PÈREZ, JOSEP MARIA VE2 M6269000000000 131 131
28 TOMAS PORRES, CARLOS VE1 M38494300000000 130 130
29 CABANES CALVET, ALBERT VE2 M182932450000000 124 124
30 RIERA I CAIRE, ALBERT S23 M6161000000000 122 122
31 LLUIS LLANSAMA, GABRIEL VE2 M33430440000000 120 120
32 ESCURRIOLA NAVARRO, RAMON VE2 M03336490000000 118 118
33 CASTELLS SEGARRA, ANTONI SEN M0052640000000 116 116
34 VALMAÑA, ELOY VE1 M29444100000000 114 114
35 CUGAT MULET, JAUME VE1 M02639460000000 111 111
36 PELLICER MARTINEZ, DANI SEN M4800610000000 109 109
37 MARTOS MARTI, ANGEL VE1 M30393700000000 106 106
38 MENDEZ PRUNERA, ALEX SEN M1030000000000 103 103
39 GRAU VIDAL, ALBERTO VE1 M0048540000000 102 102
40 GAIC, ROBERT DAVID SEN M222225320000000 101 101
41 FERRË CANALS, TONI MA1 M02434420000000 100 100
42 SABATER CABRERA, ENRIC VE2 M0465000000000 96 96
43 FIBLA REVERTER, HERMINI VE2 M82823340000000 93 93
44 RUIZ SERRANO, JUSTINO MA2 M19320400000000 91 91
45 BERTOMEU CURTO, JOEL SEN M91631310000000 87 87
46 CURTO BAIGES, ALBERT SEN M02327360000000 86 86
47 TARRAGÓ COLOMER, ROBERT VE1 M000850000000 85 85
48 SANCHO JOSE, VICTOR MA1 M21300330000000 84 84
49 ESQUERRE FERRE, ROMAN VE2 M3647000000000 83 83
50 TORRES , JORGE VE1 M02022390000000 81 81
51 PLA SEGURA, EDU SEN M007900000000 79 79
52 LLORCA PINTOR, FCO. JAVIER SEN M01920370000000 76 76
53 SORIANO LOPEZ, ANTONIO VE1 M3504000000000 75 75
54 FORNÉ CASTELLS, XAVIER VE2 M730000000000 73 73
55 REDÓ GÓMEZ, JUAN CARLOS VE1 M0314200000000 73 73
56 PELEGRIN SANCHEZ, JOAN CARLES MA1 M13021380000000 72 72
57 MARTOS MARTI, JOAN SEN M710000000000 71 71
58 CARRILLO HERNANDEZ, DAVID VE1 M007100000000 71 71
59 VIUDEZ TOMÀS, MARTÍ VE1 M070000000000 70 70
60 NOU CASTELL, RAMON VE1 M007000000000 70 70
61 FOLCH PUIG, ENRIC VE1 M000700000000 70 70
62 CURTO ARAGONÉS, MARC SEN M680000000000 68 68
63 SUÑER CARLES, PAU SEN M068000000000 68 68
64 DUEÑAS RODRIGUEZ, ALBERTO VE1 M000680000000 68 68
65 RENALES PRIETO, ALEJANDRO SEN M670000000000 67 67
66 SORIANO LÓPEZ, MARTÍ VE1 M006700000000 67 67
67 SERRET ROIG, ADRIA VE2 M23150290000000 67 67
68 PEREZ MUÑOZ, FRANCISCO JESUS VE2 M660000000000 66 66
69 DOMINGUEZ ARASA, ALBERT SEN M066000000000 66 66
70 CABALLÉ ANDREU, ENRIC VE1 M650000000000 65 65
71 MONLLEO ROYO, LIBERTO VE2 M065000000000 65 65
72 GARRIGA MARÍ, JOSEP VE1 M000650000000 65 65
73 FERNANDO ROYAL, JOSEP ENRIC VE1 M0030350000000 65 65
74 RODA JIMENEZ, JOSEP SEN M640000000000 64 64
75 PALAU CIVIT, JORDI VE1 M064000000000 64 64
76 VILANOVA ARDIT, JOSEP VE1 M000630000000 63 63
77 QUERALT ROIG, DANI VE1 M2538000000000 63 63
78 REDÓ VIUDEZ, CARLOS SEN M062000000000 62 62
79 GÜELL VILLAR, ORIOL VE1 M006200000000 62 62
80 SANZ CASTELL, RAUL SEN M006100000000 61 61
81 REPISO MARTINEZ, JOAN VE2 M060000000000 60 60
82 RIBERA ROIG, PABLO VE1 M006000000000 60 60
83 ESCODA SERRES, JORDI VE1 M000600000000 60 60
84 FORTUÑO NAVARRO, JOSE LUIS VE2 M31016300000000 59 59
85 ALBESA ABADAL, ANDRES VE1 M580000000000 58 58
86 MARIN MARIN, DANIEL SEN M570000000000 57 57
87 QUERAL FORCADELL, DAVID VE1 M560000000000 56 56
88 SOTOMAYOR DUQUE, XAVI VE1 M3202400000000 56 56
89 MARZA PLA, XAVI S23 M005500000000 55 55
90 REVELLES PI, ADRIÀ SEN M000550000000 55 55
91 GIMENEZ BELLOBI, JORDI SEN M540000000000 54 54
92 TORRES BERTOMEU, JOSEP VE1 M01115280000000 54 54
93 GRAU SANZ, MAX VE2 M530000000000 53 53
94 CAMARERO LÓPEZ, GUILLERMO VE1 M053000000000 53 53
95 CID GUBAU, ORIOL SEN M000530000000 53 53
96 TONDA SALVADÓ, JOSEP LLUIS VE2 M510000000000 51 51
97 GARCIA SUAREZ, JULIO CESAR VE1 M000510000000 51 51
98 CURTO RUE, DAVID VE1 M050000000000 50 50
99 GRANGÉ GALINDO, JOSEP LLUIS VE2 M21214220000000 50 50
100 FERNANDEZ AGUIAR, MANU VE1 M004900000000 49 49
101 TALARN CAUBET, JOAQUIM VE1 M1435000000000 49 49
102 FERRÉ, ARNAU CASACUBERTA FERRÉ SEN M000480000000 48 48
103 BELTRAN ARQUES, JUAN FRANCISCO VE2 M004700000000 47 47
104 LOPEZ FARINOS, DANIELA S18 M004500000000 45 45
105 MARESMA FELIPO, JOAN VE2 M004400000000 44 44
106 SOTA MARTI, CARLOS VE2 M000430000000 43 43
107 VELASCO, PASCAL MA1 M420000000000 42 42
108 ESCUDERO COROMINES, DANI VE1 M042000000000 42 42
109 PIQUERA NARANJO , OSCAR VE1 M410000000000 41 41
110 FRANCH VENTURA, PERE VE1 M041000000000 41 41
111 SEGARRA FARNÓS, SERGI SEN M000410000000 41 41
112 CORTÉS CALVO, MANU VE1 M400000000000 40 40
113 SEBASTIA VALLDEPEREZ, JORDI VE1 M670270000000 40 40
114 GARCIA SANGÜESA, DAMIÀ VE2 M390000000000 39 39
115 CID ESPUNY, JOSEP LLUIS MA1 M2001800000000 38 38
116 ALIMBAU REVERTE, MIQUEL VE2 M370000000000 37 37
117 GARGALLO ROYO, JOSE RAMÓN SEN M037000000000 37 37
118 PEREZ FRANCH, JOAN VE1 M036000000000 36 36
119 ACERO VENDRELL, ALVARO VE2 M340000000000 34 34
120 MIGUEL GARRIDO, JOSÉ ANTONIO VE1 M034000000000 34 34
121 CAÑÍS SÁNCHEZ, DANIEL VE2 M225250000000 34 34
122 FABREGAT CAMPOS, NIL S23 M003300000000 33 33
123 LANGE EBRI, ARTURO MA1 M227210000000 32 32
124 GOMEZ ROMEU, GERARD SEN M0130180000000 31 31
125 NOFRE ROMERA, DOMINGO VE1 M002900000000 29 29
126 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M002800000000 28 28
127 ESCODA MARTIN, ISMAEL VE1 M270000000000 27 27
128 MONFORT BEL, ALBERT SEN M027000000000 27 27
129 PLA ALONSO, SERGI SEN M260000000000 26 26
130 NOFRE ROMERA, PEDRO SEN M002600000000 26 26
131 VALMAÑA CALBET, PAU SEN M000260000000 26 26
132 REVERTER BULLON, JOSE MIGUEL VE2 M222200000000 26 26
133 REDO PRINCEP, RICARD VE1 M240000000000 24 24
134 FUMADO CASANOVA, JUAN JOSE MA1 M000240000000 24 24
135 GARCIA I BERTRAN, JOAN VE1 M000230000000 23 23
136 LOPEZ MORENO, CRISTIAN SEN M021000000000 21 21
137 HERNANDEZ RODRIGUEZ, CARLOS MA1 M202170000000 21 21
138 ADELL WINKLER, PERE VE2 M220160000000 20 20
139 GUZMAN MORCILLO, PACO VE2 M001900000000 19 19
140 GARBI HUERGA, CARLOS TOMÁS VE1 M000190000000 19 19
141 DAZA BERENGUER, DANI VE1 M018000000000 18 18
142 DOMINGUEZ MARCH, OSCAR SEN M017000000000 17 17
143 MARTORELL RUBIO, JORDI VE2 M001700000000 17 17
144 FORNÓS MONLLAU, MARC VE1 M160000000000 16 16
145 CASTELLS FABRA, LLUIS VE1 M200140000000 16 16
146 LLETI NAVARRO, FERNANDO VE2 M150000000000 15 15
147 SABATE SABATE, JAVIER SEN M000150000000 15 15
148 ESPINOSA VILLAR, BORJA VE1 M201300000000 15 15
149 SUBIRATS FERRERES, IVAN VE1 M014000000000 14 14
150 MIRALLES LLORCA, JESÚS VE1 M031000000000 13 13
151 RODEZNO ELVIR, DANIEL VE1 M001200000000 12 12
152 ROMEU ESQUERRÉ, FERNANDO VE1 M110000000000 11 11
153 GINE CARRASCO, JOSE SEN M001100000000 11 11
154 QUIRÓS PONFERRADA, DAVID VE1 M100000000000 10 10
155 MARTI GUARI, DAVID VE2 M09000000000 9 9
156 SANS FERRER, ALBERT VE1 M00900000000 9 9
157 SOLÉ PÀMIES, RAMON VE2 M08000000000 8 8
158 MARTIN ARASA, JOSEP VE1 M00800000000 8 8
159 LEÓN MORA, AUGUSTO LEO VE2 M70000000000 7 7
160 BAIGET FARRÉ, JAUME SEN M25000000000 7 7
161 MARRO BELLOT, CRISTIAN SEN M06000000000 6 6
162 PEDROL PASCUAL, OSCAR S23 M00600000000 6 6
163 SERRET GOMEZ, JUAN CARLOS VE1 M22200000000 6 6
164 VALDIVIAS AHUMADA, OSCAR VE2 M50000000000 5 5
165 SERRA TORTA, ANTON VE1 M40000000000 4 4
166 NEBOT FORCADELL, MICHAEL SEN M04000000000 4 4
167 FIBLA REVERTER, ANTONI MA2 M00400000000 4 4
168 GARCIA DRAGO, JOSEP VE2 M22000000000 4 4
169 GIMENEZ CASANOVA, LLUIS SEN M22000000000 4 4
170 SUBIRATS CID, JORDI VE1 M02200000000 4 4
171 ARASA ARASA, JUAN JOSE MA1 M20200000000 4 4
172 TOMÀS TORRES, ISMAEL MA1 M02200000000 4 4
173 BROUGHTON, JIM MA1 M22000000000 4 4
174 BELTRAN SUBIRATS, JOSEP MARIA VE2 M22000000000 4 4
175 MILLAN MASDEU, JOAN IGNASI MA1 M20200000000 4 4
176 RIBAS BEL, ALBERT VE1 M00300000000 3 3
177 MASOLLER ARIAS, FRANCESC VE2 M20000000000 2 2
178 JUAN APARICIO, SANTI VE1 M20000000000 2 2
179 PARIS BRETÓ, GUILLERMO SEN M20000000000 2 2
180 GELLIDA BELMONTE, RUBEN SEN M20000000000 2 2
181 FERRE LOPEZ, CARLOS SEN M20000000000 2 2
182 CENTELLES GASCON, ELOI VE1 M00200000000 2 2
183 TOLDA GIL, MANEL VE1 M20000000000 2 2
184 SUBIRATS MARTÍN, JULIÀ SEN M02000000000 2 2
185 FUMADO GISBERT, ORIOL S18 M00200000000 2 2
186 MULET AGUILÓ , GERARD VICENT SEN M20000000000 2 2
187 CABRERA CABALLÉ, MARCOS VE2 M02000000000 2 2
188 GARCIA REDONDO, DOMINGO VE2 M00200000000 2 2
189 SUBIRATS CID, XAVI SEN M00200000000 2 2
190 GARRIGA ALMO, FRANCISCO MA1 M20000000000 2 2
191 MONTOYA LECEGUI, SANTI VE1 M02000000000 2 2
192 FANDOS COLOMINES, FELIP VE1 M02000000000 2 2
193 VENTURA GILABERT, SERGI SEN M20000000000 2 2
194 SEGUER GARCIA, JAIME VE1 M00200000000 2 2
195 CHAVARRIA ARAGONES, JOAN MA1 M00200000000 2 2
196 LUCAS JARDI, DAVID VE1 M20000000000 2 2
197 TOMÀS I ROIGET, ADAM VE2 M20000000000 2 2
198 BENIKEN, KAMEL MA1 M02000000000 2 2
199 GALARZA SANCHEZ, ALEJANDRO VE2 M00200000000 2 2
200 GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT VE1 M20000000000 2 2
201 PEIRET DE LA FUENTE, CARLES VE2 M02000000000 2 2
202 ACCENSI CASAJUST, JOEL VE1 M20000000000 2 2
203 ARASA CARDONA, RICARD VE2 M02000000000 2 2
204 LOZANO HERNANDEZ, JOSE MARIA VE2 M20000000000 2 2
205 VILA SOLÉ, FRANCESC VE1 M02000000000 2 2
206 MARQUEZ, MANEL VE1 M02000000000 2 2
207 GARCIA VIZUETE, JUANSE VE1 M02000000000 2 2
208 WUERTH, KARL-HEINZ MA2 M02000000000 2 2
209 MONTERO AURA, JORDI VE1 M02000000000 2 2