ABSOLUT MASCULÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 OUHDADI, YASSINE SEN M1150000000000 115 115
2 MENDEZ PRUNERA, ALEX SEN M1030000000000 103 103
3 JUAN-CAMPS CASTELL, AGUS VE1 M930000000000 93 93
4 FATHI, ALI SEN M850000000000 85 85
5 SOWE , MUSA VE1 M790000000000 79 79
6 ALEMANY SEBASTIA , SAMUEL VE1 M750000000000 75 75
7 FORNÉ CASTELLS, XAVIER VE2 M730000000000 73 73
8 MARTOS MARTI, JOAN SEN M710000000000 71 71
9 SALES FERRE, ENRIC SEN M700000000000 70 70
10 TRESO MASCARELL, MARC SEN M690000000000 69 69
11 CURTO ARAGONÉS, MARC SEN M680000000000 68 68
12 RENALES PRIETO, ALEJANDRO SEN M670000000000 67 67
13 PEREZ MUÑOZ, FRANCISCO JESUS VE2 M660000000000 66 66
14 CABALLÉ ANDREU, ENRIC VE1 M650000000000 65 65
15 RODA JIMENEZ, JOSEP SEN M640000000000 64 64
16 GINÉ CID, ALBERT VE1 M630000000000 63 63
17 MONTERO PÈREZ, JOSEP MARIA VE2 M620000000000 62 62
18 RIERA I CAIRE, ALBERT S23 M610000000000 61 61
19 ALABART ALCOBER, JOSEP MARIA VE2 M600000000000 60 60
20 SOTA MARTÍ, JORDI VE1 M590000000000 59 59
21 ALBESA ABADAL, ANDRES VE1 M580000000000 58 58
22 MARIN MARIN, DANIEL SEN M570000000000 57 57
23 QUERAL FORCADELL, DAVID VE1 M560000000000 56 56
24 ASÍN QUEROL, JAVI VE1 M550000000000 55 55
25 GIMENEZ BELLOBI, JORDI SEN M540000000000 54 54
26 GRAU SANZ, MAX VE2 M530000000000 53 53
27 VALLESPI DE LA CRUZ, JORDI VE1 M520000000000 52 52
28 TONDA SALVADÓ, JOSEP LLUIS VE2 M510000000000 51 51
29 GOMBAU MURRIA, ELISEU SEN M500000000000 50 50
30 CURTO I GILABERT, DAVID VE2 M490000000000 49 49
31 PELLICER MARTINEZ, DANI SEN M480000000000 48 48
32 CASTELLS LOPEZ, RAMON VE1 M470000000000 47 47
33 MIRO ANDREU , ANTONI MA1 M460000000000 46 46
34 ULLDEMOLINS TODÓ, ALFONS VE1 M450000000000 45 45
35 GAUXACHS FONT, DAVID SEN M440000000000 44 44
36 ZARAGOZA VALLDEPEREZ, RAMON VE1 M430000000000 43 43
37 VELASCO, PASCAL MA1 M420000000000 42 42
38 PIQUERA NARANJO , OSCAR VE1 M410000000000 41 41
39 CORTÉS CALVO, MANU VE1 M400000000000 40 40
40 GARCIA SANGÜESA, DAMIÀ VE2 M390000000000 39 39
41 TOMAS PORRES, CARLOS VE1 M380000000000 38 38
42 ALIMBAU REVERTE, MIQUEL VE2 M370000000000 37 37
43 ESQUERRE FERRE, ROMAN VE2 M360000000000 36 36
44 SORIANO LOPEZ, ANTONIO VE1 M350000000000 35 35
45 ACERO VENDRELL, ALVARO VE2 M340000000000 34 34
46 LLUIS LLANSAMA, GABRIEL VE2 M330000000000 33 33
47 SOTOMAYOR DUQUE, XAVI VE1 M320000000000 32 32
48 CARBÓ FRANCH, ÉRIAN S23 M310000000000 31 31
49 MARTOS MARTI, ANGEL VE1 M300000000000 30 30
50 VALMAÑA, ELOY VE1 M290000000000 29 29
51 LLEIXÀ CHAVARRIA, JOSEP VE2 M280000000000 28 28
52 ESCODA MARTIN, ISMAEL VE1 M270000000000 27 27
53 PLA ALONSO, SERGI SEN M260000000000 26 26
54 QUERALT ROIG, DANI VE1 M250000000000 25 25
55 REDO PRINCEP, RICARD VE1 M240000000000 24 24
56 SERRET ROIG, ADRIA VE2 M230000000000 23 23
57 GAIC, ROBERT DAVID SEN M220000000000 22 22
58 SANCHO JOSE, VICTOR MA1 M210000000000 21 21
59 CID ESPUNY, JOSEP LLUIS MA1 M200000000000 20 20
60 RUIZ SERRANO, JUSTINO MA2 M190000000000 19 19
61 CABANES CALVET, ALBERT VE2 M180000000000 18 18
62 VILLAR MORERA, JOSE LUIS VE1 M170000000000 17 17
63 FORNÓS MONLLAU, MARC VE1 M160000000000 16 16
64 LLETI NAVARRO, FERNANDO VE2 M150000000000 15 15
65 TALARN CAUBET, JOAQUIM VE1 M140000000000 14 14
66 PELEGRIN SANCHEZ, JOAN CARLES MA1 M130000000000 13 13
67 GUART AUXACHS, JOAN VE1 M120000000000 12 12
68 ROMEU ESQUERRÉ, FERNANDO VE1 M110000000000 11 11
69 QUIRÓS PONFERRADA, DAVID VE1 M100000000000 10 10
70 BERTOMEU CURTO, JOEL SEN M90000000000 9 9
71 FIBLA REVERTER, HERMINI VE2 M80000000000 8 8
72 LEÓN MORA, AUGUSTO LEO VE2 M70000000000 7 7
73 SEBASTIA VALLDEPEREZ, JORDI VE1 M60000000000 6 6
74 VALDIVIAS AHUMADA, OSCAR VE2 M50000000000 5 5
75 SERRA TORTA, ANTON VE1 M40000000000 4 4
76 FORTUÑO NAVARRO, JOSE LUIS VE2 M30000000000 3 3
77 GARCIA DRAGO, JOSEP VE2 M20000000000 2 2
78 MASOLLER ARIAS, FRANCESC VE2 M20000000000 2 2
79 GIMENEZ CASANOVA, LLUIS SEN M20000000000 2 2
80 JUAN APARICIO, SANTI VE1 M20000000000 2 2
81 PARIS BRETÓ, GUILLERMO SEN M20000000000 2 2
82 GELLIDA BELMONTE, RUBEN SEN M20000000000 2 2
83 FERRE LOPEZ, CARLOS SEN M20000000000 2 2
84 CAÑÍS SÁNCHEZ, DANIEL VE2 M20000000000 2 2
85 BAIGET FARRÉ, JAUME SEN M20000000000 2 2
86 TOLDA GIL, MANEL VE1 M20000000000 2 2
87 REVERTER BULLON, JOSE MIGUEL VE2 M20000000000 2 2
88 MULET AGUILÓ , GERARD VICENT SEN M20000000000 2 2
89 ARASA ARASA, JUAN JOSE MA1 M20000000000 2 2
90 GRANGÉ GALINDO, JOSEP LLUIS VE2 M20000000000 2 2
91 GARRIGA ALMO, FRANCISCO MA1 M20000000000 2 2
92 SERRET GOMEZ, JUAN CARLOS VE1 M20000000000 2 2
93 VENTURA GILABERT, SERGI SEN M20000000000 2 2
94 LANGE EBRI, ARTURO MA1 M20000000000 2 2
95 LUCAS JARDI, DAVID VE1 M20000000000 2 2
96 TOMÀS I ROIGET, ADAM VE2 M20000000000 2 2
97 HERNANDEZ RODRIGUEZ, CARLOS MA1 M20000000000 2 2
98 ADELL WINKLER, PERE VE2 M20000000000 2 2
99 BROUGHTON, JIM MA1 M20000000000 2 2
100 BELTRAN SUBIRATS, JOSEP MARIA VE2 M20000000000 2 2
101 GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT VE1 M20000000000 2 2
102 ACCENSI CASAJUST, JOEL VE1 M20000000000 2 2
103 LOZANO HERNANDEZ, JOSE MARIA VE2 M20000000000 2 2
104 CASTELLS FABRA, LLUIS VE1 M20000000000 2 2
105 ESPINOSA VILLAR, BORJA VE1 M20000000000 2 2
106 MILLAN MASDEU, JOAN IGNASI MA1 M20000000000 2 2