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 CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 SANCHO JOSE, VICTOR 859310310300 384 384
2 PELEGRIN SANCHEZ, JOAN CARLES 7979857900 322 322
3 ROFES BARCELO, JOSEP 930939300 279 279
4 HERNANDEZ RODRIGUEZ, CARLOS 1151030000 218 218
5 MIRO ANDREU, ANTONI 00115000 115 115
6 PALLARÉS MARTÍ, JOSEP 00011500 115 115
7 SANCHEZ MIRALLES, JUAN ANTONIO 01150000 115 115
8 ESPINOSA ZAVALETA, EDGAR RICARDO 10300000 103 103
9 DOORNBOS, ROY 0008500 85 85
10 FUMADO CASANOVA, JUAN JOSE 0850000 85 85
11 ARASA ARASA, JUAN JOSE 0079000 79 79
12 TOMÀS TORRES, ISMAEL 0075000 75 75
13 CID ESPUNY, JOSEP LLUIS 0007500 75 75
14 LUQUE CRESPILLO, FRANCISCO 0750000 75 75
15 ALIAU PONS, JOAN JOSEP 0730000 73 73




Amb el suport de:

comunicar incidències sobre les classificacions.
Recorda que per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.