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	Ulldecona	Perelló	S.Bàrbara	Camarles	Tortosa	Total	Punts
1	CURTO I GILABERT, DAVID	73	75	93	93	79	85	103	601	601
2	PUENTES GARCÍA, LUIS FCO	0	115	103	115	103	0	115	551	551
3	LLEIXÀ CHAVARRIA, JOSEP	66	66	71	85	75	79	75	517	517
4	ALABART ALCOBER, JOSEP MARIA	85	103	115	103	85	0	0	491	491
5	CABANES CALVET, ALBERT	64	68	70	75	68	73	69	487	487
6	FIBLA REVERTER, HERMINI	62	67	69	70	69	71	68	476	476
7	FORTUÑO NAVARRO, JOSE LUIS	59	63	66	69	67	68	66	458	458
8	GRANGÉ GALINDO, JOSEP LLUIS	54	64	65	66	62	66	64	441	441
9	REVERTER BULLON, JOSE MIGUEL	55	59	63	65	60	62	60	424	424
10	LLUIS LLANSAMA, GABRIEL	67	70	0	73	70	75	67	422	422
11	FORNÉ CASTELLS, XAVIER	115	0	0	0	115	115	0	345	345
12	SERRET ROIG, ADRIA	65	65	0	68	66	67	0	331	331
13	CAÑÍS SÁNCHEZ, DANIEL	56	57	64	67	64	0	0	308	308
14	ESCURRIOLA NAVARRO, RAMON	0	69	73	79	0	0	73	294	294
15	SABATER CABRERA, ENRIC	0	71	85	0	0	0	85	241	241
16	LEÓN MORA, AUGUSTO LEO	61	0	0	0	65	69	0	195	195
17	MONTERO PÈREZ, JOSEP MARIA	93	93	0	0	0	0	0	186	186
18	ADELL WINKLER, PERE	52	56	0	64	0	0	0	172	172
19	ESQUERRE FERRE, ROMAN	69	73	0	0	0	0	0	142	142
20	RIBES SERRA, JOSEP MARIA	0	0	0	0	61	65	0	126	126
21	GARCIA DRAGO, JOSEP	58	60	0	0	0	0	0	118	118
22	ARASA CARDONA, RICARD	0	53	0	0	0	60	0	113	113
23	BELTRAN SUBIRATS, JOSEP MARIA	51	55	0	0	0	0	0	106	106
24	BALASTEGUI CONTRERAS, FRANCISCO	0	0	0	0	0	103	0	103	103
25	PEREZ MUÑOZ, FRANCISCO JESUS	103	0	0	0	0	0	0	103	103
26	FRANCOME GUTIERREZ, DAVID	0	0	0	0	93	0	0	93	93
27	ALONSO BURGOS , DAVID	0	0	0	0	0	93	0	93	93
28	VILLAUBI, GERARD	0	0	0	0	0	0	93	93	93
29	MONLLEO ROYO, LIBERTO	0	85	0	0	0	0	0	85	85
30	REPISO MARTINEZ, JOAN	0	79	0	0	0	0	0	79	79
31	GRAU SANZ, MAX	79	0	0	0	0	0	0	79	79
32	ROMERO BELTRAN, ANTONIO MANUEL	0	0	0	0	0	0	79	79	79
33	BELTRAN ARQUES, JUAN FRANCISCO	0	0	79	0	0	0	0	79	79
34	TONDA SALVADÓ, JOSEP LLUIS	75	0	0	0	0	0	0	75	75
35	MARESMA FELIPO, JOAN	0	0	75	0	0	0	0	75	75
36	VENTURA CASTELLS, JOAN	0	0	0	0	73	0	0	73	73
37	SAIZ VIVES, JOSE MARIA	0	0	0	0	0	0	71	71	71
38	GARCIA SANGÜESA, DAMIÀ	71	0	0	0	0	0	0	71	71
39	RIUS CERVELLO, JOSEP ANTONI	0	0	0	0	71	0	0	71	71
40	SOTA MARTI, CARLOS	0	0	0	71	0	0	0	71	71
41	ALIMBAU REVERTE, MIQUEL	70	0	0	0	0	0	0	70	70
42	FERRER SABATÉ, ROGER	0	0	0	0	0	0	70	70	70
43	BUSTOS FUENTES, ANDRES	0	0	0	0	0	70	0	70	70
44	ACERO VENDRELL, ALVARO	68	0	0	0	0	0	0	68	68
45	GUZMAN MORCILLO, PACO	0	0	68	0	0	0	0	68	68
46	MARTORELL RUBIO, JORDI	0	0	67	0	0	0	0	67	67
47	MARÍN GIMÉNEZ, FERNANDO	0	0	0	0	0	0	65	65	65
48	CURTO NACHER, ALEX	0	0	0	0	0	64	0	64	64
49	LLETI NAVARRO, FERNANDO	63	0	0	0	0	0	0	63	63
50	PRADES CURTO, MICHEL	0	0	0	0	0	63	0	63	63
51	CALLARISA GAVALDA, RAMON	0	0	0	0	63	0	0	63	63
52	CANO LEON, RICARDO	0	0	0	0	0	0	63	63	63
53	MARTI GUARI, DAVID	0	62	0	0	0	0	0	62	62
54	GARCIA REDONDO, DOMINGO	0	0	62	0	0	0	0	62	62
55	GARCIA CALERO, ENRIQUE JAVIER	0	0	0	0	0	0	62	62	62
56	SOLÉ PÀMIES, RAMON	0	61	0	0	0	0	0	61	61
57	ADRIANUS JOHANNES, ARTHUR	0	0	0	0	0	0	61	61	61
58	GALVE CURTO, FERNANDO	0	0	0	0	0	61	0	61	61
59	GALARZA SANCHEZ, ALEJANDRO	0	0	61	0	0	0	0	61	61
60	VALDIVIAS AHUMADA, OSCAR	60	0	0	0	0	0	0	60	60
61	EIXARCH CONESA, LLUIS	0	0	0	0	59	0	0	59	59
62	TIRON CAMISON, JAUME	0	0	0	0	0	59	0	59	59
63	CABRERA CABALLÉ, MARCOS	0	58	0	0	0	0	0	58	58
64	TAFALLA ANDREU, QUIM	0	0	0	0	58	0	0	58	58
65	MASOLLER ARIAS, FRANCESC	57	0	0	0	0	0	0	57	57
66	PEIRET DE LA FUENTE, CARLES	0	54	0	0	0	0	0	54	54
67	TOMÀS I ROIGET, ADAM	53	0	0	0	0	0	0	53	53
68	LOZANO HERNANDEZ, JOSE MARIA	50	0	0	0	0	0	0	50	50

Amb el suport de: