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 CamarlesL'AmpollaL'AldeaAmpostaDeltebre Total Punts
1 RODA SALES, DAVID 1150000 115 115
2 MARTOS MARTI, JOAN 1030000 103 103
3 DUEÑAS RODRIGUEZ, ALBERTO 930000 93 93
4 MOSEGUI TORA, RAFEL 850000 85 85
5 SABATÉ MASIP , ADRIÀ 790000 79 79
6 ULLDEMOLINS TODÓ, ALFONS 750000 75 75
7 SIGÜENZA AMARO, FRANCISCO 730000 73 73
8 MARTOS MARTI, ANGEL 710000 71 71
9 TORREBLANCA CERVELLÓ, JOSE ANGEL 700000 70 70
10 BUERA REBULLIDA, JOSEP MIQUEL 690000 69 69
11 LUQUE LLUCH, OLIVER 680000 68 68
12 FERRE VADILLO, ENRIC 670000 67 67
13 PAGÀ SORRIBES, FRANCESC 660000 66 66
14 MAURI HIERRO, DAVID 650000 65 65
15 MARGALEF PELEGRIN, JOSEP 640000 64 64
16 FARRÉ GARCIA, JORDI 630000 63 63




Amb el suport de: