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 1151151151151151031150000 793 793
2 FERRË CANALS, TONI 0931031038593790000 556 556
3 LANGE EBRI, ARTURO 718579756970700000 519 519
4 PELEGRIN SANCHEZ, JOAN CARLES 79093937585730000 498 498
5 SANCHO JOSE, VICTOR 93103085790750000 435 435
6 HERNANDEZ RODRIGUEZ, CARLOS 70070736769690000 418 418
7 CID ESPUNY, JOSEP LLUIS 8508507373710000 387 387
8 ARASA ARASA, JUAN JOSE 750750707100000 291 291
9 TOMÀS TORRES, ISMAEL 07973066000000 218 218
10 SABATER, JOSEP MARIA 00009301030000 196 196
11 VELASCO, PASCAL 10300000850000 188 188
12 PONS URQUIZU, JOSE MARIA 0000717500000 146 146
13 BROUGHTON, JIM 6973000000000 142 142
14 CHAVARRIA ARAGONES, JOAN 0071068000000 139 139
15 MILLAN MASDEU, JOAN IGNASI 6806900000000 137 137
16 FERNANDEZ GUIRADO, JOSE MANUEL 0000011500000 115 115
17 SOLE CRESPI, JOSEP 0000103000000 103 103
18 ABRIL ESPAÑOL, JOAN 000000930000 93 93
19 PALLARÉS MARTÍ, JOSEP 000007900000 79 79
20 FUMADO CASANOVA, JUAN JOSE 000790000000 79 79
21 BENIKEN, KAMEL 075000000000 75 75
22 GARRIGA ALMO, FRANCISCO 730000000000 73 73
23 ALIAU PONS, JOAN JOSEP 000006800000 68 68




Amb el suport de: