CLASSIFICACIÓ 5K: SÈNIOR 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="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaTivenysEl PerellóS.BàrbaraCamarlesBateaDeltebreJesúsL'Aldea Total Punts
1 PANISELLO GIL, LAUREANO 11511500000000 230 230
2 SABORIDO ESCURRIOLA, GENÍS 857900000000 164 164
3 GABALDA FERRE, ELOI 797100000000 150 150
4 JIMÉNEZ BRANERA, DANI 737300000000 146 146
5 PEDROL PASCUAL, OSCAR 717000000000 141 141
6 FRANCH FRANCH, JOAN MARTI 696800000000 137 137
7 BACEIREDO RAMOS, ALVARO 103000000000 103 103
8 ROIG MALLÉN , CARLES 010300000000 103 103
9 MACHI CABALLE, OMAR 93000000000 93 93
10 LLORACH MATAMOROS, JONATAN 09300000000 93 93
11 AVINYO ARASA, PAU. 08500000000 85 85
12 GARRIGA ESTELLÉ, JOEL 75000000000 75 75
13 CASAS CABRERA, FRANCISCO 07500000000 75 75
14 ROCA REY, ROGER 70000000000 70 70
15 GRACIA MONSERRATE, PABLO 06900000000 69 69
16 RODRIGUEZ ADELL, IAN 68000000000 68 68
17 GARCIA DIAZ, AITOR 67000000000 67 67
18 CURTO GARCIN, CARLOS 06700000000 67 67
19 MULET AGUILÓ , GERARD VICENT 66000000000 66 66
20 BAYARRI OVALAT, CAYLA 06600000000 66 66
21 SOLER RUIZ, DANIEL 65000000000 65 65
22 MARICIUC, VASILICA ANDREI 06500000000 65 65




Amb el suport de: