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. AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 GARCIA REDONDO, DOMINGO VE2 M79757100000 225 225
2 TOMÀS BUITRAGO, AITOR SEN M11507900000 194 194
3 TORREBLANCA CERVELLÓ, JOSE ANGEL VE1 M63646300000 190 190
4 ESTORACH SOL, OSCAR SEN M10385000000 188 188
5 MACHI CABALLE, OMAR SEN M9393000000 186 186
6 ORTEGA BLANCO, JAIME VE1 M62616200000 185 185
7 CAMPOY LOZANO, JUAN VE1 M71446800000 183 183
8 LUQUE LLUCH, OLIVER VE1 M65605700000 182 182
9 ALMENDROS RODA, IGNASI VE2 M66516400000 181 181
10 SANAHUJA BARRANCO, JOSEP RAMON VE2 M01037500000 178 178
11 SEDIKI AIT SILARBI, HAKIM VE2 M58566100000 175 175
12 BALAGUE BELTRAN, JOAQUIN VE1 M57555800000 170 170
13 ROCA REY, ROGER SEN M51495400000 154 154
14 MARGALEF BORRELL, JOSEP MA1 M52505100000 153 153
15 GALARZA SANCHEZ, ALEJANDRO VE2 M54465200000 152 152
16 RIERA I CAIRE, XAVIER S18 M7573000000 148 148
17 MARTÍ JOVE, JOSEP MA1 M50455300000 148 148
18 FUCHO PASCUAL, FELIP MA1 M7069000000 139 139
19 GOMEZ AUSACH, ANDREU SEN M6867000000 135 135
20 BERTOMEU BAILE, DAVID VE2 M6768000000 135 135
21 LLUCH ARBONA, FRANCESC VE1 M6406500000 129 129
22 ABAGHAD, YOUSSEF S23 M0115000000 115 115
23 MAIJÓ FRIGOLA, ÀDAM S23 M0011500000 115 115
24 BERTOMEU CASANOVA, AARON SEN M5657000000 113 113
25 FUMADO GISBERT, ORIOL S18 M0545600000 110 110
26 CARMONA PARADA, FRANCESC VE1 M0010300000 103 103
27 CUBELLS I CUBELLS, HERIBERT SEN M009300000 93 93
28 COLI MUNAR, PERE S23 M850000000 85 85
29 BENAIGES MARGALEF, JOSEP VE1 M008500000 85 85
30 BLANCH ALSO, ARNAU S18 M079000000 79 79
31 RODRIGUEZ SUBIRATS, DAVID VE1 M730000000 73 73
32 LEANDRO QUERO, JORDI VE1 M007300000 73 73
33 PAGA MARGALEF, JOAN PERE VE1 M071000000 71 71
34 CASAS CABRERA, PACO SEN M070000000 70 70
35 ESPINOSA CALLAU, CARLOS S18 M007000000 70 70
36 CÁCERES AZNAR, KARIM SEN M690000000 69 69
37 VALENCIA, MANUEL VE2 M006900000 69 69
38 CAPTARI, FABIAN ESTEBAN S23 M006700000 67 67
39 ASMOUH, MOHAMED S18 M066000000 66 66
40 JIMÉNEZ BRANERA , DANI SEN M006600000 66 66
41 ALONSO QUESADA, OSCAR VE2 M065000000 65 65
42 HAMDOUNI, AYOUB S23 M063000000 63 63
43 PEDROL PASCUAL, OSCAR S23 M062000000 62 62
44 LLUIS LLANSAMA, ANTONIO VE1 M610000000 61 61
45 FERRE FOLCH, DAVID VE2 M600000000 60 60
46 MAIJÓ FRIGOLA, ABEL SEN M006000000 60 60
47 ALMENDROS GARCIA, FERRAN S18 M059000000 59 59
48 PALMER FERRER, PERE VE2 M590000000 59 59
49 GABALDA FERRE, ELOI SEN M005900000 59 59
50 CURTO GARCIN, CARLOS SEN M058000000 58 58
51 GONZALEZ REVERTER, RAMON MA1 M550000000 55 55
52 FANDOS COLOMINES, FELIP VE1 M005500000 55 55
53 RIBES SERRA, JOSEP MARIA VE2 M053000000 53 53
54 VECIANA CARBONELL, JOSEP VE1 M530000000 53 53
55 PRATS TACHÉ, PERE MA1 M052000000 52 52
56 GERARD, DUBENT MA2 M005000000 50 50
57 SAMPER BRUNO, ALBERT VE1 M490000000 49 49
58 SOTO PAREDES, DANIEL VE1 M048000000 48 48
59 GARRIGA SANZ, ANTONI VE1 M480000000 48 48
60 MARTINEZ DE LEON, ORIOL VE1 M047000000 47 47
61 SOLÉ SUBIRATS, JULI VE2 M470000000 47 47
62 BALLESTE SCIORA, ALEX S18 M043000000 43 43
63 COTAINA CABALLE, JAVIER MA1 M042000000 42 42
64 DUSSARRAT, ROBIN SEN M041000000 41 41
65 MUR BAGES, JOAN RAMON MA1 M040000000 40 40
66 GARBI HUERGA, CARLOS TOMÁS VE1 M039000000 39 39
67 PAGA FABRA, AGUSTI SEN M038000000 38 38
68 DUBENT, GERARD MA2 M037000000 37 37
69 GONZÁLEZ MARCOS, DANIEL VE1 M036000000 36 36
70 ARASA FORNOS, OSCAR VE2 M035000000 35 35