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 9311585791031030000 578 578
2 GOMBAU MURRIA, ELISEU 70686871757579000 506 506
3 PELLICER MARTINEZ, DANI 66666573736873000 484 484
4 SOWE , MUSA 08500115115115000 430 430
5 BRET GALI , JORDI 60565958616167000 422 422
6 SALES FERRE, ENRIC 730738593850000 409 409
7 GAIC, ROBERT DAVID 6462636566071000 391 391
8 AVINYO ARASA, PAU 696767007175000 349 349
9 PLA ALONSO, SERGI 656966707100000 341 341
10 VIUDEZ TOMÀS, MARTÍ 010379750590000 316 316
11 FATHI, ALI 00930093103000 289 289
12 GONZALEZ GILABERT, OCTAVI 00646770700000 271 271
13 ADAM CHAVARRIA, CARLOS 0797500093000 247 247
14 SUBIRATS CID, JORDI 61580610630000 243 243
15 MARGALEF PELEGRIN, JOSEP 5800060620000 180 180
16 TRESO MASCARELL, MARC 859300000000 178 178
17 MORILLO PORRAS, DAVID 5560620000000 177 177
18 MORILLO PORRAS, JUAN ANTONIO 5659610000000 176 176
19 ESPANYA SERRET, MARCEL 000085730000 158 158
20 REDÓ VIUDEZ, CARLOS 073000690000 142 142
21 GOMEZ RODRIGUEZ, ERIC 000006770000 137 137
22 RIPOLL BENAIGES, FERRAN 680066000000 134 134
23 FERRÉ, ARNAU CASACUBERTA FERRÉ 064069000000 133 133
24 PLA SEGURA, EDU 001150000000 115 115
25 GUTIERREZ GARCIA, CRISTIAN 000115000000 115 115
26 MARTOS MARTI, JOAN 115000000000 115 115
27 MONTEVERDE GRAU, GERARD 103000000000 103 103
28 MESTRE QUEROL, ALBERT 001030000000 103 103
29 DURA CREMADES, RICARDO 000103000000 103 103
30 ALSO SELMA, MIQUEL 00093000000 93 93
31 CASTELLS BARRACHINA, BLAY 00000085000 85 85
32 ESTORACH SOL, OSCAR 79000000000 79 79
33 SANS GRAU, DAVID 00000790000 79 79
34 FOLCH GOMIS, ALEIX 00007900000 79 79
35 MARIN MARIN, DANIEL 75000000000 75 75
36 SUÑER CARLES, PAU 07500000000 75 75
37 GUIMERA FIBLA, CHRISTIAN 00710000000 71 71
38 GIMENEZ BELLOBI, JORDI 71000000000 71 71
39 DOMINGUEZ ARASA, JOSEP 07100000000 71 71
40 ABAT BARRERA, IVAN 00700000000 70 70
41 SABORIDO ESCURRIOLA, EDUARD 07000000000 70 70
42 CASADO, ALEX 00690000000 69 69
43 CAPARRÓS APARICIO, ORIOL 00006900000 69 69
44 ADAM CHAVARRIA, FERRAN 00000069000 69 69
45 FIGUERAS MONER, RAMON 00068000000 68 68
46 GOMEZ AUSACH, ANDREU 00006800000 68 68
47 REYES CUBELLS, MARC 00000068000 68 68
48 ESQUERRE, EROS 67000000000 67 67
49 BERTOMEU CURTO, JOEL 00006700000 67 67
50 RIBER CHALER, EDGAR 00000660000 66 66
51 CASANOVA BORRAS, CARLES 00000066000 66 66
52 KLESHNIN, VOVOL 06500000000 65 65
53 DURA CONDE, RAUL 00006500000 65 65
54 CARLES PERIS, JOSEP 00000650000 65 65
55 HERNÁNDEZ CARPIO, ALEJANDRO 00006400000 64 64
56 VERNET FALCÓ, IGNASI 00064000000 64 64
57 CÁCERES AZNAR, KARIM 00000640000 64 64
58 PEREZ FRANCH, JOAN 06300000000 63 63
59 CHAVARRIA GARCIA, PERE 63000000000 63 63
60 CID CLUA, JAUME 00006300000 63 63
61 DOMENECH QUEROL, AITOR 00063000000 63 63
62 CHAVARRIA GARCIA, ENRIC 62000000000 62 62
63 NIVERA TORRES, MARC 00006200000 62 62
64 LOPEZ MORENO, CRISTIAN 00062000000 62 62
65 CAMACHO MARGALEF, DAVID 06100000000 61 61
66 CURTO BAIGES, ALBERT 00600000000 60 60
67 TAIDLER, FLORIN 00000600000 60 60
68 SERRAL ZARAGOZA, JOAN 00060000000 60 60
69 ESPINOSA VILLAR, JOSE MANUEL 59000000000 59 59
70 GRAU ROCA, ÀLEX 00059000000 59 59
71 GOMBAU SOLÉ, CARLOS 00580000000 58 58
72 FONOLLOSA AULADELL, XAVIER 05700000000 57 57
73 VENTURA GILABERT, SERGI 57000000000 57 57
74 MONTOYA LECEGUI, SANTI 05500000000 55 55
75 KONFIDERA, RUDSON 54000000000 54 54
76 SERRET ABELLA, ELOI 05400000000 54 54
77 DELGADO, FRANCESC 53000000000 53 53
78 SERRANO JURADO, DANIEL 05300000000 53 53
79 SEGARRA VICENTE, ALEXANDRE 52000000000 52 52
80 PELLICER ABELLANEDA, DANIEL 05200000000 52 52
81 CARTES REVERTÉ, TONI 51000000000 51 51
82 ALBILLOS BLANCO, JOSÉ LUÍS 50000000000 50 50