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