CLASSIFICACIÓ 5K: ABSOLUT MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. CamarlesL'AmpollaL'AldeaAmpostaDeltebre Total Punts
1 OUCHBAB, AISSA S18 M1150000 115 115
2 MONTSERRAT AGUILÓ, ÒSCAR SEN M1030000 103 103
3 ABAGHAD, YOUSSEF SEN M930000 93 93
4 RODA SALES, DAVID VE1 M850000 85 85
5 RENALES PRIETO, ALEJANDRO SEN M790000 79 79
6 MARTOS MARTI, JOAN VE1 M750000 75 75
7 DUEÑAS RODRIGUEZ, ALBERTO VE1 M730000 73 73
8 MOSEGUI TORA, RAFEL VE1 M710000 71 71
9 ARIAS NOGUÉS, ROBERT SEN M700000 70 70
10 SABATÉ MASIP , ADRIÀ VE1 M690000 69 69
11 RODRÍGUEZ SALVADÓ, GERARD SEN M680000 68 68
12 SABORIDO ESCURRIOLA, GENÍS SEN M670000 67 67
13 ALIAU BERTOMEU, JORDI S23 M660000 66 66
14 ULLDEMOLINS TODÓ, ALFONS VE1 M650000 65 65
15 LEON PORTES, JOSE LUIS S23 M640000 64 64
16 GARCIA REDONDO, DOMINGO VE2 M630000 63 63
17 PUIG AGUILO, VICENT SEN M620000 62 62
18 SIGÜENZA AMARO, FRANCISCO VE1 M610000 61 61
19 GABALDA FERRE, ELOI SEN M600000 60 60
20 MIRO ANDREU, ANTONI MA1 M590000 59 59
21 RODRIGUEZ GAS, XIMO VE2 M580000 58 58
22 GONZÁLEZ CABALLERO, DAVID SEN M570000 57 57
23 MARTOS MARTI, ANGEL VE1 M560000 56 56
24 MONLLAO FERRE, PAU SEN M550000 55 55
25 ANDREU LOPEZ, AARÓN SEN M540000 54 54
26 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M530000 53 53
27 GARCIA CERVETO, CARLES SEN M520000 52 52
28 BERTOMEU BAILE, DAVID VE2 M510000 51 51
29 FRANCH FRANCH, JOAN MARTI SEN M500000 50 50
30 BUERA FRANCH, MIQUEL S18 M490000 49 49
31 BUERA REBULLIDA, JOSEP MIQUEL VE1 M480000 48 48
32 AGRAMUNT NAVARRO, ALVARO VE2 M470000 47 47
33 MBALLOW, OUSMAN S18 M460000 46 46
34 MAURI BONET , JORDI S18 M450000 45 45
35 GONZALEZ REVERTER, RAMON MA1 M440000 44 44
36 AYET SALES, DAVID VE2 M430000 43 43
37 ANDREU FERRANDO, XAVIER MA1 M420000 42 42
38 MARTÍN DOMENECH, JOAN S23 M410000 41 41
39 LUQUE LLUCH, OLIVER VE1 M400000 40 40
40 TORRES , JORGE VE2 M390000 39 39
41 FERRE VADILLO, ENRIC VE1 M380000 38 38
42 PAGÀ SORRIBES, FRANCESC VE1 M370000 37 37
43 SEDIKI AIT SILARBI, HAKIM VE2 M360000 36 36
44 GALARZA SANCHEZ, ALEJANDRO VE2 M350000 35 35
45 MAURI HIERRO, DAVID VE1 M340000 34 34
46 MARTÍ JOVE, JOSEP MA2 M330000 33 33
47 ALIAU BERTOMEU, JOAN S18 M320000 32 32
48 ALSO GAS, LLORENS MA1 M310000 31 31
49 SERRA ZARAGOZA, PAU S18 M300000 30 30
50 BROUGHTON, JIM MA2 M290000 29 29
51 DAUDEN MORENO, MIGUEL SEN M280000 28 28
52 MARGALEF PELEGRIN, JOSEP VE1 M270000 27 27
53 FARRÉ GARCIA, JORDI VE1 M260000 26 26
54 MUR BAGES, JOAN RAMON MA1 M250000 25 25
55 LEÓN CORDOVA, EZEQUIEL S18 M240000 24 24




Amb el suport de: