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 11510310393103103103115 838 554
3 BERTOMEU BAILE, DAVID 10393085939385103 655 485
4 GALARZA SANCHEZ, ALEJANDRO 7371756873859379 617 420
5 SEDIKI AIT SILARBI, HAKIM 75797973790093 478 405
6 ALMENDROS RODA, IGNASI 937385790000 330 330
7 ALONSO QUESADA, OSCAR 0850085000 170 170
8 DURAN PINO, RAFEL 0007100085 156 156
9 RIBES SERRA, JOSEP MARIA 0750075000 150 150
10 ARASA FORNOS, OSCAR 0700650000 135 135
11 BELTRAN ARQUES, JUAN FRANCISCO 0001030000 103 103
12 VALENCIA, MANUEL 009300000 93 93
13 FERRE FOLCH, DAVID 850000000 85 85
14 PALMER FERRER, PERE 790000000 79 79
15 LEÓN MORA, AUGUSTO LEO 000000790 79 79
16 BONFILL SEGURA, MIQUEL ANGEL 000750000 75 75
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: