CLASSIFICACIÓ 10K: SÈNIOR 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="SEN M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 FATHI, ALI 9310311511511510311511511500 989 896
2 SALES FERRE, ENRIC 799301031030103103931030 780 780
3 COLOMINES CUADRAD, JAUME 085850939385079930 613 613
4 GOMBAU MURRIA, ELISEU 677175757073757375790 733 596
5 GAIC, ROBERT DAVID 636668666366686367710 661 535
6 BERTOMEU CURTO, JOEL 626271656562706466700 657 533
7 GAUXACHS FONT, DAVID 657007971690797300 506 506
8 REVELLES PI, ADRIÀ 000736968736969850 506 506
9 LLORCA PINTOR, FCO. JAVIER 064676866071068730 477 477
10 FRANCO SMEETS, CLAUDIO 0000858593938500 441 441
11 SABATE SABATE, JAVIER 00062605806162690 372 372
12 OUHDADI, YASSINE 11511500011500000 345 345
13 CURTO BAIGES, ALBERT 0677067670066000 337 337
14 PELLICER MARTINEZ, DANI 660085071075000 297 297
15 CASTELLS SEGARRA, ANTONI 00739300007100 237 237
16 TRESO MASCARELL, MARC 7509300000000 168 168
17 REDÓ VIUDEZ, CARLOS 0730007500000 148 148
18 GELLIDA BELMONTE, RUBEN 5900073000000 132 132
19 PARIS BRETÓ, GUILLERMO 6000064000000 124 124
20 GOMEZ ROMEU, GERARD 0610630000000 124 124
21 SUBIRATS MARTÍN, JULIÀ 0560006500000 121 121
22 GIMENEZ CASANOVA, LLUIS 6157000000000 118 118
23 BAIGET FARRÉ, JAUME 5759000000000 116 116
24 SALES FERRE, LLORENÇ 0000000001150 115 115
25 MENDEZ PRUNERA, ALEX 1030000000000 103 103
26 PLA SEGURA, EDU 0010300000000 103 103
27 CARRERO DÍEZ, JAVI 0000000010300 103 103
28 MARTOS MARTI, JOAN 850000000000 85 85
29 FERRERES ESPINOSA, CARLOS 000000085000 85 85
30 MARSAL FIGUERES, TOMAS 000000790000 79 79
31 MARCO CASANOVA, PAULO 000079000000 79 79
32 SUÑER CARLES, PAU 079000000000 79 79
33 FERNÁNDEZ TOMÀS, JOAN LLUÍS 000007900000 79 79
34 SANZ CASTELL, RAUL 007900000000 79 79
35 REMOLINA RALLO, FERRAN 000075000000 75 75
36 DOMINGUEZ ARASA, ALBERT 075000000000 75 75
37 ALBIOL CHERTA, GERARD 000000000750 75 75
38 CURTO ARAGONÉS, MARC 730000000000 73 73
39 RENALES PRIETO, ALEJANDRO 710000000000 71 71
40 ARRUFAT SANCHEZ, ALEIX 000000071000 71 71
41 CID GUBAU, ORIOL 000710000000 71 71
42 RODA JIMENEZ, JOSEP 700000000000 70 70
43 RUIZ MONJO, IVAN 000007000000 70 70
44 ARRUFAT CID, IVAN 000000070000 70 70
45 FERRÉ, ARNAU CASACUBERTA FERRÉ 000700000000 70 70
46 SANCHEZ PALACIOS, RAUL 000000007000 70 70
47 MARIN MARIN, DANIEL 690000000000 69 69
48 GARGALLO ROYO, JOSE RAMÓN 069000000000 69 69
49 NOFRE ROMERA, PEDRO 006900000000 69 69
50 SEGARRA FARNÓS, SERGI 000690000000 69 69
51 OUVRARD, KEVIN 000000690000 69 69
52 GIMENEZ BELLOBI, JORDI 680000000000 68 68
53 PEREZ JIMENEZ, JORGE 000068000000 68 68
54 ESPUNY ROS, LLUC 000000068000 68 68
55 MONFORT BEL, ALBERT 068000000000 68 68
56 FORCADA MORESO, CARLOS 000000067000 67 67
57 CERVELLERA SECH, JORDI 000006700000 67 67
58 VELASCO, YOANN 000000670000 67 67
59 GINE CARRASCO, JOSE 006600000000 66 66
60 SABATE SABATE, JAVIER 000000660000 66 66
61 CASAS LOPEZ, MIGUEL ANGEL 000000065000 65 65
62 LOPEZ MORENO, CRISTIAN 065000000000 65 65
63 PELEGRIN VALLS, JONATHAN 000000006500 65 65
64 SUBIRATS CID, XAVI 006500000000 65 65
65 PLA ALONSO, SERGI 640000000000 64 64
66 VALMAÑA CALBET, PAU 000640000000 64 64
67 FONOLLOSA AULADELL, XAVIER 000006400000 64 64
68 BERTOMEU GUIL, ORIOL 000000006400 64 64
69 DOMINGUEZ MARCH, OSCAR 063000000000 63 63
70 PRADES FERREIRA, MARC 000006300000 63 63
71 CASANOVA SERRAL, JORDI 000000006300 63 63
72 FERNANDEZ GARCIA, DANIEL 000000062000 62 62
73 BELLO SUBIRATS, HECTOR 000062000000 62 62
74 VIUDEZ, MARC VIUDEZ BRUNET 000006100000 61 61
75 CID CLUA, JAUME 000061000000 61 61
76 MARRO BELLOT, CRISTIAN 060000000000 60 60
77 GIMENO PUIGCERVER, MARC 000006000000 60 60
78 VILLARES MUÑIZ, MARTÍ-PAU 000005900000 59 59
79 MORILLO PORRAS, DAVID 000059000000 59 59
80 NEBOT FORCADELL, MICHAEL 058000000000 58 58
81 FERRE LOPEZ, CARLOS 580000000000 58 58
82 MULET AGUILÓ , GERARD VICENT 560000000000 56 56
83 VENTURA GILABERT, SERGI 550000000000 55 55




Amb el suport de: