CLASSIFICACIÓ 10K: VETERÀ-2 MASCULÍ

SELECT historic.nom AS sujeto, historic.dni AS doc, historic.sexe AS sex1, historic.categoria AS cate, corredors.email AS correu, 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, IFNULL((SELECT puntscat FROM historic WHERE idcursa=141 AND dni=doc ),0) AS dotze, IFNULL((SELECT puntscat FROM historic WHERE idcursa=142 AND dni=doc ),0) AS tretze, SUM(historic.puntsgen) AS punts, SUM(historic.empat) AS desempat FROM historic JOIN corredors ON historic.dni = corredors.dni WHERE categoria="VE2 M" GROUP BY historic.dni ORDER BY punts DESC, desempat ASC;

* Per a la classificació final puntuen les 10 millors curses i s’haurà de participar a un mínim de 4 curses per a puntuar.

-F- = Finisher (ha fet totes les curses de la temporada).

Pos	Nom	L'Ampolla	Móra la Nova	L'Aldea	Deltebre	El Perelló Cursa d'Or	La Sénia Cursa d'Or	Camarles	Jesús	Tortosa Cursa d'Or	Santa Bàrbara	Amposta	Gandesa	St Jaume Enveja Cursa d'Or	Total	Punts*
1	QUERAL FORCADELL, XAVI	115	115	115	115	0	0	0	0	0	0	0	0	0	356	460
2	BONET FRANCH, THAIS (A)	85	115	103	115	0	0	0	0	0	0	0	0	0	325	418
3	PÉREZ CARCELLE , PAULA	73	103	85	93	0	0	0	0	0	0	0	0	0	267	354
4	BO BERTOMEU, LORENZO	93	85	79	79	0	0	0	0	0	0	0	0	0	230	336
5	PEPIOL ARGENTÓ, LAURA	103	0	115	103	0	0	0	0	0	0	0	0	0	261
6	DELLA CALLEN, CARLOS	85	79	75	75	0	0	0	0	0	0	0	0	0	211	314
7	FAVA BENEITO, RUBEN	67	70	68	103	0	0	0	0	0	0	0	0	0	180	308
8	CODORNIU MORENO, RAMON	66	71	69	71	0	0	0	0	0	0	0	0	0	155	277
9	CONSTANTIN, SOARE	61	64	63	61	0	0	0	0	0	0	0	0	0	65	249
10	GARCIA BALAGUE, JULI	56	63	64	62	0	0	0	0	0	0	0	0	0	67	245
11	GILABERT PITARCH, MARIA JOSE	0	85	73	79	0	0	0	0	0	0	0	0	0	179
12	SANCHO RALDA, ALFONSO	75	0	73	73	0	0	0	0	0	0	0	0	0	135
13	PANISELLO RODRIGUEZ, SONIA	68	0	71	73	0	0	0	0	0	0	0	0	0	148
14	MARTINEZ MARTI, ALBERT	0	69	70	67	0	0	0	0	0	0	0	0	0	118
15	VIDAL I GARRIGA, JOAN ENRIC	64	66	67	0	0	0	0	0	0	0	0	0	0	94
16	ALAIXENDRI JARDI, MAURO	103	0	93	0	0	0	0	0	0	0	0	0	0	128
17	ESPAÑA GARCÉS, FABIAN	62	0	65	64	0	0	0	0	0	0	0	0	0	51
18	FRANCO CIURANA, JOSÉ ANTONIO	0	59	61	60	0	0	0	0	0	0	0	0	0	37
19	GARCIA SUAREZ, JULIO	0	0	85	93	0	0	0	0	0	0	0	0	0	131
20	GARCIA GARCIA, MARC	0	60	59	59	0	0	0	0	0	0	0	0	0	36
21	FERRE GARCIA, MIGUEL	55	58	60	0	0	0	0	0	0	0	0	0	0	33
22	ROMANI GUART, MONTSE	79	93	0	0	0	0	0	0	0	0	0	0	0	132
23	ORTÍN FONT, XAVIER	0	103	0	63	0	0	0	0	0	0	0	0	0	92
24	MONSERRAT MONTAGUT, SÍLVIA (A)	75	0	79	0	0	0	0	0	0	0	0	0	0	127
25	SEGURA UNIÓ, MÒNICA	0	79	75	0	0	0	0	0	0	0	0	0	0	117
26	PARTIDO TENA, IVAN	73	75	0	0	0	0	0	0	0	0	0	0	0	84
27	SABATER CABRERA, ENRIC	79	0	0	69	0	0	0	0	0	0	0	0	0	76
28	GARCIA ALPAÑES, HECTOR	71	73	0	0	0	0	0	0	0	0	0	0	0	77
29	AYET SALES, DAVID (A)	69	0	71	0	0	0	0	0	0	0	0	0	0	73
30	SERRAL TOMAS, ALVARO	65	0	0	68	0	0	0	0	0	0	0	0	0	46
31	BAYO GODES, IVAN [A]	0	0	66	65	0	0	0	0	0	0	0	0	0	52
32	CID SOLE, OSCAR	0	57	0	70	0	0	0	0	0	0	0	0	0	48
33	AVALOS, ERIKA	115	0	0	0	0	0	0	0	0	0	0	0	0	103
34	FALGAS MORENO, ALEX	0	0	103	0	0	0	0	0	0	0	0	0	0	79
35	LANDACHE, CRIS	93	0	0	0	0	0	0	0	0	0	0	0	0	75
36	CONTRERAS GÓMEZ, LAURA	0	0	93	0	0	0	0	0	0	0	0	0	0	85
37	CASTELLVI, IVAN	0	93	0	0	0	0	0	0	0	0	0	0	0	65
38	BAIGES GIRALT, MARINA	0	0	0	85	0	0	0	0	0	0	0	0	0	62
39	ALIAU ESMEL, JOSE MARI	0	0	0	85	0	0	0	0	0	0	0	0	0	62
40	SEGURA ESTUPIÑÁ , ESTER	0	0	0	75	0	0	0	0	0	0	0	0	0	49
41	SOLÉ ARTIGAU, BEATRIZ	71	0	0	0	0	0	0	0	0	0	0	0	0	55
42	CUGAT GUERRERO, MARTA	70	0	0	0	0	0	0	0	0	0	0	0	0	51
43	GARCIA AMELA, BELEN	0	0	70	0	0	0	0	0	0	0	0	0	0	57
44	LLUIS LLANSAMA, GABRIEL (A)	70	0	0	0	0	0	0	0	0	0	0	0	0	26
45	GARCIA ALTADILL, ANGELS	69	0	0	0	0	0	0	0	0	0	0	0	0	49
46	ROIG MESTRE , MARI CARMEN	0	0	69	0	0	0	0	0	0	0	0	0	0	56
47	OBIOL REVERTE, RAMON (A)	68	0	0	0	0	0	0	0	0	0	0	0	0	23
48	BADENAS GUINJOAN, CARLOS	0	68	0	0	0	0	0	0	0	0	0	0	0	43
49	GARCIA ALTADILL, NURIA	67	0	0	0	0	0	0	0	0	0	0	0	0	39
50	VILANOVA ARRUFAT, IVAN	0	67	0	0	0	0	0	0	0	0	0	0	0	41
51	MIRÓ JUAN, RUBEN	0	0	0	66	0	0	0	0	0	0	0	0	0	24
52	GIRONÉS PEDROL, LLUIS	0	65	0	0	0	0	0	0	0	0	0	0	0	33
53	CASES BLANCH, CARLES	63	0	0	0	0	0	0	0	0	0	0	0	0	8
54	ARTIGAS BELTRAN, MIQUEL	0	62	0	0	0	0	0	0	0	0	0	0	0	23
55	TORTA SIMÓ, JOAN	0	0	62	0	0	0	0	0	0	0	0	0	0	24
56	PERELLÓ COMPTE , OVIDI	0	61	0	0	0	0	0	0	0	0	0	0	0	22
57	FORCADELL MORALES, ALFONS	60	0	0	0	0	0	0	0	0	0	0	0	0	2
58	GARRIGA SOROLLA, XAVIER	59	0	0	0	0	0	0	0	0	0	0	0	0	2
59	ARASA PELLISA, ANGEL	58	0	0	0	0	0	0	0	0	0	0	0	0	2
60	ESKU, DANI	57	0	0	0	0	0	0	0	0	0	0	0	0	2
61	ANFRUNS ORTIZ, MARC	54	0	0	0	0	0	0	0	0	0	0	0	0	2
62	GOMEZ MARTINEZ, JOSE LUIS	53	0	0	0	0	0	0	0	0	0	0	0	0	2

* Per a la classificació final puntuen les 10 millors curses i s’haurà de participar a un mínim de 4 curses per a puntuar.

-F- = Finisher (ha fet totes les curses de la temporada).

comunicar incidències sobre les classificacions.
Per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.