SELECT * FROM competitors ORDER BY name ASC
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.competitors' doesn't existSELECT competitors.name, competitors.competitor_id, discipline_id, score, NULL AS _time
FROM competitors
JOIN _best_scores ON competitors.competitor_id = _best_scores.competitor_id
WHERE competitors.competitor_id = :competitor_id
UNION
SELECT competitors.name, competitors.competitor_id, discipline_id, score, _time
FROM competitors
JOIN _best_scores_ml ON competitors.competitor_id = _best_scores_ml.competitor_id
WHERE competitors.competitor_id = :competitor_id
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db139224x3593297.competitors' doesn't exist
| I | N | T | E | R | N | A | T | I | O | N | A | L | A | S | S | O | C | I | A | T | I | O | N | M | E | M | O | R | Y |
| Discipline |
Explanation
Your IAM level is a reflection of your achievements across all 22 IAM and ML disciplines.
It is calculated by averaging your 10 highest discipline levels.
Additional notes:
- To ensure balance, your best 10 must include at least one discipline (and a maximum of four) from each of the 5 categories: Numbers (inc. Binary), Cards, Names, Words and Other.
- If you have fewer than 10 discipline scores, they are averaged.