CLASSIFICACIÓ 10K: VETERÀ-2 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="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..

Pos	Nom	Camarles	L'Ampolla	La Galera	L'Aldea	Amposta	Deltebre	Total	Punts
1	DE TORRES BURGOS, FERRAN	115	0	0	0	0	0	115	115
2	PUENTES GARCÍA, LUIS FCO	103	0	0	0	0	0	103	103
3	FALGAS MORENO, ALEX	93	0	0	0	0	0	93	93
4	QUERAL FORCADELL, DAVID	85	0	0	0	0	0	85	85
5	CURTO I GILABERT, DAVID	79	0	0	0	0	0	79	79
6	LLUIS LLANSAMA, GABRIEL	75	0	0	0	0	0	75	75
7	GALIANA BARCELÓ, JOAN	73	0	0	0	0	0	73	73
8	SERRET ROIG, ADRIA	71	0	0	0	0	0	71	71
9	CABANES CALVET, ALBERT	70	0	0	0	0	0	70	70
10	FORTUÑO NAVARRO, JOSE LUIS	69	0	0	0	0	0	69	69
11	LEÓN MORA, AUGUSTO LEO	68	0	0	0	0	0	68	68
12	GARCIA BALAGUE, JULI	67	0	0	0	0	0	67	67
13	BORRAS LLOSA, ALBERT	66	0	0	0	0	0	66	66
14	CLUA GAYA, MARC	65	0	0	0	0	0	65	65
15	TOMÀS I ROIGET, ADAM	64	0	0	0	0	0	64	64
16	BATALLA, JOAN CARLES	63	0	0	0	0	0	63	63
17	CARMONA HERNÁNDEZ, JAVIER	62	0	0	0	0	0	62	62