CLASSIFICACIÓ 5K: SÈNIOR 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="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 TOMÀS BUITRAGO, AITOR 1150103115115000 448 448
2 MACHI CABALLE, OMAR 931150930000 301 301
3 ESTORACH SOL, OSCAR 1031030850000 291 291
4 ROCA REY, ROGER 737375700000 291 291
5 JIMÉNEZ BRANERA , DANI 009375103000 271 271
6 GOMEZ AUSACH, ANDREU 7985000000 164 164
7 GABALDA FERRE, ELOI 0079730000 152 152
8 BERTOMEU CASANOVA, AARON 7575000000 150 150
9 CUBELLS I CUBELLS, HERIBERT 0011500000 115 115
10 REMOLINA RALLO, FERRAN 0001030000 103 103
11 CASAS CABRERA, PACO 093000000 93 93
12 GONZÁLEZ CABALLERO, DAVID 000093000 93 93
13 CÁCERES AZNAR, KARIM 850000000 85 85
14 MAIJÓ FRIGOLA, ABEL 008500000 85 85
15 FONOLLOSA AULADELL, XAVIER 000085000 85 85
16 DEL VALLE PUIG, ADRIA 000790000 79 79
17 CURTO GARCIN, CARLOS 079000000 79 79
18 CASTELLS CASANOVA, JOEL 000710000 71 71
19 DUSSARRAT, ROBIN 071000000 71 71
20 PAGA FABRA, AGUSTI 070000000 70 70
21 FRANCH FRANCH, JOAN MARTI 000690000 69 69
22 BELTRAN, MANEL 000680000 68 68




Amb el suport de: