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