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	Total	Punts
1	TOMÀS BUITRAGO, AITOR	115	0	103	115	115	448	448
2	MACHI CABALLE, OMAR	93	115	0	93	0	301	301
3	ESTORACH SOL, OSCAR	103	103	0	85	0	291	291
4	ROCA REY, ROGER	73	73	75	70	0	291	291
5	JIMÉNEZ BRANERA , DANI	0	0	93	75	103	271	271
6	GOMEZ AUSACH, ANDREU	79	85	0	0	0	164	164
7	GABALDA FERRE, ELOI	0	0	79	73	0	152	152
8	BERTOMEU CASANOVA, AARON	75	75	0	0	0	150	150
9	CUBELLS I CUBELLS, HERIBERT	0	0	115	0	0	115	115
10	REMOLINA RALLO, FERRAN	0	0	0	103	0	103	103
11	CASAS CABRERA, PACO	0	93	0	0	0	93	93
12	GONZÁLEZ CABALLERO, DAVID	0	0	0	0	93	93	93
13	CÁCERES AZNAR, KARIM	85	0	0	0	0	85	85
14	MAIJÓ FRIGOLA, ABEL	0	0	85	0	0	85	85
15	FONOLLOSA AULADELL, XAVIER	0	0	0	0	85	85	85
16	DEL VALLE PUIG, ADRIA	0	0	0	79	0	79	79
17	CURTO GARCIN, CARLOS	0	79	0	0	0	79	79
18	CASTELLS CASANOVA, JOEL	0	0	0	71	0	71	71
19	DUSSARRAT, ROBIN	0	71	0	0	0	71	71
20	PAGA FABRA, AGUSTI	0	70	0	0	0	70	70
21	FRANCH FRANCH, JOAN MARTI	0	0	0	69	0	69	69
22	BELTRAN, MANEL	0	0	0	68	0	68	68

Amb el suport de: