CLASSIFICACIÓ 10K: VETERÀ-2 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="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 DE TORRES BURGOS, FERRAN 11510310311500 436 436
2 CURTO I GILABERT, DAVID 7979857900 322 322
3 LLUIS LLANSAMA, GABRIEL 7575798500 314 314
4 PUENTES GARCÍA, LUIS FCO 1039393000 289 289
5 FORTUÑO NAVARRO, JOSE LUIS 6969706800 276 276
6 GARCIA BALAGUE, JULI 6768716900 275 275
7 LEÓN MORA, AUGUSTO LEO 6867686700 270 270
8 MARTÍNEZ RODRIGUEZ, ÁNGEL 0115115000 230 230
9 GARCIA SANGÜESA, DAMIÀ 073737300 219 219
10 GUIU BAGÉS, ALBERT 063656500 193 193
11 SABATE ROIG, ENRIC 08509300 178 178
12 GALIANA BARCELÓ, JOAN 73700000 143 143
13 REVERTER BULLON, JOSE MIGUEL 06606600 132 132
14 FORNÉ CASTELLS, XAVIER 00010300 103 103
15 FALGAS MORENO, ALEX 9300000 93 93
16 QUERAL FORCADELL, DAVID 8500000 85 85
17 ESQUERRE FERRE, ROMAN 0007500 75 75
18 SEVILLANO MORAN, ENRIQUE 0075000 75 75
19 SABATER CABRERA, ENRIC 0710000 71 71
20 GAS PANISELLO, DAVID 0007100 71 71
21 SERRET ROIG, ADRIA 7100000 71 71
22 REDO PRINCEP, RICARD 0007000 70 70
23 CABANES CALVET, ALBERT 7000000 70 70
24 ANDUCAS PLANAS, JORDI 0069000 69 69
25 BORT I CORTIELLA, JOSEP JOAN 0067000 67 67
26 PEIRET DE LA FUENTE, CARLES 0066000 66 66
27 BORRAS LLOSA, ALBERT 6600000 66 66
28 RODA CID, SERGI 0650000 65 65
29 CLUA GAYA, MARC 6500000 65 65
30 BEL PLA, RAMON 0640000 64 64
31 FERRIZ MARINÉ, ALEX 0064000 64 64
32 TOMÀS I ROIGET, ADAM 6400000 64 64
33 GALARZA SANCHEZ, ALEJANDRO 0063000 63 63
34 BATALLA, JOAN CARLES 6300000 63 63
35 BELTRAN SUBIRATS, JOSEP MARIA 0062000 62 62
36 CARMONA HERNÁNDEZ, JAVIER 6200000 62 62




Amb el suport de:

comunicar incidències sobre les classificacions.
Recorda que per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.