SELECT scores.score, disciplines.discipline, disciplines.discipline_id, competitors.competitor_id, competitors.name, competitors.country, competitions.competition_id, competitions.title, name_user_level.level AS disc_level FROM scores JOIN disciplines ON disciplines.discipline_id = scores.discipline_id LEFT OUTER JOIN competitors ON competitors.competitor_id = scores.competitor_id JOIN competitions ON competitions.competition_id = scores.competition_id JOIN name_user_level ON name_user_level.competitor_id = competitors.competitor_id AND disciplines.discipline_id = name_user_level.discipline_id WHERE scores.discipline_id = :discipline_id AND competitions.rankable = 'Y' AND competitors.country = :country ORDER BY scores.score DESC
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'iam_stats1.scores' doesn't exist