CLASSIFICACIÓ 10K: SÈNIOR MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntscat FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntscat FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic WHERE categoria="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..

Pos	Nom	Camarles	L'Ampolla	La Galera	L'Aldea	Amposta	Deltebre	Total	Punts
1	SALES FERRE, ENRIC	115	103	93	115	0	0	426	426
2	GAIC, ROBERT DAVID	79	79	73	70	0	0	301	301
3	MAURI BARDI, JORDI	70	75	71	71	0	0	287	287
4	SABATE SABATE, JAVIER	61	69	68	65	0	0	263	263
5	FATHI, ALI	0	115	115	0	0	0	230	230
6	REDÓ VIUDEZ, CARLOS	103	0	0	79	0	0	182	182
7	ALBIOL CHERTA, GERARD	0	0	75	103	0	0	178	178
8	PARDO ARQUES, ROGER	85	93	0	0	0	0	178	178
9	BASSIYD, MUSTAPHA	0	85	0	85	0	0	170	170
10	GOMBAU MURRIA, ELISEU	93	0	0	75	0	0	168	168
11	MONTEVERDE MAURI, MARC	67	73	0	0	0	0	140	140
12	TOMÀS BUITRAGO, AITOR	0	0	103	0	0	0	103	103
13	NAVAS PORTELLA, VÍCTOR	0	0	0	93	0	0	93	93
14	SAGRISTA NOE, JOSEP	0	0	85	0	0	0	85	85
15	ABELLÀ RIBA, ANDREU	0	0	79	0	0	0	79	79
16	OBIOL PEDROL, ENRIC	75	0	0	0	0	0	75	75
17	GONZALEZ GILABERT, OCTAVI	0	0	0	73	0	0	73	73
18	PELEGRIN VALLS, JONATHAN	73	0	0	0	0	0	73	73
19	CASTELLS BARRACHINA, BLAY	71	0	0	0	0	0	71	71
20	MATEOS VIDAL, EDUARD	0	71	0	0	0	0	71	71
21	ANDREU LOPEZ, AARÓN	0	0	70	0	0	0	70	70
22	MARGALEF CABRERA, MIGUEL	0	70	0	0	0	0	70	70
23	FATSINI LLETI, DANIEL	0	0	69	0	0	0	69	69
24	FIBLA MORENO, JOAN LLUIS	69	0	0	0	0	0	69	69
25	ALSINA SALMORAL, XAVIER	0	0	0	69	0	0	69	69
26	CAMACHO MARGALEF, DAVID	0	0	0	68	0	0	68	68
27	CUESTA GARCIA, DANI	68	0	0	0	0	0	68	68
28	VILLEGAS GIRALDO, BAHUER	0	0	0	67	0	0	67	67
29	VILLARES MUÑIZ, MARTÍ-PAU	66	0	0	0	0	0	66	66
30	CURTO GARCIN, CARLOS	0	0	0	66	0	0	66	66
31	SUBIRATS CID, XAVI	65	0	0	0	0	0	65	65
32	GIMENO PUIGCERVER, MARC	64	0	0	0	0	0	64	64
33	MULET ROYO, JORDI	63	0	0	0	0	0	63	63
34	SANSALONI GILABERT, PAU	62	0	0	0	0	0	62	62
35	IBAÑEZ BISMARCH, JUST	60	0	0	0	0	0	60	60

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.