CLASSIFICACIÓ 10K: VETERÀ-1 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="VE1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SOWE, MUSA 11500000 115 115
2 BUTLER, JONATHAN 10300000 103 103
3 MESTRE QUEROL, ALBERT 9300000 93 93
4 FRANCO SMEETS, CLAUDIO 8500000 85 85
5 RIBERA ROIG, PABLO 7900000 79 79
6 VIUDEZ TOMÀS, MARTÍ 7500000 75 75
7 ROYO GUILLEM, ANDREU 7300000 73 73
8 SORIANO LÓPEZ, MARTÍ 7100000 71 71
9 GIMENEZ BELLOBI, JORDI 7000000 70 70
10 BOVO, MARIO ANTONIO 6900000 69 69
11 GARCIA SUAREZ, JULIO CESAR 6800000 68 68
12 DELLA CALLEN, CARLOS 6700000 67 67
13 CUGAT MULET, JAUME 6600000 66 66
14 PAGA MARGALEF, JOAN PERE 6500000 65 65
15 BELTRAN COLLADO, ORIOL 6400000 64 64
16 MONTESÓ JIMENEZ, DAVID MONTESÓ JIMÉNEZ 6300000 63 63
17 PUTAN CÓRDOBA, WILSON 6200000 62 62
18 DELGADO ARAGONESES, VÍCTOR 6100000 61 61
19 GARCIA ALPAÑES, HECTOR 6000000 60 60
20 MONTEVERDE, JORDI 5900000 59 59
21 GONZALEZ MORATALLA, ALFREDO 5800000 58 58
22 SUBIRATS CID, JORDI 5700000 57 57
23 TORRES BERTOMEU, JOSEP 5600000 56 56
24 CASTELLS FABRA, LLUIS 5500000 55 55




Amb el suport de: