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 AmpostaL'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 MONTERO PÈREZ, JOSEP MARIA 10310300000000 206 206
2 LLEIXÀ CHAVARRIA, JOSEP 939300000000 186 186
3 FIBLA REVERTER, HERMINI 707500000000 145 145
4 CUCURULL POCURULL, GERARD 687100000000 139 139
5 FORTUÑO NAVARRO, JOSE LUIS 666800000000 134 134
6 REVERTER BULLON, JOSE MIGUEL 656900000000 134 134
7 ROMERO NOFRE, FERNANDO 626600000000 128 128
8 BELTRAN SUBIRATS, JOSEP MARIA 616200000000 123 123
9 ORTÍN FONT, XAVIER 011500000000 115 115
10 ALBESA ABADAL, ANDRES 115000000000 115 115
11 SABATER CABRERA, ENRIC 08500000000 85 85
12 GRAU SANZ, MAX 85000000000 85 85
13 LLUIS LLANSAMA, GABRIEL 79000000000 79 79
14 BELTRAN ARQUES, JUAN FRANCISCO 07900000000 79 79
15 GARCIA REDONDO, DOMINGO 75000000000 75 75
16 CASTELLS CARLES, ALEJANDRO 73000000000 73 73
17 SANCHEZ MIRALLES, JUAN ANTONIO 07300000000 73 73
18 CABANES CALVET, ALBERT 71000000000 71 71
19 TORRES , JORGE 07000000000 70 70
20 CASELLAS APARICIO, RAFAEL 69000000000 69 69
21 VIDAL FOIX, XAVIER 67000000000 67 67
22 MANZANERO HERAS, VICENT 06700000000 67 67
23 BORRAS LLOSA, ALBERT 06500000000 65 65
24 GONZALEZ CURIEL, JULIO 64000000000 64 64
25 GUIU BAGÉS, ALBERT 06400000000 64 64
26 TOMÀS I ROIGET, ADAM 63000000000 63 63
27 GOMEZ MARTINEZ, JOSE LUIS 06300000000 63 63
28 GARCIA BALLÚS, DAVID 06100000000 61 61




Amb el suport de: