CLASSIFICACIÓ 5K: VETERÀ-1 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="VE1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaTivenysEl PerellóS.BàrbaraCamarlesBateaDeltebreJesúsL'Aldea Total Punts
1 RODA SALES, DAVID. 11510300000000 218 218
2 DUEÑAS RODRIGUEZ, ALBERTO. 1038500000000 188 188
3 MARTOS MARTI, ANGEL 937300000000 166 166
4 TORREBLANCA CERVELLÓ, JOSE ANGEL 857000000000 155 155
5 PAGA MARGALEF, JOAN PERE 797500000000 154 154
6 ORTEGA BLANCO, JAUME 756900000000 144 144
7 LUQUE LLUCH, OLIVER 696600000000 135 135
8 MARGALEF PELEGRIN, JOSEP 686300000000 131 131
9 CÍSCAR MUÑOZ, JUAN MIGUEL 666400000000 130 130
10 LACALLE CARRIÓN , GORKA 645900000000 123 123
11 HERRERAS, CARLOS 011500000000 115 115
12 LOPEZ GIL, DENIS 09300000000 93 93
13 MOSEGUI TORA, RAFEL 07900000000 79 79
14 LLUIS LLANSAMA, ANTONIO 73000000000 73 73
15 BEL VERGE, EUGENIO 07100000000 71 71
16 AYET SALES, DAVID 71000000000 71 71
17 ALBUERA REVERTE, FRANCESC 70000000000 70 70
18 SEBASTIA VALLDEPEREZ, JORDI 06800000000 68 68
19 BLANES DOMENE, CHRISTIAN 06700000000 67 67
20 LLASAT ESCRICHE, FRANK 67000000000 67 67
21 SABATER CABRERA, DANI 06500000000 65 65
22 ALEGRE HIERRO, JORDI 65000000000 65 65
23 BONELL GONZALEZ, JOAN 06200000000 62 62
24 TUGUI TUGUI, ALINA 06100000000 61 61
25 DELLA CALLEN, CARLOS 06000000000 60 60
26 MATAMOROS GASPARIN, MARC 05800000000 58 58
27 LLAO GARCIA, ALEX 05700000000 57 57




Amb el suport de: