Symfony Profiler

SELECT
  c0_.name AS name_0,
  c0_.httpsUpgrade AS httpsUpgrade_1,
  c0_.id AS id_2,
  c0_.uid AS uid_3,
  c0_.createdAt AS createdAt_4,
  c0_.updatedAt AS updatedAt_5,
  c0_.touchedAt AS touchedAt_6,
  c0_.dnsLookupAt AS dnsLookupAt_7,
  c0_.dnsLookupResult AS dnsLookupResult_8,
  c0_.redirection_enabled AS redirection_enabled_9,
  c0_.redirection_host AS redirection_host_10,
  c0_.redirection_path AS redirection_path_11,
  c0_.redirection_appendPath AS redirection_appendPath_12,
  c0_.redirection_query AS redirection_query_13,
  c0_.redirection_appendQuery AS redirection_appendQuery_14,
  c0_.redirection_code AS redirection_code_15,
  c0_.apex AS apex_16,
  c0_.certificate AS certificate_17,
  c0_.tenant AS tenant_18,
  c0_.createdBy AS createdBy_19,
  c0_.updatedBy AS updatedBy_20,
  c0_.touchedBy AS touchedBy_21
FROM
  cms__domain__domain c0_
  LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id
WHERE
  (
    c0_.name = ?
    AND c1_.host = ?
  )
  OR (
    c0_.name = ?
    AND c1_.host = ?
  )
LIMIT
  1

SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id WHERE (c0_.name = '' AND c1_.host = 'wcsd.fallhaven.org') OR (c0_.name = 'wcsd' AND c1_.host = 'fallhaven.org') LIMIT 1;

SELECT
  t0.expiration AS expiration_1,
  t0.ready AS ready_2,
  t0.error AS error_3,
  t0.id AS id_4,
  t0.uid AS uid_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7,
  t0.touchedAt AS touchedAt_8,
  t0.data_privateKey AS data_privateKey_9,
  t0.data_intermediateCertificates AS data_intermediateCertificates_10,
  t0.data_certficate AS data_certficate_11,
  t0.data_certificateSigningRequest AS data_certificateSigningRequest_12,
  t0.domain AS domain_13,
  t0.tenant AS tenant_14,
  t0.createdBy AS createdBy_15,
  t0.updatedBy AS updatedBy_16,
  t0.touchedBy AS touchedBy_17,
  t0._discr,
  t0.csr_email AS csr_email_18,
  t0.csr_organization AS csr_organization_19,
  t0.csr_unit AS csr_unit_20,
  t0.csr_country AS csr_country_21,
  t0.csr_province AS csr_province_22,
  t0.csr_locality AS csr_locality_23,
  t0.le_challenge AS le_challenge_24,
  t0.le_token AS le_token_25,
  t0.le_payload AS le_payload_26
FROM
  cms__domain__ssl_certificate t0
WHERE
  t0.id = ?
  AND t0._discr IN ('custom', 'lets-encrypt')

SELECT t0.expiration AS expiration_1, t0.ready AS ready_2, t0.error AS error_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.data_privateKey AS data_privateKey_9, t0.data_intermediateCertificates AS data_intermediateCertificates_10, t0.data_certficate AS data_certficate_11, t0.data_certificateSigningRequest AS data_certificateSigningRequest_12, t0.domain AS domain_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr, t0.csr_email AS csr_email_18, t0.csr_organization AS csr_organization_19, t0.csr_unit AS csr_unit_20, t0.csr_country AS csr_country_21, t0.csr_province AS csr_province_22, t0.csr_locality AS csr_locality_23, t0.le_challenge AS le_challenge_24, t0.le_token AS le_token_25, t0.le_payload AS le_payload_26 FROM cms__domain__ssl_certificate t0 WHERE t0.id = 39 AND t0._discr IN ('custom', 'lets-encrypt');

SELECT
  t0.host AS host_1,
  t0.id AS id_2,
  t0.uid AS uid_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.touchedAt AS touchedAt_6,
  t0.dnsLookupAt AS dnsLookupAt_7,
  t0.dnsLookupResult AS dnsLookupResult_8,
  t0.verification_code AS verification_code_9,
  t0.verification_date AS verification_date_10,
  t0.tenant AS tenant_11,
  t0.createdBy AS createdBy_12,
  t0.updatedBy AS updatedBy_13,
  t0.touchedBy AS touchedBy_14
FROM
  cms__domain__apex t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 1)
  )

SELECT t0.host AS host_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.dnsLookupAt AS dnsLookupAt_7, t0.dnsLookupResult AS dnsLookupResult_8, t0.verification_code AS verification_code_9, t0.verification_date AS verification_date_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__domain__apex t0 WHERE t0.id = 1 AND ((t0.tenant = 1));

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.status AS status_3,
  t0.emailsDisplay AS emailsDisplay_4,
  t0.policy AS policy_5,
  t0.disqusId AS disqusId_6,
  t0.googleToken AS googleToken_7,
  t0.stage AS stage_8,
  t0.teamworkTasklist AS teamworkTasklist_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.redirects AS redirects_12,
  t0.redirectCodes AS redirectCodes_13,
  t0.debugging AS debugging_14,
  t0.products AS products_15,
  t0.hubspotId AS hubspotId_16,
  t0.weglotId AS weglotId_17,
  t0.id AS id_18,
  t0.uid AS uid_19,
  t0.createdAt AS createdAt_20,
  t0.updatedAt AS updatedAt_21,
  t0.touchedAt AS touchedAt_22,
  t0.data_custom0 AS data_custom0_23,
  t0.data_custom1 AS data_custom1_24,
  t0.data_custom2 AS data_custom2_25,
  t0.data_custom3 AS data_custom3_26,
  t0.authenticationTypes AS authenticationTypes_27,
  t0.classlinkCustomerId AS classlinkCustomerId_28,
  t0.cleverCustomerId AS cleverCustomerId_29,
  t0.gg4lCustomerId AS gg4lCustomerId_30,
  t0.googleCustomerId AS googleCustomerId_31,
  t0.microsoftCustomerId AS microsoftCustomerId_32,
  t0.ulid AS ulid_33,
  t0.locale_timezone AS locale_timezone_34,
  t0.ada_reportsFolder AS ada_reportsFolder_35,
  t0.ada_reportsPrimary AS ada_reportsPrimary_36,
  t0.ada_reportsDocuments AS ada_reportsDocuments_37,
  t0.type_primary AS type_primary_38,
  t0.type_secondary AS type_secondary_39
FROM
  cms__tenant__tenant t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.status AS status_3, t0.emailsDisplay AS emailsDisplay_4, t0.policy AS policy_5, t0.disqusId AS disqusId_6, t0.googleToken AS googleToken_7, t0.stage AS stage_8, t0.teamworkTasklist AS teamworkTasklist_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.redirects AS redirects_12, t0.redirectCodes AS redirectCodes_13, t0.debugging AS debugging_14, t0.products AS products_15, t0.hubspotId AS hubspotId_16, t0.weglotId AS weglotId_17, t0.id AS id_18, t0.uid AS uid_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.touchedAt AS touchedAt_22, t0.data_custom0 AS data_custom0_23, t0.data_custom1 AS data_custom1_24, t0.data_custom2 AS data_custom2_25, t0.data_custom3 AS data_custom3_26, t0.authenticationTypes AS authenticationTypes_27, t0.classlinkCustomerId AS classlinkCustomerId_28, t0.cleverCustomerId AS cleverCustomerId_29, t0.gg4lCustomerId AS gg4lCustomerId_30, t0.googleCustomerId AS googleCustomerId_31, t0.microsoftCustomerId AS microsoftCustomerId_32, t0.ulid AS ulid_33, t0.locale_timezone AS locale_timezone_34, t0.ada_reportsFolder AS ada_reportsFolder_35, t0.ada_reportsPrimary AS ada_reportsPrimary_36, t0.ada_reportsDocuments AS ada_reportsDocuments_37, t0.type_primary AS type_primary_38, t0.type_secondary AS type_secondary_39 FROM cms__tenant__tenant t0 WHERE t0.id = 1;

SELECT
  c0_.name AS name_0,
  c0_.httpsUpgrade AS httpsUpgrade_1,
  c0_.id AS id_2,
  c0_.uid AS uid_3,
  c0_.createdAt AS createdAt_4,
  c0_.updatedAt AS updatedAt_5,
  c0_.touchedAt AS touchedAt_6,
  c0_.dnsLookupAt AS dnsLookupAt_7,
  c0_.dnsLookupResult AS dnsLookupResult_8,
  c0_.redirection_enabled AS redirection_enabled_9,
  c0_.redirection_host AS redirection_host_10,
  c0_.redirection_path AS redirection_path_11,
  c0_.redirection_appendPath AS redirection_appendPath_12,
  c0_.redirection_query AS redirection_query_13,
  c0_.redirection_appendQuery AS redirection_appendQuery_14,
  c0_.redirection_code AS redirection_code_15,
  c0_.apex AS apex_16,
  c0_.certificate AS certificate_17,
  c0_.tenant AS tenant_18,
  c0_.createdBy AS createdBy_19,
  c0_.updatedBy AS updatedBy_20,
  c0_.touchedBy AS touchedBy_21
FROM
  cms__domain__domain c0_
  LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id
  AND (c1_.tenant = 1)
WHERE
  (
    (
      c0_.name = ?
      AND c1_.host = ?
    )
    OR (
      c0_.name = ?
      AND c1_.host = ?
    )
  )
  AND (c0_.tenant = 1)
LIMIT
  1

SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = '' AND c1_.host = 'wcsd.fallhaven.org') OR (c0_.name = 'wcsd' AND c1_.host = 'fallhaven.org')) AND (c0_.tenant = 1) LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.hidden AS hidden_3,
  t0.color AS color_4,
  t0.code AS code_5,
  t0.schoolNowMigrated AS schoolNowMigrated_6,
  t0.id AS id_7,
  t0.uid AS uid_8,
  t0.createdAt AS createdAt_9,
  t0.updatedAt AS updatedAt_10,
  t0.touchedAt AS touchedAt_11,
  t0.rt AS rt_12,
  t0.lvl AS lvl_13,
  t0.lft AS lft_14,
  t0.rgt AS rgt_15,
  t0.navigation AS navigation_16,
  t0.moduleFlags_alert AS moduleFlags_alert_17,
  t0.moduleFlags_blog AS moduleFlags_blog_18,
  t0.moduleFlags_calendar AS moduleFlags_calendar_19,
  t0.moduleFlags_gallery AS moduleFlags_gallery_20,
  t0.moduleFlags_news AS moduleFlags_news_21,
  t0.moduleFlags_page AS moduleFlags_page_22,
  t0.moduleFlags_people AS moduleFlags_people_23,
  t0.moduleFlags_question AS moduleFlags_question_24,
  t0.moduleFlags_snippet AS moduleFlags_snippet_25,
  t0.moduleFlags_feed AS moduleFlags_feed_26,
  t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27,
  t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28,
  t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29,
  t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30,
  t0.preferred AS preferred_31,
  t0.parent AS parent_32,
  t0.domain AS domain_33,
  t0.tenant AS tenant_34,
  t0.createdBy AS createdBy_35,
  t0.updatedBy AS updatedBy_36,
  t0.touchedBy AS touchedBy_37,
  t0.defaultTheme AS defaultTheme_38,
  t0.defaultOuterLayout AS defaultOuterLayout_39,
  t0.defaultInnerLayout AS defaultInnerLayout_40,
  t0._discr
FROM
  cms__container__container t0
WHERE
  t0.domain = ?
  AND t0._discr IN ('generic')
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.hidden AS hidden_3, t0.color AS color_4, t0.code AS code_5, t0.schoolNowMigrated AS schoolNowMigrated_6, t0.id AS id_7, t0.uid AS uid_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.touchedAt AS touchedAt_11, t0.rt AS rt_12, t0.lvl AS lvl_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.navigation AS navigation_16, t0.moduleFlags_alert AS moduleFlags_alert_17, t0.moduleFlags_blog AS moduleFlags_blog_18, t0.moduleFlags_calendar AS moduleFlags_calendar_19, t0.moduleFlags_gallery AS moduleFlags_gallery_20, t0.moduleFlags_news AS moduleFlags_news_21, t0.moduleFlags_page AS moduleFlags_page_22, t0.moduleFlags_people AS moduleFlags_people_23, t0.moduleFlags_question AS moduleFlags_question_24, t0.moduleFlags_snippet AS moduleFlags_snippet_25, t0.moduleFlags_feed AS moduleFlags_feed_26, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30, t0.preferred AS preferred_31, t0.parent AS parent_32, t0.domain AS domain_33, t0.tenant AS tenant_34, t0.createdBy AS createdBy_35, t0.updatedBy AS updatedBy_36, t0.touchedBy AS touchedBy_37, t0.defaultTheme AS defaultTheme_38, t0.defaultOuterLayout AS defaultOuterLayout_39, t0.defaultInnerLayout AS defaultInnerLayout_40, t0._discr FROM cms__container__container t0 WHERE t0.domain = 12 AND t0._discr IN ('generic') AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.hidden AS hidden_2,
  c0_.color AS color_3,
  c0_.code AS code_4,
  c0_.schoolNowMigrated AS schoolNowMigrated_5,
  c0_.id AS id_6,
  c0_.uid AS uid_7,
  c0_.createdAt AS createdAt_8,
  c0_.updatedAt AS updatedAt_9,
  c0_.touchedAt AS touchedAt_10,
  c0_.rt AS rt_11,
  c0_.lvl AS lvl_12,
  c0_.lft AS lft_13,
  c0_.rgt AS rgt_14,
  c0_.navigation AS navigation_15,
  c0_.moduleFlags_alert AS moduleFlags_alert_16,
  c0_.moduleFlags_blog AS moduleFlags_blog_17,
  c0_.moduleFlags_calendar AS moduleFlags_calendar_18,
  c0_.moduleFlags_gallery AS moduleFlags_gallery_19,
  c0_.moduleFlags_news AS moduleFlags_news_20,
  c0_.moduleFlags_page AS moduleFlags_page_21,
  c0_.moduleFlags_people AS moduleFlags_people_22,
  c0_.moduleFlags_question AS moduleFlags_question_23,
  c0_.moduleFlags_snippet AS moduleFlags_snippet_24,
  c0_.moduleFlags_feed AS moduleFlags_feed_25,
  c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26,
  c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27,
  c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28,
  c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29,
  c0_.preferred AS preferred_30,
  c0_.importIndex AS importIndex_31,
  c0_.feedSetting_blog AS feedSetting_blog_32,
  c0_.feedSetting_calendar AS feedSetting_calendar_33,
  c0_.feedSetting_news AS feedSetting_news_34,
  c0_.feedSetting_alert AS feedSetting_alert_35,
  c0_.preferred AS preferred_36,
  c0_._discr AS _discr_37,
  c0_.parent AS parent_38,
  c0_.domain AS domain_39,
  c0_.tenant AS tenant_40,
  c0_.createdBy AS createdBy_41,
  c0_.updatedBy AS updatedBy_42,
  c0_.touchedBy AS touchedBy_43,
  c0_.defaultTheme AS defaultTheme_44,
  c0_.defaultOuterLayout AS defaultOuterLayout_45,
  c0_.defaultInnerLayout AS defaultInnerLayout_46,
  c0_.account AS account_47,
  c0_.container AS container_48,
  c0_.import AS import_49
FROM
  cms__container__container c0_
WHERE
  (
    (
      c0_.rt = ?
      AND c0_.lft < ?
      AND c0_.rgt > ?
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
ORDER BY
  c0_.lft ASC

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_.importIndex AS importIndex_31, c0_.feedSetting_blog AS feedSetting_blog_32, c0_.feedSetting_calendar AS feedSetting_calendar_33, c0_.feedSetting_news AS feedSetting_news_34, c0_.feedSetting_alert AS feedSetting_alert_35, c0_.preferred AS preferred_36, c0_._discr AS _discr_37, c0_.parent AS parent_38, c0_.domain AS domain_39, c0_.tenant AS tenant_40, c0_.createdBy AS createdBy_41, c0_.updatedBy AS updatedBy_42, c0_.touchedBy AS touchedBy_43, c0_.defaultTheme AS defaultTheme_44, c0_.defaultOuterLayout AS defaultOuterLayout_45, c0_.defaultInnerLayout AS defaultInnerLayout_46, c0_.account AS account_47, c0_.container AS container_48, c0_.import AS import_49 FROM cms__container__container c0_ WHERE ((c0_.rt = 149 AND c0_.lft < 1 AND c0_.rgt > 24) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC;

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.oneRosterOrg AS oneRosterOrg_3,
  t0.id AS id_4,
  t0.uid AS uid_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7,
  t0.touchedAt AS touchedAt_8,
  t0.ulid AS ulid_9,
  t0.details_phone AS details_phone_10,
  t0.details_fax AS details_fax_11,
  t0.details_links AS details_links_12,
  t0.details_inquiryEmails AS details_inquiryEmails_13,
  t0.details_checkupEmails AS details_checkupEmails_14,
  t0.details_sisUrl AS details_sisUrl_15,
  t0.details_contactManagement AS details_contactManagement_16,
  t0.details_address_recipient AS details_address_recipient_17,
  t0.details_address_organization AS details_address_organization_18,
  t0.details_address_street AS details_address_street_19,
  t0.details_address_unit AS details_address_unit_20,
  t0.details_address_city AS details_address_city_21,
  t0.details_address_state AS details_address_state_22,
  t0.details_address_postalCode AS details_address_postalCode_23,
  t0.details_address_country AS details_address_country_24,
  t0.branding_bust AS branding_bust_25,
  t0.branding_images AS branding_images_26,
  t0.branding_colorPrimary AS branding_colorPrimary_27,
  t0.branding_colorSecondary AS branding_colorSecondary_28,
  t0.branding_colorTertiary AS branding_colorTertiary_29,
  t0.branding_colorMobileHeader AS branding_colorMobileHeader_30,
  t0.branding_colorMobileText AS branding_colorMobileText_31,
  t0.mobile_shortcuts AS mobile_shortcuts_32,
  t0.mobile_directoryUrl AS mobile_directoryUrl_33,
  t0.department AS department_34,
  t0.tenant AS tenant_35,
  t0.createdBy AS createdBy_36,
  t0.updatedBy AS updatedBy_37,
  t0.touchedBy AS touchedBy_38
FROM
  sys__school t0
WHERE
  (
    (t0.tenant = 1)
  )
ORDER BY
  t0.type ASC,
  t0.name ASC

SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE ((t0.tenant = 1)) ORDER BY t0.type ASC, t0.name ASC;

SELECT
  t0.theme AS theme_1,
  t0.name AS name_2,
  t0.fonts AS fonts_3,
  t0.bust AS bust_4,
  t0.id AS id_5,
  t0.uid AS uid_6,
  t0.createdAt AS createdAt_7,
  t0.updatedAt AS updatedAt_8,
  t0.touchedAt AS touchedAt_9,
  t0.variables AS variables_10,
  t0.source AS source_11,
  t0.configs AS configs_12,
  t0.outerLayout AS outerLayout_13,
  t0.innerLayout AS innerLayout_14,
  t0.tenant AS tenant_15,
  t0.createdBy AS createdBy_16,
  t0.updatedBy AS updatedBy_17,
  t0.touchedBy AS touchedBy_18
FROM
  cms__theme__template t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 1)
  )

SELECT t0.theme AS theme_1, t0.name AS name_2, t0.fonts AS fonts_3, t0.bust AS bust_4, t0.id AS id_5, t0.uid AS uid_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.touchedAt AS touchedAt_9, t0.variables AS variables_10, t0.source AS source_11, t0.configs AS configs_12, t0.outerLayout AS outerLayout_13, t0.innerLayout AS innerLayout_14, t0.tenant AS tenant_15, t0.createdBy AS createdBy_16, t0.updatedBy AS updatedBy_17, t0.touchedBy AS touchedBy_18 FROM cms__theme__template t0 WHERE t0.id = 2 AND ((t0.tenant = 1));

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.oneRosterOrg AS oneRosterOrg_3,
  t0.id AS id_4,
  t0.uid AS uid_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7,
  t0.touchedAt AS touchedAt_8,
  t0.ulid AS ulid_9,
  t0.details_phone AS details_phone_10,
  t0.details_fax AS details_fax_11,
  t0.details_links AS details_links_12,
  t0.details_inquiryEmails AS details_inquiryEmails_13,
  t0.details_checkupEmails AS details_checkupEmails_14,
  t0.details_sisUrl AS details_sisUrl_15,
  t0.details_contactManagement AS details_contactManagement_16,
  t0.details_address_recipient AS details_address_recipient_17,
  t0.details_address_organization AS details_address_organization_18,
  t0.details_address_street AS details_address_street_19,
  t0.details_address_unit AS details_address_unit_20,
  t0.details_address_city AS details_address_city_21,
  t0.details_address_state AS details_address_state_22,
  t0.details_address_postalCode AS details_address_postalCode_23,
  t0.details_address_country AS details_address_country_24,
  t0.branding_bust AS branding_bust_25,
  t0.branding_images AS branding_images_26,
  t0.branding_colorPrimary AS branding_colorPrimary_27,
  t0.branding_colorSecondary AS branding_colorSecondary_28,
  t0.branding_colorTertiary AS branding_colorTertiary_29,
  t0.branding_colorMobileHeader AS branding_colorMobileHeader_30,
  t0.branding_colorMobileText AS branding_colorMobileText_31,
  t0.mobile_shortcuts AS mobile_shortcuts_32,
  t0.mobile_directoryUrl AS mobile_directoryUrl_33,
  t0.department AS department_34,
  t0.tenant AS tenant_35,
  t0.createdBy AS createdBy_36,
  t0.updatedBy AS updatedBy_37,
  t0.touchedBy AS touchedBy_38
FROM
  sys__school t0
WHERE
  (
    (t0.tenant = 1)
  )
ORDER BY
  t0.type ASC,
  t0.name ASC

SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE ((t0.tenant = 1)) ORDER BY t0.type ASC, t0.name ASC;

SELECT
  DISTINCT id_10
FROM
  (
    SELECT
      DISTINCT id_10,
      pinned_50,
      timestamp_44,
      label_45
    FROM
      (
        SELECT
          s0_.schoolTypes AS schoolTypes_0,
          s0_.visibility AS visibility_1,
          s0_.migrationId AS migrationId_2,
          s0_.migrationUid AS migrationUid_3,
          s0_.scheduledAt AS scheduledAt_4,
          s0_.channels AS channels_5,
          s0_.websiteBehavior AS websiteBehavior_6,
          s0_.websiteLevel AS websiteLevel_7,
          s0_.websiteEndDateTime AS websiteEndDateTime_8,
          s0_.socialPosts AS socialPosts_9,
          s0_.id AS id_10,
          s0_.createdAt AS createdAt_11,
          s0_.updatedAt AS updatedAt_12,
          s0_.touchedAt AS touchedAt_13,
          s0_.headline AS headline_14,
          s0_.timestamp AS timestamp_15,
          s0_.semaphore AS semaphore_16,
          s0_.startsAt AS startsAt_17,
          s0_.stopsAt AS stopsAt_18,
          s0_.blurb AS blurb_19,
          s0_.details AS details_20,
          s0_.html AS html_21,
          s0_.slug AS slug_22,
          s0_.startsAt AS startsAt_23,
          s0_.stopsAt AS stopsAt_24,
          s0_.blurb AS blurb_25,
          s0_.details AS details_26,
          s0_.html AS html_27,
          s0_.slug AS slug_28,
          s0_.media AS media_29,
          s0_.blurb AS blurb_30,
          s0_.slug AS slug_31,
          s0_.media AS media_32,
          s0_.html AS html_33,
          s0_.blurb AS blurb_34,
          s0_.slug AS slug_35,
          s0_.media AS media_36,
          s0_.blurb AS blurb_37,
          s0_.details AS details_38,
          s0_.html AS html_39,
          s0_.slug AS slug_40,
          s0_.media AS media_41,
          s0_.link AS link_42,
          s1_.schoolType AS schoolType_43,
          s1_.timestamp AS timestamp_44,
          s1_.label AS label_45,
          s1_.preview AS preview_46,
          s1_.media AS media_47,
          s1_.visibility AS visibility_48,
          s1_.boosted AS boosted_49,
          s1_.pinned AS pinned_50,
          s1_.pinnedAt AS pinnedAt_51,
          s1_.link AS link_52,
          s1_.id AS id_53,
          s1_.createdAt AS createdAt_54,
          s1_.updatedAt AS updatedAt_55,
          s1_.touchedAt AS touchedAt_56,
          c2_.name AS name_57,
          c2_.slug AS slug_58,
          c2_.hidden AS hidden_59,
          c2_.color AS color_60,
          c2_.code AS code_61,
          c2_.schoolNowMigrated AS schoolNowMigrated_62,
          c2_.id AS id_63,
          c2_.uid AS uid_64,
          c2_.createdAt AS createdAt_65,
          c2_.updatedAt AS updatedAt_66,
          c2_.touchedAt AS touchedAt_67,
          c2_.rt AS rt_68,
          c2_.lvl AS lvl_69,
          c2_.lft AS lft_70,
          c2_.rgt AS rgt_71,
          c2_.navigation AS navigation_72,
          c2_.moduleFlags_alert AS moduleFlags_alert_73,
          c2_.moduleFlags_blog AS moduleFlags_blog_74,
          c2_.moduleFlags_calendar AS moduleFlags_calendar_75,
          c2_.moduleFlags_gallery AS moduleFlags_gallery_76,
          c2_.moduleFlags_news AS moduleFlags_news_77,
          c2_.moduleFlags_page AS moduleFlags_page_78,
          c2_.moduleFlags_people AS moduleFlags_people_79,
          c2_.moduleFlags_question AS moduleFlags_question_80,
          c2_.moduleFlags_snippet AS moduleFlags_snippet_81,
          c2_.moduleFlags_feed AS moduleFlags_feed_82,
          c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83,
          c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84,
          c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85,
          c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86,
          c2_.preferred AS preferred_87,
          c2_.importIndex AS importIndex_88,
          c2_.feedSetting_blog AS feedSetting_blog_89,
          c2_.feedSetting_calendar AS feedSetting_calendar_90,
          c2_.feedSetting_news AS feedSetting_news_91,
          c2_.feedSetting_alert AS feedSetting_alert_92,
          c2_.preferred AS preferred_93,
          s0_.discr AS discr_94,
          s1_.discr AS discr_95,
          c2_._discr AS _discr_96
        FROM
          sn__content__object s0_
          LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object
          AND s1_.discr IN (
            'content', 'content.events.event',
            'content.exhibits.gallery', 'content.posts.post',
            'content.exhibits.video'
          )
          AND (s1_.tenant = 1)
          LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id
          AND c2_._discr IN (
            'generic', 'personal', 'intranet',
            'storage'
          )
          AND (c2_.tenant = 1)
        WHERE
          (
            (
              c2_.rt = ?
              AND (
                (s1_.schoolType & ?) > 0
                OR s1_.department IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
              )
              AND s1_.boosted = ?
              AND s1_.visibility = ?
              AND s1_.timestamp <= ?
            )
            AND (s0_.tenant = 1)
          )
          AND s0_.discr IN (
            'alerts.alert', 'events.event', 'exhibits.gallery',
            'exhibits.video', 'posts.post'
          )
      ) dctrn_result_inner
    ORDER BY
      pinned_50 DESC,
      timestamp_44 DESC,
      label_45 ASC
  ) dctrn_result
LIMIT
  13