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 01151151151150 460 460
2 SANAHUJA BARRANCO, JOSEP RAMON 1159301031030 414 414
3 GARCIA REDONDO, DOMINGO 9375093850 346 346
4 FUMADO GISBERT, ORIOL 62685969670 325 325
5 MARTÍ JOVE, JOSEP 65615260550 293 293
6 BALAGUE BELTRAN, JOAQUIN 6966636600 264 264
7 ROCA REY, ROGER 6462560570 239 239
8 GRUESO OTALO, ANTONIO 103850000 188 188
9 ALCOVERRO FABREGAT, LEO 666557000 188 188
10 ORTEGA BLANCO, JAIME 064610620 187 187
11 TORREBLANCA CERVELLÓ, JOSE ANGEL 005865630 186 186
12 CABALLÉ ANDREU, ENRIC 07900930 172 172
13 ESTORACH SOL, OSCAR 00738500 158 158
14 GERARD, DUBENT 054490510 154 154
15 GOMEZ AUSACH, ANDREU 79730000 152 152
16 SALES CENTELLES, LLUIS 75007500 150 150
17 MATAMOROS, SERGI 00073710 144 144
18 OBIOL PEDROL, ENRIC 00071690 140 140
19 BERTOMEU BAILE, DAVID 00670680 135 135
20 ALONSO QUESADA, OSCAR 00070640 134 134
21 BAJADOR BATALLA, ALEIX 00068660 134 134
22 ALDAO MORELLÓ, ERIC 06706700 134 134
23 ARASA ARASA, JUAN JOSE 00061590 120 120
24 EL JIHAOUI, AZZIZ 00103000 103 103
25 SOWE , MUSA 01030000 103 103
26 NAVARRO FALCÓ, JOSEP 05348000 101 101
27 CEBALLOS CAMAÑES , ADRIA 0093000 93 93
28 ELAKRAA, OTHMAN 0085000 85 85
29 RIERA FLORES, JORDI 8500000 85 85
30 COVAS DOMENECH, KEVIN 0079000 79 79
31 MORA SANSALONO, DAVID 0000790 79 79
32 ANTÚNEZ TIRADO, JOSE 0007900 79 79
33 TORTOSA, DAVID 0075000 75 75
34 PALÀ RAMOS, ELOI 0000750 75 75
35 LEANDRO QUERO, JORDI 0000730 73 73
36 TRILLO LUCENA, JOSE 7300000 73 73
37 GARCÍA ANTA , JESUS 0071000 71 71
38 MENENEDEZ GIMENO, ALEX 7100000 71 71
39 CAPTARI, FABIAN 0710000 71 71
40 HERNANDEZ GARRIDO, GERARD 0070000 70 70
41 SABORIDO ESCURRIOLA, GENÍS 0000700 70 70
42 SUBIRATS MARTÍN, JULIÀ 7000000 70 70
43 ALBACAR CLIMENT, CONRAD 0700000 70 70
44 CRESPO PEREZ, DIDAC 0069000 69 69
45 MAURI GALVE, ALBERT 0690000 69 69
46 MACHI CABALLE, OMAR 0068000 68 68
47 POQUET DOMENECH, PAU 6800000 68 68
48 ROCA ALGUERÓ, JOAN 6700000 67 67
49 TORRES , JORGE 0066000 66 66
50 BERTOMEU BELLES, CRISTIAN 0065000 65 65
51 FERRE FOLCH, DAVID 0000650 65 65
52 MONLLAO FERRE, PAU 0064000 64 64
53 NAVARRO PEDRET, FRANCESC 0006400 64 64
54 WATSON, JAMIE 6300000 63 63
55 AGUILAR RODRÍGUEZ, MARC 0006300 63 63
56 PASCUAL VENDRELL, SERGEI 0630000 63 63
57 ESPINOZA GOMEZ, ADRIÀ 0062000 62 62
58 JIMÉNEZ MUR, PERE JOSEP 0006200 62 62
59 MIRO JUAN, ALBERT 0000610 61 61
60 GOLENEVA, ASYA 6100000 61 61
61 MECA VENTURA, CARLOS 0060000 60 60
62 VENTURA VENTURA, HÈCTOR 0000600 60 60
63 FUSTER GIL, ANGEL LLUIS 0600000 60 60
64 MUR BAGES, JOAN RAMON 0005900 59 59
65 BRULL MARGALEF, JORDI 0590000 59 59
66 LLORET PÉREZ, GASPAR 0000580 58 58
67 GARRIDO LOPEZ, MARCOS 0580000 58 58
68 SAMANIEGO GOMEZ, XAVI 0570000 57 57
69 GIMENEZ CASANOVA, LLUIS 0000560 56 56
70 ALBIAC VIÑOLAS, FERRAN 0560000 56 56
71 MARTI MARTI, MARC SEBASTIA 0055000 55 55
72 GONZÀLEZ CORTINA, OSCAR 0550000 55 55
73 TERAN GOMEZ, JOAN 0054000 54 54
74 PORRES FURIO, CLAUDIO 0000540 54 54
75 MAURI HIERRO, DAVID 0053000 53 53
76 CASANOVA CURTO, ALVAR 0000530 53 53
77 BARBERA MARTI, VICTOR MANUEL 0000520 52 52
78 DE CARALT, ALVARO 0051000 51 51
79 OLLE CAMPAMA, FRANCESC 0050000 50 50
80 DELATORRE FERRE, XAVIER 0000500 50 50
81 MARTINEZ BONET, JUAN ENRIQUE 0047000 47 47
82 CMADIERNO , JUAN 0046000 46 46