CLASSIFICACIÓ 10K: SÈNIOR 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="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SALES FERRE, ENRIC 1151039311500 426 426
2 GAIC, ROBERT DAVID 7979737000 301 301
3 MAURI BARDI, JORDI 7075717100 287 287
4 SABATE SABATE, JAVIER 6169686500 263 263
5 FATHI, ALI 0115115000 230 230
6 REDÓ VIUDEZ, CARLOS 103007900 182 182
7 ALBIOL CHERTA, GERARD 007510300 178 178
8 PARDO ARQUES, ROGER 85930000 178 178
9 BASSIYD, MUSTAPHA 08508500 170 170
10 GOMBAU MURRIA, ELISEU 93007500 168 168
11 MONTEVERDE MAURI, MARC 67730000 140 140
12 TOMÀS BUITRAGO, AITOR 00103000 103 103
13 NAVAS PORTELLA, VÍCTOR 0009300 93 93
14 SAGRISTA NOE, JOSEP 0085000 85 85
15 ABELLÀ RIBA, ANDREU 0079000 79 79
16 OBIOL PEDROL, ENRIC 7500000 75 75
17 GONZALEZ GILABERT, OCTAVI 0007300 73 73
18 PELEGRIN VALLS, JONATHAN 7300000 73 73
19 CASTELLS BARRACHINA, BLAY 7100000 71 71
20 MATEOS VIDAL, EDUARD 0710000 71 71
21 ANDREU LOPEZ, AARÓN 0070000 70 70
22 MARGALEF CABRERA, MIGUEL 0700000 70 70
23 FATSINI LLETI, DANIEL 0069000 69 69
24 FIBLA MORENO, JOAN LLUIS 6900000 69 69
25 ALSINA SALMORAL, XAVIER 0006900 69 69
26 CAMACHO MARGALEF, DAVID 0006800 68 68
27 CUESTA GARCIA, DANI 6800000 68 68
28 VILLEGAS GIRALDO, BAHUER 0006700 67 67
29 VILLARES MUÑIZ, MARTÍ-PAU 6600000 66 66
30 CURTO GARCIN, CARLOS 0006600 66 66
31 SUBIRATS CID, XAVI 6500000 65 65
32 GIMENO PUIGCERVER, MARC 6400000 64 64
33 MULET ROYO, JORDI 6300000 63 63
34 SANSALONI GILABERT, PAU 6200000 62 62
35 IBAÑEZ BISMARCH, JUST 6000000 60 60




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.