Grasski.net - Travní lyžování

No valid database connection Unknown column 'abpoints' in 'order clause' SQL=SELECT @rid:=r.roostercode AS roostercode, CONCAT_WS(' ',r.surname,r.firstname) AS name, c.title AS country, (SELECT SUM(fiscuppoints) FROM jos_gs_results AS r LEFT JOIN jos_gs_competitions AS c ON r.competition_id=c.id WHERE rooster_id=@rid AND c.season=2010) AS apoints ,(SELECT SUM(fiscuppoints) FROM jos_gs_results AS r LEFT JOIN jos_gs_competitions AS c ON r.competition_id=c.id WHERE rooster_id=@rid AND c.disc_id=1 AND c.season=2010) AS slpoints ,(SELECT SUM(fiscuppoints) FROM jos_gs_results AS r LEFT JOIN jos_gs_competitions AS c ON r.competition_id=c.id WHERE rooster_id=@rid AND c.disc_id=2 AND c.season=2010) AS gspoints ,(SELECT SUM(fiscuppoints) FROM jos_gs_results AS r LEFT JOIN jos_gs_competitions AS c ON r.competition_id=c.id WHERE rooster_id=@rid AND c.disc_id=3 AND c.season=2010) AS sgpoints ,(SELECT SUM(fiscuppoints) FROM jos_gs_results AS r LEFT JOIN jos_gs_competitions AS c ON r.competition_id=c.id WHERE rooster_id=@rid AND c.disc_id=4 AND c.season=2010) AS scpoints FROM jos_gs_roosters AS r LEFT JOIN jos_gs_countries AS c ON r.country_id=c.id WHERE r.sex=0 ORDER BY abpoints DESC, r.surname, r.firstname

		Vše		SL		GS		SG		SC
Jméno	Stát	Pozice	Bodů	Pozice	Bodů	Pozice	Bodů	Pozice	Bodů	Pozice	Bodů