CLASSIFICACIÓ 10K: MÀSTER-1 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="MA1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 FERRÉ CANALS, TONI 10310300000000 206 206
2 HERNANDEZ RODRIGUEZ, CARLOS 798500000000 164 164
3 BROUGHTON, JIM 757900000000 154 154
4 COMES GARCIA, MARTI 011500000000 115 115
5 TONDA SALVADÓ, JOSEP LLUIS 115000000000 115 115
6 SANCHO JOSE, VICTOR 93000000000 93 93
7 PÉREZ FERNANDEZ , MIGUEL 09300000000 93 93
8 CID ESPUNY, JOSEP LLUIS 85000000000 85 85
9 FUMADO CASANOVA, JUAN JOSE 07500000000 75 75
10 GARRIGA ALMO, FRANCISCO 73000000000 73 73
11 VALENCIA NEBOT, ENRIC 71000000000 71 71
12 ALBESA ARASA, JOAN 70000000000 70 70




Amb el suport de: