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. AmpostaL'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 PONS TOMÀS, RAMON S23 M859300000000 178 178
2 SOLANAS PEREZ, SERGIO VE1 M797500000000 154 154
3 RUIZ CULIÁÑEZ, JOSÉ MARIO SEN M737000000000 143 143
4 MONTERO PÈREZ, JOSEP MARIA VE2 M696900000000 138 138
5 CASTELLS LOPEZ, RAMON VE1 M666700000000 133 133
6 SOTA MARTÍ, JORDI VE1 M676300000000 130 130
7 ASÍN QUEROL, JAVI VE1 M636400000000 127 127
8 GARCIA SUAREZ, JULIO CESAR VE1 M606200000000 122 122
9 GÜELL VILLAR, ORIOL VE1 M616100000000 122 122
10 BUERA REBULLIDA, JOSEP MIQUEL VE1 M595900000000 118 118
11 FATHI, ALI SEN M115000000000 115 115
12 SALES FERRE, LLORENÇ SEN M011500000000 115 115
13 ULLDEMOLINS TODÓ, ALFONS VE1 M575800000000 115 115
14 LLEIXÀ CHAVARRIA, JOSEP VE2 M565600000000 112 112
15 ZARAGOZA VALLDEPEREZ, RAMON VE1 M555500000000 110 110
16 EL JIHAOUI, AZZIZ VE1 M103000000000 103 103
17 SALES FERRE, ENRIC SEN M010300000000 103 103
18 VALLESPI DE LA CRUZ, JORDI VE1 M504900000000 99 99
19 MAS CACERES, LLUISMA VE1 M93000000000 93 93
20 CUGAT MULET, JAUME VE1 M414500000000 86 86
21 VIUDEZ TOMÀS, MARTÍ VE1 M08500000000 85 85
22 LUQUE JULIA, CARLOS VE1 M394600000000 85 85
23 SALVATELLA ROIJALS, JOAN VE1 M344700000000 81 81
24 ORTÍN FONT, XAVIER VE2 M07900000000 79 79
25 FERRÉ CANALS, TONI MA1 M354400000000 79 79
26 FIBLA REVERTER, HERMINI VE2 M383900000000 77 77
27 GARCIA ARGENTÓ, VICENT VE1 M75000000000 75 75
28 IBAÑEZ BISMARK, JUST SEN M07300000000 73 73
29 RODA JIMENEZ, JOSEP SEN M71000000000 71 71
30 COMES GARCIA, MARTI MA1 M07100000000 71 71
31 ALBESA ABADAL, ANDRES VE2 M70000000000 70 70
32 SORIANO LÓPEZ, MARTÍ VE1 M68000000000 68 68
33 SUÑER CARLES, PAU SEN M06800000000 68 68
34 CUCURULL POCURULL, GERARD VE2 M333400000000 67 67
35 PUIG SOLER, MARC SEN M06600000000 66 66
36 FERNÁNDEZ TOMÀS, JOAN LLUÍS SEN M65000000000 65 65
37 REDÓ VIUDEZ, CARLOS SEN M06500000000 65 65
38 TONDA SALVADÓ, JOSEP LLUIS MA1 M64000000000 64 64
39 VILANOVA ARDIT, JOSEP VE1 M62000000000 62 62
40 RUIZ SERRANO, JUSTINO MA2 M283300000000 61 61
41 DOMINGUEZ ARASA, ALBERT SEN M06000000000 60 60
42 CÓZAR TORÁN, PEDRO VE1 M58000000000 58 58
43 BUENO GARCIA, FRAN SEN M05700000000 57 57
44 SOTOMAYOR DUQUE, XAVI VE1 M54000000000 54 54
45 RIBERA ROIG, PABLO VE1 M05400000000 54 54
46 DELLA CALLEN, JUAN JOSE VE1 M53000000000 53 53
47 BENAVENT BENAVENT, PEP SEN M05300000000 53 53
48 SANCHO RALDA, ALFONSO VE1 M52000000000 52 52
49 SABATER CABRERA, ENRIC VE2 M05200000000 52 52
50 PUIG AGUILO, VICENT SEN M51000000000 51 51
51 CURTO BAIGES, ALBERT SEN M05100000000 51 51
52 SIERRA IZQUIERDO, BORJA VE1 M05000000000 50 50
53 GRAU SANZ, MAX VE2 M49000000000 49 49
54 SUBIRATS CID, JORDI VE1 M202900000000 49 49
55 LLUIS LLANSAMA, GABRIEL VE2 M48000000000 48 48
56 BERTOMEU BELLES, CRISTIAN VE1 M04800000000 48 48
57 GARCIA REDONDO, DOMINGO VE2 M47000000000 47 47
58 FORTUÑO NAVARRO, JOSE LUIS VE2 M222500000000 47 47
59 GUZMAN, MATIAS VE1 M46000000000 46 46
60 GAIC, ROBERT DAVID SEN M182800000000 46 46
61 CASTELLS CARLES, ALEJANDRO VE2 M45000000000 45 45
62 GARGALLO ROYO, JOSE RAMÓN VE1 M44000000000 44 44
63 BERTOMEU CURTO, JOEL VE1 M43000000000 43 43
64 BELTRAN ARQUES, JUAN FRANCISCO VE2 M04300000000 43 43
65 REVERTER BULLON, JOSE MIGUEL VE2 M172600000000 43 43
66 CABANES CALVET, ALBERT VE2 M42000000000 42 42
67 BATSI ARAGON, CARLOS VE1 M04200000000 42 42
68 GONZALEZ MORATALLA, ALFREDO VE1 M192300000000 42 42
69 GARCIA ALPAÑES, HECTOR VE1 M04100000000 41 41
70 VALMAÑA, ELOY VE1 M40000000000 40 40
71 CURTO IBAÑEZ, ADRIA S23 M04000000000 40 40
72 LLORCA PINTOR, FCO. JAVIER SEN M03800000000 38 38
73 DELLA CALLEN, CARLOS VE1 M37000000000 37 37
74 ESCUDERO COLOMINES, DANI VE1 M03700000000 37 37
75 CASELLAS APARICIO, RAFAEL VE2 M36000000000 36 36
76 DAZA BERENGUER, DANI VE1 M03600000000 36 36
77 SANCHEZ MIRALLES, JUAN ANTONIO VE2 M03500000000 35 35
78 AGUILÓ BO, XAVIER VE1 M32000000000 32 32
79 TORRES , JORGE VE2 M03200000000 32 32
80 BRETÓ VERGE, FRANCESC VE1 M31000000000 31 31
81 QUERALT ROIG, DANI VE1 M03100000000 31 31
82 PONS URQUIZU, JOSE MARIA MA2 M30000000000 30 30
83 SAHRAOUI CABRERA, CARLES SEN M03000000000 30 30
84 GONZALEZ GILABERT, OCTAVI SEN M29000000000 29 29
85 SANCHO JOSE, VICTOR MA1 M27000000000 27 27
86 MONTOYA LECEGUI, SANTI VE1 M02700000000 27 27
87 VIDAL FOIX, XAVIER VE2 M26000000000 26 26
88 BESALDUCH BEL, XAVI VE1 M25000000000 25 25
89 CID ESPUNY, JOSEP LLUIS MA1 M24000000000 24 24
90 LANGE EBRI, ARTURO MA2 M02400000000 24 24
91 ESPINOSA VILLAR, BORJA VE1 M23000000000 23 23
92 HERNANDEZ RODRIGUEZ, CARLOS MA1 M71600000000 23 23
93 GARRIGA SOROLLA, XAVIER VE1 M81500000000 23 23
94 PÉREZ FERNANDEZ , MIGUEL MA1 M02200000000 22 22
95 SUBIRATS CID, XAVI SEN M21000000000 21 21
96 ASÍN QUEROL, JORGE VE1 M02100000000 21 21
97 BRUNET ZARAGOZA, MIKEL SEN M02000000000 20 20
98 MANZANERO HERAS, VICENT VE2 M01900000000 19 19
99 ROMERO NOFRE, FERNANDO VE2 M21700000000 19 19
100 SARIÓ DOMECH, SALVADOR SEN M01800000000 18 18
101 FERRE LOPEZ, CARLOS SEN M16000000000 16 16
102 BROUGHTON, JIM MA1 M61000000000 16 16
103 SIMÓ QUERALT, EUGENI VE1 M15000000000 15 15
104 FELIX RIPOLL, JUAN VE1 M21300000000 15 15
105 SEBASTIA VALLDEPEREZ, JORDI VE1 M14000000000 14 14
106 BORRAS LLOSA, ALBERT VE2 M01400000000 14 14
107 ORTS MORA, BORJA VE1 M21200000000 14 14
108 SERRET GOMEZ, JUAN CARLOS VE1 M13000000000 13 13
109 FRANCO CIURANA, JOSÉ ANTONIO VE1 M12000000000 12 12
110 GONZALEZ CURIEL, JULIO VE2 M11000000000 11 11
111 CURTO PIÑANA, CRISTIAN VE1 M01100000000 11 11
112 ACERO GUERRERO, JORGE VE1 M10000000000 10 10
113 DOSDAD CAMPOS , OSCAR VE1 M9000000000 9 9
114 GUIU BAGÉS, ALBERT VE2 M0900000000 9 9
115 GOMEZ MARTINEZ, JOSE LUIS VE2 M0800000000 8 8
116 BAREA SEBASTIA, NOE VE1 M2600000000 8 8
117 FUMADO CASANOVA, JUAN JOSE MA1 M0700000000 7 7
118 BELTRAN SUBIRATS, JOSEP MARIA VE2 M2500000000 7 7
119 TOMÀS I ROIGET, ADAM VE2 M5000000000 5 5
120 SABATE SABATE, JAVIER SEN M2300000000 5 5
121 GARRIGA ALMO, FRANCISCO MA1 M4000000000 4 4
122 GARCIA BALLÚS, DAVID VE2 M0400000000 4 4
123 CASTELLS FABRA, LLUIS VE1 M2200000000 4 4
124 VALENCIA NEBOT, ENRIC MA1 M3000000000 3 3
125 ALBESA ARASA, JOAN MA1 M2000000000 2 2
126 GUTIÉRREZ MÁRQUEZ, FCO JAVIER VE1 M2000000000 2 2
127 SUBIRANA SARDA, MANEL MA2 M2000000000 2 2




Amb el suport de: