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




Amb el suport de: