Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.`content` AS content_1,
  t0_.lastTranslationUpdate AS lastTranslationUpdate_2,
  t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3,
  t0_.lastTranslationPageToken AS lastTranslationPageToken_4,
  t0_.firstTranslationUpdate AS firstTranslationUpdate_5
FROM
  `TranslationFile` t0_
ORDER BY
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-07-27 10:02:35' AND m0_.ending_date > '2025-07-27 10:02:35' AND m0_.is_completed = 0;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-07-27 10:02:36' AND m0_.ending_date > '2025-07-27 10:02:36' AND m0_.is_completed = 0;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.isActive = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.isActive = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tag AS tag_2,
  c0_.currency AS currency_3,
  c0_.currency_symbol AS currency_symbol_4,
  c0_.is_default AS is_default_5,
  c0_.`translations` AS translations_6,
  c0_.school_calendar_id AS school_calendar_id_7
FROM
  `Country` c0_
WHERE
  c0_.tag = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = 'US' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.tag = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.tag = 'en-CA';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.`translations` AS translations_2
FROM
  `StudiedLanguage` s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_ WHERE s0_.name = 'Anglais' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.color AS color_2,
  c0_.`translations` AS translations_3
FROM
  `Concept` c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.color AS color_2, c0_.`translations` AS translations_3 FROM `Concept` c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.`translations` AS translations_2
FROM
  `StudiedLanguage` s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_;

SELECT
  e0_.id AS id_0,
  e0_.display_name AS display_name_1,
  e0_.`translations` AS translations_2
FROM
  `EducationalPathway` e0_

SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 9;

SELECT
  t0_.id AS id_0,
  t0_.challenge_template_id AS challenge_template_id_1,
  t0_.educational_pathway_id AS educational_pathway_id_2
FROM
  `troub_ChallengeTemplateAssociation` t0_
WHERE
  t0_.educational_pathway_id = ?

SELECT t0_.id AS id_0, t0_.challenge_template_id AS challenge_template_id_1, t0_.educational_pathway_id AS educational_pathway_id_2 FROM `troub_ChallengeTemplateAssociation` t0_ WHERE t0_.educational_pathway_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id
WHERE
  troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_order AS display_order_3,
  t0.translations AS translations_4,
  t0.description AS description_5,
  t0.educational_pathway_id AS educational_pathway_id_6
FROM
  `GradeLevel` t0
WHERE
  t0.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.translations AS translations_4, t0.description AS description_5, t0.educational_pathway_id AS educational_pathway_id_6 FROM `GradeLevel` t0 WHERE t0.educational_pathway_id = 2;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 19;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 20;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 21;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 22;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 23;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id
WHERE
  troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id
WHERE
  troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id
WHERE
  troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 55;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id
WHERE
  troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 67;