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 tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, 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, 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àrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 MAS CACERES, LLUISMA 11511510311511510311511500 896 896
2 ALEMANY SEBASTIA , SAMUEL 103103931031039310385850 871 786
3 OLIVA SIMÓ, JUAN JOSÉ 6969858579738575790 699 630
4 ALABART ALCOBER, JOSEP MARIA 070707573699370750 595 595
5 SOTA MARTÍ, JORDI 797573797571069730 594 594
6 CASTELLS LOPEZ, RAMON 7068757171707962690 635 573
7 CURTO I GILABERT, DAVID 6765686870676767670 606 541
8 ULLDEMOLINS TODÓ, ALFONS 665807068646665680 525 525
9 ZARAGOZA VALLDEPEREZ, RAMON 5957666467626455650 559 504
10 QUERAL FORCADELL, XAVI 09311500115079930 495 495
11 PAGA MARGALEF, JOAN PERE 65616769065616100 449 449
12 LUQUE LLUCH, OLIVER 4442495353525152610 457 415
13 PRINCEP CARDONA, JESUS 757909385006800 400 400
14 ROMEU ESQUERRÉ, FERNANDO 50506105455555400 379 379
15 CASTELLS FABRA, LLUIS 3937484946454749510 411 374
16 SOTOMAYOR DUQUE, XAVI 4151636566006300 349 349
17 DELLA CALLEN, JUAN JOSE 5249590060605800 338 338
18 ALIMBAU REVERTE, MIQUEL 059646664005900 312 312
19 MARGALEF JORNET, PERE 73730093007100 310 310
20 VALLESPI DE LA CRUZ, JORDI 06771730075000 286 286
21 MONTESÓ JIMENEZ, DAVID 574860606100000 286 286
22 RODRIGUEZ SUBIRATS, DAVID 00690696373000 274 274
23 SEBASTIA VALLDEPEREZ, JORDI 464458636200000 273 273
24 MARTI GUARI, DAVID 420051050490560 248 248
25 REVERTER BULLON, JOSE MIGUEL 450510484600550 245 245
26 OLIVA SORIA, ANTONIO 61605461000000 236 236
27 MARTOS MARTI, ANGEL 05562576000000 234 234
28 QUERALT ROIG, DANI 58520625900000 231 231
29 FERNANDO ROYAL, JOSEP ENRIC 55005657580000 226 226
30 GRUESO OTALO, ANTONIO 8500000700700 225 225
31 MARTIN ARASA, JOSEP 54005458530000 219 219
32 CUGAT MULET, JAUME 43410005900620 205 205
33 FANDOS COLOMINES, FELIP 00050494850000 197 197
34 EL JIHAOUI, AZZIZ 0000000931030 196 196
35 LLEIXA GUARRO, IVAN 6406500000500 179 179
36 DELLA CALLEN, CARLOS 0000057566000 173 173
37 SORIANO LÓPEZ, MARTÍ 085000850000 170 170
38 ARAGON MORA , FELIP 4900005453000 156 156
39 SANS FERRER, ALBERT 0047000520490 148 148
40 GAS PANISELLO, DAVID 071000007300 144 144
41 MARGALEF BENAIGES, PAU 000670071000 138 138
42 CÓZAR TORÁN, PEDRO 686600000000 134 134
43 GARCIA SUAREZ, JULIO CESAR 000063062000 125 125
44 SORIANO LOPEZ, ANTONIO 530000000660 119 119
45 GARCIA FERNANDEZ, JORGE 000000001150 115 115
46 LLUCH ARBONA, DAVID 054000610000 115 115
47 GRATOVIL PEREZ, ENRIC 000005659000 115 115
48 CID MESEGUER, SIMON 565300000000 109 109
49 AGUILAR BONAVIDA, ESTEVE 480000000570 105 105
50 BALAGUE BELTRAN, JOAQUIN 470570000000 104 104
51 DELI I ANDÚJAR, MANEL 000000010300 103 103
52 ALBA RODRIGUEZ, TONI 510000430000 94 94
53 BELLART SANS, MIQUEL 93000000000 93 93
54 ALVAREZ GUTIERREZ, RUBEN 040000005300 93 93
55 SERRET GOMEZ, JUAN CARLOS 039500000000 89 89
56 PÉREZ SANZ, RAÚL 000004244000 86 86
57 VILAR ALCÁZAR, DAVID 00000790000 79 79
58 NOU CASTELL, RAMON 00790000000 79 79
59 CAPELL BUENDIA, ANTONI 00000750000 75 75
60 ALBESA ABADAL, ANDRES 71000000000 71 71
61 ALFARA GARCIA, BIENVE 00000000710 71 71
62 MATHEU GAS, XAVI 00000069000 69 69
63 ROYO GUILLEM, ANDREU 00000680000 68 68
64 RUBIO DIAZ, MARC 00000068000 68 68
65 BUERA REBULLIDA , JOSEP MIQUEL 00000660000 66 66
66 PELLICER PLAZAS, CHRISTIAN 00000006600 66 66
67 OLLE CAMPAMA, FRANCESC 00000065000 65 65
68 MOTES MARTINEZ, LUIS 00006500000 65 65
69 ESCUDERO COROMINES, DANI 06400000000 64 64
70 CUCURULL POCURULL, ORIOL 00000006400 64 64
71 GRAU VIDAL, ALBERTO 00000000640 64 64
72 DUEÑAS RODRIGUEZ, ALBERTO 06300000000 63 63
73 ASÍN QUEROL, JAVI 63000000000 63 63
74 FRANCH MARRO, XAVIER 00000063000 63 63
75 GINÉ CID, ALBERT 00000000630 63 63
76 LOPEZ GIL, DENIS 62000000000 62 62
77 FERNANDEZ FUERTES, ALEX 06200000000 62 62
78 MORENO GARCIA, JUAN 60000000000 60 60
79 CID PIUG, J. GABRIEL 00000000600 60 60
80 JUANPERE POBLET, MANEL 00059000000 59 59
81 MARTÍN GUZMÁN, DANIEL 00000000590 59 59
82 BUSTINDUY CASTILLO, IVÁN 00000058000 58 58
83 MARGALEF LLAO, TIBURCI ANDREU 00058000000 58 58
84 TORREBLANCA CERVELLÓ, JOSE ANGEL 00000000580 58 58
85 ALEIXENDRI ARRIBA, RAMON 00000057000 57 57
86 TALARN CAUBET, JOAQUIM 00000005700 57 57
87 CALDUCH GARCIA, JUAN 05600000000 56 56
88 VALMAÑA, ELOY 00005600000 56 56
89 RIBAS BEL, ALBERT 00560000000 56 56
90 MIGUEL BARTOLOME, ALBERTO 00000005600 56 56
91 CASTEJON, JOSE 00005500000 55 55
92 SUOMINEN, IRRON 00550000000 55 55
93 ALFONSO GOMEZ, SANTIAGO 00055000000 55 55
94 BORRAS MARTINEZ, GERARD 00000054000 54 54
95 PLADELLORENS SALVANS, JOEL 00000000540 54 54
96 VACHERESSE ORTIZ, STEPHANE 00530000000 53 53
97 CIFRE SOSPEDRA, JOSE ANGEL 00520000000 52 52
98 TORRES , JORGE 00005200000 52 52
99 AZNAR RUIZ, CHRISTIAN 00052000000 52 52
100 CASANOVA PALLEJÀ, XAVIER 00000000520 52 52
101 TORRENT NAVARRO, ENRIC 00000510000 51 51
102 ALÚTIZ ESPAÑA, XAVIER 00005100000 51 51
103 GUARNER VILOCA, RICARD 00000005100 51 51
104 JIMÉNEZ CATALÁ, ANDREU 00005000000 50 50
105 PANISELLO FERRE, JAVIER 00000005000 50 50
106 VAQUERIZO RODRIGUEZ, EDUARDO 00000490000 49 49
107 ALEIXANDRI AUDÍ , JOSEP RAMON 00000048000 48 48
108 ACCENCI, RUBEN 00000000480 48 48
109 ROMERO VILLANUEVA, JUAN CARLOS 04700000000 47 47
110 TORRES BERTOMEU, JOSEP 00000470000 47 47
111 VARELA, JOSEP MANEL 00004700000 47 47
112 CABRÉ, MARIÀ 04600000000 46 46
113 CANO LEON, RICARDO 00000046000 46 46
114 SOTO PAREDES, DANIEL 04500000000 45 45
115 BORUP, SINE 00000045000 45 45
116 CLUA GAYA, MARC 00000440000 44 44
117 MARINAS VALLS, IVAN 04300000000 43 43
118 ROSELLO CASTELLS, ORIOL 00000410000 41 41
119 TERAN GOMEZ, JOAN 40000000000 40 40
120 PRADES PRADES, JOSEP M. 03800000000 38 38
121 ALVENTOSA LARA, RAFAEL 03600000000 36 36
122 FRANCH BONET, ROSANA 03500000000 35 35