public static Competition getCompetitionById(int competitionId)
        {
            Dictionary<string, object> result = querySingleSql(""
                + "SELECT "
                    + "* "
                + "FROM "
                    + "`" + tableName + "` "
                + "WHERE "
                    + "`" + field_competitionId + "` = " + competitionId
            );

            if (result == null)
            {
                return null;
            }

            Competition competition = new Competition(
                Convert.ToInt32(result[field_competitionId]),
                Convert.ToString(result[field_competitionName])
            );

            foreach (DisciplineSet disciplineSet in DisciplineSetProvider.getDisciplineSetsByCompetition(competition))
            {
                competition.addDisciplineSet(disciplineSet);
            }

            return competition;
        }