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 dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS una, 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, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpollaPerellóCamarlesTortosaDeltebreJesús Total Punts
1 TOMÀS BUITRAGO, AITOR 011511511500 345 345
2 SANAHUJA BARRANCO, JOSEP RAMON 11593010300 311 311
3 BALAGUE BELTRAN, JOAQUIN 6966636600 264 264
4 GARCIA REDONDO, DOMINGO 937509300 261 261
5 FUMADO GISBERT, ORIOL 6268596900 258 258
6 MARTÍ JOVE, JOSEP 6561526000 238 238
7 GRUESO OTALO, ANTONIO 103850000 188 188
8 ALCOVERRO FABREGAT, LEO 666557000 188 188
9 ROCA REY, ROGER 646256000 182 182
10 ESTORACH SOL, OSCAR 00738500 158 158
11 GOMEZ AUSACH, ANDREU 79730000 152 152
12 SALES CENTELLES, LLUIS 75007500 150 150
13 ALDAO MORELLÓ, ERIC 06706700 134 134
14 ORTEGA BLANCO, JAIME 06461000 125 125
15 TORREBLANCA CERVELLÓ, JOSE ANGEL 00586500 123 123
16 EL JIHAOUI, AZZIZ 00103000 103 103
17 SOWE , MUSA 01030000 103 103
18 GERARD, DUBENT 05449000 103 103
19 NAVARRO FALCÓ, JOSEP 05348000 101 101
20 CEBALLOS CAMAÑES , ADRIA 0093000 93 93
21 ELAKRAA, OTHMAN 0085000 85 85
22 RIERA FLORES, JORDI 8500000 85 85
23 COVAS DOMENECH, KEVIN 0079000 79 79
24 ANTÚNEZ TIRADO, JOSE 0007900 79 79
25 CABALLÉ ANDREU, ENRIC 0790000 79 79
26 TORTOSA, DAVID 0075000 75 75
27 TRILLO LUCENA, JOSE 7300000 73 73
28 MATAMOROS, SERGI 0007300 73 73
29 GARCÍA ANTA , JESUS 0071000 71 71
30 MENENEDEZ GIMENO, ALEX 7100000 71 71
31 OBIOL PEDROL, ENRIC 0007100 71 71
32 CAPTARI, FABIAN 0710000 71 71
33 HERNANDEZ GARRIDO, GERARD 0070000 70 70
34 SUBIRATS MARTÍN, JULIÀ 7000000 70 70
35 ALONSO QUESADA, OSCAR 0007000 70 70
36 ALBACAR CLIMENT, CONRAD 0700000 70 70
37 CRESPO PEREZ, DIDAC 0069000 69 69
38 MAURI GALVE, ALBERT 0690000 69 69
39 MACHI CABALLE, OMAR 0068000 68 68
40 POQUET DOMENECH, PAU 6800000 68 68
41 BAJADOR BATALLA, ALEIX 0006800 68 68
42 BERTOMEU BAILE, DAVID 0067000 67 67
43 ROCA ALGUERÓ, JOAN 6700000 67 67
44 TORRES , JORGE 0066000 66 66
45 BERTOMEU BELLES, CRISTIAN 0065000 65 65
46 MONLLAO FERRE, PAU 0064000 64 64
47 NAVARRO PEDRET, FRANCESC 0006400 64 64
48 WATSON, JAMIE 6300000 63 63
49 AGUILAR RODRÍGUEZ, MARC 0006300 63 63
50 PASCUAL VENDRELL, SERGEI 0630000 63 63
51 ESPINOZA GOMEZ, ADRIÀ 0062000 62 62
52 JIMÉNEZ MUR, PERE JOSEP 0006200 62 62
53 GOLENEVA, ASYA 6100000 61 61
54 ARASA ARASA, JUAN JOSE 0006100 61 61
55 MECA VENTURA, CARLOS 0060000 60 60
56 FUSTER GIL, ANGEL LLUIS 0600000 60 60
57 MUR BAGES, JOAN RAMON 0005900 59 59
58 BRULL MARGALEF, JORDI 0590000 59 59
59 GARRIDO LOPEZ, MARCOS 0580000 58 58
60 SAMANIEGO GOMEZ, XAVI 0570000 57 57
61 ALBIAC VIÑOLAS, FERRAN 0560000 56 56
62 MARTI MARTI, MARC SEBASTIA 0055000 55 55
63 GONZÀLEZ CORTINA, OSCAR 0550000 55 55
64 TERAN GOMEZ, JOAN 0054000 54 54
65 MAURI HIERRO, DAVID 0053000 53 53
66 DE CARALT, ALVARO 0051000 51 51
67 OLLE CAMPAMA, FRANCESC 0050000 50 50
68 MARTINEZ BONET, JUAN ENRIQUE 0047000 47 47
69 CMADIERNO , JUAN 0046000 46 46