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 tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, 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, 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 AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 COLOMINES CUADRAD, JAUME 931158579103103085850 748 748
2 SOWE , MUSA 085001151151151031030 636 636
3 GOMBAU MURRIA, ELISEU 7068687175757971690 646 578
4 SALES FERRE, ENRIC 73073859385073790 561 561
5 PELLICER MARTINEZ, DANI 6666657373687369680 621 556
6 GAIC, ROBERT DAVID 646263656607162600 513 513
7 BRET GALI , JORDI 6056595861616759590 540 484
8 FATHI, ALI 0093009310393930 475 475
9 VIUDEZ TOMÀS, MARTÍ 0103797505907900 395 395
10 AVINYO ARASA, PAU 696767007175000 349 349
11 PLA ALONSO, SERGI 656966707100000 341 341
12 GONZALEZ GILABERT, OCTAVI 006467707006100 332 332
13 ADAM CHAVARRIA, CARLOS 07975000930750 322 322
14 GOMEZ RODRIGUEZ, ERIC 00000677065660 268 268
15 SUBIRATS CID, JORDI 61580610630000 243 243
16 MONTEVERDE GRAU, GERARD 10300000067650 235 235
17 MESTRE QUEROL, ALBERT 00103000001150 218 218
18 MARGALEF PELEGRIN, JOSEP 5800060620000 180 180
19 TRESO MASCARELL, MARC 859300000000 178 178
20 MORILLO PORRAS, DAVID 5560620000000 177 177
21 MORILLO PORRAS, JUAN ANTONIO 5659610000000 176 176
22 CASTELLS BARRACHINA, BLAY 000000857500 160 160
23 ESPANYA SERRET, MARCEL 000085730000 158 158
24 GUIMERA FIBLA, CHRISTIAN 007100000730 144 144
25 REDÓ VIUDEZ, CARLOS 073000690000 142 142
26 ABAT BARRERA, IVAN 007000000710 141 141
27 CASADO, ALEX 006900000700 139 139
28 RIPOLL BENAIGES, FERRAN 680066000000 134 134
29 GIMENEZ BELLOBI, JORDI 710000000620 133 133
30 FERRÉ, ARNAU CASACUBERTA FERRÉ 064069000000 133 133
31 BERTOMEU CURTO, JOEL 000067000630 130 130
32 PEREZ FRANCH, JOAN 063000006300 126 126
33 BERTOMEU BELLES, CRISTIAN 000000060640 124 124
34 PLA SEGURA, EDU 001150000000 115 115
35 OUHDADI, YASSINE 000000011500 115 115
36 GUTIERREZ GARCIA, CRISTIAN 000115000000 115 115
37 MARTOS MARTI, JOAN 115000000000 115 115
38 DURA CREMADES, RICARDO 000103000000 103 103
39 ALSO SELMA, MIQUEL 00093000000 93 93
40 ESTORACH SOL, OSCAR 79000000000 79 79
41 SANS GRAU, DAVID 00000790000 79 79
42 FOLCH GOMIS, ALEIX 00007900000 79 79
43 MARIN MARIN, DANIEL 75000000000 75 75
44 SUÑER CARLES, PAU 07500000000 75 75
45 DOMINGUEZ ARASA, JOSEP 07100000000 71 71
46 SABORIDO ESCURRIOLA, EDUARD 07000000000 70 70
47 OHANNI, ALI 00000007000 70 70
48 CAPARRÓS APARICIO, ORIOL 00006900000 69 69
49 ADAM CHAVARRIA, FERRAN 00000069000 69 69
50 FIGUERAS MONER, RAMON 00068000000 68 68
51 GOMEZ AUSACH, ANDREU 00006800000 68 68
52 RIVERA VLOOTHUIS, MARCO 00000006800 68 68
53 REYES CUBELLS, MARC 00000068000 68 68
54 MURIA JARDI, JOAN 00000000670 67 67
55 ESQUERRE, EROS 67000000000 67 67
56 CASTELLS SEGARRA, ANTONI 00000006600 66 66
57 RIBER CHALER, EDGAR 00000660000 66 66
58 CASANOVA BORRAS, CARLES 00000066000 66 66
59 KLESHNIN, VOVOL 06500000000 65 65
60 DURA CONDE, RAUL 00006500000 65 65
61 CARLES PERIS, JOSEP 00000650000 65 65
62 MELICH CURTO, FRANCESC 00000006400 64 64
63 HERNÁNDEZ CARPIO, ALEJANDRO 00006400000 64 64
64 VERNET FALCÓ, IGNASI 00064000000 64 64
65 CÁCERES AZNAR, KARIM 00000640000 64 64
66 CHAVARRIA GARCIA, PERE 63000000000 63 63
67 CID CLUA, JAUME 00006300000 63 63
68 DOMENECH QUEROL, AITOR 00063000000 63 63
69 CHAVARRIA GARCIA, ENRIC 62000000000 62 62
70 NIVERA TORRES, MARC 00006200000 62 62
71 LOPEZ MORENO, CRISTIAN 00062000000 62 62
72 MURIA JARDÍ, FRANCESC 00000000610 61 61
73 CAMACHO MARGALEF, DAVID 06100000000 61 61
74 CURTO BAIGES, ALBERT 00600000000 60 60
75 TAIDLER, FLORIN 00000600000 60 60
76 SERRAL ZARAGOZA, JOAN 00060000000 60 60
77 ESPINOSA VILLAR, JOSE MANUEL 59000000000 59 59
78 GRAU ROCA, ÀLEX 00059000000 59 59
79 GOMBAU SOLÉ, CARLOS 00580000000 58 58
80 NICOLAU SALIDO, MIQUEL 00000000580 58 58
81 FONOLLOSA AULADELL, XAVIER 05700000000 57 57
82 VENTURA GILABERT, SERGI 57000000000 57 57
83 MONTOYA LECEGUI, SANTI 05500000000 55 55
84 KONFIDERA, RUDSON 54000000000 54 54
85 SERRET ABELLA, ELOI 05400000000 54 54
86 DELGADO, FRANCESC 53000000000 53 53
87 SERRANO JURADO, DANIEL 05300000000 53 53
88 SEGARRA VICENTE, ALEXANDRE 52000000000 52 52
89 PELLICER ABELLANEDA, DANIEL 05200000000 52 52
90 CARTES REVERTÉ, TONI 51000000000 51 51
91 ALBILLOS BLANCO, JOSÉ LUÍS 50000000000 50 50