CLASSIFICACIÓ 10K: ABSOLUT MASCULÍ

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

Pos	Nom	Cat.	Camarles	L'Ampolla	La Galera	L'Aldea	Amposta	Deltebre	Total	Punts
1	SOWE, MUSA	VE1 M	115	0	0	0	0	0	115	115
2	DE TORRES BURGOS, FERRAN	VE2 M	103	0	0	0	0	0	103	103
3	PUENTES GARCÍA, LUIS FCO	VE2 M	93	0	0	0	0	0	93	93
4	SALES FERRE, ENRIC	SEN M	85	0	0	0	0	0	85	85
5	BUTLER, JONATHAN	VE1 M	79	0	0	0	0	0	79	79
6	MESTRE QUEROL, ALBERT	VE1 M	75	0	0	0	0	0	75	75
7	FALGAS MORENO, ALEX	VE2 M	73	0	0	0	0	0	73	73
8	FRANCO SMEETS, CLAUDIO	VE1 M	71	0	0	0	0	0	71	71
9	RIBERA ROIG, PABLO	VE1 M	70	0	0	0	0	0	70	70
10	VIUDEZ TOMÀS, MARTÍ	VE1 M	69	0	0	0	0	0	69	69
11	ROYO GUILLEM, ANDREU	VE1 M	68	0	0	0	0	0	68	68
12	QUERAL FORCADELL, DAVID	VE2 M	67	0	0	0	0	0	67	67
13	REDÓ VIUDEZ, CARLOS	SEN M	66	0	0	0	0	0	66	66
14	CURTO I GILABERT, DAVID	VE2 M	65	0	0	0	0	0	65	65
15	SORIANO LÓPEZ, MARTÍ	VE1 M	64	0	0	0	0	0	64	64
16	GIMENEZ BELLOBI, JORDI	VE1 M	63	0	0	0	0	0	63	63
17	BOVO, MARIO ANTONIO	VE1 M	62	0	0	0	0	0	62	62
18	GARCIA SUAREZ, JULIO CESAR	VE1 M	61	0	0	0	0	0	61	61
19	GOMBAU MURRIA, ELISEU	SEN M	60	0	0	0	0	0	60	60
20	DELLA CALLEN, CARLOS	VE1 M	59	0	0	0	0	0	59	59
21	PARDO ARQUES, ROGER	SEN M	58	0	0	0	0	0	58	58
22	CUGAT MULET, JAUME	VE1 M	57	0	0	0	0	0	57	57
23	PAGA MARGALEF, JOAN PERE	VE1 M	56	0	0	0	0	0	56	56
24	LLUIS LLANSAMA, GABRIEL	VE2 M	55	0	0	0	0	0	55	55
25	BELTRAN COLLADO, ORIOL	VE1 M	54	0	0	0	0	0	54	54
26	MONTESÓ JIMENEZ, DAVID MONTESÓ JIMÉNEZ	VE1 M	53	0	0	0	0	0	53	53
27	PUTAN CÓRDOBA, WILSON	VE1 M	52	0	0	0	0	0	52	52
28	GAIC, ROBERT DAVID	SEN M	51	0	0	0	0	0	51	51
29	OBIOL PEDROL, ENRIC	SEN M	50	0	0	0	0	0	50	50
30	DELGADO ARAGONESES, VÍCTOR	VE1 M	49	0	0	0	0	0	49	49
31	GALIANA BARCELÓ, JOAN	VE2 M	48	0	0	0	0	0	48	48
32	PELEGRIN VALLS, JONATHAN	SEN M	47	0	0	0	0	0	47	47
33	CASTELLS BARRACHINA, BLAY	SEN M	46	0	0	0	0	0	46	46
34	SERRET ROIG, ADRIA	VE2 M	45	0	0	0	0	0	45	45
35	CABANES CALVET, ALBERT	VE2 M	44	0	0	0	0	0	44	44
36	GARCIA ALPAÑES, HECTOR	VE1 M	43	0	0	0	0	0	43	43
37	MAURI BARDI, JORDI	SEN M	42	0	0	0	0	0	42	42
38	FORTUÑO NAVARRO, JOSE LUIS	VE2 M	41	0	0	0	0	0	41	41
39	LEÓN MORA, AUGUSTO LEO	VE2 M	40	0	0	0	0	0	40	40
40	FIBLA MORENO, JOAN LLUIS	SEN M	39	0	0	0	0	0	39	39
41	RUIZ SERRANO, JUSTINO	MA2 M	38	0	0	0	0	0	38	38
42	HERNANDEZ RODRIGUEZ, CARLOS	MA1 M	37	0	0	0	0	0	37	37
43	MONTEVERDE, JORDI	VE1 M	36	0	0	0	0	0	36	36
44	CUESTA GARCIA, DANI	SEN M	35	0	0	0	0	0	35	35
45	MONTEVERDE MAURI, MARC	SEN M	34	0	0	0	0	0	34	34
46	GONZALEZ MORATALLA, ALFREDO	VE1 M	33	0	0	0	0	0	33	33
47	GARCIA BALAGUE, JULI	VE2 M	32	0	0	0	0	0	32	32
48	ESPINOSA ZAVALETA, EDGAR RICARDO	MA1 M	31	0	0	0	0	0	31	31
49	VILLARES MUÑIZ, MARTÍ-PAU	SEN M	30	0	0	0	0	0	30	30
50	SUBIRATS CID, XAVI	SEN M	29	0	0	0	0	0	29	29
51	SUBIRATS CID, JORDI	VE1 M	28	0	0	0	0	0	28	28
52	ROFES BARCELO, JOSEP	MA1 M	27	0	0	0	0	0	27	27
53	GIMENO PUIGCERVER, MARC	SEN M	26	0	0	0	0	0	26	26
54	SANCHO JOSE, VICTOR	MA1 M	25	0	0	0	0	0	25	25
55	LANGE EBRI, ARTURO	MA2 M	24	0	0	0	0	0	24	24
56	MULET ROYO, JORDI	SEN M	23	0	0	0	0	0	23	23
57	BORRAS LLOSA, ALBERT	VE2 M	22	0	0	0	0	0	22	22
58	SANSALONI GILABERT, PAU	SEN M	21	0	0	0	0	0	21	21
59	PELEGRIN SANCHEZ, JOAN CARLES	MA1 M	20	0	0	0	0	0	20	20
60	CLUA GAYA, MARC	VE2 M	19	0	0	0	0	0	19	19
61	TORRES BERTOMEU, JOSEP	VE1 M	18	0	0	0	0	0	18	18
62	TOMÀS I ROIGET, ADAM	VE2 M	17	0	0	0	0	0	17	17
63	CASTELLS FABRA, LLUIS	VE1 M	16	0	0	0	0	0	16	16
64	BATALLA, JOAN CARLES	VE2 M	15	0	0	0	0	0	15	15
65	VILLARES FERNÁNDEZ, VILLARES	MA2 M	14	0	0	0	0	0	14	14
66	IBAÑEZ BISMARCH, JUST	SEN M	13	0	0	0	0	0	13	13
67	CARMONA HERNÁNDEZ, JAVIER	VE2 M	12	0	0	0	0	0	12	12