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
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Country IAM ID Competitions



* An IAM level in bold indicates that this discipline is one of the best 10 used for the competitor's IAM Level calculation.