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	Amposta	L'Ampolla	Perelló	S.Bàrbara	Camarles	Batea	Deltebre	Jesús	La Galera	L'Aldea	Total	Punts
1	MONTERO PÈREZ, JOSEP MARIA	103	103	0	0	0	0	0	0	0	0	206	206
2	LLEIXÀ CHAVARRIA, JOSEP	93	93	0	0	0	0	0	0	0	0	186	186
3	FIBLA REVERTER, HERMINI	70	75	0	0	0	0	0	0	0	0	145	145
4	CUCURULL POCURULL, GERARD	68	71	0	0	0	0	0	0	0	0	139	139
5	FORTUÑO NAVARRO, JOSE LUIS	66	68	0	0	0	0	0	0	0	0	134	134
6	REVERTER BULLON, JOSE MIGUEL	65	69	0	0	0	0	0	0	0	0	134	134
7	ROMERO NOFRE, FERNANDO	62	66	0	0	0	0	0	0	0	0	128	128
8	BELTRAN SUBIRATS, JOSEP MARIA	61	62	0	0	0	0	0	0	0	0	123	123
9	ORTÍN FONT, XAVIER	0	115	0	0	0	0	0	0	0	0	115	115
10	ALBESA ABADAL, ANDRES	115	0	0	0	0	0	0	0	0	0	115	115
11	SABATER CABRERA, ENRIC	0	85	0	0	0	0	0	0	0	0	85	85
12	GRAU SANZ, MAX	85	0	0	0	0	0	0	0	0	0	85	85
13	LLUIS LLANSAMA, GABRIEL	79	0	0	0	0	0	0	0	0	0	79	79
14	BELTRAN ARQUES, JUAN FRANCISCO	0	79	0	0	0	0	0	0	0	0	79	79
15	GARCIA REDONDO, DOMINGO	75	0	0	0	0	0	0	0	0	0	75	75
16	CASTELLS CARLES, ALEJANDRO	73	0	0	0	0	0	0	0	0	0	73	73
17	SANCHEZ MIRALLES, JUAN ANTONIO	0	73	0	0	0	0	0	0	0	0	73	73
18	CABANES CALVET, ALBERT	71	0	0	0	0	0	0	0	0	0	71	71
19	TORRES , JORGE	0	70	0	0	0	0	0	0	0	0	70	70
20	CASELLAS APARICIO, RAFAEL	69	0	0	0	0	0	0	0	0	0	69	69
21	VIDAL FOIX, XAVIER	67	0	0	0	0	0	0	0	0	0	67	67
22	MANZANERO HERAS, VICENT	0	67	0	0	0	0	0	0	0	0	67	67
23	BORRAS LLOSA, ALBERT	0	65	0	0	0	0	0	0	0	0	65	65
24	GONZALEZ CURIEL, JULIO	64	0	0	0	0	0	0	0	0	0	64	64
25	GUIU BAGÉS, ALBERT	0	64	0	0	0	0	0	0	0	0	64	64
26	TOMÀS I ROIGET, ADAM	63	0	0	0	0	0	0	0	0	0	63	63
27	GOMEZ MARTINEZ, JOSE LUIS	0	63	0	0	0	0	0	0	0	0	63	63
28	GARCIA BALLÚS, DAVID	0	61	0	0	0	0	0	0	0	0	61	61