Error 194: Table 'hockeycanada.seasons_trans' doesn't exist
SQL: SELECT ps.*, st.season_name, st.shortname as short_season_name, seasons.career, seasons.start_date as seasonstartdate, ttrans.name as teamName
FROM player_stats as ps, seasons, teams, teams_trans ttrans, teams_players tp, seasons_trans st
WHERE ps.player_id=8678
AND ps.season_id=seasons.id
AND ps.team_id=teams.id
AND tp.team_id=ps.team_id and tp.player_id=ps.player_id and tp.season_id=ps.season_id
AND seasons.league_id = '2'
AND seasons.playoff='0'
AND seasons.career='1'
AND ttrans.lang_id='1' AND ttrans.team_id=teams.id AND ttrans.season_id=seasons.id
AND st.lang_id='1' AND st.season_id=seasons.id
group by ps.season_id,ps.team_id
ORDER BY seasons.start_date desc, tp.start_date desc
