CLASSIFICACIÓ 10K: 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 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="VE2 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 CURTO I GILABERT, DAVID 7375939379851030000 601 601
2 PUENTES GARCÍA, LUIS FCO 011510311510301150000 551 551
3 LLEIXÀ CHAVARRIA, JOSEP 666671857579750000 517 517
4 ALABART ALCOBER, JOSEP MARIA 8510311510385000000 491 491
5 CABANES CALVET, ALBERT 646870756873690000 487 487
6 FIBLA REVERTER, HERMINI 626769706971680000 476 476
7 FORTUÑO NAVARRO, JOSE LUIS 596366696768660000 458 458
8 GRANGÉ GALINDO, JOSEP LLUIS 546465666266640000 441 441
9 REVERTER BULLON, JOSE MIGUEL 555963656062600000 424 424
10 LLUIS LLANSAMA, GABRIEL 67700737075670000 422 422
11 FORNÉ CASTELLS, XAVIER 11500011511500000 345 345
12 SERRET ROIG, ADRIA 6565068666700000 331 331
13 CAÑÍS SÁNCHEZ, DANIEL 5657646764000000 308 308
14 ESCURRIOLA NAVARRO, RAMON 069737900730000 294 294
15 SABATER CABRERA, ENRIC 07185000850000 241 241
16 LEÓN MORA, AUGUSTO LEO 61000656900000 195 195
17 MONTERO PÈREZ, JOSEP MARIA 9393000000000 186 186
18 ADELL WINKLER, PERE 52560640000000 172 172
19 ESQUERRE FERRE, ROMAN 6973000000000 142 142
20 RIBES SERRA, JOSEP MARIA 0000616500000 126 126
21 GARCIA DRAGO, JOSEP 5860000000000 118 118
22 ARASA CARDONA, RICARD 0530006000000 113 113
23 BELTRAN SUBIRATS, JOSEP MARIA 5155000000000 106 106
24 BALASTEGUI CONTRERAS, FRANCISCO 0000010300000 103 103
25 PEREZ MUÑOZ, FRANCISCO JESUS 1030000000000 103 103
26 FRANCOME GUTIERREZ, DAVID 000093000000 93 93
27 ALONSO BURGOS , DAVID 000009300000 93 93
28 VILLAUBI, GERARD 000000930000 93 93
29 MONLLEO ROYO, LIBERTO 085000000000 85 85
30 REPISO MARTINEZ, JOAN 079000000000 79 79
31 GRAU SANZ, MAX 790000000000 79 79
32 ROMERO BELTRAN, ANTONIO MANUEL 000000790000 79 79
33 BELTRAN ARQUES, JUAN FRANCISCO 007900000000 79 79
34 TONDA SALVADÓ, JOSEP LLUIS 750000000000 75 75
35 MARESMA FELIPO, JOAN 007500000000 75 75
36 VENTURA CASTELLS, JOAN 000073000000 73 73
37 SAIZ VIVES, JOSE MARIA 000000710000 71 71
38 GARCIA SANGÜESA, DAMIÀ 710000000000 71 71
39 RIUS CERVELLO, JOSEP ANTONI 000071000000 71 71
40 SOTA MARTI, CARLOS 000710000000 71 71
41 ALIMBAU REVERTE, MIQUEL 700000000000 70 70
42 FERRER SABATÉ, ROGER 000000700000 70 70
43 BUSTOS FUENTES, ANDRES 000007000000 70 70
44 ACERO VENDRELL, ALVARO 680000000000 68 68
45 GUZMAN MORCILLO, PACO 006800000000 68 68
46 MARTORELL RUBIO, JORDI 006700000000 67 67
47 MARÍN GIMÉNEZ, FERNANDO 000000650000 65 65
48 CURTO NACHER, ALEX 000006400000 64 64
49 LLETI NAVARRO, FERNANDO 630000000000 63 63
50 PRADES CURTO, MICHEL 000006300000 63 63
51 CALLARISA GAVALDA, RAMON 000063000000 63 63
52 CANO LEON, RICARDO 000000630000 63 63
53 MARTI GUARI, DAVID 062000000000 62 62
54 GARCIA REDONDO, DOMINGO 006200000000 62 62
55 GARCIA CALERO, ENRIQUE JAVIER 000000620000 62 62
56 SOLÉ PÀMIES, RAMON 061000000000 61 61
57 ADRIANUS JOHANNES, ARTHUR 000000610000 61 61
58 GALVE CURTO, FERNANDO 000006100000 61 61
59 GALARZA SANCHEZ, ALEJANDRO 006100000000 61 61
60 VALDIVIAS AHUMADA, OSCAR 600000000000 60 60
61 EIXARCH CONESA, LLUIS 000059000000 59 59
62 TIRON CAMISON, JAUME 000005900000 59 59
63 CABRERA CABALLÉ, MARCOS 058000000000 58 58
64 TAFALLA ANDREU, QUIM 000058000000 58 58
65 MASOLLER ARIAS, FRANCESC 570000000000 57 57
66 PEIRET DE LA FUENTE, CARLES 054000000000 54 54
67 TOMÀS I ROIGET, ADAM 530000000000 53 53
68 LOZANO HERNANDEZ, JOSE MARIA 500000000000 50 50




Amb el suport de: