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 115115115115115103115001150 908 908
2 FERRË CANALS, TONI 093103103859379931151030 867 788
3 PELEGRIN SANCHEZ, JOAN CARLES 790939375857375103750 751 678
4 LANGE EBRI, ARTURO 718579756970707393790 764 625
5 HERNANDEZ RODRIGUEZ, CARLOS 70070736769697185710 645 578
6 SANCHO JOSE, VICTOR 931030857907585000 520 520
7 CID ESPUNY, JOSEP LLUIS 8508507373710000 387 387
8 TOMÀS TORRES, ISMAEL 0797306600700730 361 361
9 ARASA ARASA, JUAN JOSE 750750707100000 291 291
10 PONS URQUIZU, JOSE MARIA 00007175000930 239 239
11 SOLE CRESPI, JOSEP 000010300115000 218 218
12 CHAVARRIA ARAGONES, JOAN 00710680069000 208 208
13 SABATER, JOSEP MARIA 00009301030000 196 196
14 ABRIL ESPAÑOL, JOAN 00000093103000 196 196
15 VELASCO, PASCAL 10300000850000 188 188
16 FUMADO CASANOVA, JUAN JOSE 0007900079000 158 158
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: