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 10371857179000 409 409
2 TORREBLANCA CERVELLÓ, JOSE ANGEL 79103756870000 395 395
3 LUQUE LLUCH, OLIVER 938570650000 313 313
4 ORTEGA BLANCO, JAIME 759373690000 310 310
5 BALAGUE BELTRAN, JOAQUIN 717971660000 287 287
6 RODRIGUEZ SUBIRATS, DAVID 115007375000 263 263
7 RODA SALES, DAVID 000103103000 206 206
8 LLUCH ARBONA, FRANCESC 8507900000 164 164
9 MARTOS MARTI, ANGEL 0007071000 141 141
10 FRANCH BONET, ROSANA 6669000000 66 135
11 ULLAH, AHSAN 0000115000 115 115
12 CARMONA PARADA, FRANCESC 0011500000 115 115
13 GARRIGUES MONLEON , VICENTE 0001150000 115 115
14 PAGA MARGALEF, JOAN PERE 0115000000 115 115
15 BENAIGES MARGALEF, JOSEP 0010300000 103 103
16 LOPEZ GIL, DENIS 000093000 93 93
17 LÓPEZ SANZ , IKER 000930000 93 93
18 LEANDRO QUERO, JORDI 009300000 93 93
19 GARCÍA ANTA , JESUS 000850000 85 85
20 VALLESPI DE LA CRUZ, JORDI 000085000 85 85
21 DELGADO ARAGONESES, VÍCTOR 000790000 79 79
22 ROYO GUILLEM, ANDREU 000750000 75 75
23 SOTO PAREDES, DANIEL 075000000 75 75
24 PRINCEP CARDONA, JESUS 000073000 73 73
25 LLUIS LLANSAMA, ANTONIO 730000000 73 73
26 MARTINEZ DE LEON, ORIOL 073000000 73 73
27 VECIANA CARBONELL, JOSEP 700000000 70 70
28 GARBI HUERGA, CARLOS TOMÁS 070000000 70 70
29 SAMPER BRUNO, ALBERT 690000000 69 69
30 FANDOS COLOMINES, FELIP 006900000 69 69
31 GONZÁLEZ MARCOS, DANIEL 069000000 69 69
32 GARRIGA SANZ, ANTONI 680000000 68 68
33 ESPINOSA VILLAR, BORJA 000670000 67 67
34 BUERA REBULLIDA , JOSEP MIQUEL 000640000 64 64
35 MAURI HIERRO, DAVID 000630000 63 63
36 DELGADO, FRANCESC 000620000 62 62
37 ROMANÍ ALSO, DAVID 000610000 61 61
38 SABORIDO ESCURRIOLA, EDUARD 000600000 60 60




Amb el suport de: