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.	Amposta	L'Ampolla	Perelló	S.Bàrbara	Camarles	Batea	Deltebre	Jesús	La Galera	L'Aldea	Total	Punts
1	PONS TOMÀS, RAMON	S23 M	85	93	0	0	0	0	0	0	0	0	178	178
2	SOLANAS PEREZ, SERGIO	VE1 M	79	75	0	0	0	0	0	0	0	0	154	154
3	RUIZ CULIÁÑEZ, JOSÉ MARIO	SEN M	73	70	0	0	0	0	0	0	0	0	143	143
4	MONTERO PÈREZ, JOSEP MARIA	VE2 M	69	69	0	0	0	0	0	0	0	0	138	138
5	CASTELLS LOPEZ, RAMON	VE1 M	66	67	0	0	0	0	0	0	0	0	133	133
6	SOTA MARTÍ, JORDI	VE1 M	67	63	0	0	0	0	0	0	0	0	130	130
7	ASÍN QUEROL, JAVI	VE1 M	63	64	0	0	0	0	0	0	0	0	127	127
8	GARCIA SUAREZ, JULIO CESAR	VE1 M	60	62	0	0	0	0	0	0	0	0	122	122
9	GÜELL VILLAR, ORIOL	VE1 M	61	61	0	0	0	0	0	0	0	0	122	122
10	BUERA REBULLIDA, JOSEP MIQUEL	VE1 M	59	59	0	0	0	0	0	0	0	0	118	118
11	FATHI, ALI	SEN M	115	0	0	0	0	0	0	0	0	0	115	115
12	SALES FERRE, LLORENÇ	SEN M	0	115	0	0	0	0	0	0	0	0	115	115
13	ULLDEMOLINS TODÓ, ALFONS	VE1 M	57	58	0	0	0	0	0	0	0	0	115	115
14	LLEIXÀ CHAVARRIA, JOSEP	VE2 M	56	56	0	0	0	0	0	0	0	0	112	112
15	ZARAGOZA VALLDEPEREZ, RAMON	VE1 M	55	55	0	0	0	0	0	0	0	0	110	110
16	EL JIHAOUI, AZZIZ	VE1 M	103	0	0	0	0	0	0	0	0	0	103	103
17	SALES FERRE, ENRIC	SEN M	0	103	0	0	0	0	0	0	0	0	103	103
18	VALLESPI DE LA CRUZ, JORDI	VE1 M	50	49	0	0	0	0	0	0	0	0	99	99
19	MAS CACERES, LLUISMA	VE1 M	93	0	0	0	0	0	0	0	0	0	93	93
20	CUGAT MULET, JAUME	VE1 M	41	45	0	0	0	0	0	0	0	0	86	86
21	VIUDEZ TOMÀS, MARTÍ	VE1 M	0	85	0	0	0	0	0	0	0	0	85	85
22	LUQUE JULIA, CARLOS	VE1 M	39	46	0	0	0	0	0	0	0	0	85	85
23	SALVATELLA ROIJALS, JOAN	VE1 M	34	47	0	0	0	0	0	0	0	0	81	81
24	ORTÍN FONT, XAVIER	VE2 M	0	79	0	0	0	0	0	0	0	0	79	79
25	FERRÉ CANALS, TONI	MA1 M	35	44	0	0	0	0	0	0	0	0	79	79
26	FIBLA REVERTER, HERMINI	VE2 M	38	39	0	0	0	0	0	0	0	0	77	77
27	GARCIA ARGENTÓ, VICENT	VE1 M	75	0	0	0	0	0	0	0	0	0	75	75
28	IBAÑEZ BISMARK, JUST	SEN M	0	73	0	0	0	0	0	0	0	0	73	73
29	RODA JIMENEZ, JOSEP	SEN M	71	0	0	0	0	0	0	0	0	0	71	71
30	COMES GARCIA, MARTI	MA1 M	0	71	0	0	0	0	0	0	0	0	71	71
31	ALBESA ABADAL, ANDRES	VE2 M	70	0	0	0	0	0	0	0	0	0	70	70
32	SORIANO LÓPEZ, MARTÍ	VE1 M	68	0	0	0	0	0	0	0	0	0	68	68
33	SUÑER CARLES, PAU	SEN M	0	68	0	0	0	0	0	0	0	0	68	68
34	CUCURULL POCURULL, GERARD	VE2 M	33	34	0	0	0	0	0	0	0	0	67	67
35	PUIG SOLER, MARC	SEN M	0	66	0	0	0	0	0	0	0	0	66	66
36	FERNÁNDEZ TOMÀS, JOAN LLUÍS	SEN M	65	0	0	0	0	0	0	0	0	0	65	65
37	REDÓ VIUDEZ, CARLOS	SEN M	0	65	0	0	0	0	0	0	0	0	65	65
38	TONDA SALVADÓ, JOSEP LLUIS	MA1 M	64	0	0	0	0	0	0	0	0	0	64	64
39	VILANOVA ARDIT, JOSEP	VE1 M	62	0	0	0	0	0	0	0	0	0	62	62
40	RUIZ SERRANO, JUSTINO	MA2 M	28	33	0	0	0	0	0	0	0	0	61	61
41	DOMINGUEZ ARASA, ALBERT	SEN M	0	60	0	0	0	0	0	0	0	0	60	60
42	CÓZAR TORÁN, PEDRO	VE1 M	58	0	0	0	0	0	0	0	0	0	58	58
43	BUENO GARCIA, FRAN	SEN M	0	57	0	0	0	0	0	0	0	0	57	57
44	SOTOMAYOR DUQUE, XAVI	VE1 M	54	0	0	0	0	0	0	0	0	0	54	54
45	RIBERA ROIG, PABLO	VE1 M	0	54	0	0	0	0	0	0	0	0	54	54
46	DELLA CALLEN, JUAN JOSE	VE1 M	53	0	0	0	0	0	0	0	0	0	53	53
47	BENAVENT BENAVENT, PEP	SEN M	0	53	0	0	0	0	0	0	0	0	53	53
48	SANCHO RALDA, ALFONSO	VE1 M	52	0	0	0	0	0	0	0	0	0	52	52
49	SABATER CABRERA, ENRIC	VE2 M	0	52	0	0	0	0	0	0	0	0	52	52
50	PUIG AGUILO, VICENT	SEN M	51	0	0	0	0	0	0	0	0	0	51	51
51	CURTO BAIGES, ALBERT	SEN M	0	51	0	0	0	0	0	0	0	0	51	51
52	SIERRA IZQUIERDO, BORJA	VE1 M	0	50	0	0	0	0	0	0	0	0	50	50
53	GRAU SANZ, MAX	VE2 M	49	0	0	0	0	0	0	0	0	0	49	49
54	SUBIRATS CID, JORDI	VE1 M	20	29	0	0	0	0	0	0	0	0	49	49
55	LLUIS LLANSAMA, GABRIEL	VE2 M	48	0	0	0	0	0	0	0	0	0	48	48
56	BERTOMEU BELLES, CRISTIAN	VE1 M	0	48	0	0	0	0	0	0	0	0	48	48
57	GARCIA REDONDO, DOMINGO	VE2 M	47	0	0	0	0	0	0	0	0	0	47	47
58	FORTUÑO NAVARRO, JOSE LUIS	VE2 M	22	25	0	0	0	0	0	0	0	0	47	47
59	GUZMAN, MATIAS	VE1 M	46	0	0	0	0	0	0	0	0	0	46	46
60	GAIC, ROBERT DAVID	SEN M	18	28	0	0	0	0	0	0	0	0	46	46
61	CASTELLS CARLES, ALEJANDRO	VE2 M	45	0	0	0	0	0	0	0	0	0	45	45
62	GARGALLO ROYO, JOSE RAMÓN	VE1 M	44	0	0	0	0	0	0	0	0	0	44	44
63	BERTOMEU CURTO, JOEL	VE1 M	43	0	0	0	0	0	0	0	0	0	43	43
64	BELTRAN ARQUES, JUAN FRANCISCO	VE2 M	0	43	0	0	0	0	0	0	0	0	43	43
65	REVERTER BULLON, JOSE MIGUEL	VE2 M	17	26	0	0	0	0	0	0	0	0	43	43
66	CABANES CALVET, ALBERT	VE2 M	42	0	0	0	0	0	0	0	0	0	42	42
67	BATSI ARAGON, CARLOS	VE1 M	0	42	0	0	0	0	0	0	0	0	42	42
68	GONZALEZ MORATALLA, ALFREDO	VE1 M	19	23	0	0	0	0	0	0	0	0	42	42
69	GARCIA ALPAÑES, HECTOR	VE1 M	0	41	0	0	0	0	0	0	0	0	41	41
70	VALMAÑA, ELOY	VE1 M	40	0	0	0	0	0	0	0	0	0	40	40
71	CURTO IBAÑEZ, ADRIA	S23 M	0	40	0	0	0	0	0	0	0	0	40	40
72	LLORCA PINTOR, FCO. JAVIER	SEN M	0	38	0	0	0	0	0	0	0	0	38	38
73	DELLA CALLEN, CARLOS	VE1 M	37	0	0	0	0	0	0	0	0	0	37	37
74	ESCUDERO COLOMINES, DANI	VE1 M	0	37	0	0	0	0	0	0	0	0	37	37
75	CASELLAS APARICIO, RAFAEL	VE2 M	36	0	0	0	0	0	0	0	0	0	36	36
76	DAZA BERENGUER, DANI	VE1 M	0	36	0	0	0	0	0	0	0	0	36	36
77	SANCHEZ MIRALLES, JUAN ANTONIO	VE2 M	0	35	0	0	0	0	0	0	0	0	35	35
78	AGUILÓ BO, XAVIER	VE1 M	32	0	0	0	0	0	0	0	0	0	32	32
79	TORRES , JORGE	VE2 M	0	32	0	0	0	0	0	0	0	0	32	32
80	BRETÓ VERGE, FRANCESC	VE1 M	31	0	0	0	0	0	0	0	0	0	31	31
81	QUERALT ROIG, DANI	VE1 M	0	31	0	0	0	0	0	0	0	0	31	31
82	PONS URQUIZU, JOSE MARIA	MA2 M	30	0	0	0	0	0	0	0	0	0	30	30
83	SAHRAOUI CABRERA, CARLES	SEN M	0	30	0	0	0	0	0	0	0	0	30	30
84	GONZALEZ GILABERT, OCTAVI	SEN M	29	0	0	0	0	0	0	0	0	0	29	29
85	SANCHO JOSE, VICTOR	MA1 M	27	0	0	0	0	0	0	0	0	0	27	27
86	MONTOYA LECEGUI, SANTI	VE1 M	0	27	0	0	0	0	0	0	0	0	27	27
87	VIDAL FOIX, XAVIER	VE2 M	26	0	0	0	0	0	0	0	0	0	26	26
88	BESALDUCH BEL, XAVI	VE1 M	25	0	0	0	0	0	0	0	0	0	25	25
89	CID ESPUNY, JOSEP LLUIS	MA1 M	24	0	0	0	0	0	0	0	0	0	24	24
90	LANGE EBRI, ARTURO	MA2 M	0	24	0	0	0	0	0	0	0	0	24	24
91	ESPINOSA VILLAR, BORJA	VE1 M	23	0	0	0	0	0	0	0	0	0	23	23
92	HERNANDEZ RODRIGUEZ, CARLOS	MA1 M	7	16	0	0	0	0	0	0	0	0	23	23
93	GARRIGA SOROLLA, XAVIER	VE1 M	8	15	0	0	0	0	0	0	0	0	23	23
94	PÉREZ FERNANDEZ , MIGUEL	MA1 M	0	22	0	0	0	0	0	0	0	0	22	22
95	SUBIRATS CID, XAVI	SEN M	21	0	0	0	0	0	0	0	0	0	21	21
96	ASÍN QUEROL, JORGE	VE1 M	0	21	0	0	0	0	0	0	0	0	21	21
97	BRUNET ZARAGOZA, MIKEL	SEN M	0	20	0	0	0	0	0	0	0	0	20	20
98	MANZANERO HERAS, VICENT	VE2 M	0	19	0	0	0	0	0	0	0	0	19	19
99	ROMERO NOFRE, FERNANDO	VE2 M	2	17	0	0	0	0	0	0	0	0	19	19
100	SARIÓ DOMECH, SALVADOR	SEN M	0	18	0	0	0	0	0	0	0	0	18	18
101	FERRE LOPEZ, CARLOS	SEN M	16	0	0	0	0	0	0	0	0	0	16	16
102	BROUGHTON, JIM	MA1 M	6	10	0	0	0	0	0	0	0	0	16	16
103	SIMÓ QUERALT, EUGENI	VE1 M	15	0	0	0	0	0	0	0	0	0	15	15
104	FELIX RIPOLL, JUAN	VE1 M	2	13	0	0	0	0	0	0	0	0	15	15
105	SEBASTIA VALLDEPEREZ, JORDI	VE1 M	14	0	0	0	0	0	0	0	0	0	14	14
106	BORRAS LLOSA, ALBERT	VE2 M	0	14	0	0	0	0	0	0	0	0	14	14
107	ORTS MORA, BORJA	VE1 M	2	12	0	0	0	0	0	0	0	0	14	14
108	SERRET GOMEZ, JUAN CARLOS	VE1 M	13	0	0	0	0	0	0	0	0	0	13	13
109	FRANCO CIURANA, JOSÉ ANTONIO	VE1 M	12	0	0	0	0	0	0	0	0	0	12	12
110	GONZALEZ CURIEL, JULIO	VE2 M	11	0	0	0	0	0	0	0	0	0	11	11
111	CURTO PIÑANA, CRISTIAN	VE1 M	0	11	0	0	0	0	0	0	0	0	11	11
112	ACERO GUERRERO, JORGE	VE1 M	10	0	0	0	0	0	0	0	0	0	10	10
113	DOSDAD CAMPOS , OSCAR	VE1 M	9	0	0	0	0	0	0	0	0	0	9	9
114	GUIU BAGÉS, ALBERT	VE2 M	0	9	0	0	0	0	0	0	0	0	9	9
115	GOMEZ MARTINEZ, JOSE LUIS	VE2 M	0	8	0	0	0	0	0	0	0	0	8	8
116	BAREA SEBASTIA, NOE	VE1 M	2	6	0	0	0	0	0	0	0	0	8	8
117	FUMADO CASANOVA, JUAN JOSE	MA1 M	0	7	0	0	0	0	0	0	0	0	7	7
118	BELTRAN SUBIRATS, JOSEP MARIA	VE2 M	2	5	0	0	0	0	0	0	0	0	7	7
119	TOMÀS I ROIGET, ADAM	VE2 M	5	0	0	0	0	0	0	0	0	0	5	5
120	SABATE SABATE, JAVIER	SEN M	2	3	0	0	0	0	0	0	0	0	5	5
121	GARRIGA ALMO, FRANCISCO	MA1 M	4	0	0	0	0	0	0	0	0	0	4	4
122	GARCIA BALLÚS, DAVID	VE2 M	0	4	0	0	0	0	0	0	0	0	4	4
123	CASTELLS FABRA, LLUIS	VE1 M	2	2	0	0	0	0	0	0	0	0	4	4
124	VALENCIA NEBOT, ENRIC	MA1 M	3	0	0	0	0	0	0	0	0	0	3	3
125	ALBESA ARASA, JOAN	MA1 M	2	0	0	0	0	0	0	0	0	0	2	2
126	GUTIÉRREZ MÁRQUEZ, FCO JAVIER	VE1 M	2	0	0	0	0	0	0	0	0	0	2	2
127	SUBIRANA SARDA, MANEL	MA2 M	2	0	0	0	0	0	0	0	0	0	2	2