Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.diameter AS diameter_3,
  t0.face_number AS face_number_4,
  t0.state AS state_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.rulebook_id AS rulebook_id_10
FROM
  target_face t0
  INNER JOIN bafa_target_face ON t0.id = bafa_target_face.target_face_id
WHERE
  bafa_target_face.bafa_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.diameter AS diameter_3, t0.face_number AS face_number_4, t0.state AS state_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.rulebook_id AS rulebook_id_10 FROM target_face t0 INNER JOIN bafa_target_face ON t0.id = bafa_target_face.target_face_id WHERE bafa_target_face.bafa_id = 2;

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.round_number AS round_number_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.state AS state_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.age_class_id AS age_class_id_12,
  t0.division_id AS division_id_13,
  t0.tournament_format_id AS tournament_format_id_14,
  t0.rulebook_id AS rulebook_id_15
FROM
  bafa t0
  INNER JOIN bafa_target_face ON t0.id = bafa_target_face.bafa_id
WHERE
  bafa_target_face.target_face_id = ?

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.round_number AS round_number_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.state AS state_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.age_class_id AS age_class_id_12, t0.division_id AS division_id_13, t0.tournament_format_id AS tournament_format_id_14, t0.rulebook_id AS rulebook_id_15 FROM bafa t0 INNER JOIN bafa_target_face ON t0.id = bafa_target_face.bafa_id WHERE bafa_target_face.target_face_id = 2;

SELECT
  t0.id AS id_1,
  t0.fee AS fee_2,
  t0.currency AS currency_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.age_class_id AS age_class_id_8,
  t0.tournament_id AS tournament_id_9
FROM
  tournament_age_class t0
WHERE
  t0.age_class_id = ?

SELECT t0.id AS id_1, t0.fee AS fee_2, t0.currency AS currency_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.age_class_id AS age_class_id_8, t0.tournament_id AS tournament_id_9 FROM tournament_age_class t0 WHERE t0.age_class_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.registration_start_at AS registration_start_at_5,
  t0.registration_end_at AS registration_end_at_6,
  t0.ianseo_link AS ianseo_link_7,
  t0.description AS description_8,
  t0.url AS url_9,
  t0.state AS state_10,
  t0.token AS token_11,
  t0.slug AS slug_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.tournament_category_id AS tournament_category_id_17,
  t0.tournament_format_id AS tournament_format_id_18,
  t0.place_id AS place_id_19,
  t0.user_organizer_id AS user_organizer_id_20,
  t0.club_organizer_id AS club_organizer_id_21,
  t0.rule_book_id AS rule_book_id_22,
  t0.banner_file_id AS banner_file_id_23
FROM
  tournament t0
WHERE
  t0.tournament_format_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.registration_start_at AS registration_start_at_5, t0.registration_end_at AS registration_end_at_6, t0.ianseo_link AS ianseo_link_7, t0.description AS description_8, t0.url AS url_9, t0.state AS state_10, t0.token AS token_11, t0.slug AS slug_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.tournament_category_id AS tournament_category_id_17, t0.tournament_format_id AS tournament_format_id_18, t0.place_id AS place_id_19, t0.user_organizer_id AS user_organizer_id_20, t0.club_organizer_id AS club_organizer_id_21, t0.rule_book_id AS rule_book_id_22, t0.banner_file_id AS banner_file_id_23 FROM tournament t0 WHERE t0.tournament_format_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.registration_start_at AS registration_start_at_5,
  t0.registration_end_at AS registration_end_at_6,
  t0.ianseo_link AS ianseo_link_7,
  t0.description AS description_8,
  t0.url AS url_9,
  t0.state AS state_10,
  t0.token AS token_11,
  t0.slug AS slug_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.tournament_category_id AS tournament_category_id_17,
  t0.tournament_format_id AS tournament_format_id_18,
  t0.place_id AS place_id_19,
  t0.user_organizer_id AS user_organizer_id_20,
  t0.club_organizer_id AS club_organizer_id_21,
  t0.rule_book_id AS rule_book_id_22,
  t0.banner_file_id AS banner_file_id_23
FROM
  tournament t0
  INNER JOIN tournament_division ON t0.id = tournament_division.tournament_id
WHERE
  tournament_division.division_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.registration_start_at AS registration_start_at_5, t0.registration_end_at AS registration_end_at_6, t0.ianseo_link AS ianseo_link_7, t0.description AS description_8, t0.url AS url_9, t0.state AS state_10, t0.token AS token_11, t0.slug AS slug_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.tournament_category_id AS tournament_category_id_17, t0.tournament_format_id AS tournament_format_id_18, t0.place_id AS place_id_19, t0.user_organizer_id AS user_organizer_id_20, t0.club_organizer_id AS club_organizer_id_21, t0.rule_book_id AS rule_book_id_22, t0.banner_file_id AS banner_file_id_23 FROM tournament t0 INNER JOIN tournament_division ON t0.id = tournament_division.tournament_id WHERE tournament_division.division_id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.referee_label AS referee_label_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  rule_book t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.referee_label AS referee_label_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM rule_book t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.state AS state_4,
  t0.round_count_max AS round_count_max_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.rule_book_id AS rule_book_id_10
FROM
  tournament_format t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.state AS state_4, t0.round_count_max AS round_count_max_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.rule_book_id AS rule_book_id_10 FROM tournament_format t0 WHERE t0.rule_book_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.ranking_tournament_count AS ranking_tournament_count_5,
  t0.rule_book_id AS rule_book_id_6
FROM
  season t0
  INNER JOIN season_tournament_format ON t0.id = season_tournament_format.season_id
WHERE
  season_tournament_format.tournament_format_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.ranking_tournament_count AS ranking_tournament_count_5, t0.rule_book_id AS rule_book_id_6 FROM season t0 INNER JOIN season_tournament_format ON t0.id = season_tournament_format.season_id WHERE season_tournament_format.tournament_format_id = 19;

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.round_number AS round_number_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.state AS state_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.age_class_id AS age_class_id_12,
  t0.division_id AS division_id_13,
  t0.tournament_format_id AS tournament_format_id_14,
  t0.rulebook_id AS rulebook_id_15
FROM
  bafa t0
WHERE
  t0.tournament_format_id = ?

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.round_number AS round_number_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.state AS state_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.age_class_id AS age_class_id_12, t0.division_id AS division_id_13, t0.tournament_format_id AS tournament_format_id_14, t0.rulebook_id AS rulebook_id_15 FROM bafa t0 WHERE t0.tournament_format_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gender AS gender_3,
  t0.state AS state_4,
  t0.age_min AS age_min_5,
  t0.age_max AS age_max_6,
  t0.abbreviation AS abbreviation_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rule_book_id AS rule_book_id_12
FROM
  age_class t0
  INNER JOIN age_class_age_class ON t0.id = age_class_age_class.age_class_source
WHERE
  age_class_age_class.age_class_target = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.state AS state_4, t0.age_min AS age_min_5, t0.age_max AS age_max_6, t0.abbreviation AS abbreviation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rule_book_id AS rule_book_id_12 FROM age_class t0 INNER JOIN age_class_age_class ON t0.id = age_class_age_class.age_class_source WHERE age_class_age_class.age_class_target = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gender AS gender_3,
  t0.state AS state_4,
  t0.age_min AS age_min_5,
  t0.age_max AS age_max_6,
  t0.abbreviation AS abbreviation_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rule_book_id AS rule_book_id_12
FROM
  age_class t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.age_min ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.state AS state_4, t0.age_min AS age_min_5, t0.age_max AS age_max_6, t0.abbreviation AS abbreviation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rule_book_id AS rule_book_id_12 FROM age_class t0 WHERE t0.rule_book_id = 1 ORDER BY t0.age_min ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_public AS is_public_3,
  t0.token AS token_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.division_id AS division_id_10,
  t0.tournament_session_id AS tournament_session_id_11
FROM
  team t0
WHERE
  t0.division_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.token AS token_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.division_id AS division_id_10, t0.tournament_session_id AS tournament_session_id_11 FROM team t0 WHERE t0.division_id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gender AS gender_3,
  t0.state AS state_4,
  t0.age_min AS age_min_5,
  t0.age_max AS age_max_6,
  t0.abbreviation AS abbreviation_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rule_book_id AS rule_book_id_12
FROM
  age_class t0
  INNER JOIN age_class_age_class ON t0.id = age_class_age_class.age_class_target
WHERE
  age_class_age_class.age_class_source = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.state AS state_4, t0.age_min AS age_min_5, t0.age_max AS age_max_6, t0.abbreviation AS abbreviation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rule_book_id AS rule_book_id_12 FROM age_class t0 INNER JOIN age_class_age_class ON t0.id = age_class_age_class.age_class_target WHERE age_class_age_class.age_class_source = 31;

SELECT
  t0.id AS id_1,
  t0.state AS state_2,
  t0.result AS result_3,
  t0.is_guest AS is_guest_4,
  t0.correspondence_language AS correspondence_language_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.phone AS phone_9,
  t0.address AS address_10,
  t0.zip AS zip_11,
  t0.city AS city_12,
  t0.birth_date AS birth_date_13,
  t0.license_number AS license_number_14,
  t0.country AS country_15,
  t0.token AS token_16,
  t0.club_name AS club_name_17,
  t0.is_wheelchair_user AS is_wheelchair_user_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.created_by AS created_by_21,
  t0.updated_by AS updated_by_22,
  t0.user_id AS user_id_23,
  t0.tournament_session_id AS tournament_session_id_24,
  t0.division_id AS division_id_25,
  t0.tournament_age_class_id AS tournament_age_class_id_26,
  t0.team_id AS team_id_27,
  t0.target_face_id AS target_face_id_28
FROM
  session_registration t0
WHERE
  t0.division_id = ?

SELECT t0.id AS id_1, t0.state AS state_2, t0.result AS result_3, t0.is_guest AS is_guest_4, t0.correspondence_language AS correspondence_language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.phone AS phone_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.birth_date AS birth_date_13, t0.license_number AS license_number_14, t0.country AS country_15, t0.token AS token_16, t0.club_name AS club_name_17, t0.is_wheelchair_user AS is_wheelchair_user_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.user_id AS user_id_23, t0.tournament_session_id AS tournament_session_id_24, t0.division_id AS division_id_25, t0.tournament_age_class_id AS tournament_age_class_id_26, t0.team_id AS team_id_27, t0.target_face_id AS target_face_id_28 FROM session_registration t0 WHERE t0.division_id = 20;

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.round_number AS round_number_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.state AS state_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.age_class_id AS age_class_id_12,
  t0.division_id AS division_id_13,
  t0.tournament_format_id AS tournament_format_id_14,
  t0.rulebook_id AS rulebook_id_15
FROM
  bafa t0
WHERE
  t0.age_class_id = ?

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.round_number AS round_number_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.state AS state_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.age_class_id AS age_class_id_12, t0.division_id AS division_id_13, t0.tournament_format_id AS tournament_format_id_14, t0.rulebook_id AS rulebook_id_15 FROM bafa t0 WHERE t0.age_class_id = 31;

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.round_number AS round_number_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.state AS state_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.age_class_id AS age_class_id_12,
  t0.division_id AS division_id_13,
  t0.tournament_format_id AS tournament_format_id_14,
  t0.rulebook_id AS rulebook_id_15
FROM
  bafa t0
WHERE
  t0.rulebook_id = ?

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.round_number AS round_number_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.state AS state_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.age_class_id AS age_class_id_12, t0.division_id AS division_id_13, t0.tournament_format_id AS tournament_format_id_14, t0.rulebook_id AS rulebook_id_15 FROM bafa t0 WHERE t0.rulebook_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.state AS state_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.rule_book_id AS rule_book_id_9
FROM
  division t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.state AS state_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.rule_book_id AS rule_book_id_9 FROM division t0 WHERE t0.rule_book_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.valid_from AS valid_from_2,
  t0.valid_to AS valid_to_3,
  t0.round_number AS round_number_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.state AS state_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.age_class_id AS age_class_id_12,
  t0.division_id AS division_id_13,
  t0.tournament_format_id AS tournament_format_id_14,
  t0.rulebook_id AS rulebook_id_15
FROM
  bafa t0
WHERE
  t0.division_id = ?

SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_to AS valid_to_3, t0.round_number AS round_number_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.state AS state_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.age_class_id AS age_class_id_12, t0.division_id AS division_id_13, t0.tournament_format_id AS tournament_format_id_14, t0.rulebook_id AS rulebook_id_15 FROM bafa t0 WHERE t0.division_id = 20;

SELECT
  t0.id AS id_1,
  t0.record_date AS record_date_2,
  t0.result AS result_3,
  t0.status AS status_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.result_max AS result_max_7,
  t0.record_category AS record_category_8,
  t0.tournament_session_category AS tournament_session_category_9,
  t0.tournament_name AS tournament_name_10,
  t0.club_organizer AS club_organizer_11,
  t0.external_link AS external_link_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.next_record_id AS next_record_id_17,
  t0.age_class_id AS age_class_id_18,
  t0.division_id AS division_id_19,
  t0.target_face_id AS target_face_id_20,
  t0.tournament_format_id AS tournament_format_id_21
FROM
  record t0
WHERE
  t0.division_id = ?

SELECT t0.id AS id_1, t0.record_date AS record_date_2, t0.result AS result_3, t0.status AS status_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.result_max AS result_max_7, t0.record_category AS record_category_8, t0.tournament_session_category AS tournament_session_category_9, t0.tournament_name AS tournament_name_10, t0.club_organizer AS club_organizer_11, t0.external_link AS external_link_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.next_record_id AS next_record_id_17, t0.age_class_id AS age_class_id_18, t0.division_id AS division_id_19, t0.target_face_id AS target_face_id_20, t0.tournament_format_id AS tournament_format_id_21 FROM record t0 WHERE t0.division_id = 20;

