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 AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 SOWE , MUSA 103115931151151151151151151150 1116 920
2 CASTELLS LOPEZ, RAMON 687170937975939369710 782 645
3 GUART AUXACHS, JOAN 526561646269757973750 675 562
4 ZARAGOZA VALLDEPEREZ, RAMON 666864696863707165640 668 541
5 LLEIXA GUARRO, IVAN 070667369680079850 510 510
6 ASÍN QUEROL, JAVI 707371071079756800 507 507
7 ALEMANY SEBASTIA , SAMUEL 93010301030103103000 505 505
8 ULLDEMOLINS TODÓ, ALFONS 670656767667306700 472 472
9 GARCIA SUAREZ, JULIO CESAR 000656464686963690 462 462
10 SOTA MARTÍ, JORDI 75857385730007000 461 461
11 CUGAT MULET, JAUME 054566206267686400 433 433
12 CASTELLS FABRA, LLUIS 4100554052565757550 413 413
13 TORRES BERTOMEU, JOSEP 050485952006360610 393 393
14 VALLESPI DE LA CRUZ, JORDI 6975670000700680 349 349
15 VIUDEZ TOMÀS, MARTÍ 093000730075730 314 314
16 TALARN CAUBET, JOAQUIM 5357000006762670 306 306
17 SUBIRATS CID, JORDI 04540043575960000 304 304
18 TORRES , JORGE 0534961590064000 286 286
19 VILANOVA ARDIT, JOSEP 000707071007100 282 282
20 SEBASTIA VALLDEPEREZ, JORDI 4949058006162000 279 279
21 GINÉ CID, ALBERT 791030000085000 267 267
22 VILLAR MORERA, JOSE LUIS 556155630000000 234 234
23 JUAN-CAMPS CASTELL, AGUS 115011500000000 230 230
24 ROMEU ESQUERRÉ, FERNANDO 510005306206100 227 227
25 GRAU VIDAL, ALBERTO 00626663000000 191 191
26 TOMAS PORRES, CARLOS 63666000000000 189 189
27 EL JIHAOUI, AZZIZ 00000103008500 188 188
28 GARCIA ARGENTÓ, VICENT 0000093009300 186 186
29 VALMAÑA, ELOY 59645800000000 181 181
30 REDÓ GÓMEZ, JUAN CARLOS 05559061000000 175 175
31 MARTOS MARTI, ANGEL 60605400000000 174 174
32 SERRET GOMEZ, JUAN CARLOS 454438041000000 168 168
33 LEANDRO QUERO, JORDI 0000008500790 164 164
34 TORREBLANCA CERVELLÓ, JOSE ANGEL 00510510000620 164 164
35 FERNANDO ROYAL, JOSEP ENRIC 00536048000000 161 161
36 MIRALLES LLORCA, JESÚS 04845047000000 140 140
37 PUIG CARLES, JOSEP 0000065690000 134 134
38 BELTRAN COLLADO, ORIOL 0000006400660 130 130
39 FERNANDEZ AGUIAR, MANU 0063066000000 129 129
40 REDO PRINCEP, RICARD 5600000650000 121 121
41 SANCHO RALDA, ALFONSO 0000570000630 120 120
42 SORIANO LOPEZ, ANTONIO 6205700000000 119 119
43 CURTO CODORNIU, PAU 0000000595800 117 117
44 QUERALT ROIG, DANI 5759000000000 116 116
45 ARIÑO FUSTÉ, PEDRO 0000055005900 114 114
46 GARBI HUERGA, CARLOS TOMÁS 0005605600000 112 112
47 SOTOMAYOR DUQUE, XAVI 6105000000000 111 111
48 TARRAGÓ COLOMER, ROBERT 0001030000000 103 103
49 ULLAH, AHSAN 0000000010300 103 103
50 GARCIA FERNANDEZ, JORGE 0000000001030 103 103
51 VILAR ALCÁZAR, DAVID 000093000000 93 93
52 RODA SALES, DAVID 000000000930 93 93
53 MARTIN ARASA, JOSEP 0043046000000 89 89
54 ESPINOSA VILLAR, BORJA 4004700000000 87 87
55 CARRILLO HERNANDEZ, DAVID 008500000000 85 85
56 NAVARRO BARBERA, JORDI 000085000000 85 85
57 FALGAS MORENO, ALEX 000008500000 85 85
58 CABALLÉ ANDREU, ENRIC 850000000000 85 85
59 SEGUER GARCIA, JAIME 0039042000000 81 81
60 NOU CASTELL, RAMON 007900000000 79 79
61 SANS GRAU, DAVID 000007900000 79 79
62 FOLCH PUIG, ENRIC 000790000000 79 79
63 PALAU CIVIT, JORDI 079000000000 79 79
64 SORIANO LÓPEZ, MARTÍ 007500000000 75 75
65 DUEÑAS RODRIGUEZ, ALBERTO 000750000000 75 75
66 ABAT BARRERA, IVAN 000075000000 75 75
67 ALBESA ABADAL, ANDRES 730000000000 73 73
68 CÓZAR TORÁN, PEDRO 000000073000 73 73
69 GARRIGA MARÍ, JOSEP 000710000000 71 71
70 QUERAL FORCADELL, DAVID 710000000000 71 71
71 ALEU ARDIACA, JOSEP MARIA 000000710000 71 71
72 BUERA REBULLIDA , JOSEP MIQUEL 000000000700 70 70
73 GIL ANTEQUERA, PABLO 000007000000 70 70
74 GÜELL VILLAR, ORIOL 006900000000 69 69
75 CAMARERO LÓPEZ, GUILLERMO 069000000000 69 69
76 RIBERA ROIG, PABLO 006800000000 68 68
77 ESCODA SERRES, JORDI 000680000000 68 68
78 CURTO RUE, DAVID 067000000000 67 67
79 FERRE VADILLO, ENRIC 000006700000 67 67
80 MULET PRATS , SALVADOR 000000006600 66 66
81 PLA CANALDA, ALBERT 000000066000 66 66
82 CASTEJON, JOSE 000000660000 66 66
83 DEIXENS MARTINEZ, JOAN 000065000000 65 65
84 PIQUERA NARANJO , OSCAR 650000000000 65 65
85 MATHEU GAS, XAVI 000000065000 65 65
86 LABERNIA FERRE, VICENT 000000000650 65 65
87 CORTÉS CALVO, MANU 640000000000 64 64
88 ESCUDERO COROMINES, DANI 063000000000 63 63
89 CID MESEGUER, SIMON 000000630000 63 63
90 FRANCH VENTURA, PERE 062000000000 62 62
91 DELLA CALLEN, CARLOS 000006100000 61 61
92 FRANCH MARTI, JOSEP 000000061000 61 61
93 PELLICER PLAZAS, CHRISTIAN 000060000000 60 60
94 DELLA CALLEN, JUAN JOSE 000006000000 60 60
95 CID PIUG, J. GABRIEL 000000000600 60 60
96 GONZALEZ MORATALLA, ALFREDO 000000600000 60 60
97 BOVO , MARIO 000005900000 59 59
98 VALLS CLUA, JORDI 000000000590 59 59
99 PEREZ FRANCH, JOAN 058000000000 58 58
100 ESCODA MARTIN, ISMAEL 580000000000 58 58
101 PUTAN, WILSON 000058000000 58 58
102 MELICH PUJOL, BENJAMIN 000005800000 58 58
103 RODRIGUEZ SUBIRATS, DAVID 000000000580 58 58
104 PORTA LAHIGUERA, JOSE LUIS 000000058000 58 58
105 ALEXIS, FOUQUET 000000580000 58 58
106 VILLARTA ÁLVAREZ, JESÚS MANUEL 000000000570 57 57
107 GARCIA I BERTRAN, JOAN 000570000000 57 57
108 PINEAU, ALEXANDRE 000000570000 57 57
109 MIGUEL GARRIDO, JOSÉ ANTONIO 056000000000 56 56
110 LEON JUAREZ, MARCOS 000056000000 56 56
111 ALONSO SEBASTIÀ, JORDI 000000000560 56 56
112 DAGA RECIO, SEBASTIÀ 000055000000 55 55
113 MASCARELL CABALLERO, CASIMIRO 000000550000 55 55
114 MONTESÓ JIMENEZ, DAVID 000054000000 54 54
115 FORNÓS MONLLAU, MARC 540000000000 54 54
116 ROSELLO CASTELLS, ORIOL 000005400000 54 54
117 GARRIGA SOROLLA, XAVIER 000005300000 53 53
118 NOFRE ROMERA, DOMINGO 005200000000 52 52
119 DAZA BERENGUER, DANI 052000000000 52 52
120 SUBIRATS FERRERES, IVAN 051000000000 51 51
121 SUBIRATS RILLO, ALBERT 000050000000 50 50
122 QUIRÓS PONFERRADA, DAVID 500000000000 50 50
123 ADELL QUEROL, CHRISTIAN 000049000000 49 49
124 SERRA TORTA, ANTON 480000000000 48 48
125 JUAN APARICIO, SANTI 470000000000 47 47
126 MONTOYA LECEGUI, SANTI 047000000000 47 47
127 RODEZNO ELVIR, DANIEL 004600000000 46 46
128 TOLDA GIL, MANEL 460000000000 46 46
129 FANDOS COLOMINES, FELIP 046000000000 46 46
130 FAUS SASTRE, CARLOS 000045000000 45 45
131 SANS FERRER, ALBERT 004400000000 44 44
132 PAGO TORDERA, JOAN 000044000000 44 44
133 LUCAS JARDI, DAVID 440000000000 44 44
134 GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT 430000000000 43 43
135 VILA SOLÉ, FRANCESC 043000000000 43 43
136 RIBAS BEL, ALBERT 004200000000 42 42
137 ACCENSI CASAJUST, JOEL 420000000000 42 42
138 MARQUEZ, MANEL 042000000000 42 42
139 CENTELLES GASCON, ELOI 004100000000 41 41
140 GARCIA VIZUETE, JUANSE 041000000000 41 41
141 MONTERO AURA, JORDI 040000000000 40 40
142 PÉREZ SANZ, RAÚL 000039000000 39 39




Amb el suport de: