|
Query:
select tts.season, tg.name as tg_name, tgs1.name as tgs_name,
tts.place, tgsp.games, tgsp.won, tgsp.drew, tgsp.lost,
tgsp.goals, tgsp.conceded, tst1.has_tables, t.id as t_id,
tgs1.id as tgs_id
from team_tour_statistics tts, tournament_gr_st_participants tgsp,
teams tm, tournament_groups tg, tournament_stages tst,
tournament_groups_stages tgs, tournament_groups_stages tgs1,
tournaments t, tournament_stages tst1
where tts.team = '1496' and tm.id = tts.team
and tgsp.team = tts.team and tg.tournament = t.id
and tgs1.stage = tts.highest_stage and tgs1.id = tgsp.gr_st
and tgs1.group = tg.id and tgs.stage = tst.id and tgs.group = tg.id
and tgs1.stage = tst1.id and tts.season = tgs1.season
and tts.season = tgsp.season and tts.season = tg.season
and tts.season = tst.season and tts.season = tgs.season
group by t.id, /*tgs.group,*/ tgs.season
order by tts.season, t.id
error: Unknown column 'tgs1.season' in 'where clause' |
