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	Jesús	Deltebre	La Galera	Total	Punts
1	PUENTES GARCÍA, LUIS FCO	0	115	103	115	103	0	115	103	103	0	757	757
2	CURTO I GILABERT, DAVID	73	75	93	93	79	85	103	0	93	0	694	694
3	ALABART ALCOBER, JOSEP MARIA	85	103	115	103	85	0	0	85	79	0	655	655
4	LLEIXÀ CHAVARRIA, JOSEP	66	66	71	85	75	79	75	79	85	93	774	642
5	LLUIS LLANSAMA, GABRIEL	67	70	0	73	70	75	67	73	71	85	651	584
6	CABANES CALVET, ALBERT	64	68	70	75	68	73	69	68	70	79	704	572
7	FIBLA REVERTER, HERMINI	62	67	69	70	69	71	68	70	0	75	621	559
8	FORTUÑO NAVARRO, JOSE LUIS	59	63	66	69	67	68	66	69	69	71	667	545
9	GRANGÉ GALINDO, JOSEP LLUIS	54	64	65	66	62	66	64	67	67	68	643	527
10	REVERTER BULLON, JOSE MIGUEL	55	59	63	65	60	62	60	66	68	69	627	513
11	ESCURRIOLA NAVARRO, RAMON	0	69	73	79	0	0	73	75	73	0	442	442
12	FORNÉ CASTELLS, XAVIER	115	0	0	0	115	115	0	0	0	0	345	345
13	SERRET ROIG, ADRIA	65	65	0	68	66	67	0	0	0	0	331	331
14	SABATER CABRERA, ENRIC	0	71	85	0	0	0	85	0	75	0	316	316
15	CAÑÍS SÁNCHEZ, DANIEL	56	57	64	67	64	0	0	0	0	0	308	308
16	LEÓN MORA, AUGUSTO LEO	61	0	0	0	65	69	0	0	0	70	265	265
17	ADELL WINKLER, PERE	52	56	0	64	0	0	0	0	65	0	237	237
18	DE TORRES BURGOS, FERRAN	0	0	0	0	0	0	0	115	0	115	230	230
19	MONTERO PÈREZ, JOSEP MARIA	93	93	0	0	0	0	0	0	0	0	186	186
20	BELTRAN SUBIRATS, JOSEP MARIA	51	55	0	0	0	0	0	64	0	0	170	170
21	GARCIA REDONDO, DOMINGO	0	0	62	0	0	0	0	0	0	103	165	165
22	ESQUERRE FERRE, ROMAN	69	73	0	0	0	0	0	0	0	0	142	142
23	GALARZA SANCHEZ, ALEJANDRO	0	0	61	0	0	0	0	0	0	66	127	127
24	RIBES SERRA, JOSEP MARIA	0	0	0	0	61	65	0	0	0	0	126	126
25	GARCIA DRAGO, JOSEP	58	60	0	0	0	0	0	0	0	0	118	118
26	FRANCOME GUTIERREZ, DAVID	0	0	0	0	0	0	0	0	115	0	115	115
27	ARASA CARDONA, RICARD	0	53	0	0	0	60	0	0	0	0	113	113
28	BALASTEGUI CONTRERAS, FRANCISCO	0	0	0	0	0	103	0	0	0	0	103	103
29	PEREZ MUÑOZ, FRANCISCO JESUS	103	0	0	0	0	0	0	0	0	0	103	103
30	FRANCOME GUTIERREZ, DAVID	0	0	0	0	93	0	0	0	0	0	93	93
31	ALAIXENDRI JARDÍ, OSCAR	0	0	0	0	0	0	0	93	0	0	93	93
32	ALONSO BURGOS , DAVID	0	0	0	0	0	93	0	0	0	0	93	93
33	VILLAUBI, GERARD	0	0	0	0	0	0	93	0	0	0	93	93
34	MONLLEO ROYO, LIBERTO	0	85	0	0	0	0	0	0	0	0	85	85
35	REPISO MARTINEZ, JOAN	0	79	0	0	0	0	0	0	0	0	79	79
36	GRAU SANZ, MAX	79	0	0	0	0	0	0	0	0	0	79	79
37	ROMERO BELTRAN, ANTONIO MANUEL	0	0	0	0	0	0	79	0	0	0	79	79
38	BELTRAN ARQUES, JUAN FRANCISCO	0	0	79	0	0	0	0	0	0	0	79	79
39	TONDA SALVADÓ, JOSEP LLUIS	75	0	0	0	0	0	0	0	0	0	75	75
40	MARESMA FELIPO, JOAN	0	0	75	0	0	0	0	0	0	0	75	75
41	VENTURA CASTELLS, JOAN	0	0	0	0	73	0	0	0	0	0	73	73
42	BORT I CORTIELLA, JOSEP JOAN	0	0	0	0	0	0	0	0	0	73	73	73
43	SAIZ VIVES, JOSE MARIA	0	0	0	0	0	0	71	0	0	0	71	71
44	GARCIA SANGÜESA, DAMIÀ	71	0	0	0	0	0	0	0	0	0	71	71
45	RIUS CERVELLO, JOSEP ANTONI	0	0	0	0	71	0	0	0	0	0	71	71
46	PARÉS MARTÍNEZ, CARLES	0	0	0	0	0	0	0	71	0	0	71	71
47	SOTA MARTI, CARLOS	0	0	0	71	0	0	0	0	0	0	71	71
48	ALIMBAU REVERTE, MIQUEL	70	0	0	0	0	0	0	0	0	0	70	70
49	FERRER SABATÉ, ROGER	0	0	0	0	0	0	70	0	0	0	70	70
50	BUSTOS FUENTES, ANDRES	0	0	0	0	0	70	0	0	0	0	70	70
51	ACERO VENDRELL, ALVARO	68	0	0	0	0	0	0	0	0	0	68	68
52	GUZMAN MORCILLO, PACO	0	0	68	0	0	0	0	0	0	0	68	68
53	MARTORELL RUBIO, JORDI	0	0	67	0	0	0	0	0	0	0	67	67
54	OLMO GARCIA, ENRIC	0	0	0	0	0	0	0	0	0	67	67	67
55	BARREDA BARREDA , DIEGO	0	0	0	0	0	0	0	0	66	0	66	66
56	MARÍN GIMÉNEZ, FERNANDO	0	0	0	0	0	0	65	0	0	0	65	65
57	PARES MARTÍNEZ, DAVID	0	0	0	0	0	0	0	65	0	0	65	65
58	CURTO NACHER, ALEX	0	0	0	0	0	64	0	0	0	0	64	64
59	LLETI NAVARRO, FERNANDO	63	0	0	0	0	0	0	0	0	0	63	63
60	PRADES CURTO, MICHEL	0	0	0	0	0	63	0	0	0	0	63	63
61	CALLARISA GAVALDA, RAMON	0	0	0	0	63	0	0	0	0	0	63	63
62	CANO LEON, RICARDO	0	0	0	0	0	0	63	0	0	0	63	63
63	MALLÉN BARBERÀ, EDUARD	0	0	0	0	0	0	0	63	0	0	63	63
64	MARTI GUARI, DAVID	0	62	0	0	0	0	0	0	0	0	62	62
65	GARCIA CALERO, ENRIQUE JAVIER	0	0	0	0	0	0	62	0	0	0	62	62
66	TEJEDA GIL, TOMÀS	0	0	0	0	0	0	0	62	0	0	62	62
67	SOLÉ PÀMIES, RAMON	0	61	0	0	0	0	0	0	0	0	61	61
68	ADRIANUS JOHANNES, ARTHUR	0	0	0	0	0	0	61	0	0	0	61	61
69	GALVE CURTO, FERNANDO	0	0	0	0	0	61	0	0	0	0	61	61
70	VALDIVIAS AHUMADA, OSCAR	60	0	0	0	0	0	0	0	0	0	60	60
71	EIXARCH CONESA, LLUIS	0	0	0	0	59	0	0	0	0	0	59	59
72	TIRON CAMISON, JAUME	0	0	0	0	0	59	0	0	0	0	59	59
73	CABRERA CABALLÉ, MARCOS	0	58	0	0	0	0	0	0	0	0	58	58
74	TAFALLA ANDREU, QUIM	0	0	0	0	58	0	0	0	0	0	58	58
75	MASOLLER ARIAS, FRANCESC	57	0	0	0	0	0	0	0	0	0	57	57
76	PEIRET DE LA FUENTE, CARLES	0	54	0	0	0	0	0	0	0	0	54	54
77	TOMÀS I ROIGET, ADAM	53	0	0	0	0	0	0	0	0	0	53	53
78	LOZANO HERNANDEZ, JOSE MARIA	50	0	0	0	0	0	0	0	0	0	50	50

Amb el suport de: