CLASSIFICACIÓ 10K: 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.	Camarles	L'Ampolla	La Galera	L'Aldea	Amposta	Deltebre	Total	Punts
1	SOWE, MUSA	VE1 M	115	93	79	115	0	0	402	402
2	DE TORRES BURGOS, FERRAN	VE2 M	103	85	75	103	0	0	366	366
3	SALES FERRE, ENRIC	SEN M	85	73	68	79	0	0	305	305
4	CURTO I GILABERT, DAVID	VE2 M	65	63	57	60	0	0	245	245
5	PUENTES GARCÍA, LUIS FCO	VE2 M	93	79	69	0	0	0	241	241
6	VIUDEZ TOMÀS, MARTÍ	VE1 M	69	75	0	93	0	0	237	237
7	LLUIS LLANSAMA, GABRIEL	VE2 M	55	61	56	62	0	0	234	234
8	IZQUIERDO ACON, ALEX	VE1 M	0	71	71	85	0	0	227	227
9	GIMENEZ BELLOBI, JORDI	VE1 M	63	54	47	55	0	0	219	219
10	FATHI, ALI	SEN M	0	115	103	0	0	0	218	218
11	BUTLER, JONATHAN	VE1 M	79	0	67	71	0	0	217	217
12	FRANCO SMEETS, CLAUDIO	VE1 M	71	69	66	0	0	0	206	206
13	GAIC, ROBERT DAVID	SEN M	51	52	48	49	0	0	200	200
14	MARTÍNEZ RODRIGUEZ, ÁNGEL	VE2 M	0	103	93	0	0	0	196	196
15	MAURI BARDI, JORDI	SEN M	42	51	46	51	0	0	190	190
16	PAGA MARGALEF, JOAN PERE	VE1 M	56	64	59	0	0	0	179	179
17	GARCIA SUAREZ, JULIO CESAR	VE1 M	61	0	53	63	0	0	177	177
18	GARCIA SANGÜESA, DAMIÀ	VE2 M	0	58	51	56	0	0	165	165
19	RUIZ SERRANO, JUSTINO	MA2 M	38	46	38	39	0	0	161	161
20	FORTUÑO NAVARRO, JOSE LUIS	VE2 M	41	44	35	36	0	0	156	156
21	GARCIA BALAGUE, JULI	VE2 M	32	42	37	37	0	0	148	148
22	LEÓN MORA, AUGUSTO LEO	VE2 M	40	39	33	34	0	0	146	146
23	MESTRE QUEROL, ALBERT	VE1 M	75	0	70	0	0	0	145	145
24	SABATE ROIG, ENRIC	VE2 M	0	70	0	70	0	0	140	140
25	FERRE VADILLO, ENRIC	VE1 M	0	41	43	47	0	0	131	131
26	ALBIOL CHERTA, GERARD	SEN M	0	0	62	68	0	0	130	130
27	LLEIXA GUARRO, IVAN	VE1 M	0	65	64	0	0	0	129	129
28	CASTELLS LOPEZ, RAMON	VE1 M	0	66	61	0	0	0	127	127
29	REDÓ VIUDEZ, CARLOS	SEN M	66	0	0	61	0	0	127	127
30	SANCHO JOSE, VICTOR	MA1 M	25	38	29	32	0	0	124	124
31	BASSIYD, MUSTAPHA	SEN M	0	57	0	65	0	0	122	122
32	PARDO ARQUES, ROGER	SEN M	58	62	0	0	0	0	120	120
33	GOMBAU MURRIA, ELISEU	SEN M	60	0	0	57	0	0	117	117
34	MAIJÓ FRIGOLA, ÀDAM	S23 M	0	0	115	0	0	0	115	115
35	SALVATELLA ROIJALS, JOAN	VE1 M	0	60	50	0	0	0	110	110
36	CUGAT MULET, JAUME	VE1 M	57	0	0	52	0	0	109	109
37	LANGE EBRI, ARTURO	MA2 M	24	32	31	22	0	0	109	109
38	VALLESPI DE LA CRUZ, JORDI	VE1 M	0	50	0	53	0	0	103	103
39	PELEGRIN SANCHEZ, JOAN CARLES	MA1 M	20	27	24	27	0	0	98	98
40	GALIANA BARCELÓ, JOAN	VE2 M	48	49	0	0	0	0	97	97
41	GARBI HUERGA, CARLOS TOMÁS	VE1 M	0	37	30	29	0	0	96	96
42	SUBIRATS CID, JORDI	VE1 M	28	36	0	30	0	0	94	94
43	VALMAÑA, ELOY	VE1 M	0	45	0	46	0	0	91	91
44	EL JIHAOUI, AZZIZ	VE1 M	0	0	85	0	0	0	85	85
45	ROFES BARCELO, JOSEP	MA1 M	27	0	27	31	0	0	85	85
46	SOLÉ MIRALLES, DAVID	VE1 M	0	0	40	41	0	0	81	81
47	MONTEVERDE MAURI, MARC	SEN M	34	47	0	0	0	0	81	81
48	HERNANDEZ RODRIGUEZ, CARLOS	MA1 M	37	40	0	0	0	0	77	77
49	NAVARRO BARBERA, JORDI	VE1 M	0	0	0	75	0	0	75	75
50	TOMÀS BUITRAGO, AITOR	SEN M	0	0	73	0	0	0	73	73
51	FALGAS MORENO, ALEX	VE2 M	73	0	0	0	0	0	73	73
52	FORNÉ CASTELLS, XAVIER	VE2 M	0	0	0	73	0	0	73	73
53	RIBERA ROIG, PABLO	VE1 M	70	0	0	0	0	0	70	70
54	PUIG IZQUIERDO , ANTONI	VE1 M	0	0	0	69	0	0	69	69
55	CASTELLS FABRA, LLUIS	VE1 M	16	20	15	18	0	0	69	69
56	ROYO GUILLEM, ANDREU	VE1 M	68	0	0	0	0	0	68	68
57	VILANOVA ARDIT, JOSEP	VE1 M	0	68	0	0	0	0	68	68
58	QUERAL FORCADELL, DAVID	VE2 M	67	0	0	0	0	0	67	67
59	NAVAS PORTELLA, VÍCTOR	SEN M	0	0	0	67	0	0	67	67
60	GELLIDA ALBIOL, JESÚS	VE1 M	0	67	0	0	0	0	67	67
61	GUIU BAGÉS, ALBERT	VE2 M	0	25	22	20	0	0	67	67
62	SABATE SABATE, JAVIER	SEN M	15	21	14	17	0	0	67	67
63	BUERA REBULLIDA, JOSEP MIQUEL	VE1 M	0	0	0	66	0	0	66	66
64	SAGRISTA NOE, JOSEP	SEN M	0	0	65	0	0	0	65	65
65	SORIANO LÓPEZ, MARTÍ	VE1 M	64	0	0	0	0	0	64	64
66	DELLA CALLEN, JUAN JOSE	VE1 M	0	0	0	64	0	0	64	64
67	ABELLÀ RIBA, ANDREU	SEN M	0	0	63	0	0	0	63	63
68	BOVO, MARIO ANTONIO	VE1 M	62	0	0	0	0	0	62	62
69	JULIO SALES, RUBÉN	S23 M	0	0	60	0	0	0	60	60
70	DELLA CALLEN, CARLOS	VE1 M	59	0	0	0	0	0	59	59
71	GARCIA LOPEZ, JUAN	VE1 M	0	0	0	59	0	0	59	59
72	BORRÀS CAMPS, EDUARD	VE1 M	0	59	0	0	0	0	59	59
73	LABERNIA FERRE, VICENT	VE1 M	0	0	58	0	0	0	58	58
74	ESQUERRE FERRE, ROMAN	VE2 M	0	0	0	58	0	0	58	58
75	REVERTER BULLON, JOSE MIGUEL	VE2 M	0	35	0	23	0	0	58	58
76	SABATER CABRERA, ENRIC	VE2 M	0	56	0	0	0	0	56	56
77	PUIG CARLES, JOSEP	VE1 M	0	0	55	0	0	0	55	55
78	CURTO IBAÑEZ, ADRIÀ	S23 M	0	55	0	0	0	0	55	55
79	ALBO GARCIA, DAVID	VE1 M	0	0	54	0	0	0	54	54
80	BELTRAN COLLADO, ORIOL	VE1 M	54	0	0	0	0	0	54	54
81	GONZALEZ GILABERT, OCTAVI	SEN M	0	0	0	54	0	0	54	54
82	MONTESÓ JIMENEZ, DAVID MONTESÓ JIMÉNEZ	VE1 M	53	0	0	0	0	0	53	53
83	MARGALEF BENAIGES, PAU	VE1 M	0	53	0	0	0	0	53	53
84	SEVILLANO MORAN, ENRIQUE	VE2 M	0	0	52	0	0	0	52	52
85	PUTAN CÓRDOBA, WILSON	VE1 M	52	0	0	0	0	0	52	52
86	OBIOL PEDROL, ENRIC	SEN M	50	0	0	0	0	0	50	50
87	GAS PANISELLO, DAVID	VE2 M	0	0	0	50	0	0	50	50
88	ULLDEMOLINS TODÓ, ALFONS	VE1 M	0	0	49	0	0	0	49	49
89	DELGADO ARAGONESES, VÍCTOR	VE1 M	49	0	0	0	0	0	49	49
90	REDO PRINCEP, RICARD	VE2 M	0	0	0	48	0	0	48	48
91	PEREZ FRANCH, JOAN	VE1 M	0	48	0	0	0	0	48	48
92	PELEGRIN VALLS, JONATHAN	SEN M	47	0	0	0	0	0	47	47
93	CASTELLS BARRACHINA, BLAY	SEN M	46	0	0	0	0	0	46	46
94	MIRO ANDREU, ANTONI	MA1 M	0	0	45	0	0	0	45	45
95	SERRET ROIG, ADRIA	VE2 M	45	0	0	0	0	0	45	45
96	GRAU VIDAL, ALBERTO	VE1 M	0	0	0	45	0	0	45	45
97	ANDREU LOPEZ, AARÓN	SEN M	0	0	44	0	0	0	44	44
98	CABANES CALVET, ALBERT	VE2 M	44	0	0	0	0	0	44	44
99	SANAHUJA MORENO, IVAN	VE1 M	0	0	0	44	0	0	44	44
100	GARCIA ALPAÑES, HECTOR	VE1 M	43	0	0	0	0	0	43	43
101	PALLARÉS MARTÍ, JOSEP	MA1 M	0	0	0	43	0	0	43	43
102	SANCHEZ MIRALLES, JUAN ANTONIO	MA1 M	0	43	0	0	0	0	43	43
103	EL AKRAA, MOHAMED	S18 M	0	0	42	0	0	0	42	42
104	ALSINA SALMORAL, XAVIER	SEN M	0	0	0	42	0	0	42	42
105	TORREBLANCA CERVELLÓ, JOSE ANGEL	VE1 M	0	0	41	0	0	0	41	41
106	CAMACHO MARGALEF, DAVID	SEN M	0	0	0	40	0	0	40	40
107	FATSINI LLETI, DANIEL	SEN M	0	0	39	0	0	0	39	39
108	FIBLA MORENO, JOAN LLUIS	SEN M	39	0	0	0	0	0	39	39
109	VILLEGAS GIRALDO, BAHUER	SEN M	0	0	0	38	0	0	38	38
110	BEL MUÑOZ, BIEL	S18 M	0	0	36	0	0	0	36	36
111	MONTEVERDE, JORDI	VE1 M	36	0	0	0	0	0	36	36
112	CUESTA GARCIA, DANI	SEN M	35	0	0	0	0	0	35	35
113	CATALA BONANZA, BLAS	VE1 M	0	0	0	35	0	0	35	35
114	ANDUCAS PLANAS, JORDI	VE2 M	0	0	34	0	0	0	34	34
115	RODA CID, SERGI	VE2 M	0	34	0	0	0	0	34	34
116	GONZALEZ MORATALLA, ALFREDO	VE1 M	33	0	0	0	0	0	33	33
117	MIRALLES LLORCA, JESÚS	VE1 M	0	0	0	33	0	0	33	33
118	BEL PLA, RAMON	VE2 M	0	33	0	0	0	0	33	33
119	BORT I CORTIELLA, JOSEP JOAN	VE2 M	0	0	32	0	0	0	32	32
120	ESPINOSA ZAVALETA, EDGAR RICARDO	MA1 M	31	0	0	0	0	0	31	31
121	MIRAS ARNEDO, IBAN	VE1 M	0	31	0	0	0	0	31	31
122	VILLARES MUÑIZ, MARTÍ-PAU	SEN M	30	0	0	0	0	0	30	30
123	SANCHEZ PEREZ, JAVIER	VE1 M	0	30	0	0	0	0	30	30
124	SUBIRATS CID, XAVI	SEN M	29	0	0	0	0	0	29	29
125	MATEOS VIDAL, EDUARD	SEN M	0	29	0	0	0	0	29	29
126	PEIRET DE LA FUENTE, CARLES	VE2 M	0	0	28	0	0	0	28	28
127	DOORNBOS, ROY	MA1 M	0	0	0	28	0	0	28	28
128	FUMADO CASANOVA, JUAN JOSE	MA1 M	0	28	0	0	0	0	28	28
129	LAPUERTA CARDONA, FRANSEC	S18 M	0	0	26	0	0	0	26	26
130	GIMENO PUIGCERVER, MARC	SEN M	26	0	0	0	0	0	26	26
131	CHAVARRIA FERRÉ, DANI	VE1 M	0	0	0	26	0	0	26	26
132	MARGALEF CABRERA, MIGUEL	SEN M	0	26	0	0	0	0	26	26
133	SUBIRATS RILLO, ALBERT	VE1 M	0	0	25	0	0	0	25	25
134	PONS URQUIZU, JOSE MARIA	MA2 M	0	0	0	25	0	0	25	25
135	CID ESPUNY, JOSEP LLUIS	MA1 M	0	0	0	24	0	0	24	24
136	SEBASTIA VALLDEPEREZ, JORDI	VE1 M	0	24	0	0	0	0	24	24
137	BROUGHTON, JIM	MA2 M	0	0	23	0	0	0	23	23
138	MULET ROYO, JORDI	SEN M	23	0	0	0	0	0	23	23
139	LUQUE CRESPILLO, FRANCISCO	MA1 M	0	23	0	0	0	0	23	23
140	BORRAS LLOSA, ALBERT	VE2 M	22	0	0	0	0	0	22	22
141	ALIAU PONS, JOAN JOSEP	MA1 M	0	22	0	0	0	0	22	22
142	ARASA ARASA, JUAN JOSE	MA1 M	0	0	21	0	0	0	21	21
143	SANSALONI GILABERT, PAU	SEN M	21	0	0	0	0	0	21	21
144	CURTO GARCIN, CARLOS	SEN M	0	0	0	21	0	0	21	21
145	FERRIZ MARINÉ, ALEX	VE2 M	0	0	20	0	0	0	20	20
146	GALARZA SANCHEZ, ALEJANDRO	VE2 M	0	0	19	0	0	0	19	19
147	CLUA GAYA, MARC	VE2 M	19	0	0	0	0	0	19	19
148	FABRA ARQUES, CARLOS	VE1 M	0	0	0	19	0	0	19	19
149	ALLÓ BORT, MARC	S23 M	0	0	18	0	0	0	18	18
150	TORRES BERTOMEU, JOSEP	VE1 M	18	0	0	0	0	0	18	18
151	TOMÀS TORRES, ISMAEL	MA1 M	0	0	17	0	0	0	17	17
152	TOMÀS I ROIGET, ADAM	VE2 M	17	0	0	0	0	0	17	17
153	BELTRAN SUBIRATS, JOSEP MARIA	VE2 M	0	0	16	0	0	0	16	16
154	BATALLA, JOAN CARLES	VE2 M	14	0	0	0	0	0	14	14
155	VILLARES FERNÁNDEZ, VILLARES	MA2 M	13	0	0	0	0	0	13	13
156	IBAÑEZ BISMARCH, JUST	SEN M	12	0	0	0	0	0	12	12
157	CARMONA HERNÁNDEZ, JAVIER	VE2 M	11	0	0	0	0	0	11	11

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.