CLASSIFICACIÓ 10K: MÀSTER-1 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="MA1 M" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 MIRO ANDREU , ANTONI 11511511511511510311500115115 1023 920
2 FERRË CANALS, TONI 09310310385937993115103103 970 806
3 PELEGRIN SANCHEZ, JOAN CARLES 7909393758573751037585 836 688
4 LANGE EBRI, ARTURO 7185797569707073937979 843 649
5 HERNANDEZ RODRIGUEZ, CARLOS 700707367696971857173 718 582
6 SANCHO JOSE, VICTOR 931030857907585000 520 520
7 CID ESPUNY, JOSEP LLUIS 85085073737100093 480 480
8 ARASA ARASA, JUAN JOSE 7507507071000071 362 362
9 TOMÀS TORRES, ISMAEL 0797306600700730 361 361
10 PONS URQUIZU, JOSE MARIA 00007175000930 239 239
11 FUMADO CASANOVA, JUAN JOSE 00079000790075 233 233
12 SOLE CRESPI, JOSEP 000010300115000 218 218
13 CHAVARRIA ARAGONES, JOAN 00710680069000 208 208
14 SABATER, JOSEP MARIA 00009301030000 196 196
15 ABRIL ESPAÑOL, JOAN 00000093103000 196 196
16 VELASCO, PASCAL 10300000850000 188 188
17 BROUGHTON, JIM 6973000000000 142 142
18 MILLAN MASDEU, JOAN IGNASI 6806900000000 137 137
19 FERNANDEZ GUIRADO, JOSE MANUEL 0000011500000 115 115
20 GONZALEZ REVERTER, RAMON 000000000850 85 85
21 PALLARÉS MARTÍ, JOSEP 000007900000 79 79
22 BENIKEN, KAMEL 075000000000 75 75
23 GARRIGA ALMO, FRANCISCO 730000000000 73 73
24 ALIAU PONS, JOAN JOSEP 000006800000 68 68




Amb el suport de: