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 CamarlesL'AmpollaL'AldeaAmpostaDeltebre Total Punts
1 MONTSERRAT AGUILÓ, ÒSCAR 1150000 115 115
2 ABAGHAD, YOUSSEF 1030000 103 103
3 RENALES PRIETO, ALEJANDRO 930000 93 93
4 ARIAS NOGUÉS, ROBERT 850000 85 85
5 RODRÍGUEZ SALVADÓ, GERARD 790000 79 79
6 SABORIDO ESCURRIOLA, GENÍS 750000 75 75
7 PUIG AGUILO, VICENT 730000 73 73
8 GABALDA FERRE, ELOI 710000 71 71
9 GONZÁLEZ CABALLERO, DAVID 700000 70 70
10 MONLLAO FERRE, PAU 690000 69 69
11 ANDREU LOPEZ, AARÓN 680000 68 68
12 GARCIA CERVETO, CARLES 670000 67 67
13 FRANCH FRANCH, JOAN MARTI 660000 66 66
14 DAUDEN MORENO, MIGUEL 650000 65 65




Amb el suport de: