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