CLASSIFICACIÓ 5K: VETERÀ-1 MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="VE1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 RODA SALES, DAVID 000103103115115115 551 551
2 CAMPOY LOZANO, JUAN 1037185717985103103 700 494
3 TORREBLANCA CERVELLÓ, JOSE ANGEL 79103756870717575 616 422
4 ORTEGA BLANCO, JAIME 759373690737979 541 399
5 MARTOS MARTI, ANGEL 0007071758585 386 386
6 PAGA MARGALEF, JOAN PERE 0115000799393 380 380
7 LLUCH ARBONA, FRANCESC 8507900696971 373 373
8 BALAGUE BELTRAN, JOAQUIN 71797166067700 424 358
9 RODRIGUEZ SUBIRATS, DAVID 1150073759300 356 356
10 LUQUE LLUCH, OLIVER 938570650000 313 313
11 GARBI HUERGA, CARLOS TOMÁS 0700000680 138 138
12 FRANCH BONET, ROSANA 6669000000 66 135
13 ULLAH, AHSAN 0000115000 115 115
14 CARMONA PARADA, FRANCESC 0011500000 115 115
15 GARRIGUES MONLEON , VICENTE 0001150000 115 115
16 BENAIGES MARGALEF, JOSEP 0010300000 103 103
17 GIL ANTEQUERA, PABLO 0000010300 103 103
18 LOPEZ GIL, DENIS 000093000 93 93
19 LÓPEZ SANZ , IKER 000930000 93 93
20 LEANDRO QUERO, JORDI 009300000 93 93
21 GARCÍA ANTA , JESUS 000850000 85 85
22 VALLESPI DE LA CRUZ, JORDI 000085000 85 85
23 DELGADO ARAGONESES, VÍCTOR 000790000 79 79
24 ROYO GUILLEM, ANDREU 000750000 75 75
25 SOTO PAREDES, DANIEL 075000000 75 75
26 PRINCEP CARDONA, JESUS 000073000 73 73
27 LLUIS LLANSAMA, ANTONIO 730000000 73 73
28 BRETÓ VERGE, FRANCESC 000000073 73 73
29 FRANCH VENTURA, PERE 000000730 73 73
30 MARTINEZ DE LEON, ORIOL 073000000 73 73
31 MIGUEL BARTOLOME, ALBERTO 000000710 71 71
32 SANCHO RALDA, ALFONSO 000007000 70 70
33 VECIANA CARBONELL, JOSEP 700000000 70 70
34 BESALDUCH BEL, XAVI 000000070 70 70
35 SAMPER BRUNO, ALBERT 690000000 69 69
36 FANDOS COLOMINES, FELIP 006900000 69 69
37 GONZÁLEZ MARCOS, DANIEL 069000000 69 69
38 DOSDAD CAMPOS , OSCAR 000000069 69 69
39 PEREZ FUSTE, JORDI 000006800 68 68
40 GARRIGA SANZ, ANTONI 680000000 68 68
41 PINEAU, ALEXANDRE 000000068 68 68
42 ESPINOSA VILLAR, BORJA 000670000 67 67
43 MAIER, TONI 000000670 67 67
44 MONTESÓ FALCÓ, XAVI 000000067 67 67
45 PUIG VILÀS, ENRIC 000006600 66 66
46 GALINDO AYORA, RUBEN 000000660 66 66
47 ALAIXENDRI JARDÍ, MAURO 000006500 65 65
48 GASPARIN, MARC 000000650 65 65
49 BUERA REBULLIDA , JOSEP MIQUEL 000640000 64 64
50 MAURI HIERRO, DAVID 000630000 63 63
51 DELGADO, FRANCESC 000620000 62 62
52 ROMANÍ ALSO, DAVID 000610000 61 61
53 SABORIDO ESCURRIOLA, EDUARD 000600000 60 60




Amb el suport de: