SELECT competitors.name, numcomps, competitors.country, countries.flag_code,iam_title.title as iam_title,iam_title.star, competitors.competitor_id, _active_world_ranking.rank AS competitor_rank, _best_scores.score, _best_scores.rank AS score_rank, disciplines.discipline_id, disciplines.discipline, competitions.title, competitions.competition_id, feature_scores.current_national_record, iam_level.level AS iam_level, name_user_level.level AS disc_level, name_user_level.inclusion FROM competitors JOIN num_comps on competitors.competitor_id=num_comps.competitor_id JOIN countries on competitors.country=countries.country LEFT JOIN iam_title on competitors.competitor_id=iam_title.competitor_id JOIN _best_scores ON competitors.competitor_id = _best_scores.competitor_id LEFT OUTER JOIN _active_world_ranking ON _active_world_ranking.competitor_id = competitors.competitor_id JOIN competitions ON _best_scores.competition_id = competitions.competition_id JOIN disciplines ON disciplines.discipline_id = _best_scores.discipline_id LEFT OUTER JOIN iam_level ON iam_level.competitor_id = competitors.competitor_id JOIN name_user_level ON name_user_level.competitor_id = competitors.competitor_id AND disciplines.discipline_id = name_user_level.discipline_id LEFT OUTER JOIN feature_scores ON competitors.competitor_id = feature_scores.competitor_id AND feature_scores.discipline_id = _best_scores.discipline_id AND feature_scores.current_national_record = 1 and competitions.competition_id=feature_scores.competition_id WHERE competitors.competitor_id = :competitor_id AND disciplines.active = 'Y'
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.competitors' doesn't exist
SELECT competitors.name, competitions.start_date, competitors.country, competitions.title, competitions.competition_id, _competition_rankings.rank FROM competitors JOIN _competition_rankings ON competitors.competitor_id = _competition_rankings.competitor_id JOIN competitions ON _competition_rankings.competition_id = competitions.competition_id WHERE competitors.competitor_id = :competitor_id ORDER BY start_date DESC
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.competitors' doesn't exist