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 AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 FATHI, ALI 931031151150000000 426 426
2 GOMBAU MURRIA, ELISEU 677175750000000 288 288
3 SALES FERRE, ENRIC 799301030000000 275 275
4 GAIC, ROBERT DAVID 636668660000000 263 263
5 BERTOMEU CURTO, JOEL 626271650000000 260 260
6 OUHDADI, YASSINE 115115000000000 230 230
7 GAUXACHS FONT, DAVID 65700790000000 214 214
8 CURTO BAIGES, ALBERT 06770670000000 204 204
9 LLORCA PINTOR, FCO. JAVIER 06467680000000 199 199
10 COLOMINES CUADRAD, JAUME 0858500000000 170 170
11 TRESO MASCARELL, MARC 7509300000000 168 168
12 CASTELLS SEGARRA, ANTONI 0073930000000 166 166
13 PELLICER MARTINEZ, DANI 6600850000000 151 151
14 GOMEZ ROMEU, GERARD 0610630000000 124 124
15 GIMENEZ CASANOVA, LLUIS 6157000000000 118 118
16 BAIGET FARRÉ, JAUME 5759000000000 116 116
17 MENDEZ PRUNERA, ALEX 1030000000000 103 103
18 PLA SEGURA, EDU 0010300000000 103 103
19 MARTOS MARTI, JOAN 850000000000 85 85
20 SUÑER CARLES, PAU 079000000000 79 79
21 SANZ CASTELL, RAUL 007900000000 79 79
22 DOMINGUEZ ARASA, ALBERT 075000000000 75 75
23 CURTO ARAGONÉS, MARC 730000000000 73 73
24 REDÓ VIUDEZ, CARLOS 073000000000 73 73
25 REVELLES PI, ADRIÀ 000730000000 73 73
26 RENALES PRIETO, ALEJANDRO 710000000000 71 71
27 CID GUBAU, ORIOL 000710000000 71 71
28 RODA JIMENEZ, JOSEP 700000000000 70 70
29 FERRÉ, ARNAU CASACUBERTA FERRÉ 000700000000 70 70
30 MARIN MARIN, DANIEL 690000000000 69 69
31 GARGALLO ROYO, JOSE RAMÓN 069000000000 69 69
32 NOFRE ROMERA, PEDRO 006900000000 69 69
33 SEGARRA FARNÓS, SERGI 000690000000 69 69
34 GIMENEZ BELLOBI, JORDI 680000000000 68 68
35 MONFORT BEL, ALBERT 068000000000 68 68
36 GINE CARRASCO, JOSE 006600000000 66 66
37 LOPEZ MORENO, CRISTIAN 065000000000 65 65
38 SUBIRATS CID, XAVI 006500000000 65 65
39 PLA ALONSO, SERGI 640000000000 64 64
40 VALMAÑA CALBET, PAU 000640000000 64 64
41 DOMINGUEZ MARCH, OSCAR 063000000000 63 63
42 SABATE SABATE, JAVIER 000620000000 62 62
43 MARRO BELLOT, CRISTIAN 060000000000 60 60
44 PARIS BRETÓ, GUILLERMO 600000000000 60 60
45 GELLIDA BELMONTE, RUBEN 590000000000 59 59
46 NEBOT FORCADELL, MICHAEL 058000000000 58 58
47 FERRE LOPEZ, CARLOS 580000000000 58 58
48 SUBIRATS MARTÍN, JULIÀ 056000000000 56 56
49 MULET AGUILÓ , GERARD VICENT 560000000000 56 56
50 VENTURA GILABERT, SERGI 550000000000 55 55