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 79930103103010310393103115 895 816
3 COLOMINES CUADRAD, JAUME 08585093938507993103 716 716
4 GOMBAU MURRIA, ELISEU 6771757570737573757975 808 615
5 REVELLES PI, ADRIÀ 0007369687369698585 591 591
6 GAUXACHS FONT, DAVID 6570079716907973073 579 579
7 BERTOMEU CURTO, JOEL 6262716565627064667069 726 555
8 GAIC, ROBERT DAVID 6366686663666863677167 728 554
9 LLORCA PINTOR, FCO. JAVIER 064676866071068730 477 477
10 FRANCO SMEETS, CLAUDIO 0000858593938500 441 441
11 SABATE SABATE, JAVIER 000626058061626965 437 437
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 CERVELLERA SECH, JORDI 0000067000068 135 135
19 GELLIDA BELMONTE, RUBEN 5900073000000 132 132
20 PARIS BRETÓ, GUILLERMO 6000064000000 124 124
21 GOMEZ ROMEU, GERARD 0610630000000 124 124
22 SUBIRATS MARTÍN, JULIÀ 0560006500000 121 121
23 GIMENEZ CASANOVA, LLUIS 6157000000000 118 118
24 BAIGET FARRÉ, JAUME 5759000000000 116 116
25 SALES FERRE, LLORENÇ 0000000001150 115 115
26 MENDEZ PRUNERA, ALEX 1030000000000 103 103
27 PLA SEGURA, EDU 0010300000000 103 103
28 CARRERO DÍEZ, JAVI 0000000010300 103 103
29 IBAÑEZ BISMARCH, JUST 000000000093 93 93
30 MARTOS MARTI, JOAN 850000000000 85 85
31 FERRERES ESPINOSA, CARLOS 000000085000 85 85
32 MARSAL FIGUERES, TOMAS 000000790000 79 79
33 MARCO CASANOVA, PAULO 000079000000 79 79
34 SUÑER CARLES, PAU 079000000000 79 79
35 FERNÁNDEZ TOMÀS, JOAN LLUÍS 000007900000 79 79
36 SANZ CASTELL, RAUL 007900000000 79 79
37 RODRÍGUEZ SALVADÓ, GERARD 000000000079 79 79
38 REMOLINA RALLO, FERRAN 000075000000 75 75
39 DOMINGUEZ ARASA, ALBERT 075000000000 75 75
40 ALBIOL CHERTA, GERARD 000000000750 75 75
41 CURTO ARAGONÉS, MARC 730000000000 73 73
42 RENALES PRIETO, ALEJANDRO 710000000000 71 71
43 ARRUFAT SANCHEZ, ALEIX 000000071000 71 71
44 ROJAS ESTEVE, FRANCESC 000000000071 71 71
45 CID GUBAU, ORIOL 000710000000 71 71
46 RODA JIMENEZ, JOSEP 700000000000 70 70
47 RUIZ MONJO, IVAN 000007000000 70 70
48 ARRUFAT CID, IVAN 000000070000 70 70
49 FERRÉ, ARNAU CASACUBERTA FERRÉ 000700000000 70 70
50 BUENO GARCIA, FRAN 000000000070 70 70
51 SANCHEZ PALACIOS, RAUL 000000007000 70 70
52 MARIN MARIN, DANIEL 690000000000 69 69
53 GARGALLO ROYO, JOSE RAMÓN 069000000000 69 69
54 NOFRE ROMERA, PEDRO 006900000000 69 69
55 SEGARRA FARNÓS, SERGI 000690000000 69 69
56 OUVRARD, KEVIN 000000690000 69 69
57 GIMENEZ BELLOBI, JORDI 680000000000 68 68
58 PEREZ JIMENEZ, JORGE 000068000000 68 68
59 ESPUNY ROS, LLUC 000000068000 68 68
60 MONFORT BEL, ALBERT 068000000000 68 68
61 FORCADA MORESO, CARLOS 000000067000 67 67
62 VELASCO, YOANN 000000670000 67 67
63 GINE CARRASCO, JOSE 006600000000 66 66
64 GIRBES ESPUNY, LLUC 000000000066 66 66
65 SABATE SABATE, JAVIER 000000660000 66 66
66 CASAS LOPEZ, MIGUEL ANGEL 000000065000 65 65
67 LOPEZ MORENO, CRISTIAN 065000000000 65 65
68 PELEGRIN VALLS, JONATHAN 000000006500 65 65
69 SUBIRATS CID, XAVI 006500000000 65 65
70 PLA ALONSO, SERGI 640000000000 64 64
71 VALMAÑA CALBET, PAU 000640000000 64 64
72 FONOLLOSA AULADELL, XAVIER 000006400000 64 64
73 BERTOMEU GUIL, ORIOL 000000006400 64 64
74 DOMINGUEZ MARCH, OSCAR 063000000000 63 63
75 PRADES FERREIRA, MARC 000006300000 63 63
76 CASANOVA SERRAL, JORDI 000000006300 63 63
77 FERNANDEZ GARCIA, DANIEL 000000062000 62 62
78 BELLO SUBIRATS, HECTOR 000062000000 62 62
79 VIUDEZ, MARC VIUDEZ BRUNET 000006100000 61 61
80 CID CLUA, JAUME 000061000000 61 61
81 MARRO BELLOT, CRISTIAN 060000000000 60 60
82 GIMENO PUIGCERVER, MARC 000006000000 60 60
83 VILLARES MUÑIZ, MARTÍ-PAU 000005900000 59 59
84 MORILLO PORRAS, DAVID 000059000000 59 59
85 NEBOT FORCADELL, MICHAEL 058000000000 58 58
86 FERRE LOPEZ, CARLOS 580000000000 58 58
87 MULET AGUILÓ , GERARD VICENT 560000000000 56 56
88 VENTURA GILABERT, SERGI 550000000000 55 55




Amb el suport de: