CLASSIFICACIÓ 10K: SÈNIOR 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="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SALES FERRE, ENRIC 11500000 115 115
2 REDÓ VIUDEZ, CARLOS 10300000 103 103
3 GOMBAU MURRIA, ELISEU 9300000 93 93
4 PARDO ARQUES, ROGER 8500000 85 85
5 GAIC, ROBERT DAVID 7900000 79 79
6 OBIOL PEDROL, ENRIC 7500000 75 75
7 PELEGRIN VALLS, JONATHAN 7300000 73 73
8 CASTELLS BARRACHINA, BLAY 7100000 71 71
9 MAURI BARDI, JORDI 7000000 70 70
10 FIBLA MORENO, JOAN LLUIS 6900000 69 69
11 CUESTA GARCIA, DANI 6800000 68 68
12 MONTEVERDE MAURI, MARC 6700000 67 67
13 VILLARES MUÑIZ, MARTÍ-PAU 6600000 66 66
14 SUBIRATS CID, XAVI 6500000 65 65
15 GIMENO PUIGCERVER, MARC 6400000 64 64
16 MULET ROYO, JORDI 6300000 63 63
17 SANSALONI GILABERT, PAU 6200000 62 62
18 IBAÑEZ BISMARCH, JUST 6100000 61 61




Amb el suport de: