SELECT DISTINCT competitors.name, competitors.competitor_id, competitors.country, countries.continent, competitions.title AS competition_title, competitions.start_date, competitions.end_date, competitions.country AS competition_country, competitions.championship_status, totals.total, _ranking_totals.ranking_total
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
JOIN totals ON totals.competitor_id = scores.competitor_id and totals.competition_id = :competition_id
JOIN _ranking_totals ON _ranking_totals.competitor_id = scores.competitor_id
WHERE totals.competition_id = :competition_id AND _ranking_totals.competition_id = :competition_id
ORDER BY totals.total DESC
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.scores' doesn't exist
SELECT feature_scores.country,score, personal_best, world_record,national_record, feature_scores.competition_id, competition_disciplines.discipline_id, competition_disciplines.seq_num, disciplines.discipline, feature_scores.competitor_id, feature_scores.discipline_id, competitors.name
FROM feature_scores
JOIN competitors ON competitors.competitor_id = feature_scores.competitor_id
JOIN competition_disciplines ON competition_disciplines.discipline_id = feature_scores.discipline_id
JOIN disciplines ON disciplines.discipline_id = competition_disciplines.discipline_id
WHERE feature_scores.competition_id = :competition_id AND competition_disciplines.competition_id = feature_scores.competition_id
ORDER BY competition_disciplines.seq_num, score DESC
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.feature_scores' doesn't exist
–
Overall standings