SELECT DISTINCT competitors.name, competitors.competitor_id, competitors.country, competitions.title AS competition_title, competitions.start_date, competitions.end_date, competitions.competition_id FROM scores JOIN competitors ON competitors.competitor_id = scores.competitor_id LEFT OUTER JOIN countries ON competitors.country = countries.country JOIN competitions ON competitions.competition_id = :competition_id WHERE competitors.competitor_id = :competitor_id
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'iam_stats1.scores' doesn't exist