VETERÀ-2 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="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 ORTÍN FONT, XAVIER 115115115115115115115115930 1013 920
2 LLUIS LLANSAMA, GABRIEL 103791037571857979700 744 674
3 VALENCIA, MANUEL 00858579938585790 591 591
4 MONTERO PÈREZ, JOSEP MARIA 000103851039393850 562 562
5 PELEGRIN SANCHEZ, JOAN CARLES 7167736967696766630 612 549
6 FORTUÑO NAVARRO, JOSE LUIS 6364686764797069650 609 546
7 VALDIVIAS AHUMADA, OSCAR 6668616460716871620 591 531
8 SEDIKI AIT SILARBI, HAKIM 6569676558706665610 586 528
9 RIBES SERRA, JOSEP MARIA 686570636367640600 520 520
10 LLEIXÀ CHAVARRIA, JOSEP 07379796507570660 507 507
11 ALMENDROS RODA, IGNASI 07575707007373680 504 504
12 GALARZA SANCHEZ, ALEJANDRO 5960586254656160550 534 480
13 LEON MORA, AUGUSTO LEO 70717168557371000 479 479
14 SERRET ROIG, ADRIA 6466696666750000 406 406
15 CABRERA CABALLÉ, MARCOS 6770650006567640 398 398
16 BELTRAN SUBIRATS, JOSEP MARIA 0615961560061560 354 354
17 FIBLA REVERTER, HERMINI 006606268690670 332 332
18 GRAU SANZ, MAX 7900073000750 227 227
19 DE TORRES BURGOS, FERRAN 00000010301150 218 218
20 FORNÉ CASTELLS, XAVIER 00000001031030 206 206
21 ALONSO QUESADA, OSCAR 7500052000580 185 185
22 GARCIA SANGÜESA, DAMIÀ 858500000000 170 170
23 SANCHEZ LLOPIS, ROBERTO 009300000730 166 166
24 RODES HORTA, GERARD 000710000690 140 140
25 GARCIA DRAGO, JOSEP 610640000000 125 125
26 CAÑÍS SÁNCHEZ, DANIEL 606300000000 123 123
27 FERRÁNDIZ LARRAMONA, JAVIER 000053006800 121 121
28 ALBESA RUBIO, XAVIER 006000000590 119 119
29 BALASTEGUI CONTRERAS, FRANCISCO 000010300000 103 103
30 RAMOS ALFONSO, ANTONIO 010300000000 103 103
31 GARCIA REDONDO, DOMINGO 00009300000 93 93
32 SERRA BENEDICTO, JOAN 00093000000 93 93
33 VENTURA CASTELLS, JOAN 09300000000 93 93
34 TONDA SALVADO, MANEL 93000000000 93 93
35 ROMERO BELTRAN, ANTONIO 00007500000 75 75
36 PARÉS MARTÍNEZ, CARLES 00000007500 75 75
37 GALVE TORRES, JOAN CARLES 00073000000 73 73
38 CAMACHO TEVAS, JOSEP 73000000000 73 73
39 BORT I CORTIELLA, JOSEP JOAN 00000000710 71 71
40 FERRE BALSELLS, RAMON 00006900000 69 69
41 PELLICER DIAZ, JOSEP JOAQUIM 69000000000 69 69
42 BERTOMEU BAILE, DAVID 00006800000 68 68
43 CORRALES ARNAU, RAFEL 00000660000 66 66
44 CUGAT TOMAS, CLAUDIO 00000640000 64 64
45 ARASA CARDONA, RICARD 00000006400 64 64
46 TORRENT OLLÉ, JORDI 00630000000 63 63
47 TIRON CAMISON, JAUME 00000630000 63 63
48 VIVES I ISIDRO, JOAN 00000006300 63 63
49 MASOLLER ARIAS, FRANCESC 00000063000 63 63
50 GRANGÉ GALINDO, JOSEP LLUIS 62000000000 62 62
51 ESPANYA FORCADELL, ANTONI 00620000000 62 62
52 CASTAÑO DE LA ASUNCION, JUAN CARLOS 06200000000 62 62
53 AZNAR LOPEZ, FRANCISCO JOSE 00000620000 62 62
54 PARES MARTÍNEZ, DAVID 00000006200 62 62
55 NIELSEN, MICHKEL 00000062000 62 62
56 MARÍN GIMÉNEZ, FERNANDO 00006100000 61 61
57 ESPINOSA ZAVALETA, EDGAR RICARDO 00000610000 61 61
58 MONFORTE GARGALLO, PACO 00060000000 60 60
59 RODA MARTINEZ, SANTIAGO DAVID 00005900000 59 59
60 FORCADELL, DANI 00005700000 57 57
61 BARCELÓ MASDÉU, ALBERT 00000000570 57 57
62 PLA ALARCON, OSCAR 00000000540 54 54
63 AÑÓ LUNA, CARLES 00000000530 53 53
64 TAFALLA ANDREU, QUIM 00005100000 51 51