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 115010311511511593115 771 575
2 JIMÉNEZ BRANERA , DANI 00937510385093 449 449
3 MACHI CABALLE, OMAR 931150930000 301 301
4 GABALDA FERRE, ELOI 007973071075 298 298
5 ESTORACH SOL, OSCAR 1031030850000 291 291
6 ROCA REY, ROGER 737375700000 291 291
7 CUBELLS I CUBELLS, HERIBERT 001150001030 218 218
8 CASTELLS CASANOVA, JOEL 00071062750 208 208
9 GOMEZ AUSACH, ANDREU 7985000000 164 164
10 BELTRAN, MANEL 0006800850 153 153
11 BERTOMEU CASANOVA, AARON 7575000000 150 150
12 FRANCH FRANCH, JOAN MARTI 0006900710 140 140
13 OUHDADI, YASSINE 0000001150 115 115
14 REMOLINA RALLO, FERRAN 0001030000 103 103
15 OURHOU OUAMOU, ILYASSE 0000010300 103 103
16 AVINYO ARASA, PAU 0000000103 103 103
17 CASAS CABRERA, PACO 093000000 93 93
18 PAREDES MARTÍ, SAM 000009300 93 93
19 GONZÁLEZ CABALLERO, DAVID 000093000 93 93
20 CÁCERES AZNAR, KARIM 850000000 85 85
21 ROJAS ESTEVE, JOSUÉ 000000085 85 85
22 MAIJÓ FRIGOLA, ABEL 008500000 85 85
23 FONOLLOSA AULADELL, XAVIER 000085000 85 85
24 DEL VALLE PUIG, ADRIA 000790000 79 79
25 BERTOMEU BELLES, CRISTIAN 000000790 79 79
26 MONTALVO SANZ, RAÚL 000007900 79 79
27 CASTELLVI SORIANO, JORDI 000000079 79 79
28 CURTO GARCIN, CARLOS 079000000 79 79
29 ROCA AÑON, VICTOR 000007500 75 75
30 ROVIRA CID, LEANDRO 000007300 73 73
31 MORESO ABELLA , VICTOR 000000073 73 73
32 CASANOVA BERTOMEU, FERRAN 000000730 73 73
33 DUSSARRAT, ROBIN 071000000 71 71
34 LLOSA GAS, CARLOS 000000071 71 71
35 OLIVER BLANCH, OSCAR 000007000 70 70
36 PAGA FABRA, AGUSTI 070000000 70 70
37 OLIVER BLANCH, SERGIO 000006800 68 68
38 TURCAN, NICOLAE 000006700 67 67
39 GARCIA BEATO, ALBERT 000006600 66 66
40 BENEITO FAUS, RUBEN 000006500 65 65
41 REDO MUSSO, ALEX 000006400 64 64
42 BARBERÀ ALSO, JOAQUIM 000006300 63 63
43 MELERO CURTO, JOSEP 000006100 61 61
44 CODORNIU CODORNIU, ADRIÀ 000006000 60 60
45 BARBERÀ ALSO, ANTONI 000005900 59 59




Amb el suport de: