CLASSIFICACIÓ 10K: ABSOLUT MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SOWE, MUSA VE1 M11500000 115 115
2 DE TORRES BURGOS, FERRAN VE2 M10300000 103 103
3 PUENTES GARCÍA, LUIS FCO VE2 M9300000 93 93
4 SALES FERRE, ENRIC SEN M8500000 85 85
5 BUTLER, JONATHAN VE1 M7900000 79 79
6 MESTRE QUEROL, ALBERT VE1 M7500000 75 75
7 FALGAS MORENO, ALEX VE2 M7300000 73 73
8 FRANCO SMEETS, CLAUDIO VE1 M7100000 71 71
9 RIBERA ROIG, PABLO VE1 M7000000 70 70
10 VIUDEZ TOMÀS, MARTÍ VE1 M6900000 69 69
11 ROYO GUILLEM, ANDREU VE1 M6800000 68 68
12 QUERAL FORCADELL, DAVID VE2 M6700000 67 67
13 REDÓ VIUDEZ, CARLOS SEN M6600000 66 66
14 CURTO I GILABERT, DAVID VE2 M6500000 65 65
15 SORIANO LÓPEZ, MARTÍ VE1 M6400000 64 64
16 GIMENEZ BELLOBI, JORDI VE1 M6300000 63 63
17 BOVO, MARIO ANTONIO VE1 M6200000 62 62
18 GARCIA SUAREZ, JULIO CESAR VE1 M6100000 61 61
19 GOMBAU MURRIA, ELISEU SEN M6000000 60 60
20 DELLA CALLEN, CARLOS VE1 M5900000 59 59
21 PARDO ARQUES, ROGER SEN M5800000 58 58
22 CUGAT MULET, JAUME VE1 M5700000 57 57
23 PAGA MARGALEF, JOAN PERE VE1 M5600000 56 56
24 LLUIS LLANSAMA, GABRIEL VE2 M5500000 55 55
25 BELTRAN COLLADO, ORIOL VE1 M5400000 54 54
26 MONTESÓ JIMENEZ, DAVID MONTESÓ JIMÉNEZ VE1 M5300000 53 53
27 PUTAN CÓRDOBA, WILSON VE1 M5200000 52 52
28 GAIC, ROBERT DAVID SEN M5100000 51 51
29 OBIOL PEDROL, ENRIC SEN M5000000 50 50
30 DELGADO ARAGONESES, VÍCTOR VE1 M4900000 49 49
31 GALIANA BARCELÓ, JOAN VE2 M4800000 48 48
32 PELEGRIN VALLS, JONATHAN SEN M4700000 47 47
33 CASTELLS BARRACHINA, BLAY SEN M4600000 46 46
34 SERRET ROIG, ADRIA VE2 M4500000 45 45
35 CABANES CALVET, ALBERT VE2 M4400000 44 44
36 GARCIA ALPAÑES, HECTOR VE1 M4300000 43 43
37 MAURI BARDI, JORDI SEN M4200000 42 42
38 FORTUÑO NAVARRO, JOSE LUIS VE2 M4100000 41 41
39 LEÓN MORA, AUGUSTO LEO VE2 M4000000 40 40
40 FIBLA MORENO, JOAN LLUIS SEN M3900000 39 39
41 RUIZ SERRANO, JUSTINO MA2 M3800000 38 38
42 HERNANDEZ RODRIGUEZ, CARLOS MA1 M3700000 37 37
43 MONTEVERDE, JORDI VE1 M3600000 36 36
44 CUESTA GARCIA, DANI SEN M3500000 35 35
45 MONTEVERDE MAURI, MARC SEN M3400000 34 34
46 GONZALEZ MORATALLA, ALFREDO VE1 M3300000 33 33
47 GARCIA BALAGUE, JULI VE2 M3200000 32 32
48 ESPINOSA ZAVALETA, EDGAR RICARDO MA1 M3100000 31 31
49 VILLARES MUÑIZ, MARTÍ-PAU SEN M3000000 30 30
50 SUBIRATS CID, XAVI SEN M2900000 29 29
51 SUBIRATS CID, JORDI VE1 M2800000 28 28
52 ROFES BARCELO, JOSEP MA1 M2700000 27 27
53 GIMENO PUIGCERVER, MARC SEN M2600000 26 26
54 SANCHO JOSE, VICTOR MA1 M2500000 25 25
55 LANGE EBRI, ARTURO MA2 M2400000 24 24
56 MULET ROYO, JORDI SEN M2300000 23 23
57 BORRAS LLOSA, ALBERT VE2 M2200000 22 22
58 SANSALONI GILABERT, PAU SEN M2100000 21 21
59 PELEGRIN SANCHEZ, JOAN CARLES MA1 M2000000 20 20
60 CLUA GAYA, MARC VE2 M1900000 19 19
61 TORRES BERTOMEU, JOSEP VE1 M1800000 18 18
62 TOMÀS I ROIGET, ADAM VE2 M1700000 17 17
63 CASTELLS FABRA, LLUIS VE1 M1600000 16 16
64 BATALLA, JOAN CARLES VE2 M1500000 15 15
65 VILLARES FERNÁNDEZ, VILLARES MA2 M1400000 14 14
66 IBAÑEZ BISMARCH, JUST SEN M1300000 13 13
67 CARMONA HERNÁNDEZ, JAVIER VE2 M1200000 12 12




Amb el suport de: