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 CAMPOY LOZANO, JUAN 10371857179851030 597 455
2 RODA SALES, DAVID 0001031031151150 436 436
3 TORREBLANCA CERVELLÓ, JOSE ANGEL 7910375687071750 541 403
4 ORTEGA BLANCO, JAIME 75937369073790 462 393
5 BALAGUE BELTRAN, JOAQUIN 71797166067700 424 358
6 RODRIGUEZ SUBIRATS, DAVID 1150073759300 356 356
7 LUQUE LLUCH, OLIVER 938570650000 313 313
8 LLUCH ARBONA, FRANCESC 850790069690 302 302
9 MARTOS MARTI, ANGEL 000707175850 301 301
10 PAGA MARGALEF, JOAN PERE 011500079930 287 287
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 FRANCH VENTURA, PERE 000000730 73 73
29 MARTINEZ DE LEON, ORIOL 073000000 73 73
30 MIGUEL BARTOLOME, ALBERTO 000000710 71 71
31 SANCHO RALDA, ALFONSO 000007000 70 70
32 VECIANA CARBONELL, JOSEP 700000000 70 70
33 SAMPER BRUNO, ALBERT 690000000 69 69
34 FANDOS COLOMINES, FELIP 006900000 69 69
35 GONZÁLEZ MARCOS, DANIEL 069000000 69 69
36 PEREZ FUSTE, JORDI 000006800 68 68
37 GARRIGA SANZ, ANTONI 680000000 68 68
38 ESPINOSA VILLAR, BORJA 000670000 67 67
39 MAIER, TONI 000000670 67 67
40 PUIG VILÀS, ENRIC 000006600 66 66
41 GALINDO AYORA, RUBEN 000000660 66 66
42 ALAIXENDRI JARDÍ, MAURO 000006500 65 65
43 GASPARIN, MARC 000000650 65 65
44 BUERA REBULLIDA , JOSEP MIQUEL 000640000 64 64
45 MAURI HIERRO, DAVID 000630000 63 63
46 DELGADO, FRANCESC 000620000 62 62
47 ROMANÍ ALSO, DAVID 000610000 61 61
48 SABORIDO ESCURRIOLA, EDUARD 000600000 60 60




Amb el suport de: