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 103115931151151151150000 771 771
2 CASTELLS LOPEZ, RAMON 687170937975930000 549 549
3 ZARAGOZA VALLDEPEREZ, RAMON 666864696863700000 468 468
4 GUART AUXACHS, JOAN 526561646269750000 448 448
5 ULLDEMOLINS TODÓ, ALFONS 67065676766730000 405 405
6 ALEMANY SEBASTIA , SAMUEL 930103010301030000 402 402
7 SOTA MARTÍ, JORDI 7585738573000000 391 391
8 ASÍN QUEROL, JAVI 7073710710790000 364 364
9 LLEIXA GUARRO, IVAN 0706673696800000 346 346
10 CUGAT MULET, JAUME 0545662062670000 301 301
11 GARCIA SUAREZ, JULIO CESAR 000656464680000 261 261
12 SUBIRATS CID, JORDI 0454004357590000 244 244
13 CASTELLS FABRA, LLUIS 4100554052560000 244 244
14 VILLAR MORERA, JOSE LUIS 556155630000000 234 234
15 JUAN-CAMPS CASTELL, AGUS 115011500000000 230 230
16 TORRES , JORGE 053496159000000 222 222
17 SEBASTIA VALLDEPEREZ, JORDI 494905800610000 217 217
18 VALLESPI DE LA CRUZ, JORDI 69756700000000 211 211
19 VILANOVA ARDIT, JOSEP 00070707100000 211 211
20 TORRES BERTOMEU, JOSEP 050485952000000 209 209
21 GRAU VIDAL, ALBERTO 00626663000000 191 191
22 TOMAS PORRES, CARLOS 63666000000000 189 189
23 GINÉ CID, ALBERT 79103000000000 182 182
24 VALMAÑA, ELOY 59645800000000 181 181
25 REDÓ GÓMEZ, JUAN CARLOS 05559061000000 175 175
26 MARTOS MARTI, ANGEL 60605400000000 174 174
27 SERRET GOMEZ, JUAN CARLOS 454438041000000 168 168
28 VIUDEZ TOMÀS, MARTÍ 0930007300000 166 166
29 ROMEU ESQUERRÉ, FERNANDO 51000530620000 166 166
30 FERNANDO ROYAL, JOSEP ENRIC 00536048000000 161 161
31 MIRALLES LLORCA, JESÚS 04845047000000 140 140
32 PUIG CARLES, JOSEP 0000065690000 134 134
33 FERNANDEZ AGUIAR, MANU 0063066000000 129 129
34 REDO PRINCEP, RICARD 5600000650000 121 121
35 SORIANO LOPEZ, ANTONIO 6205700000000 119 119
36 QUERALT ROIG, DANI 5759000000000 116 116
37 GARBI HUERGA, CARLOS TOMÁS 0005605600000 112 112
38 SOTOMAYOR DUQUE, XAVI 6105000000000 111 111
39 TALARN CAUBET, JOAQUIM 5357000000000 110 110
40 EL JIHAOUI, AZZIZ 0000010300000 103 103
41 TARRAGÓ COLOMER, ROBERT 0001030000000 103 103
42 TORREBLANCA CERVELLÓ, JOSE ANGEL 0051051000000 102 102
43 VILAR ALCÁZAR, DAVID 000093000000 93 93
44 GARCIA ARGENTÓ, VICENT 000009300000 93 93
45 MARTIN ARASA, JOSEP 0043046000000 89 89
46 ESPINOSA VILLAR, BORJA 4004700000000 87 87
47 CARRILLO HERNANDEZ, DAVID 008500000000 85 85
48 NAVARRO BARBERA, JORDI 000085000000 85 85
49 FALGAS MORENO, ALEX 000008500000 85 85
50 CABALLÉ ANDREU, ENRIC 850000000000 85 85
51 LEANDRO QUERO, JORDI 000000850000 85 85
52 SEGUER GARCIA, JAIME 0039042000000 81 81
53 NOU CASTELL, RAMON 007900000000 79 79
54 SANS GRAU, DAVID 000007900000 79 79
55 FOLCH PUIG, ENRIC 000790000000 79 79
56 PALAU CIVIT, JORDI 079000000000 79 79
57 SORIANO LÓPEZ, MARTÍ 007500000000 75 75
58 DUEÑAS RODRIGUEZ, ALBERTO 000750000000 75 75
59 ABAT BARRERA, IVAN 000075000000 75 75
60 ALBESA ABADAL, ANDRES 730000000000 73 73
61 GARRIGA MARÍ, JOSEP 000710000000 71 71
62 QUERAL FORCADELL, DAVID 710000000000 71 71
63 ALEU ARDIACA, JOSEP MARIA 000000710000 71 71
64 GIL ANTEQUERA, PABLO 000007000000 70 70
65 GÜELL VILLAR, ORIOL 006900000000 69 69
66 CAMARERO LÓPEZ, GUILLERMO 069000000000 69 69
67 RIBERA ROIG, PABLO 006800000000 68 68
68 ESCODA SERRES, JORDI 000680000000 68 68
69 CURTO RUE, DAVID 067000000000 67 67
70 FERRE VADILLO, ENRIC 000006700000 67 67
71 CASTEJON, JOSE 000000660000 66 66
72 DEIXENS MARTINEZ, JOAN 000065000000 65 65
73 PIQUERA NARANJO , OSCAR 650000000000 65 65
74 CORTÉS CALVO, MANU 640000000000 64 64
75 BELTRAN COLLADO, ORIOL 000000640000 64 64
76 ESCUDERO COROMINES, DANI 063000000000 63 63
77 CID MESEGUER, SIMON 000000630000 63 63
78 FRANCH VENTURA, PERE 062000000000 62 62
79 DELLA CALLEN, CARLOS 000006100000 61 61
80 PELLICER PLAZAS, CHRISTIAN 000060000000 60 60
81 DELLA CALLEN, JUAN JOSE 000006000000 60 60
82 GONZALEZ MORATALLA, ALFREDO 000000600000 60 60
83 BOVO , MARIO 000005900000 59 59
84 PEREZ FRANCH, JOAN 058000000000 58 58
85 ESCODA MARTIN, ISMAEL 580000000000 58 58
86 PUTAN, WILSON 000058000000 58 58
87 MELICH PUJOL, BENJAMIN 000005800000 58 58
88 ALEXIS, FOUQUET 000000580000 58 58
89 SANCHO RALDA, ALFONSO 000057000000 57 57
90 GARCIA I BERTRAN, JOAN 000570000000 57 57
91 PINEAU, ALEXANDRE 000000570000 57 57
92 MIGUEL GARRIDO, JOSÉ ANTONIO 056000000000 56 56
93 LEON JUAREZ, MARCOS 000056000000 56 56
94 DAGA RECIO, SEBASTIÀ 000055000000 55 55
95 ARIÑO FUSTÉ, PEDRO 000005500000 55 55
96 MASCARELL CABALLERO, CASIMIRO 000000550000 55 55
97 MONTESÓ JIMENEZ, DAVID 000054000000 54 54
98 FORNÓS MONLLAU, MARC 540000000000 54 54
99 ROSELLO CASTELLS, ORIOL 000005400000 54 54
100 GARRIGA SOROLLA, XAVIER 000005300000 53 53
101 NOFRE ROMERA, DOMINGO 005200000000 52 52
102 DAZA BERENGUER, DANI 052000000000 52 52
103 SUBIRATS FERRERES, IVAN 051000000000 51 51
104 SUBIRATS RILLO, ALBERT 000050000000 50 50
105 QUIRÓS PONFERRADA, DAVID 500000000000 50 50
106 ADELL QUEROL, CHRISTIAN 000049000000 49 49
107 SERRA TORTA, ANTON 480000000000 48 48
108 JUAN APARICIO, SANTI 470000000000 47 47
109 MONTOYA LECEGUI, SANTI 047000000000 47 47
110 RODEZNO ELVIR, DANIEL 004600000000 46 46
111 TOLDA GIL, MANEL 460000000000 46 46
112 FANDOS COLOMINES, FELIP 046000000000 46 46
113 FAUS SASTRE, CARLOS 000045000000 45 45
114 SANS FERRER, ALBERT 004400000000 44 44
115 PAGO TORDERA, JOAN 000044000000 44 44
116 LUCAS JARDI, DAVID 440000000000 44 44
117 GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT 430000000000 43 43
118 VILA SOLÉ, FRANCESC 043000000000 43 43
119 RIBAS BEL, ALBERT 004200000000 42 42
120 ACCENSI CASAJUST, JOEL 420000000000 42 42
121 MARQUEZ, MANEL 042000000000 42 42
122 CENTELLES GASCON, ELOI 004100000000 41 41
123 GARCIA VIZUETE, JUANSE 041000000000 41 41
124 MONTERO AURA, JORDI 040000000000 40 40
125 PÉREZ SANZ, RAÚL 000039000000 39 39




Amb el suport de: