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 10310393115000000 414 414
2 ALEMANY SEBASTIA , SAMUEL 79937593000000 340 340
3 ORTÍN FONT, XAVIER 75858585000000 330 330
4 COLOMINES CUADRAD, JAUME 73797171000000 294 294
5 SOTA MARTÍ, JORDI 66656367000000 261 261
6 OLIVA SIMÓ, JUAN JOSÉ 57586669000000 250 250
7 CASTELLS LOPEZ, RAMON 58576463000000 242 242
8 ABAGHAD, YOUSSEF 11511500000000 230 230
9 CURTO I GILABERT, DAVID 53525457000000 216 216
10 VIUDEZ TOMÀS, MARTÍ 0757068000000 213 213
11 GOMBAU MURRIA, ELISEU 54455855000000 212 212
12 PAGA MARGALEF, JOAN PERE 50465358000000 207 207
13 SALES FERRE, ENRIC 6106873000000 202 202
14 PRINCEP CARDONA, JESUS 6566070000000 201 201
15 RIERA I CAIRE, ALBERT 6068062000000 190 190
16 PLA ALONSO, SERGI 33485553000000 189 189
17 ALABART ALCOBER, JOSEP MARIA 0595966000000 184 184
18 PELLICER MARTINEZ, DANI 35405156000000 182 182
19 VALLESPI DE LA CRUZ, JORDI 0556264000000 181 181
20 LLUIS LLANSAMA, GABRIEL 46344846000000 174 174
21 QUERAL FORCADELL, XAVI 0701030000000 173 173
22 ZARAGOZA VALLDEPEREZ, RAMON 40365244000000 172 172
23 ULLDEMOLINS TODÓ, ALFONS 5139060000000 150 150
24 OLIVA SORIA, ANTONIO 45432137000000 146 146
25 TRESO MASCARELL, MARC 707300000000 143 143
26 AVINYO ARASA, PAU 4441570000000 142 142
27 ALIMBAU REVERTE, MIQUEL 0424651000000 139 139
28 ADAM CHAVARRIA, CARLOS 069690000000 138 138
29 PONS TOMÀS, RAMON 716400000000 135 135
30 MONTESÓ JIMENEZ, DAVID 34243436000000 128 128
31 MARGALEF JORNET, PERE 646100000000 125 125
32 SOTOMAYOR DUQUE, XAVI 2274550000000 124 124
33 PLA SEGURA, EDU 001150000000 115 115
34 CÓZAR TORÁN, PEDRO 555400000000 109 109
35 LLEIXÀ CHAVARRIA, JOSEP 0184248000000 108 108
36 GAIC, ROBERT DAVID 25154324000000 107 107
37 GUTIERREZ GARCIA, CRISTIAN 000103000000 103 103
38 VALENCIA, MANUEL 004459000000 103 103
39 QUERALT ROIG, DANI 3628038000000 102 102
40 MARTOS MARTI, ANGEL 0324129000000 102 102
41 LLEIXA GUARRO, IVAN 490500000000 99 99
42 GONZALEZ GILABERT, OCTAVI 004947000000 96 96
43 SANCHO JOSE, VICTOR 2303735000000 95 95
44 MARTOS MARTI, JOAN 93000000000 93 93
45 ROMEU ESQUERRÉ, FERNANDO 2426400000000 90 90
46 ALMENDROS RODA, IGNASI 0213234000000 87 87
47 RIPOLL BENAIGES, FERRAN 430043000000 86 86
48 SEBASTIA VALLDEPEREZ, JORDI 1073039000000 86 86
49 RUIZ SERRANO, JUSTINO 18162725000000 86 86
50 MONTEVERDE GRAU, GERARD 85000000000 85 85
51 FERRÉ, ARNAU CASACUBERTA FERRÉ 033052000000 85 85
52 DELLA CALLEN, JUAN JOSE 2725310000000 83 83
53 MESTRE QUEROL, ALBERT 00790000000 79 79
54 DURA CREMADES, RICARDO 00079000000 79 79
55 GARCIA SANGÜESA, DAMIÀ 393700000000 76 76
56 ALSO SELMA, MIQUEL 00075000000 75 75
57 PELEGRIN SANCHEZ, JOAN CARLES 1362828000000 75 75
58 LEON MORA, AUGUSTO LEO 12142622000000 74 74
59 FATHI, ALI 00730000000 73 73
60 SOWE , MUSA 07100000000 71 71
61 BELLART SANS, MIQUEL 69000000000 69 69
62 GRUESO OTALO, ANTONIO 68000000000 68 68
63 ESTORACH SOL, OSCAR 67000000000 67 67
64 SORIANO LÓPEZ, MARTÍ 06700000000 67 67
65 GUIMERA FIBLA, CHRISTIAN 00670000000 67 67
66 NOU CASTELL, RAMON 00650000000 65 65
67 MONTERO PÈREZ, JOSEP MARIA 00065000000 65 65
68 MARINE OLLE, PACO 003332000000 65 65
69 FUCHO PASCUAL, FELIP 022042000000 64 64
70 ALBESA ABADAL, ANDRES 63000000000 63 63
71 RAMOS ALFONSO, ANTONIO 06300000000 63 63
72 MARIN MARIN, DANIEL 62000000000 62 62
73 SUÑER CARLES, PAU 06200000000 62 62
74 CID MESEGUER, SIMON 323000000000 62 62
75 ABAT BARRERA, IVAN 00610000000 61 61
76 SERRA BENEDICTO, JOAN 00061000000 61 61
77 GAS PANISELLO, DAVID 06000000000 60 60
78 CASADO, ALEX 00600000000 60 60
79 GIMENEZ BELLOBI, JORDI 59000000000 59 59
80 FERNANDO ROYAL, JOSEP ENRIC 310027000000 58 58
81 CID ESPUNY, JOSEP LLUIS 2217018000000 57 57
82 BELTRAN MARTINEZ-AGUADO, RAMON 56000000000 56 56
83 REDÓ VIUDEZ, CARLOS 05600000000 56 56
84 RODRIGUEZ SUBIRATS, DAVID 00560000000 56 56
85 MARGALEF BENAIGES, PAU 00054000000 54 54
86 DOMINGUEZ ARASA, JOSEP 05300000000 53 53
87 CID MARTI, JORDI 52000000000 52 52
88 ESCUDERO COROMINES, DANI 05100000000 51 51
89 DUEÑAS RODRIGUEZ, ALBERTO 05000000000 50 50
90 MARTIN ARASA, JOSEP 290021000000 50 50
91 SABORIDO ESCURRIOLA, EDUARD 04900000000 49 49
92 FIGUERAS MONER, RAMON 00049000000 49 49
93 ASÍN QUEROL, JAVI 48000000000 48 48
94 VIDIELLA CURTO, SERGI 192900000000 48 48
95 SEDIKI AIT SILARBI, HAKIM 5111814000000 48 48
96 LOPEZ GIL, DENIS 47000000000 47 47
97 FERNANDEZ FUERTES, ALEX 04700000000 47 47
98 SANCHEZ LLOPIS, ROBERTO 00470000000 47 47
99 SERRET ROIG, ADRIA 352415000000 47 47
100 LECOMMANDOUX, DANIEL 00045000000 45 45
101 VENTURA CASTELLS, JOAN 04400000000 44 44
102 BALAGUE BELTRAN, JOAQUIN 140290000000 43 43
103 MORILLO PORRAS, DAVID 22390000000 43 43
104 MORENO GARCIA, JUAN 42000000000 42 42
105 MORILLO PORRAS, JUAN ANTONIO 22380000000 42 42
106 RIBES SERRA, JOSEP MARIA 83256000000 42 42
107 TONDA SALVADO, MANEL 41000000000 41 41
108 GALVE TORRES, JOAN CARLES 00041000000 41 41
109 RODES HORTA, GERARD 00040000000 40 40
110 FORTUÑO NAVARRO, JOSE LUIS 221917000000 40 40
111 GRAU SANZ, MAX 38000000000 38 38
112 KLESHNIN, VOVOL 03800000000 38 38
113 ESQUERRE, EROS 37000000000 37 37
114 MARZA PLA, XAVI 00360000000 36 36
115 CALDUCH GARCIA, JUAN 03500000000 35 35
116 BELDA SÁNCHEZ, AGUSTÍ 00033000000 33 33
117 CABRERA CABALLÉ, MARCOS 713130000000 33 33
118 VALDIVIAS AHUMADA, OSCAR 68513000000 32 32
119 LLUCH ARBONA, DAVID 03100000000 31 31
120 JUANPERE POBLET, MANEL 00031000000 31 31
121 ALONSO QUESADA, OSCAR 30000000000 30 30
122 MARGALEF LLAO, TIBURCI ANDREU 00030000000 30 30
123 SORIANO LOPEZ, ANTONIO 28000000000 28 28
124 MARGALEF BORRELL, JOSEP 22816000000 28 28
125 ALBA RODRIGUEZ, TONI 26000000000 26 26
126 ALFONSO GOMEZ, SANTIAGO 00026000000 26 26
127 ROMERO VILLANUEVA, JUAN CARLOS 02300000000 23 23
128 RIBAS BEL, ALBERT 00230000000 23 23
129 VERNET FALCÓ, IGNASI 00023000000 23 23
130 SUOMINEN, IRRON 00220000000 22 22
131 ARAGON MORA , FELIP 21000000000 21 21
132 AGUILAR BONAVIDA, ESTEVE 20000000000 20 20
133 CABRÉ, MARIÀ 02000000000 20 20
134 VACHERESSE ORTIZ, STEPHANE 00200000000 20 20
135 DOMENECH QUEROL, AITOR 00020000000 20 20
136 PEREZ FRANCH, JOAN 01900000000 19 19
137 FRANCH PINYOL, NARCIS 00019000000 19 19
138 SUBIRATS CID, JORDI 9207000000 18 18
139 LUQUE LLUCH, OLIVER 22212000000 18 18
140 CAMACHO TEVAS, JOSEP 17000000000 17 17
141 FIBLA REVERTER, HERMINI 00170000000 17 17
142 CHAVARRIA GARCIA, PERE 16000000000 16 16
143 CIFRE SOSPEDRA, JOSE ANGEL 00160000000 16 16
144 TOMÀS GINÉ, GUILLEM 02140000000 16 16
145 CHAVARRIA GARCIA, ENRIC 15000000000 15 15
146 FIBLA REVERTER, ANTONI 00150000000 15 15
147 BROUGHTON, JIM 2238000000 15 15
148 REVERTER BULLON, JOSE MIGUEL 40100000000 14 14
149 GARCIA DRAGO, JOSEP 20110000000 13 13
150 CAMACHO MARGALEF, DAVID 01200000000 12 12
151 CURTO BAIGES, ALBERT 00120000000 12 12
152 MARTI GUARI, DAVID 20010000000 12 12
153 PELLICER DIAZ, JOSEP JOAQUIM 11000000000 11 11
154 AZNAR RUIZ, CHRISTIAN 00011000000 11 11
155 GALARZA SANCHEZ, ALEJANDRO 2225000000 11 11
156 SOTO PAREDES, DANIEL 01000000000 10 10
157 CURTO IBAÑEZ, ADRIA 0900000000 9 9
158 TORRENT OLLÉ, JORDI 0090000000 9 9
159 LOPEZ MORENO, CRISTIAN 0009000000 9 9
160 BRET GALI , JORDI 2222000000 8 8
161 CASTELLS FABRA, LLUIS 2222000000 8 8
162 ALIAU PONS, JOAN JOSEP 2222000000 8 8
163 ESPANYA FORCADELL, ANTONI 0070000000 7 7
164 PONS URQUIZU, JOSE MARIA 0060000000 6 6
165 BELTRAN SUBIRATS, JOSEP MARIA 0222000000 6 6
166 MILLAN MASDEU, JOAN IGNASI 2220000000 6 6
167 HERNANDEZ RODRIGUEZ, CARLOS 2202000000 6 6
168 FUMADO CASANOVA, JUAN JOSE 0203000000 5 5
169 MARINAS VALLS, IVAN 0400000000 4 4
170 ALBESA RUBIO, XAVIER 0040000000 4 4
171 SERRAL ZARAGOZA, JOAN 0004000000 4 4
172 CUGAT MULET, JAUME 2200000000 4 4
173 CAÑÍS SÁNCHEZ, DANIEL 2200000000 4 4
174 SERRET GOMEZ, JUAN CARLOS 0220000000 4 4
175 TOMÀS TORRES, ISMAEL 0202000000 4 4
176 NEBREDA PERELLO, ANGEL 2000000000 2 2
177 FONOLLOSA AULADELL, XAVIER 0200000000 2 2
178 GRANGÉ GALINDO, JOSEP LLUIS 2000000000 2 2
179 ESPINOSA VILLAR, JOSE MANUEL 2000000000 2 2
180 TERAN GOMEZ, JOAN 2000000000 2 2
181 ALVAREZ GUTIERREZ, RUBEN 0200000000 2 2
182 MARGALEF PELEGRIN, JOSEP 2000000000 2 2
183 CASTAÑO DE LA ASUNCION, JUAN CARLOS 0200000000 2 2
184 VENTURA GILABERT, SERGI 2000000000 2 2
185 MONTOYA LECEGUI, SANTI 0200000000 2 2
186 PONS ALEMAN, ALEX 0020000000 2 2
187 KONFIDERA, RUDSON 2000000000 2 2
188 ALBESA ARASA, JOAN 2000000000 2 2
189 PRADES PRADES, JOSEP M. 0200000000 2 2
190 DELGADO, FRANCESC 2000000000 2 2
191 SERRET ABELLA, ELOI 0200000000 2 2
192 SANS FERRER, ALBERT 0020000000 2 2
193 RAMON FARGA, ÀNGEL 2000000000 2 2
194 SERRANO JURADO, DANIEL 0200000000 2 2
195 GOMBAU SOLÉ, CARLOS 0020000000 2 2
196 SEGARRA VICENTE, ALEXANDRE 2000000000 2 2
197 GRAU ROCA, ÀLEX 0002000000 2 2
198 CARTES REVERTÉ, TONI 2000000000 2 2
199 SOMMES, ANDREAS 0200000000 2 2
200 FANDOS COLOMINES, FELIP 0002000000 2 2
201 ALBILLOS BLANCO, JOSÉ LUÍS 2000000000 2 2
202 PELLICER ABELLANEDA, DANIEL 0200000000 2 2
203 NAUMBURGER, KLAUS 0200000000 2 2
204 FOLCH, JOSEP MARIA 0002000000 2 2
205 ALVENTOSA LARA, RAFAEL 0200000000 2 2
206 FRANCH BONET, ROSANA 0200000000 2 2
207 MONFORTE GARGALLO, PACO 0002000000 2 2