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'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 SOLANAS PEREZ, SERGIO 9310300000000 196 196
2 CASTELLS LOPEZ, RAMON 739300000000 166 166
3 ASÍN QUEROL, JAVI 718500000000 156 156
4 SOTA MARTÍ, JORDI 757900000000 154 154
5 GARCIA SUAREZ, JULIO CESAR 687500000000 143 143
6 GÜELL VILLAR, ORIOL 697300000000 142 142
7 BUERA REBULLIDA, JOSEP MIQUEL 677100000000 138 138
8 ULLDEMOLINS TODÓ, ALFONS 657000000000 135 135
9 ZARAGOZA VALLDEPEREZ, RAMON 646900000000 133 133
10 VALLESPI DE LA CRUZ, JORDI 606600000000 126 126
11 CUGAT MULET, JAUME 556200000000 117 117
12 LUQUE JULIA, CARLOS 536300000000 116 116
13 EL JIHAOUI, AZZIZ 115000000000 115 115
14 VIUDEZ TOMÀS, MARTÍ 011500000000 115 115
15 SALVATELLA ROIJALS, JOAN 516400000000 115 115
16 MAS CACERES, LLUISMA 103000000000 103 103
17 SUBIRATS CID, JORDI 465600000000 102 102
18 GONZALEZ MORATALLA, ALFREDO 455400000000 99 99
19 GARRIGA SOROLLA, XAVIER 385200000000 90 90
20 ORTS MORA, BORJA 365000000000 86 86
21 GARCIA ARGENTÓ, VICENT 85000000000 85 85
22 FELIX RIPOLL, JUAN 345100000000 85 85
23 BAREA SEBASTIA, NOE 354800000000 83 83
24 CASTELLS FABRA, LLUIS 334700000000 80 80
25 SORIANO LÓPEZ, MARTÍ 79000000000 79 79
26 VILANOVA ARDIT, JOSEP 70000000000 70 70
27 RIBERA ROIG, PABLO 06800000000 68 68
28 SIERRA IZQUIERDO, BORJA 06700000000 67 67
29 CÓZAR TORÁN, PEDRO 66000000000 66 66
30 BERTOMEU BELLES, CRISTIAN 06500000000 65 65
31 SOTOMAYOR DUQUE, XAVI 63000000000 63 63
32 DELLA CALLEN, JUAN JOSE 62000000000 62 62
33 SANCHO RALDA, ALFONSO 61000000000 61 61
34 BATSI ARAGON, CARLOS 06100000000 61 61
35 GARCIA ALPAÑES, HECTOR 06000000000 60 60
36 GUZMAN, MATIAS 59000000000 59 59
37 ESCUDERO COLOMINES, DANI 05900000000 59 59
38 DAZA BERENGUER, DANI 05800000000 58 58
39 GARGALLO ROYO, JOSE RAMÓN 57000000000 57 57
40 QUERALT ROIG, DANI 05700000000 57 57
41 BERTOMEU CURTO, JOEL 56000000000 56 56
42 MONTOYA LECEGUI, SANTI 05500000000 55 55
43 VALMAÑA, ELOY 54000000000 54 54
44 ASÍN QUEROL, JORGE 05300000000 53 53
45 DELLA CALLEN, CARLOS 52000000000 52 52
46 AGUILÓ BO, XAVIER 50000000000 50 50
47 BRETÓ VERGE, FRANCESC 49000000000 49 49
48 CURTO PIÑANA, CRISTIAN 04900000000 49 49
49 BESALDUCH BEL, XAVI 48000000000 48 48
50 ESPINOSA VILLAR, BORJA 47000000000 47 47
51 SIMÓ QUERALT, EUGENI 44000000000 44 44
52 SEBASTIA VALLDEPEREZ, JORDI 43000000000 43 43
53 SERRET GOMEZ, JUAN CARLOS 42000000000 42 42
54 FRANCO CIURANA, JOSÉ ANTONIO 41000000000 41 41
55 ACERO GUERRERO, JORGE 40000000000 40 40
56 DOSDAD CAMPOS , OSCAR 39000000000 39 39
57 GUTIÉRREZ MÁRQUEZ, FCO JAVIER 37000000000 37 37




Amb el suport de: