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 931031151151151031150000 759 759
2 GOMBAU MURRIA, ELISEU 677175757073750000 506 506
3 SALES FERRE, ENRIC 7993010310301030000 481 481
4 GAIC, ROBERT DAVID 636668666366680000 460 460
5 BERTOMEU CURTO, JOEL 626271656562700000 457 457
6 COLOMINES CUADRAD, JAUME 0858509393850000 441 441
7 GAUXACHS FONT, DAVID 6570079716900000 354 354
8 OUHDADI, YASSINE 11511500011500000 345 345
9 LLORCA PINTOR, FCO. JAVIER 0646768660710000 336 336
10 REVELLES PI, ADRIÀ 000736968730000 283 283
11 CURTO BAIGES, ALBERT 067706767000000 271 271
12 FRANCO SMEETS, CLAUDIO 00008585930000 263 263
13 PELLICER MARTINEZ, DANI 66008507100000 222 222
14 SABATE SABATE, JAVIER 00062605800000 180 180
15 TRESO MASCARELL, MARC 7509300000000 168 168
16 CASTELLS SEGARRA, ANTONI 0073930000000 166 166
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 MENDEZ PRUNERA, ALEX 1030000000000 103 103
25 PLA SEGURA, EDU 0010300000000 103 103
26 MARTOS MARTI, JOAN 850000000000 85 85
27 MARSAL FIGUERES, TOMAS 000000790000 79 79
28 MARCO CASANOVA, PAULO 000079000000 79 79
29 SUÑER CARLES, PAU 079000000000 79 79
30 FERNÁNDEZ TOMÀS, JOAN LLUÍS 000007900000 79 79
31 SANZ CASTELL, RAUL 007900000000 79 79
32 REMOLINA RALLO, FERRAN 000075000000 75 75
33 DOMINGUEZ ARASA, ALBERT 075000000000 75 75
34 CURTO ARAGONÉS, MARC 730000000000 73 73
35 RENALES PRIETO, ALEJANDRO 710000000000 71 71
36 CID GUBAU, ORIOL 000710000000 71 71
37 RODA JIMENEZ, JOSEP 700000000000 70 70
38 RUIZ MONJO, IVAN 000007000000 70 70
39 FERRÉ, ARNAU CASACUBERTA FERRÉ 000700000000 70 70
40 MARIN MARIN, DANIEL 690000000000 69 69
41 GARGALLO ROYO, JOSE RAMÓN 069000000000 69 69
42 NOFRE ROMERA, PEDRO 006900000000 69 69
43 SEGARRA FARNÓS, SERGI 000690000000 69 69
44 OUVRARD, KEVIN 000000690000 69 69
45 GIMENEZ BELLOBI, JORDI 680000000000 68 68
46 PEREZ JIMENEZ, JORGE 000068000000 68 68
47 MONFORT BEL, ALBERT 068000000000 68 68
48 CERVELLERA SECH, JORDI 000006700000 67 67
49 VELASCO, YOANN 000000670000 67 67
50 GINE CARRASCO, JOSE 006600000000 66 66
51 SABATE SABATE, JAVIER 000000660000 66 66
52 LOPEZ MORENO, CRISTIAN 065000000000 65 65
53 SUBIRATS CID, XAVI 006500000000 65 65
54 PLA ALONSO, SERGI 640000000000 64 64
55 VALMAÑA CALBET, PAU 000640000000 64 64
56 FONOLLOSA AULADELL, XAVIER 000006400000 64 64
57 DOMINGUEZ MARCH, OSCAR 063000000000 63 63
58 PRADES FERREIRA, MARC 000006300000 63 63
59 BELLO SUBIRATS, HECTOR 000062000000 62 62
60 VIUDEZ, MARC VIUDEZ BRUNET 000006100000 61 61
61 CID CLUA, JAUME 000061000000 61 61
62 MARRO BELLOT, CRISTIAN 060000000000 60 60
63 GIMENO PUIGCERVER, MARC 000006000000 60 60
64 VILLARES MUÑIZ, MARTÍ-PAU 000005900000 59 59
65 MORILLO PORRAS, DAVID 000059000000 59 59
66 NEBOT FORCADELL, MICHAEL 058000000000 58 58
67 FERRE LOPEZ, CARLOS 580000000000 58 58
68 MULET AGUILÓ , GERARD VICENT 560000000000 56 56
69 VENTURA GILABERT, SERGI 550000000000 55 55




Amb el suport de: