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 GARCIA REDONDO, DOMINGO 11510310393103000 517 517
2 SANAHUJA BARRANCO, JOSEP RAMON 0115115115115000 460 460
3 SEDIKI AIT SILARBI, HAKIM 7579797379000 385 385
4 BERTOMEU BAILE, DAVID 1039308593000 374 374
5 GALARZA SANCHEZ, ALEJANDRO 7371756873000 360 360
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 BONFILL SEGURA, MIQUEL ANGEL 000750000 75 75
15 DURAN PINO, RAFEL 000710000 71 71
16 SOLÉ SUBIRATS, JULI 710000000 71 71
17 ESPINOSA ZAVALETA, EDGAR RICARDO 000700000 70 70
18 IGLESIAS MESTRES, JAUME 000690000 69 69
19 GÓMEZ, JOSE ANTONIO 000670000 67 67
20 SANTISTEBAN RONCERO, TONI 000660000 66 66




Amb el suport de: