Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.state AS state_1,
  s0_.result AS result_2,
  s0_.is_guest AS is_guest_3,
  s0_.correspondence_language AS correspondence_language_4,
  s0_.first_name AS first_name_5,
  s0_.last_name AS last_name_6,
  s0_.email AS email_7,
  s0_.phone AS phone_8,
  s0_.address AS address_9,
  s0_.zip AS zip_10,
  s0_.city AS city_11,
  s0_.birth_date AS birth_date_12,
  s0_.license_number AS license_number_13,
  s0_.country AS country_14,
  s0_.token AS token_15,
  s0_.club_name AS club_name_16,
  s0_.is_wheelchair_user AS is_wheelchair_user_17,
  s0_.created_at AS created_at_18,
  s0_.updated_at AS updated_at_19,
  s0_.created_by AS created_by_20,
  s0_.updated_by AS updated_by_21,
  s0_.id AS id_22,
  s0_.state AS state_23,
  s0_.result AS result_24,
  s0_.is_guest AS is_guest_25,
  s0_.correspondence_language AS correspondence_language_26,
  s0_.first_name AS first_name_27,
  s0_.last_name AS last_name_28,
  s0_.email AS email_29,
  s0_.phone AS phone_30,
  s0_.address AS address_31,
  s0_.zip AS zip_32,
  s0_.city AS city_33,
  s0_.birth_date AS birth_date_34,
  s0_.license_number AS license_number_35,
  s0_.country AS country_36,
  s0_.token AS token_37,
  s0_.club_name AS club_name_38,
  s0_.is_wheelchair_user AS is_wheelchair_user_39,
  s0_.created_at AS created_at_40,
  s0_.updated_at AS updated_at_41,
  s0_.created_by AS created_by_42,
  s0_.updated_by AS updated_by_43,
  t1_.id AS id_44,
  t1_.fee AS fee_45,
  t1_.currency AS currency_46,
  t1_.created_at AS created_at_47,
  t1_.updated_at AS updated_at_48,
  t1_.created_by AS created_by_49,
  t1_.updated_by AS updated_by_50,
  t2_.id AS id_51,
  t2_.name AS name_52,
  t2_.register_start_at AS register_start_at_53,
  t2_.register_end_at AS register_end_at_54,
  t2_.inspection_start_at AS inspection_start_at_55,
  t2_.training_start_at AS training_start_at_56,
  t2_.shooting_start_at AS shooting_start_at_57,
  t2_.max_competitors AS max_competitors_58,
  t2_.is_final AS is_final_59,
  t2_.session_category AS session_category_60,
  t2_.is_inter_club AS is_inter_club_61,
  t2_.is_inter_gender AS is_inter_gender_62,
  t2_.team_members_number AS team_members_number_63,
  t2_.created_at AS created_at_64,
  t2_.updated_at AS updated_at_65,
  t2_.created_by AS created_by_66,
  t2_.updated_by AS updated_by_67,
  t3_.id AS id_68,
  t3_.name AS name_69,
  t3_.start_at AS start_at_70,
  t3_.end_at AS end_at_71,
  t3_.registration_start_at AS registration_start_at_72,
  t3_.registration_end_at AS registration_end_at_73,
  t3_.ianseo_link AS ianseo_link_74,
  t3_.description AS description_75,
  t3_.auto_accept_registrations AS auto_accept_registrations_76,
  t3_.url AS url_77,
  t3_.state AS state_78,
  t3_.token AS token_79,
  t3_.slug AS slug_80,
  t3_.created_at AS created_at_81,
  t3_.updated_at AS updated_at_82,
  t3_.created_by AS created_by_83,
  t3_.updated_by AS updated_by_84,
  u4_.id AS id_85,
  u4_.roles AS roles_86,
  u4_.email AS email_87,
  u4_.password AS password_88,
  u4_.username AS username_89,
  u4_.locale AS locale_90,
  u4_.last_login_at AS last_login_at_91,
  u4_.created_by AS created_by_92,
  u4_.updated_by AS updated_by_93,
  u4_.created_at AS created_at_94,
  u4_.updated_at AS updated_at_95,
  a5_.id AS id_96,
  a5_.name AS name_97,
  a5_.gender AS gender_98,
  a5_.state AS state_99,
  a5_.age_min AS age_min_100,
  a5_.age_max AS age_max_101,
  a5_.abbreviation AS abbreviation_102,
  a5_.created_at AS created_at_103,
  a5_.updated_at AS updated_at_104,
  a5_.created_by AS created_by_105,
  a5_.updated_by AS updated_by_106,
  d6_.id AS id_107,
  d6_.name AS name_108,
  d6_.abbreviation AS abbreviation_109,
  d6_.state AS state_110,
  d6_.created_at AS created_at_111,
  d6_.updated_at AS updated_at_112,
  d6_.created_by AS created_by_113,
  d6_.updated_by AS updated_by_114,
  t7_.id AS id_115,
  t7_.type AS type_116,
  t7_.name AS name_117,
  t7_.state AS state_118,
  t7_.round_count_max AS round_count_max_119,
  t7_.created_at AS created_at_120,
  t7_.updated_at AS updated_at_121,
  t7_.created_by AS created_by_122,
  t7_.updated_by AS updated_by_123,
  s0_.user_id AS user_id_124,
  s0_.tournament_session_id AS tournament_session_id_125,
  s0_.division_id AS division_id_126,
  s0_.tournament_age_class_id AS tournament_age_class_id_127,
  s0_.team_id AS team_id_128,
  t1_.age_class_id AS age_class_id_129,
  t1_.tournament_id AS tournament_id_130,
  t2_.tournament_id AS tournament_id_131,
  t3_.tournament_category_id AS tournament_category_id_132,
  t3_.tournament_format_id AS tournament_format_id_133,
  t3_.place_id AS place_id_134,
  t3_.user_organizer_id AS user_organizer_id_135,
  t3_.club_organizer_id AS club_organizer_id_136,
  t3_.rule_book_id AS rule_book_id_137,
  t3_.banner_file_id AS banner_file_id_138,
  u4_.person_id AS person_id_139,
  u4_.federation_id AS federation_id_140,
  a5_.rule_book_id AS rule_book_id_141,
  d6_.rule_book_id AS rule_book_id_142,
  t7_.rule_book_id AS rule_book_id_143
FROM
  session_registration s0_
  INNER JOIN tournament_age_class t1_ ON s0_.tournament_age_class_id = t1_.id
  INNER JOIN tournament_session t2_ ON s0_.tournament_session_id = t2_.id
  INNER JOIN tournament t3_ ON t2_.tournament_id = t3_.id
  INNER JOIN user u4_ ON s0_.user_id = u4_.id
  INNER JOIN age_class a5_ ON t1_.age_class_id = a5_.id
  INNER JOIN division d6_ ON s0_.division_id = d6_.id
  INNER JOIN tournament_format t7_ ON t3_.tournament_format_id = t7_.id
WHERE
  t3_.rule_book_id = ?
  AND t3_.start_at >= ?
  AND t3_.end_at <= ?
  AND s0_.result IS NOT NULL
  AND t2_.session_category <> ?
ORDER BY
  t2_.shooting_start_at ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.state AS state_1, s0_.result AS result_2, s0_.is_guest AS is_guest_3, s0_.correspondence_language AS correspondence_language_4, s0_.first_name AS first_name_5, s0_.last_name AS last_name_6, s0_.email AS email_7, s0_.phone AS phone_8, s0_.address AS address_9, s0_.zip AS zip_10, s0_.city AS city_11, s0_.birth_date AS birth_date_12, s0_.license_number AS license_number_13, s0_.country AS country_14, s0_.token AS token_15, s0_.club_name AS club_name_16, s0_.is_wheelchair_user AS is_wheelchair_user_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.created_by AS created_by_20, s0_.updated_by AS updated_by_21, s0_.id AS id_22, s0_.state AS state_23, s0_.result AS result_24, s0_.is_guest AS is_guest_25, s0_.correspondence_language AS correspondence_language_26, s0_.first_name AS first_name_27, s0_.last_name AS last_name_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.address AS address_31, s0_.zip AS zip_32, s0_.city AS city_33, s0_.birth_date AS birth_date_34, s0_.license_number AS license_number_35, s0_.country AS country_36, s0_.token AS token_37, s0_.club_name AS club_name_38, s0_.is_wheelchair_user AS is_wheelchair_user_39, s0_.created_at AS created_at_40, s0_.updated_at AS updated_at_41, s0_.created_by AS created_by_42, s0_.updated_by AS updated_by_43, t1_.id AS id_44, t1_.fee AS fee_45, t1_.currency AS currency_46, t1_.created_at AS created_at_47, t1_.updated_at AS updated_at_48, t1_.created_by AS created_by_49, t1_.updated_by AS updated_by_50, t2_.id AS id_51, t2_.name AS name_52, t2_.register_start_at AS register_start_at_53, t2_.register_end_at AS register_end_at_54, t2_.inspection_start_at AS inspection_start_at_55, t2_.training_start_at AS training_start_at_56, t2_.shooting_start_at AS shooting_start_at_57, t2_.max_competitors AS max_competitors_58, t2_.is_final AS is_final_59, t2_.session_category AS session_category_60, t2_.is_inter_club AS is_inter_club_61, t2_.is_inter_gender AS is_inter_gender_62, t2_.team_members_number AS team_members_number_63, t2_.created_at AS created_at_64, t2_.updated_at AS updated_at_65, t2_.created_by AS created_by_66, t2_.updated_by AS updated_by_67, t3_.id AS id_68, t3_.name AS name_69, t3_.start_at AS start_at_70, t3_.end_at AS end_at_71, t3_.registration_start_at AS registration_start_at_72, t3_.registration_end_at AS registration_end_at_73, t3_.ianseo_link AS ianseo_link_74, t3_.description AS description_75, t3_.auto_accept_registrations AS auto_accept_registrations_76, t3_.url AS url_77, t3_.state AS state_78, t3_.token AS token_79, t3_.slug AS slug_80, t3_.created_at AS created_at_81, t3_.updated_at AS updated_at_82, t3_.created_by AS created_by_83, t3_.updated_by AS updated_by_84, u4_.id AS id_85, u4_.roles AS roles_86, u4_.email AS email_87, u4_.password AS password_88, u4_.username AS username_89, u4_.locale AS locale_90, u4_.last_login_at AS last_login_at_91, u4_.created_by AS created_by_92, u4_.updated_by AS updated_by_93, u4_.created_at AS created_at_94, u4_.updated_at AS updated_at_95, a5_.id AS id_96, a5_.name AS name_97, a5_.gender AS gender_98, a5_.state AS state_99, a5_.age_min AS age_min_100, a5_.age_max AS age_max_101, a5_.abbreviation AS abbreviation_102, a5_.created_at AS created_at_103, a5_.updated_at AS updated_at_104, a5_.created_by AS created_by_105, a5_.updated_by AS updated_by_106, d6_.id AS id_107, d6_.name AS name_108, d6_.abbreviation AS abbreviation_109, d6_.state AS state_110, d6_.created_at AS created_at_111, d6_.updated_at AS updated_at_112, d6_.created_by AS created_by_113, d6_.updated_by AS updated_by_114, t7_.id AS id_115, t7_.type AS type_116, t7_.name AS name_117, t7_.state AS state_118, t7_.round_count_max AS round_count_max_119, t7_.created_at AS created_at_120, t7_.updated_at AS updated_at_121, t7_.created_by AS created_by_122, t7_.updated_by AS updated_by_123, s0_.user_id AS user_id_124, s0_.tournament_session_id AS tournament_session_id_125, s0_.division_id AS division_id_126, s0_.tournament_age_class_id AS tournament_age_class_id_127, s0_.team_id AS team_id_128, t1_.age_class_id AS age_class_id_129, t1_.tournament_id AS tournament_id_130, t2_.tournament_id AS tournament_id_131, t3_.tournament_category_id AS tournament_category_id_132, t3_.tournament_format_id AS tournament_format_id_133, t3_.place_id AS place_id_134, t3_.user_organizer_id AS user_organizer_id_135, t3_.club_organizer_id AS club_organizer_id_136, t3_.rule_book_id AS rule_book_id_137, t3_.banner_file_id AS banner_file_id_138, u4_.person_id AS person_id_139, u4_.federation_id AS federation_id_140, a5_.rule_book_id AS rule_book_id_141, d6_.rule_book_id AS rule_book_id_142, t7_.rule_book_id AS rule_book_id_143 FROM session_registration s0_ INNER JOIN tournament_age_class t1_ ON s0_.tournament_age_class_id = t1_.id INNER JOIN tournament_session t2_ ON s0_.tournament_session_id = t2_.id INNER JOIN tournament t3_ ON t2_.tournament_id = t3_.id INNER JOIN user u4_ ON s0_.user_id = u4_.id INNER JOIN age_class a5_ ON t1_.age_class_id = a5_.id INNER JOIN division d6_ ON s0_.division_id = d6_.id INNER JOIN tournament_format t7_ ON t3_.tournament_format_id = t7_.id WHERE t3_.rule_book_id = 1 AND t3_.start_at >= '2026-03-01 00:00:00' AND t3_.end_at <= '2026-09-30 00:00:00' AND s0_.result IS NOT NULL AND t2_.session_category <> 20 ORDER BY t2_.shooting_start_at ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.gender AS gender_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.npa AS npa_8,
  t0.city AS city_9,
  t0.birth_date AS birth_date_10,
  t0.decease_date AS decease_date_11,
  t0.retire_date AS retire_date_12,
  t0.printedAt AS printedAt_13,
  t0.lastPrintedAt AS lastPrintedAt_14,
  t0.numberPrinted AS numberPrinted_15,
  t0.note AS note_16,
  t0.language AS language_17,
  t0.membership_date AS membership_date_18,
  t0.membership_type AS membership_type_19,
  t0.deletedAt AS deletedAt_20,
  t0.locked AS locked_21,
  t0.licenseNumber AS licenseNumber_22,
  t0.hash AS hash_23,
  t0.birth_city_country AS birth_city_country_24,
  t0.height AS height_25,
  t0.spouse_children AS spouse_children_26,
  t0.former_name AS former_name_27,
  t0.residence_city_country AS residence_city_country_28,
  t0.education_city_country AS education_city_country_29,
  t0.occupation AS occupation_30,
  t0.website AS website_31,
  t0.twitter AS twitter_32,
  t0.facebook AS facebook_33,
  t0.instagram AS instagram_34,
  t0.snapchat AS snapchat_35,
  t0.discr AS discr_36,
  t0.created_by AS created_by_37,
  t0.updated_by AS updated_by_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.federation_id AS federation_id_41,
  t42.id AS id_43,
  t42.name AS name_44,
  t42.shortName AS shortName_45,
  t42.code AS code_46,
  t42.correspondenceLanguage AS correspondenceLanguage_47,
  t42.country AS country_48,
  t42.visible AS visible_49,
  t42.address AS address_50,
  t42.npa AS npa_51,
  t42.city AS city_52,
  t42.cantonCode AS cantonCode_53,
  t42.phone AS phone_54,
  t42.phone2 AS phone2_55,
  t42.mobile AS mobile_56,
  t42.fax AS fax_57,
  t42.fax2 AS fax2_58,
  t42.correspondanceCountry AS correspondanceCountry_59,
  t42.affiliated_year AS affiliated_year_60,
  t42.contactName AS contactName_61,
  t42.emailAddress AS emailAddress_62,
  t42.url AS url_63,
  t42.isMember AS isMember_64,
  t42.sendTo AS sendTo_65,
  t42.member_until_date AS member_until_date_66,
  t42.comment AS comment_67,
  t0.previous_federation_id AS previous_federation_id_68,
  t69.id AS id_70,
  t69.name AS name_71,
  t69.shortName AS shortName_72,
  t69.code AS code_73,
  t69.correspondenceLanguage AS correspondenceLanguage_74,
  t69.country AS country_75,
  t69.visible AS visible_76,
  t69.address AS address_77,
  t69.npa AS npa_78,
  t69.city AS city_79,
  t69.cantonCode AS cantonCode_80,
  t69.phone AS phone_81,
  t69.phone2 AS phone2_82,
  t69.mobile AS mobile_83,
  t69.fax AS fax_84,
  t69.fax2 AS fax2_85,
  t69.correspondanceCountry AS correspondanceCountry_86,
  t69.affiliated_year AS affiliated_year_87,
  t69.contactName AS contactName_88,
  t69.emailAddress AS emailAddress_89,
  t69.url AS url_90,
  t69.isMember AS isMember_91,
  t69.sendTo AS sendTo_92,
  t69.member_until_date AS member_until_date_93,
  t69.comment AS comment_94,
  t95.id AS id_96,
  t95.roles AS roles_97,
  t95.email AS email_98,
  t95.password AS password_99,
  t95.username AS username_100,
  t95.locale AS locale_101,
  t95.last_login_at AS last_login_at_102,
  t95.created_by AS created_by_103,
  t95.updated_by AS updated_by_104,
  t95.created_at AS created_at_105,
  t95.updated_at AS updated_at_106,
  t95.person_id AS person_id_107,
  t95.federation_id AS federation_id_108
FROM
  person t0
  LEFT JOIN federation t42 ON t0.federation_id = t42.id
  LEFT JOIN federation t69 ON t0.previous_federation_id = t69.id
  LEFT JOIN user t95 ON t95.person_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.npa AS npa_8, t0.city AS city_9, t0.birth_date AS birth_date_10, t0.decease_date AS decease_date_11, t0.retire_date AS retire_date_12, t0.printedAt AS printedAt_13, t0.lastPrintedAt AS lastPrintedAt_14, t0.numberPrinted AS numberPrinted_15, t0.note AS note_16, t0.language AS language_17, t0.membership_date AS membership_date_18, t0.membership_type AS membership_type_19, t0.deletedAt AS deletedAt_20, t0.locked AS locked_21, t0.licenseNumber AS licenseNumber_22, t0.hash AS hash_23, t0.birth_city_country AS birth_city_country_24, t0.height AS height_25, t0.spouse_children AS spouse_children_26, t0.former_name AS former_name_27, t0.residence_city_country AS residence_city_country_28, t0.education_city_country AS education_city_country_29, t0.occupation AS occupation_30, t0.website AS website_31, t0.twitter AS twitter_32, t0.facebook AS facebook_33, t0.instagram AS instagram_34, t0.snapchat AS snapchat_35, t0.discr AS discr_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.federation_id AS federation_id_41, t42.id AS id_43, t42.name AS name_44, t42.shortName AS shortName_45, t42.code AS code_46, t42.correspondenceLanguage AS correspondenceLanguage_47, t42.country AS country_48, t42.visible AS visible_49, t42.address AS address_50, t42.npa AS npa_51, t42.city AS city_52, t42.cantonCode AS cantonCode_53, t42.phone AS phone_54, t42.phone2 AS phone2_55, t42.mobile AS mobile_56, t42.fax AS fax_57, t42.fax2 AS fax2_58, t42.correspondanceCountry AS correspondanceCountry_59, t42.affiliated_year AS affiliated_year_60, t42.contactName AS contactName_61, t42.emailAddress AS emailAddress_62, t42.url AS url_63, t42.isMember AS isMember_64, t42.sendTo AS sendTo_65, t42.member_until_date AS member_until_date_66, t42.comment AS comment_67, t0.previous_federation_id AS previous_federation_id_68, t69.id AS id_70, t69.name AS name_71, t69.shortName AS shortName_72, t69.code AS code_73, t69.correspondenceLanguage AS correspondenceLanguage_74, t69.country AS country_75, t69.visible AS visible_76, t69.address AS address_77, t69.npa AS npa_78, t69.city AS city_79, t69.cantonCode AS cantonCode_80, t69.phone AS phone_81, t69.phone2 AS phone2_82, t69.mobile AS mobile_83, t69.fax AS fax_84, t69.fax2 AS fax2_85, t69.correspondanceCountry AS correspondanceCountry_86, t69.affiliated_year AS affiliated_year_87, t69.contactName AS contactName_88, t69.emailAddress AS emailAddress_89, t69.url AS url_90, t69.isMember AS isMember_91, t69.sendTo AS sendTo_92, t69.member_until_date AS member_until_date_93, t69.comment AS comment_94, t95.id AS id_96, t95.roles AS roles_97, t95.email AS email_98, t95.password AS password_99, t95.username AS username_100, t95.locale AS locale_101, t95.last_login_at AS last_login_at_102, t95.created_by AS created_by_103, t95.updated_by AS updated_by_104, t95.created_at AS created_at_105, t95.updated_at AS updated_at_106, t95.person_id AS person_id_107, t95.federation_id AS federation_id_108 FROM person t0 LEFT JOIN federation t42 ON t0.federation_id = t42.id LEFT JOIN federation t69 ON t0.previous_federation_id = t69.id LEFT JOIN user t95 ON t95.person_id = t0.id WHERE t0.id IN ('44269aa4-18b2-11');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.start_at AS start_at_2,
  s0_.end_at AS end_at_3,
  s0_.ranking_tournament_count AS ranking_tournament_count_4,
  s0_.rule_book_id AS rule_book_id_5
FROM
  season s0_
WHERE
  s0_.rule_book_id = ?
ORDER BY
  s0_.start_at DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.rule_book_id = 1 ORDER BY s0_.start_at DESC;

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

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;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.start_at AS start_at_2,
  s0_.end_at AS end_at_3,
  s0_.ranking_tournament_count AS ranking_tournament_count_4,
  s0_.rule_book_id AS rule_book_id_5
FROM
  season s0_
WHERE
  s0_.start_at <= ?
  AND s0_.end_at >= ?
  AND s0_.rule_book_id = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.start_at <= '2026-09-11 06:10:07' AND s0_.end_at >= '2026-09-11 06:10:07' AND s0_.rule_book_id = 1 LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.abbreviation AS abbreviation_2,
  r0_.referee_label AS referee_label_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.created_by AS created_by_6,
  r0_.updated_by AS updated_by_7
FROM
  rule_book r0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      season s1_
    WHERE
      s1_.rule_book_id = r0_.id
  ) > 0

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.abbreviation AS abbreviation_2, r0_.referee_label AS referee_label_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7 FROM rule_book r0_ WHERE (SELECT COUNT(*) FROM season s1_ WHERE s1_.rule_book_id = r0_.id) > 0;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.name AS name_2,
  t0_.state AS state_3,
  t0_.round_count_max AS round_count_max_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
  tournament_format t0_
WHERE
  t0_.rule_book_id = ?
  AND t0_.state = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.state AS state_3, t0_.round_count_max AS round_count_max_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 tournament_format t0_ WHERE t0_.rule_book_id = 1 AND t0_.state = 1 ORDER BY t0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.gender AS gender_2,
  a0_.state AS state_3,
  a0_.age_min AS age_min_4,
  a0_.age_max AS age_max_5,
  a0_.abbreviation AS abbreviation_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.created_by AS created_by_9,
  a0_.updated_by AS updated_by_10,
  a0_.rule_book_id AS rule_book_id_11
FROM
  age_class a0_
WHERE
  a0_.rule_book_id = ?
  AND a0_.state = ?
ORDER BY
  a0_.age_min ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.gender AS gender_2, a0_.state AS state_3, a0_.age_min AS age_min_4, a0_.age_max AS age_max_5, a0_.abbreviation AS abbreviation_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.created_by AS created_by_9, a0_.updated_by AS updated_by_10, a0_.rule_book_id AS rule_book_id_11 FROM age_class a0_ WHERE a0_.rule_book_id = 1 AND a0_.state = 1 ORDER BY a0_.age_min ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.abbreviation AS abbreviation_2,
  d0_.state AS state_3,
  d0_.created_at AS created_at_4,
  d0_.updated_at AS updated_at_5,
  d0_.created_by AS created_by_6,
  d0_.updated_by AS updated_by_7,
  d0_.rule_book_id AS rule_book_id_8
FROM
  division d0_
WHERE
  d0_.rule_book_id = ?
  AND d0_.state = ?
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.abbreviation AS abbreviation_2, d0_.state AS state_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.created_by AS created_by_6, d0_.updated_by AS updated_by_7, d0_.rule_book_id AS rule_book_id_8 FROM division d0_ WHERE d0_.rule_book_id = 1 AND d0_.state = 1 ORDER BY d0_.name ASC;