CLASSIFICACIÓ 5K: MÀSTER-1 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="MA1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 FUCHO PASCUAL, FELIP 1151150115115115115115 805 575
2 GONZALEZ REVERTER, RAMON 10300103103103103103 618 515
3 MARGALEF BORRELL, JOSEP 93931039393858585 730 490
4 MARTÍ JOVE, JOSEP 85851157985937579 696 478
5 MIRAPEIX TOMAS, ORIOL 00000797993 251 251
6 PRATS TACHÉ, PERE 0103000000 103 103
7 LLITRÀ VIRGILI, ESTEVE 000000930 93 93
8 NAVARRO PUIG, GUILLEM 000850000 85 85
9 COTAINA CABALLE, JAVIER 079000000 79 79
10 MUR BAGES, JOAN RAMON 075000000 75 75
11 ALSO GAS, LLORENS 000750000 75 75
12 RODRÍGUEZ FUSTÉ, HILARI 000000075 75 75
13 BROUGHTON, JIM 000000073 73 73




Amb el suport de: