CLASSIFICACIÓ 5K: VETERÀ-2 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="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 SANAHUJA BARRANCO, JOSEP RAMON 01151151151151151150 690 575
2 GARCIA REDONDO, DOMINGO 115103103931031031030 723 527
3 BERTOMEU BAILE, DAVID 103930859393850 552 467
4 GALARZA SANCHEZ, ALEJANDRO 737175687385930 538 399
5 SEDIKI AIT SILARBI, HAKIM 7579797379000 385 385
6 ALMENDROS RODA, IGNASI 937385790000 330 330
7 ALONSO QUESADA, OSCAR 0850085000 170 170
8 RIBES SERRA, JOSEP MARIA 0750075000 150 150
9 ARASA FORNOS, OSCAR 0700650000 135 135
10 BELTRAN ARQUES, JUAN FRANCISCO 0001030000 103 103
11 VALENCIA, MANUEL 009300000 93 93
12 FERRE FOLCH, DAVID 850000000 85 85
13 PALMER FERRER, PERE 790000000 79 79
14 LEÓN MORA, AUGUSTO LEO 000000790 79 79
15 BONFILL SEGURA, MIQUEL ANGEL 000750000 75 75
16 DURAN PINO, RAFEL 000710000 71 71
17 SOLÉ SUBIRATS, JULI 710000000 71 71
18 ESPINOSA ZAVALETA, EDGAR RICARDO 000700000 70 70
19 IGLESIAS MESTRES, JAUME 000690000 69 69
20 GÓMEZ, JOSE ANTONIO 000670000 67 67
21 SANTISTEBAN RONCERO, TONI 000660000 66 66




Amb el suport de: