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 AmpostaL'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 RUIZ CULIÁÑEZ, JOSÉ MARIO 1038500000000 188 188
2 GAIC, ROBERT DAVID 716500000000 136 136
3 SABATE SABATE, JAVIER 696200000000 131 131
4 FATHI, ALI 115000000000 115 115
5 SALES FERRE, LLORENÇ 011500000000 115 115
6 SALES FERRE, ENRIC 010300000000 103 103
7 IBAÑEZ BISMARK, JUST 09300000000 93 93
8 RODA JIMENEZ, JOSEP 93000000000 93 93
9 FERNÁNDEZ TOMÀS, JOAN LLUÍS 85000000000 85 85
10 SUÑER CARLES, PAU 07900000000 79 79
11 PUIG AGUILO, VICENT 79000000000 79 79
12 PUIG SOLER, MARC 07500000000 75 75
13 GONZALEZ GILABERT, OCTAVI 75000000000 75 75
14 REDÓ VIUDEZ, CARLOS 07300000000 73 73
15 SUBIRATS CID, XAVI 73000000000 73 73
16 DOMINGUEZ ARASA, ALBERT 07100000000 71 71
17 BUENO GARCIA, FRAN 07000000000 70 70
18 FERRE LOPEZ, CARLOS 70000000000 70 70
19 BENAVENT BENAVENT, PEP 06900000000 69 69
20 CURTO BAIGES, ALBERT 06800000000 68 68
21 LLORCA PINTOR, FCO. JAVIER 06700000000 67 67
22 SAHRAOUI CABRERA, CARLES 06600000000 66 66
23 BRUNET ZARAGOZA, MIKEL 06400000000 64 64
24 SARIÓ DOMECH, SALVADOR 06300000000 63 63




Amb el suport de: