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 ALABART ALCOBER, JOSEP MARIA 8510311510385008579093 748 748
3 LLEIXÀ CHAVARRIA, JOSEP 66667185757975798593115 889 701
4 CURTO I GILABERT, DAVID 73759393798510309300 694 694
5 LLUIS LLANSAMA, GABRIEL 6770073707567737185103 754 620
6 CABANES CALVET, ALBERT 6468707568736968707973 777 592
7 FIBLA REVERTER, HERMINI 626769706971687007585 706 577
8 FORTUÑO NAVARRO, JOSE LUIS 5963666967686669697171 738 565
9 GRANGÉ GALINDO, JOSEP LLUIS 5464656662666467676869 712 547
10 REVERTER BULLON, JOSE MIGUEL 5559636560626066686970 697 538
11 ESCURRIOLA NAVARRO, RAMON 06973790073757300 442 442
12 SERRET ROIG, ADRIA 65650686667000075 406 406
13 FORNÉ CASTELLS, XAVIER 11500011511500000 345 345
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 CASTELLS CARLES, ALEJANDRO 000000000079 79 79
40 TONDA SALVADÓ, JOSEP LLUIS 750000000000 75 75
41 MARESMA FELIPO, JOAN 007500000000 75 75
42 VENTURA CASTELLS, JOAN 000073000000 73 73
43 BORT I CORTIELLA, JOSEP JOAN 000000000730 73 73
44 SAIZ VIVES, JOSE MARIA 000000710000 71 71
45 GARCIA SANGÜESA, DAMIÀ 710000000000 71 71
46 RIUS CERVELLO, JOSEP ANTONI 000071000000 71 71
47 PARÉS MARTÍNEZ, CARLES 000000071000 71 71
48 SOTA MARTI, CARLOS 000710000000 71 71
49 ALIMBAU REVERTE, MIQUEL 700000000000 70 70
50 FERRER SABATÉ, ROGER 000000700000 70 70
51 BUSTOS FUENTES, ANDRES 000007000000 70 70
52 ACERO VENDRELL, ALVARO 680000000000 68 68
53 GUZMAN MORCILLO, PACO 006800000000 68 68
54 MATAMOROS NAVARRO, JOSEP 000000000068 68 68
55 MARTORELL RUBIO, JORDI 006700000000 67 67
56 OLMO GARCIA, ENRIC 000000000670 67 67
57 BARREDA BARREDA , DIEGO 000000006600 66 66
58 MARÍN GIMÉNEZ, FERNANDO 000000650000 65 65
59 PARES MARTÍNEZ, DAVID 000000065000 65 65
60 CURTO NACHER, ALEX 000006400000 64 64
61 LLETI NAVARRO, FERNANDO 630000000000 63 63
62 PRADES CURTO, MICHEL 000006300000 63 63
63 CALLARISA GAVALDA, RAMON 000063000000 63 63
64 CANO LEON, RICARDO 000000630000 63 63
65 MALLÉN BARBERÀ, EDUARD 000000063000 63 63
66 MARTI GUARI, DAVID 062000000000 62 62
67 GARCIA CALERO, ENRIQUE JAVIER 000000620000 62 62
68 TEJEDA GIL, TOMÀS 000000062000 62 62
69 SOLÉ PÀMIES, RAMON 061000000000 61 61
70 ADRIANUS JOHANNES, ARTHUR 000000610000 61 61
71 GALVE CURTO, FERNANDO 000006100000 61 61
72 VALDIVIAS AHUMADA, OSCAR 600000000000 60 60
73 EIXARCH CONESA, LLUIS 000059000000 59 59
74 TIRON CAMISON, JAUME 000005900000 59 59
75 CABRERA CABALLÉ, MARCOS 058000000000 58 58
76 TAFALLA ANDREU, QUIM 000058000000 58 58
77 MASOLLER ARIAS, FRANCESC 570000000000 57 57
78 PEIRET DE LA FUENTE, CARLES 054000000000 54 54
79 TOMÀS I ROIGET, ADAM 530000000000 53 53
80 LOZANO HERNANDEZ, JOSE MARIA 500000000000 50 50




Amb el suport de: