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