CLASSIFICACIÓ 10K: VETERÀ-2 MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntscat FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntscat FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic WHERE categoria="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 DE TORRES BURGOS, FERRAN 11500000 115 115
2 PUENTES GARCÍA, LUIS FCO 10300000 103 103
3 FALGAS MORENO, ALEX 9300000 93 93
4 QUERAL FORCADELL, DAVID 8500000 85 85
5 CURTO I GILABERT, DAVID 7900000 79 79
6 LLUIS LLANSAMA, GABRIEL 7500000 75 75
7 GALIANA BARCELÓ, JOAN 7300000 73 73
8 SERRET ROIG, ADRIA 7100000 71 71
9 CABANES CALVET, ALBERT 7000000 70 70
10 FORTUÑO NAVARRO, JOSE LUIS 6900000 69 69
11 LEÓN MORA, AUGUSTO LEO 6800000 68 68
12 GARCIA BALAGUE, JULI 6700000 67 67
13 BORRAS LLOSA, ALBERT 6600000 66 66
14 CLUA GAYA, MARC 6500000 65 65
15 TOMÀS I ROIGET, ADAM 6400000 64 64
16 BATALLA, JOAN CARLES 6300000 63 63
17 CARMONA HERNÁNDEZ, JAVIER 6200000 62 62




Amb el suport de: