CLASSIFICACIÓ 5K: SÈNIOR MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..

Pos	Nom	Amposta	Ampolla	Perelló	Camarles	Tortosa	Jesús	Deltebre	L'Aldea	Total	Punts
1	TOMÀS BUITRAGO, AITOR	115	0	103	115	115	115	93	115	771	575
2	JIMÉNEZ BRANERA , DANI	0	0	93	75	103	85	0	93	449	449
3	MACHI CABALLE, OMAR	93	115	0	93	0	0	0	0	301	301
4	GABALDA FERRE, ELOI	0	0	79	73	0	71	0	75	298	298
5	ESTORACH SOL, OSCAR	103	103	0	85	0	0	0	0	291	291
6	ROCA REY, ROGER	73	73	75	70	0	0	0	0	291	291
7	CUBELLS I CUBELLS, HERIBERT	0	0	115	0	0	0	103	0	218	218
8	CASTELLS CASANOVA, JOEL	0	0	0	71	0	62	75	0	208	208
9	GOMEZ AUSACH, ANDREU	79	85	0	0	0	0	0	0	164	164
10	BELTRAN, MANEL	0	0	0	68	0	0	85	0	153	153
11	BERTOMEU CASANOVA, AARON	75	75	0	0	0	0	0	0	150	150
12	FRANCH FRANCH, JOAN MARTI	0	0	0	69	0	0	71	0	140	140
13	OUHDADI, YASSINE	0	0	0	0	0	0	115	0	115	115
14	REMOLINA RALLO, FERRAN	0	0	0	103	0	0	0	0	103	103
15	OURHOU OUAMOU, ILYASSE	0	0	0	0	0	103	0	0	103	103
16	AVINYO ARASA, PAU	0	0	0	0	0	0	0	103	103	103
17	CASAS CABRERA, PACO	0	93	0	0	0	0	0	0	93	93
18	PAREDES MARTÍ, SAM	0	0	0	0	0	93	0	0	93	93
19	GONZÁLEZ CABALLERO, DAVID	0	0	0	0	93	0	0	0	93	93
20	CÁCERES AZNAR, KARIM	85	0	0	0	0	0	0	0	85	85
21	ROJAS ESTEVE, JOSUÉ	0	0	0	0	0	0	0	85	85	85
22	MAIJÓ FRIGOLA, ABEL	0	0	85	0	0	0	0	0	85	85
23	FONOLLOSA AULADELL, XAVIER	0	0	0	0	85	0	0	0	85	85
24	DEL VALLE PUIG, ADRIA	0	0	0	79	0	0	0	0	79	79
25	BERTOMEU BELLES, CRISTIAN	0	0	0	0	0	0	79	0	79	79
26	MONTALVO SANZ, RAÚL	0	0	0	0	0	79	0	0	79	79
27	CASTELLVI SORIANO, JORDI	0	0	0	0	0	0	0	79	79	79
28	CURTO GARCIN, CARLOS	0	79	0	0	0	0	0	0	79	79
29	ROCA AÑON, VICTOR	0	0	0	0	0	75	0	0	75	75
30	ROVIRA CID, LEANDRO	0	0	0	0	0	73	0	0	73	73
31	MORESO ABELLA , VICTOR	0	0	0	0	0	0	0	73	73	73
32	CASANOVA BERTOMEU, FERRAN	0	0	0	0	0	0	73	0	73	73
33	DUSSARRAT, ROBIN	0	71	0	0	0	0	0	0	71	71
34	LLOSA GAS, CARLOS	0	0	0	0	0	0	0	71	71	71
35	OLIVER BLANCH, OSCAR	0	0	0	0	0	70	0	0	70	70
36	PAGA FABRA, AGUSTI	0	70	0	0	0	0	0	0	70	70
37	OLIVER BLANCH, SERGIO	0	0	0	0	0	68	0	0	68	68
38	TURCAN, NICOLAE	0	0	0	0	0	67	0	0	67	67
39	GARCIA BEATO, ALBERT	0	0	0	0	0	66	0	0	66	66
40	BENEITO FAUS, RUBEN	0	0	0	0	0	65	0	0	65	65
41	REDO MUSSO, ALEX	0	0	0	0	0	64	0	0	64	64
42	BARBERÀ ALSO, JOAQUIM	0	0	0	0	0	63	0	0	63	63
43	MELERO CURTO, JOSEP	0	0	0	0	0	61	0	0	61	61
44	CODORNIU CODORNIU, ADRIÀ	0	0	0	0	0	60	0	0	60	60
45	BARBERÀ ALSO, ANTONI	0	0	0	0	0	59	0	0	59	59