VETERÀ-1 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="VE1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 SOWE , MUSA 103115931150000000 426 426
2 SOTA MARTÍ, JORDI 758573850000000 318 318
3 CASTELLS LOPEZ, RAMON 687170930000000 302 302
4 ZARAGOZA VALLDEPEREZ, RAMON 666864690000000 267 267
5 GUART AUXACHS, JOAN 526561640000000 242 242
6 VILLAR MORERA, JOSE LUIS 556155630000000 234 234
7 JUAN-CAMPS CASTELL, AGUS 115011500000000 230 230
8 ASÍN QUEROL, JAVI 70737100000000 214 214
9 VALLESPI DE LA CRUZ, JORDI 69756700000000 211 211
10 LLEIXA GUARRO, IVAN 07066730000000 209 209
11 ULLDEMOLINS TODÓ, ALFONS 67065670000000 199 199
12 ALEMANY SEBASTIA , SAMUEL 93010300000000 196 196
13 TOMAS PORRES, CARLOS 63666000000000 189 189
14 GINÉ CID, ALBERT 79103000000000 182 182
15 VALMAÑA, ELOY 59645800000000 181 181
16 MARTOS MARTI, ANGEL 60605400000000 174 174
17 CUGAT MULET, JAUME 05456620000000 172 172
18 TORRES , JORGE 05349610000000 163 163
19 TORRES BERTOMEU, JOSEP 05048590000000 157 157
20 SEBASTIA VALLDEPEREZ, JORDI 49490580000000 156 156
21 GRAU VIDAL, ALBERTO 0062660000000 128 128
22 SERRET GOMEZ, JUAN CARLOS 45443800000000 127 127
23 SORIANO LOPEZ, ANTONIO 6205700000000 119 119
24 QUERALT ROIG, DANI 5759000000000 116 116
25 REDÓ GÓMEZ, JUAN CARLOS 0555900000000 114 114
26 FERNANDO ROYAL, JOSEP ENRIC 0053600000000 113 113
27 SOTOMAYOR DUQUE, XAVI 6105000000000 111 111
28 TALARN CAUBET, JOAQUIM 5357000000000 110 110
29 TARRAGÓ COLOMER, ROBERT 0001030000000 103 103
30 CASTELLS FABRA, LLUIS 4100550000000 96 96
31 VIUDEZ TOMÀS, MARTÍ 093000000000 93 93
32 MIRALLES LLORCA, JESÚS 0484500000000 93 93
33 ESPINOSA VILLAR, BORJA 4004700000000 87 87
34 CARRILLO HERNANDEZ, DAVID 008500000000 85 85
35 CABALLÉ ANDREU, ENRIC 850000000000 85 85
36 SUBIRATS CID, JORDI 0454000000000 85 85
37 NOU CASTELL, RAMON 007900000000 79 79
38 FOLCH PUIG, ENRIC 000790000000 79 79
39 PALAU CIVIT, JORDI 079000000000 79 79
40 SORIANO LÓPEZ, MARTÍ 007500000000 75 75
41 DUEÑAS RODRIGUEZ, ALBERTO 000750000000 75 75
42 ALBESA ABADAL, ANDRES 730000000000 73 73
43 GARRIGA MARÍ, JOSEP 000710000000 71 71
44 QUERAL FORCADELL, DAVID 710000000000 71 71
45 VILANOVA ARDIT, JOSEP 000700000000 70 70
46 GÜELL VILLAR, ORIOL 006900000000 69 69
47 CAMARERO LÓPEZ, GUILLERMO 069000000000 69 69
48 RIBERA ROIG, PABLO 006800000000 68 68
49 ESCODA SERRES, JORDI 000680000000 68 68
50 CURTO RUE, DAVID 067000000000 67 67
51 PIQUERA NARANJO , OSCAR 650000000000 65 65
52 GARCIA SUAREZ, JULIO CESAR 000650000000 65 65
53 CORTÉS CALVO, MANU 640000000000 64 64
54 FERNANDEZ AGUIAR, MANU 006300000000 63 63
55 ESCUDERO COROMINES, DANI 063000000000 63 63
56 FRANCH VENTURA, PERE 062000000000 62 62
57 PEREZ FRANCH, JOAN 058000000000 58 58
58 ESCODA MARTIN, ISMAEL 580000000000 58 58
59 GARCIA I BERTRAN, JOAN 000570000000 57 57
60 MIGUEL GARRIDO, JOSÉ ANTONIO 056000000000 56 56
61 REDO PRINCEP, RICARD 560000000000 56 56
62 GARBI HUERGA, CARLOS TOMÁS 000560000000 56 56
63 FORNÓS MONLLAU, MARC 540000000000 54 54
64 NOFRE ROMERA, DOMINGO 005200000000 52 52
65 DAZA BERENGUER, DANI 052000000000 52 52
66 TORREBLANCA CERVELLÓ, JOSE ANGEL 005100000000 51 51
67 ROMEU ESQUERRÉ, FERNANDO 510000000000 51 51
68 SUBIRATS FERRERES, IVAN 051000000000 51 51
69 QUIRÓS PONFERRADA, DAVID 500000000000 50 50
70 SERRA TORTA, ANTON 480000000000 48 48
71 JUAN APARICIO, SANTI 470000000000 47 47
72 MONTOYA LECEGUI, SANTI 047000000000 47 47
73 RODEZNO ELVIR, DANIEL 004600000000 46 46
74 TOLDA GIL, MANEL 460000000000 46 46
75 FANDOS COLOMINES, FELIP 046000000000 46 46
76 SANS FERRER, ALBERT 004400000000 44 44
77 LUCAS JARDI, DAVID 440000000000 44 44
78 MARTIN ARASA, JOSEP 004300000000 43 43
79 GUERRERO MONTAÑES, FRANCISCO JAVIER (PAT 430000000000 43 43
80 VILA SOLÉ, FRANCESC 043000000000 43 43
81 RIBAS BEL, ALBERT 004200000000 42 42
82 ACCENSI CASAJUST, JOEL 420000000000 42 42
83 MARQUEZ, MANEL 042000000000 42 42
84 CENTELLES GASCON, ELOI 004100000000 41 41
85 GARCIA VIZUETE, JUANSE 041000000000 41 41
86 MONTERO AURA, JORDI 040000000000 40 40
87 SEGUER GARCIA, JAIME 003900000000 39 39