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 PUENTES GARCÍA, LUIS FCO 0115103115103011510310300 757 757
2 CURTO I GILABERT, DAVID 73759393798510309300 694 694
3 ALABART ALCOBER, JOSEP MARIA 851031151038500857900 655 655
4 LLEIXÀ CHAVARRIA, JOSEP 666671857579757985930 774 642
5 LLUIS LLANSAMA, GABRIEL 67700737075677371850 651 584
6 CABANES CALVET, ALBERT 646870756873696870790 704 572
7 FIBLA REVERTER, HERMINI 62676970697168700750 621 559
8 FORTUÑO NAVARRO, JOSE LUIS 596366696768666969710 667 545
9 GRANGÉ GALINDO, JOSEP LLUIS 546465666266646767680 643 527
10 REVERTER BULLON, JOSE MIGUEL 555963656062606668690 627 513
11 ESCURRIOLA NAVARRO, RAMON 06973790073757300 442 442
12 FORNÉ CASTELLS, XAVIER 11500011511500000 345 345
13 SERRET ROIG, ADRIA 6565068666700000 331 331
14 SABATER CABRERA, ENRIC 071850008507500 316 316
15 CAÑÍS SÁNCHEZ, DANIEL 5657646764000000 308 308
16 LEÓN MORA, AUGUSTO LEO 610006569000700 265 265
17 ADELL WINKLER, PERE 525606400006500 237 237
18 DE TORRES BURGOS, FERRAN 000000011501150 230 230
19 MONTERO PÈREZ, JOSEP MARIA 9393000000000 186 186
20 BELTRAN SUBIRATS, JOSEP MARIA 51550000064000 170 170
21 GARCIA REDONDO, DOMINGO 00620000001030 165 165
22 ESQUERRE FERRE, ROMAN 6973000000000 142 142
23 GALARZA SANCHEZ, ALEJANDRO 0061000000660 127 127
24 RIBES SERRA, JOSEP MARIA 0000616500000 126 126
25 GARCIA DRAGO, JOSEP 5860000000000 118 118
26 FRANCOME GUTIERREZ, DAVID 0000000011500 115 115
27 ARASA CARDONA, RICARD 0530006000000 113 113
28 BALASTEGUI CONTRERAS, FRANCISCO 0000010300000 103 103
29 PEREZ MUÑOZ, FRANCISCO JESUS 1030000000000 103 103
30 FRANCOME GUTIERREZ, DAVID 000093000000 93 93
31 ALAIXENDRI JARDÍ, OSCAR 000000093000 93 93
32 ALONSO BURGOS , DAVID 000009300000 93 93
33 VILLAUBI, GERARD 000000930000 93 93
34 MONLLEO ROYO, LIBERTO 085000000000 85 85
35 REPISO MARTINEZ, JOAN 079000000000 79 79
36 GRAU SANZ, MAX 790000000000 79 79
37 ROMERO BELTRAN, ANTONIO MANUEL 000000790000 79 79
38 BELTRAN ARQUES, JUAN FRANCISCO 007900000000 79 79
39 TONDA SALVADÓ, JOSEP LLUIS 750000000000 75 75
40 MARESMA FELIPO, JOAN 007500000000 75 75
41 VENTURA CASTELLS, JOAN 000073000000 73 73
42 BORT I CORTIELLA, JOSEP JOAN 000000000730 73 73
43 SAIZ VIVES, JOSE MARIA 000000710000 71 71
44 GARCIA SANGÜESA, DAMIÀ 710000000000 71 71
45 RIUS CERVELLO, JOSEP ANTONI 000071000000 71 71
46 PARÉS MARTÍNEZ, CARLES 000000071000 71 71
47 SOTA MARTI, CARLOS 000710000000 71 71
48 ALIMBAU REVERTE, MIQUEL 700000000000 70 70
49 FERRER SABATÉ, ROGER 000000700000 70 70
50 BUSTOS FUENTES, ANDRES 000007000000 70 70
51 ACERO VENDRELL, ALVARO 680000000000 68 68
52 GUZMAN MORCILLO, PACO 006800000000 68 68
53 MARTORELL RUBIO, JORDI 006700000000 67 67
54 OLMO GARCIA, ENRIC 000000000670 67 67
55 BARREDA BARREDA , DIEGO 000000006600 66 66
56 MARÍN GIMÉNEZ, FERNANDO 000000650000 65 65
57 PARES MARTÍNEZ, DAVID 000000065000 65 65
58 CURTO NACHER, ALEX 000006400000 64 64
59 LLETI NAVARRO, FERNANDO 630000000000 63 63
60 PRADES CURTO, MICHEL 000006300000 63 63
61 CALLARISA GAVALDA, RAMON 000063000000 63 63
62 CANO LEON, RICARDO 000000630000 63 63
63 MALLÉN BARBERÀ, EDUARD 000000063000 63 63
64 MARTI GUARI, DAVID 062000000000 62 62
65 GARCIA CALERO, ENRIQUE JAVIER 000000620000 62 62
66 TEJEDA GIL, TOMÀS 000000062000 62 62
67 SOLÉ PÀMIES, RAMON 061000000000 61 61
68 ADRIANUS JOHANNES, ARTHUR 000000610000 61 61
69 GALVE CURTO, FERNANDO 000006100000 61 61
70 VALDIVIAS AHUMADA, OSCAR 600000000000 60 60
71 EIXARCH CONESA, LLUIS 000059000000 59 59
72 TIRON CAMISON, JAUME 000005900000 59 59
73 CABRERA CABALLÉ, MARCOS 058000000000 58 58
74 TAFALLA ANDREU, QUIM 000058000000 58 58
75 MASOLLER ARIAS, FRANCESC 570000000000 57 57
76 PEIRET DE LA FUENTE, CARLES 054000000000 54 54
77 TOMÀS I ROIGET, ADAM 530000000000 53 53
78 LOZANO HERNANDEZ, JOSE MARIA 500000000000 50 50




Amb el suport de: