CLASSIFICACIÓ 5K: SUB-18 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="S18 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 RIERA I CAIRE, XAVIER 1151030115103931150 644 551
2 FUMADO GISBERT, ORIOL 0799310375851030 538 463
3 BLANCH ALSO, ARNAU 01150011511500 345 345
4 ESPINOSA CALLAU, CARLOS 0011500000 115 115
5 OUCHBAB, AISSA 0000010300 103 103
6 ASMOUH, MOHAMED 093000000 93 93
7 PRADES NADAL, MARC 000093000 93 93
8 PALLARES PEREZ, PAU 000930000 93 93
9 ALMENDROS GARCIA, FERRAN 085000000 85 85
10 AFSFAS, MOHAMED 000085000 85 85
11 PRADES NADAL, PAU 000079000 79 79
12 BALLESTE SCIORA, ALEX 075000000 75 75
13 MARTÍN DOMENECH, JOAN 000073000 73 73




Amb el suport de: