Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.settings_val AS settings_val_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.settings_val AS settings_val_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_location' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_category' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_whom' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_approach' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0_.id AS id_0,
  t0_.mdauto AS mdauto_1,
  t0_.mdsauto AS mdsauto_2,
  t0_.firstname AS firstname_3,
  t0_.lastname AS lastname_4,
  t0_.address1 AS address1_5,
  t0_.address2 AS address2_6,
  t0_.address3 AS address3_7,
  t0_.address4 AS address4_8,
  t0_.postcode AS postcode_9,
  t0_.country AS country_10,
  t0_.mdtel AS mdtel_11,
  t0_.private AS private_12,
  t0_.directory AS directory_13,
  t0_.clinical AS clinical_14,
  t0_.counselling AS counselling_15,
  t0_.educational AS educational_16,
  t0_.work AS work_17,
  t0_.overview AS overview_18,
  t0_.bio AS bio_19,
  t0_.map AS map_20,
  t0_.google_map_img AS google_map_img_21,
  t0_.img AS img_22,
  t0_.mdemail AS mdemail_23,
  t0_.mdwww AS mdwww_24,
  t0_.fax AS fax_25,
  t0_.login AS login_26,
  t0_.passwd AS passwd_27,
  t0_.open_mon AS open_mon_28,
  t0_.open_tue AS open_tue_29,
  t0_.open_wed AS open_wed_30,
  t0_.open_thu AS open_thu_31,
  t0_.open_fri AS open_fri_32,
  t0_.open_sat AS open_sat_33,
  t0_.open_sun AS open_sun_34,
  t0_.close_mon AS close_mon_35,
  t0_.close_tue AS close_tue_36,
  t0_.close_wed AS close_wed_37,
  t0_.close_thu AS close_thu_38,
  t0_.close_fri AS close_fri_39,
  t0_.close_sat AS close_sat_40,
  t0_.close_sun AS close_sun_41,
  t0_.logo AS logo_42,
  t0_.subdomain AS subdomain_43,
  t0_.qualifications AS qualifications_44,
  t0_.interests AS interests_45,
  t0_.memberships AS memberships_46,
  t0_.salutation AS salutation_47,
  t0_.fee AS fee_48,
  t0_.wheelchair AS wheelchair_49,
  t0_.fee_negotiable AS fee_negotiable_50,
  t0_.fee_donation AS fee_donation_51,
  t0_.fee_free AS fee_free_52,
  t0_.whom_one AS whom_one_53,
  t0_.whom_families AS whom_families_54,
  t0_.whom_groups AS whom_groups_55,
  t0_.whom_children AS whom_children_56,
  t0_.whom_teenagers AS whom_teenagers_57,
  t0_.whom_adults AS whom_adults_58,
  t0_.for_whom AS for_whom_59,
  t0_.inactive AS inactive_60,
  t0_.keywords AS keywords_61,
  t0_.old_location_id AS old_location_id_62,
  t0_.online_register AS online_register_63,
  t0_.lapsed AS lapsed_64,
  t0_.login_token AS login_token_65,
  t0_.sign_language AS sign_language_66,
  t0_.hse_frontline AS hse_frontline_67,
  t0_.pa_website_list AS pa_website_list_68,
  t0_.additional_training AS additional_training_69,
  t0_.custom_lang AS custom_lang_70,
  t0_.deletedAt AS deletedAt_71,
  t0_.image_name AS image_name_72,
  t0_.updated_at AS updated_at_73,
  t0_.member_id AS member_id_74,
  t0_.location_id AS location_id_75
FROM
  therapist t0_
  INNER JOIN member m1_ ON t0_.member_id = m1_.id
  AND (m1_.deletedAt IS NULL)
  INNER JOIN therapist_whom_relation t3_ ON t0_.id = t3_.therapist_id
  INNER JOIN dictionary d2_ ON d2_.id = t3_.whom_id
  AND (d2_.deletedAt IS NULL)
  INNER JOIN dictionary d4_ ON t0_.location_id = d4_.id
  AND (d4_.deletedAt IS NULL)
WHERE
  (
    t0_.online_register = ?
    AND t0_.lapsed = ?
    AND m1_.status = ?
    AND d2_.type_key = ?
    AND d2_.id IN (?)
    AND d4_.type_key = ?
    AND d4_.id IN (?, ?)
  )
  AND (t0_.deletedAt IS NULL)

SELECT t0_.id AS id_0, t0_.mdauto AS mdauto_1, t0_.mdsauto AS mdsauto_2, t0_.firstname AS firstname_3, t0_.lastname AS lastname_4, t0_.address1 AS address1_5, t0_.address2 AS address2_6, t0_.address3 AS address3_7, t0_.address4 AS address4_8, t0_.postcode AS postcode_9, t0_.country AS country_10, t0_.mdtel AS mdtel_11, t0_.private AS private_12, t0_.directory AS directory_13, t0_.clinical AS clinical_14, t0_.counselling AS counselling_15, t0_.educational AS educational_16, t0_.work AS work_17, t0_.overview AS overview_18, t0_.bio AS bio_19, t0_.map AS map_20, t0_.google_map_img AS google_map_img_21, t0_.img AS img_22, t0_.mdemail AS mdemail_23, t0_.mdwww AS mdwww_24, t0_.fax AS fax_25, t0_.login AS login_26, t0_.passwd AS passwd_27, t0_.open_mon AS open_mon_28, t0_.open_tue AS open_tue_29, t0_.open_wed AS open_wed_30, t0_.open_thu AS open_thu_31, t0_.open_fri AS open_fri_32, t0_.open_sat AS open_sat_33, t0_.open_sun AS open_sun_34, t0_.close_mon AS close_mon_35, t0_.close_tue AS close_tue_36, t0_.close_wed AS close_wed_37, t0_.close_thu AS close_thu_38, t0_.close_fri AS close_fri_39, t0_.close_sat AS close_sat_40, t0_.close_sun AS close_sun_41, t0_.logo AS logo_42, t0_.subdomain AS subdomain_43, t0_.qualifications AS qualifications_44, t0_.interests AS interests_45, t0_.memberships AS memberships_46, t0_.salutation AS salutation_47, t0_.fee AS fee_48, t0_.wheelchair AS wheelchair_49, t0_.fee_negotiable AS fee_negotiable_50, t0_.fee_donation AS fee_donation_51, t0_.fee_free AS fee_free_52, t0_.whom_one AS whom_one_53, t0_.whom_families AS whom_families_54, t0_.whom_groups AS whom_groups_55, t0_.whom_children AS whom_children_56, t0_.whom_teenagers AS whom_teenagers_57, t0_.whom_adults AS whom_adults_58, t0_.for_whom AS for_whom_59, t0_.inactive AS inactive_60, t0_.keywords AS keywords_61, t0_.old_location_id AS old_location_id_62, t0_.online_register AS online_register_63, t0_.lapsed AS lapsed_64, t0_.login_token AS login_token_65, t0_.sign_language AS sign_language_66, t0_.hse_frontline AS hse_frontline_67, t0_.pa_website_list AS pa_website_list_68, t0_.additional_training AS additional_training_69, t0_.custom_lang AS custom_lang_70, t0_.deletedAt AS deletedAt_71, t0_.image_name AS image_name_72, t0_.updated_at AS updated_at_73, t0_.member_id AS member_id_74, t0_.location_id AS location_id_75 FROM therapist t0_ INNER JOIN member m1_ ON t0_.member_id = m1_.id AND (m1_.deletedAt IS NULL) INNER JOIN therapist_whom_relation t3_ ON t0_.id = t3_.therapist_id INNER JOIN dictionary d2_ ON d2_.id = t3_.whom_id AND (d2_.deletedAt IS NULL) INNER JOIN dictionary d4_ ON t0_.location_id = d4_.id AND (d4_.deletedAt IS NULL) WHERE (t0_.online_register = 1 AND t0_.lapsed = 0 AND m1_.status = 'active' AND d2_.type_key = 'therapist_whom' AND d2_.id IN ('353') AND d4_.type_key = 'therapist_location' AND d4_.id IN ('77', '86')) AND (t0_.deletedAt IS NULL);

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.settings_val AS settings_val_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.field2 DESC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'events' AND ((t0.deletedAt IS NULL)) ORDER BY t0.field2 DESC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.name AS name_3,
  t0.`lead` AS lead_4,
  t0.content AS content_5,
  t0.right_column AS right_column_6,
  t0.gallery_content AS gallery_content_7,
  t0.type_key AS type_key_8,
  t0.visible AS visible_9,
  t0.priority_news AS priority_news_10,
  t0.full_width AS full_width_11,
  t0.hide_right_column AS hide_right_column_12,
  t0.hide_submenu AS hide_submenu_13,
  t0.show_subpage_panels AS show_subpage_panels_14,
  t0.show_subpage_links AS show_subpage_links_15,
  t0.show_subpage_news AS show_subpage_news_16,
  t0.use_parent_header AS use_parent_header_17,
  t0.list_order AS list_order_18,
  t0.seo_title AS seo_title_19,
  t0.custom_tabs AS custom_tabs_20,
  t0.seo_keywords AS seo_keywords_21,
  t0.seo_description AS seo_description_22,
  t0.seo_url AS seo_url_23,
  t0.parent_id AS parent_id_24,
  t0.image_name AS image_name_25,
  t0.image_alt AS image_alt_26,
  t0.image2_name AS image2_name_27,
  t0.image2_alt AS image2_alt_28,
  t0.image3_name AS image3_name_29,
  t0.image3_alt AS image3_alt_30,
  t0.heading AS heading_31,
  t0.external_link AS external_link_32,
  t0.page_date AS page_date_33,
  t0.parent_id AS parent_id_34
FROM
  page t0
WHERE
  t0.visible = ?
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.visible = 1 ORDER BY t0.list_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.name AS name_2,
  p0_.`lead` AS lead_3,
  p0_.content AS content_4,
  p0_.right_column AS right_column_5,
  p0_.gallery_content AS gallery_content_6,
  p0_.type_key AS type_key_7,
  p0_.visible AS visible_8,
  p0_.priority_news AS priority_news_9,
  p0_.full_width AS full_width_10,
  p0_.hide_right_column AS hide_right_column_11,
  p0_.hide_submenu AS hide_submenu_12,
  p0_.show_subpage_panels AS show_subpage_panels_13,
  p0_.show_subpage_links AS show_subpage_links_14,
  p0_.show_subpage_news AS show_subpage_news_15,
  p0_.use_parent_header AS use_parent_header_16,
  p0_.list_order AS list_order_17,
  p0_.seo_title AS seo_title_18,
  p0_.custom_tabs AS custom_tabs_19,
  p0_.seo_keywords AS seo_keywords_20,
  p0_.seo_description AS seo_description_21,
  p0_.seo_url AS seo_url_22,
  p0_.parent_id AS parent_id_23,
  p0_.image_name AS image_name_24,
  p0_.image_alt AS image_alt_25,
  p0_.image2_name AS image2_name_26,
  p0_.image2_alt AS image2_alt_27,
  p0_.image3_name AS image3_name_28,
  p0_.image3_alt AS image3_alt_29,
  p0_.heading AS heading_30,
  p0_.external_link AS external_link_31,
  p0_.page_date AS page_date_32,
  p0_.parent_id AS parent_id_33
FROM
  page p0_
WHERE
  p0_.type_key = ?
  AND p0_.visible = ?
  AND p0_.page_date <= ?
ORDER BY
  p0_.priority_news DESC,
  p0_.page_date DESC,
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.name AS name_2, p0_.`lead` AS lead_3, p0_.content AS content_4, p0_.right_column AS right_column_5, p0_.gallery_content AS gallery_content_6, p0_.type_key AS type_key_7, p0_.visible AS visible_8, p0_.priority_news AS priority_news_9, p0_.full_width AS full_width_10, p0_.hide_right_column AS hide_right_column_11, p0_.hide_submenu AS hide_submenu_12, p0_.show_subpage_panels AS show_subpage_panels_13, p0_.show_subpage_links AS show_subpage_links_14, p0_.show_subpage_news AS show_subpage_news_15, p0_.use_parent_header AS use_parent_header_16, p0_.list_order AS list_order_17, p0_.seo_title AS seo_title_18, p0_.custom_tabs AS custom_tabs_19, p0_.seo_keywords AS seo_keywords_20, p0_.seo_description AS seo_description_21, p0_.seo_url AS seo_url_22, p0_.parent_id AS parent_id_23, p0_.image_name AS image_name_24, p0_.image_alt AS image_alt_25, p0_.image2_name AS image2_name_26, p0_.image2_alt AS image2_alt_27, p0_.image3_name AS image3_name_28, p0_.image3_alt AS image3_alt_29, p0_.heading AS heading_30, p0_.external_link AS external_link_31, p0_.page_date AS page_date_32, p0_.parent_id AS parent_id_33 FROM page p0_ WHERE p0_.type_key = 'news' AND p0_.visible = 1 AND p0_.page_date <= '2026-06-02 19:24:40' ORDER BY p0_.priority_news DESC, p0_.page_date DESC, p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file_name AS file_name_3,
  t0.file_original_name AS file_original_name_4,
  t0.file_mime AS file_mime_5,
  t0.file_size AS file_size_6,
  t0.fee AS fee_7,
  t0.confirm_message AS confirm_message_8,
  t0.file2_name AS file2_name_9,
  t0.file2_original_name AS file2_original_name_10,
  t0.file2_mime AS file2_mime_11,
  t0.file2_size AS file2_size_12,
  t0.file3_name AS file3_name_13,
  t0.file3_original_name AS file3_original_name_14,
  t0.file3_mime AS file3_mime_15,
  t0.file3_size AS file3_size_16,
  t0.file4_name AS file4_name_17,
  t0.file4_original_name AS file4_original_name_18,
  t0.file4_mime AS file4_mime_19,
  t0.file4_size AS file4_size_20,
  t0.addfields AS addfields_21,
  t0.email_copy AS email_copy_22,
  t0.membership_no AS membership_no_23,
  t0.garda_required AS garda_required_24,
  t0.processing_fee_label AS processing_fee_label_25,
  t0.under_button_label AS under_button_label_26,
  t0.stage2_email_topic AS stage2_email_topic_27,
  t0.stage2_email_content AS stage2_email_content_28,
  t0.sf_garda_vetting AS sf_garda_vetting_29,
  t0.sf_application AS sf_application_30,
  t0.stage2_enabled AS stage2_enabled_31,
  t0.merged_form AS merged_form_32,
  t0.fee2 AS fee2_33,
  t0.stage2_email AS stage2_email_34,
  t0.updated_at AS updated_at_35
FROM
  membership_form t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.file_name AS file_name_3, t0.file_original_name AS file_original_name_4, t0.file_mime AS file_mime_5, t0.file_size AS file_size_6, t0.fee AS fee_7, t0.confirm_message AS confirm_message_8, t0.file2_name AS file2_name_9, t0.file2_original_name AS file2_original_name_10, t0.file2_mime AS file2_mime_11, t0.file2_size AS file2_size_12, t0.file3_name AS file3_name_13, t0.file3_original_name AS file3_original_name_14, t0.file3_mime AS file3_mime_15, t0.file3_size AS file3_size_16, t0.file4_name AS file4_name_17, t0.file4_original_name AS file4_original_name_18, t0.file4_mime AS file4_mime_19, t0.file4_size AS file4_size_20, t0.addfields AS addfields_21, t0.email_copy AS email_copy_22, t0.membership_no AS membership_no_23, t0.garda_required AS garda_required_24, t0.processing_fee_label AS processing_fee_label_25, t0.under_button_label AS under_button_label_26, t0.stage2_email_topic AS stage2_email_topic_27, t0.stage2_email_content AS stage2_email_content_28, t0.sf_garda_vetting AS sf_garda_vetting_29, t0.sf_application AS sf_application_30, t0.stage2_enabled AS stage2_enabled_31, t0.merged_form AS merged_form_32, t0.fee2 AS fee2_33, t0.stage2_email AS stage2_email_34, t0.updated_at AS updated_at_35 FROM membership_form t0;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
  INNER JOIN therapist_whom_relation ON t0.id = therapist_whom_relation.whom_id
WHERE
  therapist_whom_relation.therapist_id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_whom_relation ON t0.id = therapist_whom_relation.whom_id WHERE therapist_whom_relation.therapist_id = 4531 AND ((t0.deletedAt IS NULL));