SELECT
  t0.id AS id_1,
  t0.record_date AS record_date_2,
  t0.result AS result_3,
  t0.status AS status_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.result_max AS result_max_7,
  t0.record_category AS record_category_8,
  t0.tournament_session_category AS tournament_session_category_9,
  t0.tournament_name AS tournament_name_10,
  t0.club_organizer AS club_organizer_11,
  t0.external_link AS external_link_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.next_record_id AS next_record_id_17,
  t0.age_class_id AS age_class_id_18,
  t0.division_id AS division_id_19,
  t0.target_face_id AS target_face_id_20,
  t0.tournament_format_id AS tournament_format_id_21
FROM
  record t0
WHERE
  t0.tournament_format_id = ?

SELECT t0.id AS id_1, t0.record_date AS record_date_2, t0.result AS result_3, t0.status AS status_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.result_max AS result_max_7, t0.record_category AS record_category_8, t0.tournament_session_category AS tournament_session_category_9, t0.tournament_name AS tournament_name_10, t0.club_organizer AS club_organizer_11, t0.external_link AS external_link_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.next_record_id AS next_record_id_17, t0.age_class_id AS age_class_id_18, t0.division_id AS division_id_19, t0.target_face_id AS target_face_id_20, t0.tournament_format_id AS tournament_format_id_21 FROM record t0 WHERE t0.tournament_format_id = 21;

SELECT
  t0.id AS id_1,
  t0.state AS state_2,
  t0.result AS result_3,
  t0.is_guest AS is_guest_4,
  t0.correspondence_language AS correspondence_language_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.phone AS phone_9,
  t0.address AS address_10,
  t0.zip AS zip_11,
  t0.city AS city_12,
  t0.birth_date AS birth_date_13,
  t0.license_number AS license_number_14,
  t0.country AS country_15,
  t0.token AS token_16,
  t0.club_name AS club_name_17,
  t0.is_wheelchair_user AS is_wheelchair_user_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.created_by AS created_by_21,
  t0.updated_by AS updated_by_22,
  t0.user_id AS user_id_23,
  t0.tournament_session_id AS tournament_session_id_24,
  t0.division_id AS division_id_25,
  t0.tournament_age_class_id AS tournament_age_class_id_26,
  t0.team_id AS team_id_27,
  t0.target_face_id AS target_face_id_28
FROM
  session_registration t0
WHERE
  t0.target_face_id = ?

SELECT t0.id AS id_1, t0.state AS state_2, t0.result AS result_3, t0.is_guest AS is_guest_4, t0.correspondence_language AS correspondence_language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.phone AS phone_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.birth_date AS birth_date_13, t0.license_number AS license_number_14, t0.country AS country_15, t0.token AS token_16, t0.club_name AS club_name_17, t0.is_wheelchair_user AS is_wheelchair_user_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.user_id AS user_id_23, t0.tournament_session_id AS tournament_session_id_24, t0.division_id AS division_id_25, t0.tournament_age_class_id AS tournament_age_class_id_26, t0.team_id AS team_id_27, t0.target_face_id AS target_face_id_28 FROM session_registration t0 WHERE t0.target_face_id = 17;

SELECT
  t0.id AS id_1,
  t0.record_date AS record_date_2,
  t0.result AS result_3,
  t0.status AS status_4,
  t0.distance AS distance_5,
  t0.arrow_count AS arrow_count_6,
  t0.result_max AS result_max_7,
  t0.record_category AS record_category_8,
  t0.tournament_session_category AS tournament_session_category_9,
  t0.tournament_name AS tournament_name_10,
  t0.club_organizer AS club_organizer_11,
  t0.external_link AS external_link_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.next_record_id AS next_record_id_17,
  t0.age_class_id AS age_class_id_18,
  t0.division_id AS division_id_19,
  t0.target_face_id AS target_face_id_20,
  t0.tournament_format_id AS tournament_format_id_21
FROM
  record t0
WHERE
  t0.age_class_id = ?

SELECT t0.id AS id_1, t0.record_date AS record_date_2, t0.result AS result_3, t0.status AS status_4, t0.distance AS distance_5, t0.arrow_count AS arrow_count_6, t0.result_max AS result_max_7, t0.record_category AS record_category_8, t0.tournament_session_category AS tournament_session_category_9, t0.tournament_name AS tournament_name_10, t0.club_organizer AS club_organizer_11, t0.external_link AS external_link_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.next_record_id AS next_record_id_17, t0.age_class_id AS age_class_id_18, t0.division_id AS division_id_19, t0.target_face_id AS target_face_id_20, t0.tournament_format_id AS tournament_format_id_21 FROM record t0 WHERE t0.age_class_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.ranking_tournament_count AS ranking_tournament_count_5,
  t0.rule_book_id AS rule_book_id_6
FROM
  season t0
WHERE
  t0.rule_book_id = ?