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

Pos	Nom	Amposta	L'Ampolla	Ulldecona	Perelló	S.Bàrbara	Camarles	Tortosa	Jesús	Deltebre	La Galera	L'Aldea	Total	Punts
1	SOWE , MUSA	103	115	93	115	115	115	115	115	115	115	103	1219	935
2	CASTELLS LOPEZ, RAMON	68	71	70	93	79	75	93	93	69	71	71	853	661
3	LLEIXA GUARRO, IVAN	0	70	66	73	69	68	0	0	79	85	75	585	585
4	GUART AUXACHS, JOAN	52	65	61	64	62	69	75	79	73	75	70	745	585
5	ASÍN QUEROL, JAVI	70	73	71	0	71	0	79	75	68	0	69	576	576
6	ZARAGOZA VALLDEPEREZ, RAMON	66	68	64	69	68	63	70	71	65	64	0	668	541
7	ULLDEMOLINS TODÓ, ALFONS	67	0	65	67	67	66	73	0	67	0	68	540	540
8	ALEMANY SEBASTIA , SAMUEL	93	0	103	0	103	0	103	103	0	0	0	505	505
9	GARCIA SUAREZ, JULIO CESAR	0	0	0	65	64	64	68	69	63	69	0	462	462
10	SOTA MARTÍ, JORDI	75	85	73	85	73	0	0	0	70	0	0	461	461
11	TORRES BERTOMEU, JOSEP	0	50	48	59	52	0	0	63	60	61	63	456	456
12	CUGAT MULET, JAUME	0	54	56	62	0	62	67	68	64	0	0	433	433
13	CASTELLS FABRA, LLUIS	41	0	0	55	40	52	56	57	57	55	57	470	430
14	VIUDEZ TOMÀS, MARTÍ	0	93	0	0	0	73	0	0	75	73	93	407	407
15	SUBIRATS CID, JORDI	0	45	40	0	43	57	59	60	0	0	59	363	363
16	VALLESPI DE LA CRUZ, JORDI	69	75	67	0	0	0	0	70	0	68	0	349	349
17	SEBASTIA VALLDEPEREZ, JORDI	49	49	0	58	0	0	61	62	0	0	64	343	343
18	TALARN CAUBET, JOAQUIM	53	57	0	0	0	0	0	67	62	67	0	306	306
19	ROMEU ESQUERRÉ, FERNANDO	51	0	0	0	53	0	62	0	61	0	61	288	288
20	TORRES , JORGE	0	53	49	61	59	0	0	64	0	0	0	286	286
21	VILANOVA ARDIT, JOSEP	0	0	0	70	70	71	0	0	71	0	0	282	282
22	GINÉ CID, ALBERT	79	103	0	0	0	0	0	85	0	0	0	267	267
23	GRAU VIDAL, ALBERTO	0	0	62	66	63	0	0	0	0	0	65	256	256
24	VILLAR MORERA, JOSE LUIS	55	61	55	63	0	0	0	0	0	0	0	234	234
25	JUAN-CAMPS CASTELL, AGUS	115	0	115	0	0	0	0	0	0	0	0	230	230
26	TOMAS PORRES, CARLOS	63	66	60	0	0	0	0	0	0	0	0	189	189
27	EL JIHAOUI, AZZIZ	0	0	0	0	0	103	0	0	85	0	0	188	188
28	GARCIA ARGENTÓ, VICENT	0	0	0	0	0	93	0	0	93	0	0	186	186
29	VALMAÑA, ELOY	59	64	58	0	0	0	0	0	0	0	0	181	181
30	REDÓ GÓMEZ, JUAN CARLOS	0	55	59	0	61	0	0	0	0	0	0	175	175
31	MARTOS MARTI, ANGEL	60	60	54	0	0	0	0	0	0	0	0	174	174
32	ARIÑO FUSTÉ, PEDRO	0	0	0	0	0	55	0	0	59	0	58	172	172
33	SERRET GOMEZ, JUAN CARLOS	45	44	38	0	41	0	0	0	0	0	0	168	168
34	LEANDRO QUERO, JORDI	0	0	0	0	0	0	85	0	0	79	0	164	164
35	TORREBLANCA CERVELLÓ, JOSE ANGEL	0	0	51	0	51	0	0	0	0	62	0	164	164
36	FERNANDO ROYAL, JOSEP ENRIC	0	0	53	60	48	0	0	0	0	0	0	161	161
37	SEGUER GARCIA, JAIME	0	0	39	0	42	0	0	0	0	0	60	141	141
38	MIRALLES LLORCA, JESÚS	0	48	45	0	47	0	0	0	0	0	0	140	140
39	CAMARERO LÓPEZ, GUILLERMO	0	69	0	0	0	0	0	0	0	0	67	136	136
40	PUIG CARLES, JOSEP	0	0	0	0	0	65	69	0	0	0	0	134	134
41	BELTRAN COLLADO, ORIOL	0	0	0	0	0	0	64	0	0	66	0	130	130
42	FERNANDEZ AGUIAR, MANU	0	0	63	0	66	0	0	0	0	0	0	129	129
43	REDO PRINCEP, RICARD	56	0	0	0	0	0	65	0	0	0	0	121	121
44	MONTESÓ JIMENEZ, DAVID	0	0	0	0	54	0	0	0	0	0	66	120	120
45	SANCHO RALDA, ALFONSO	0	0	0	0	57	0	0	0	0	63	0	120	120
46	SORIANO LOPEZ, ANTONIO	62	0	57	0	0	0	0	0	0	0	0	119	119
47	CURTO CODORNIU, PAU	0	0	0	0	0	0	0	59	58	0	0	117	117
48	QUERALT ROIG, DANI	57	59	0	0	0	0	0	0	0	0	0	116	116
49	MAS CACERES, LLUISMA	0	0	0	0	0	0	0	0	0	0	115	115	115
50	GARBI HUERGA, CARLOS TOMÁS	0	0	0	56	0	56	0	0	0	0	0	112	112
51	SOTOMAYOR DUQUE, XAVI	61	0	50	0	0	0	0	0	0	0	0	111	111
52	TARRAGÓ COLOMER, ROBERT	0	0	0	103	0	0	0	0	0	0	0	103	103
53	ULLAH, AHSAN	0	0	0	0	0	0	0	0	103	0	0	103	103
54	GARCIA FERNANDEZ, JORGE	0	0	0	0	0	0	0	0	0	103	0	103	103
55	VILAR ALCÁZAR, DAVID	0	0	0	0	93	0	0	0	0	0	0	93	93
56	RODA SALES, DAVID	0	0	0	0	0	0	0	0	0	93	0	93	93
57	MARTIN ARASA, JOSEP	0	0	43	0	46	0	0	0	0	0	0	89	89
58	ESPINOSA VILLAR, BORJA	40	0	47	0	0	0	0	0	0	0	0	87	87
59	CARRILLO HERNANDEZ, DAVID	0	0	85	0	0	0	0	0	0	0	0	85	85
60	NAVARRO BARBERA, JORDI	0	0	0	0	85	0	0	0	0	0	0	85	85
61	FALGAS MORENO, ALEX	0	0	0	0	0	85	0	0	0	0	0	85	85
62	PUIG IZQUIERDO , ANTONI	0	0	0	0	0	0	0	0	0	0	85	85	85
63	CABALLÉ ANDREU, ENRIC	85	0	0	0	0	0	0	0	0	0	0	85	85
64	NOU CASTELL, RAMON	0	0	79	0	0	0	0	0	0	0	0	79	79
65	MESTRE QUEROL, ALBERT	0	0	0	0	0	0	0	0	0	0	79	79	79
66	SANS GRAU, DAVID	0	0	0	0	0	79	0	0	0	0	0	79	79
67	FOLCH PUIG, ENRIC	0	0	0	79	0	0	0	0	0	0	0	79	79
68	PALAU CIVIT, JORDI	0	79	0	0	0	0	0	0	0	0	0	79	79
69	SORIANO LÓPEZ, MARTÍ	0	0	75	0	0	0	0	0	0	0	0	75	75
70	DUEÑAS RODRIGUEZ, ALBERTO	0	0	0	75	0	0	0	0	0	0	0	75	75
71	ABAT BARRERA, IVAN	0	0	0	0	75	0	0	0	0	0	0	75	75
72	SUPELANO TAMBO, JUAN CARLOS	0	0	0	0	0	0	0	0	0	0	73	73	73
73	ALBESA ABADAL, ANDRES	73	0	0	0	0	0	0	0	0	0	0	73	73
74	CÓZAR TORÁN, PEDRO	0	0	0	0	0	0	0	73	0	0	0	73	73
75	GARRIGA MARÍ, JOSEP	0	0	0	71	0	0	0	0	0	0	0	71	71
76	QUERAL FORCADELL, DAVID	71	0	0	0	0	0	0	0	0	0	0	71	71
77	ALEU ARDIACA, JOSEP MARIA	0	0	0	0	0	0	71	0	0	0	0	71	71
78	BUERA REBULLIDA, JOSEP MIQUEL	0	0	0	0	0	0	0	0	0	70	0	70	70
79	GIL ANTEQUERA, PABLO	0	0	0	0	0	70	0	0	0	0	0	70	70
80	GÜELL VILLAR, ORIOL	0	0	69	0	0	0	0	0	0	0	0	69	69
81	RIBERA ROIG, PABLO	0	0	68	0	0	0	0	0	0	0	0	68	68
82	ESCODA SERRES, JORDI	0	0	0	68	0	0	0	0	0	0	0	68	68
83	CURTO RUE, DAVID	0	67	0	0	0	0	0	0	0	0	0	67	67
84	FERRE VADILLO, ENRIC	0	0	0	0	0	67	0	0	0	0	0	67	67
85	MULET PRATS , SALVADOR	0	0	0	0	0	0	0	0	66	0	0	66	66
86	PLA CANALDA, ALBERT	0	0	0	0	0	0	0	66	0	0	0	66	66
87	CASTEJON, JOSE	0	0	0	0	0	0	66	0	0	0	0	66	66
88	DEIXENS MARTINEZ, JOAN	0	0	0	0	65	0	0	0	0	0	0	65	65
89	PIQUERA NARANJO , OSCAR	65	0	0	0	0	0	0	0	0	0	0	65	65
90	MATHEU GAS, XAVI	0	0	0	0	0	0	0	65	0	0	0	65	65
91	LABERNIA FERRE, VICENT	0	0	0	0	0	0	0	0	0	65	0	65	65
92	CORTÉS CALVO, MANU	64	0	0	0	0	0	0	0	0	0	0	64	64
93	ESCUDERO COROMINES, DANI	0	63	0	0	0	0	0	0	0	0	0	63	63
94	CID MESEGUER, SIMON	0	0	0	0	0	0	63	0	0	0	0	63	63
95	FRANCH VENTURA, PERE	0	62	0	0	0	0	0	0	0	0	0	62	62
96	TORRES BERTOMEU, JAUME	0	0	0	0	0	0	0	0	0	0	62	62	62
97	DELLA CALLEN, CARLOS	0	0	0	0	0	61	0	0	0	0	0	61	61
98	FRANCH MARTI, JOSEP	0	0	0	0	0	0	0	61	0	0	0	61	61
99	PELLICER PLAZAS, CHRISTIAN	0	0	0	0	60	0	0	0	0	0	0	60	60
100	DELLA CALLEN, JUAN JOSE	0	0	0	0	0	60	0	0	0	0	0	60	60
101	CID PIUG, J. GABRIEL	0	0	0	0	0	0	0	0	0	60	0	60	60
102	GONZALEZ MORATALLA, ALFREDO	0	0	0	0	0	0	60	0	0	0	0	60	60
103	BOVO , MARIO	0	0	0	0	0	59	0	0	0	0	0	59	59
104	VALLS CLUA, JORDI	0	0	0	0	0	0	0	0	0	59	0	59	59
105	PEREZ FRANCH, JOAN	0	58	0	0	0	0	0	0	0	0	0	58	58
106	ESCODA MARTIN, ISMAEL	58	0	0	0	0	0	0	0	0	0	0	58	58
107	PUTAN, WILSON	0	0	0	0	58	0	0	0	0	0	0	58	58
108	MELICH PUJOL, BENJAMIN	0	0	0	0	0	58	0	0	0	0	0	58	58
109	RODRIGUEZ SUBIRATS, DAVID	0	0	0	0	0	0	0	0	0	58	0	58	58
110	PORTA LAHIGUERA, JOSE LUIS	0	0	0	0	0	0	0	58	0	0	0	58	58
111	ALEXIS, FOUQUET	0	0	0	0	0	0	58	0	0	0	0	58	58
112	VILLARTA ÁLVAREZ, JESÚS MANUEL	0	0	0	0	0	0	0	0	0	57	0	57	57
113	GARCIA I BERTRAN, JOAN	0	0	0	57	0	0	0	0	0	0	0	57	57
114	PINEAU, ALEXANDRE	0	0	0	0	0	0	57	0	0	0	0	57	57
115	MIGUEL GARRIDO, JOSÉ ANTONIO	0	56	0	0	0	0	0	0	0	0	0	56	56
116	LEON JUAREZ, MARCOS	0	0	0	0	56	0	0	0	0	0	0	56	56
117	ALONSO SEBASTIÀ, JORDI	0	0	0	0	0	0	0	0	0	56	0	56	56
118	DAGA RECIO, SEBASTIÀ	0	0	0	0	55	0	0	0	0	0	0	55	55
119	MASCARELL CABALLERO, CASIMIRO	0	0	0	0	0	0	55	0	0	0	0	55	55
120	FORNÓS MONLLAU, MARC	54	0	0	0	0	0	0	0	0	0	0	54	54
121	ROSELLO CASTELLS, ORIOL	0	0	0	0	0	54	0	0	0	0	0	54	54
122	GARRIGA SOROLLA, XAVIER	0	0	0	0	0	53	0	0	0	0	0	53	53
123	NOFRE ROMERA, DOMINGO	0	0	52	0	0	0	0	0	0	0	0	52	52
124	DAZA BERENGUER, DANI	0	52	0	0	0	0	0	0	0	0	0	52	52
125	SUBIRATS FERRERES, IVAN	0	51	0	0	0	0	0	0	0	0	0	51	51
126	SUBIRATS RILLO, ALBERT	0	0	0	0	50	0	0	0	0	0	0	50	50
127	QUIRÓS PONFERRADA, DAVID	50	0	0	0	0	0	0	0	0	0	0	50	50
128	ADELL QUEROL, CHRISTIAN	0	0	0	0	49	0	0	0	0	0	0	49	49
129	SERRA TORTA, ANTON	48	0	0	0	0	0	0	0	0	0	0	48	48
130	JUAN APARICIO, SANTI	47	0	0	0	0	0	0	0	0	0	0	47	47
131	MONTOYA LECEGUI, SANTI	0	47	0	0	0	0	0	0	0	0	0	47	47
132	RODEZNO ELVIR, DANIEL	0	0	46	0	0	0	0	0	0	0	0	46	46
133	TOLDA GIL, MANEL	46	0	0	0	0	0	0	0	0	0	0	46	46
134	FANDOS COLOMINES, FELIP	0	46	0	0	0	0	0	0	0	0	0	46	46
135	FAUS SASTRE, CARLOS	0	0	0	0	45	0	0	0	0	0	0	45	45
136	SANS FERRER, ALBERT	0	0	44	0	0	0	0	0	0	0	0	44	44
137	PAGO TORDERA, JOAN	0	0	0	0	44	0	0	0	0	0	0	44	44
138	LUCAS JARDI, DAVID	44	0	0	0	0	0	0	0	0	0	0	44	44
139	GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT	43	0	0	0	0	0	0	0	0	0	0	43	43
140	VILA SOLÉ, FRANCESC	0	43	0	0	0	0	0	0	0	0	0	43	43
141	RIBAS BEL, ALBERT	0	0	42	0	0	0	0	0	0	0	0	42	42
142	ACCENSI CASAJUST, JOEL	42	0	0	0	0	0	0	0	0	0	0	42	42
143	MARQUEZ, MANEL	0	42	0	0	0	0	0	0	0	0	0	42	42
144	CENTELLES GASCON, ELOI	0	0	41	0	0	0	0	0	0	0	0	41	41
145	GARCIA VIZUETE, JUANSE	0	41	0	0	0	0	0	0	0	0	0	41	41
146	MONTERO AURA, JORDI	0	40	0	0	0	0	0	0	0	0	0	40	40
147	PÉREZ SANZ, RAÚL	0	0	0	0	39	0	0	0	0	0	0	39	39