Symfony Profiler

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.slug = ?
LIMIT
  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.slug = 'staging' LIMIT 1;

SELECT
  t0.email AS email_1,
  t0.active AS active_2,
  t0.policyAcceptedOn AS policyAcceptedOn_3,
  t0.termsAcceptedOn AS termsAcceptedOn_4,
  t0.password AS password_5,
  t0.passwordChangedAt AS passwordChangedAt_6,
  t0.lastLoggedInAt AS lastLoggedInAt_7,
  t0.metadata AS metadata_8,
  t0.internalUid AS internalUid_9,
  t0.id AS id_10,
  t0.uid AS uid_11,
  t0.createdAt AS createdAt_12,
  t0.updatedAt AS updatedAt_13,
  t0.touchedAt AS touchedAt_14,
  t0.onerosterId AS onerosterId_15,
  t0.onerosterArchived AS onerosterArchived_16,
  t0.importIndex AS importIndex_17,
  t0.specialPermissions_superUser AS specialPermissions_superUser_18,
  t0.systemProfile_displayName AS systemProfile_displayName_19,
  t0.systemProfile_firstName AS systemProfile_firstName_20,
  t0.systemProfile_lastName AS systemProfile_lastName_21,
  t0.systemProfile_avatar AS systemProfile_avatar_22,
  t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23,
  t0.tenant AS tenant_24,
  t0.createdBy AS createdBy_25,
  t0.updatedBy AS updatedBy_26,
  t0.touchedBy AS touchedBy_27,
  t0.import AS import_28
FROM
  cms__security__identity__account t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 1)
  )

SELECT t0.email AS email_1, t0.active AS active_2, t0.policyAcceptedOn AS policyAcceptedOn_3, t0.termsAcceptedOn AS termsAcceptedOn_4, t0.password AS password_5, t0.passwordChangedAt AS passwordChangedAt_6, t0.lastLoggedInAt AS lastLoggedInAt_7, t0.metadata AS metadata_8, t0.internalUid AS internalUid_9, t0.id AS id_10, t0.uid AS uid_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.onerosterId AS onerosterId_15, t0.onerosterArchived AS onerosterArchived_16, t0.importIndex AS importIndex_17, t0.specialPermissions_superUser AS specialPermissions_superUser_18, t0.systemProfile_displayName AS systemProfile_displayName_19, t0.systemProfile_firstName AS systemProfile_firstName_20, t0.systemProfile_lastName AS systemProfile_lastName_21, t0.systemProfile_avatar AS systemProfile_avatar_22, t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23, t0.tenant AS tenant_24, t0.createdBy AS createdBy_25, t0.updatedBy AS updatedBy_26, t0.touchedBy AS touchedBy_27, t0.import AS import_28 FROM cms__security__identity__account t0 WHERE t0.id = '1' AND ((t0.tenant = 1));

SELECT
  c0_.account AS sclr_0,
  c0_.grp AS sclr_1
FROM
  cms__security__identity__group_account c0_
WHERE
  (c0_.account = ?)
  AND (c0_.tenant = 1)

SELECT c0_.account AS sclr_0, c0_.grp AS sclr_1 FROM cms__security__identity__group_account c0_ WHERE (c0_.account = 1) AND (c0_.tenant = 1);

SELECT
  c0_.account AS sclr_0,
  c0_.role AS sclr_1,
  c0_.container AS sclr_2,
  c0_.inheritance AS inheritance_3,
  c0_.school AS sclr_4,
  c0_.list AS sclr_5
FROM
  cms__security__access__role_association c0_
WHERE
  (
    (c0_.account = ?)
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('account')

SELECT c0_.account AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.account = 1) AND (c0_.tenant = 1)) AND c0_._discr IN ('account');

SELECT
  c0_.grp AS sclr_0,
  c0_.role AS sclr_1,
  c0_.container AS sclr_2,
  c0_.inheritance AS inheritance_3,
  c0_.school AS sclr_4,
  c0_.list AS sclr_5
FROM
  cms__security__access__role_association c0_
WHERE
  (
    (
      c0_.grp IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('group')

SELECT c0_.grp AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.grp IN (20, 93, 97, 103, 107, 108, 112, 143, 147, 148, 156, 158, 162, 168, 172, 173, 177, 183, 187, 251)) AND (c0_.tenant = 1)) AND c0_._discr IN ('group');

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_2
    FROM
      (
        SELECT
          n0_.name AS name_0,
          n0_.types AS types_1,
          n0_.id AS id_2,
          n0_.uid AS uid_3,
          n0_.createdAt AS createdAt_4,
          n0_.updatedAt AS updatedAt_5,
          n0_.touchedAt AS touchedAt_6,
          n0_.onerosterId AS onerosterId_7,
          n0_.onerosterArchived AS onerosterArchived_8,
          n0_.flags AS flags_9,
          n0_.alias AS alias_10,
          n0_.conditionQuery AS conditionQuery_11,
          n0_.discr AS discr_12
        FROM
          notis__list n0_
        WHERE
          (
            (n0_.tenant = 1)
          )
          AND n0_.discr IN (
            'district', 'static', 'school', 'condition'
          )
        ORDER BY
          n0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT n0_.name AS name_0, n0_.types AS types_1, n0_.id AS id_2, n0_.uid AS uid_3, n0_.createdAt AS createdAt_4, n0_.updatedAt AS updatedAt_5, n0_.touchedAt AS touchedAt_6, n0_.onerosterId AS onerosterId_7, n0_.onerosterArchived AS onerosterArchived_8, n0_.flags AS flags_9, n0_.alias AS alias_10, n0_.conditionQuery AS conditionQuery_11, n0_.discr AS discr_12 FROM notis__list n0_ WHERE ((n0_.tenant = 1)) AND n0_.discr IN ('district', 'static', 'school', 'condition') ORDER BY n0_.name ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_2
FROM
  (
    SELECT
      DISTINCT id_2,
      name_0
    FROM
      (
        SELECT
          n0_.name AS name_0,
          n0_.types AS types_1,
          n0_.id AS id_2,
          n0_.uid AS uid_3,
          n0_.createdAt AS createdAt_4,
          n0_.updatedAt AS updatedAt_5,
          n0_.touchedAt AS touchedAt_6,
          n0_.onerosterId AS onerosterId_7,
          n0_.onerosterArchived AS onerosterArchived_8,
          n0_.flags AS flags_9,
          n0_.alias AS alias_10,
          n0_.conditionQuery AS conditionQuery_11,
          n0_.discr AS discr_12
        FROM
          notis__list n0_
        WHERE
          (
            (n0_.tenant = 1)
          )
          AND n0_.discr IN (
            'district', 'static', 'school', 'condition'
          )
      ) dctrn_result_inner
    ORDER BY
      name_0 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2, name_0 FROM (SELECT n0_.name AS name_0, n0_.types AS types_1, n0_.id AS id_2, n0_.uid AS uid_3, n0_.createdAt AS createdAt_4, n0_.updatedAt AS updatedAt_5, n0_.touchedAt AS touchedAt_6, n0_.onerosterId AS onerosterId_7, n0_.onerosterArchived AS onerosterArchived_8, n0_.flags AS flags_9, n0_.alias AS alias_10, n0_.conditionQuery AS conditionQuery_11, n0_.discr AS discr_12 FROM notis__list n0_ WHERE ((n0_.tenant = 1)) AND n0_.discr IN ('district', 'static', 'school', 'condition')) dctrn_result_inner ORDER BY name_0 ASC) dctrn_result LIMIT 12;

SELECT
  n0_.name AS name_0,
  n0_.types AS types_1,
  n0_.id AS id_2,
  n0_.uid AS uid_3,
  n0_.createdAt AS createdAt_4,
  n0_.updatedAt AS updatedAt_5,
  n0_.touchedAt AS touchedAt_6,
  n0_.onerosterId AS onerosterId_7,
  n0_.onerosterArchived AS onerosterArchived_8,
  n0_.flags AS flags_9,
  n0_.alias AS alias_10,
  n0_.conditionQuery AS conditionQuery_11,
  n0_.discr AS discr_12,
  n0_.school AS school_13,
  n0_.tenant AS tenant_14,
  n0_.createdBy AS createdBy_15,
  n0_.updatedBy AS updatedBy_16,
  n0_.touchedBy AS touchedBy_17
FROM
  notis__list n0_
WHERE
  (
    (
      n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    )
    AND (n0_.tenant = 1)
  )
  AND n0_.discr IN (
    'district', 'static', 'school', 'condition'
  )
ORDER BY
  n0_.name ASC

SELECT n0_.name AS name_0, n0_.types AS types_1, n0_.id AS id_2, n0_.uid AS uid_3, n0_.createdAt AS createdAt_4, n0_.updatedAt AS updatedAt_5, n0_.touchedAt AS touchedAt_6, n0_.onerosterId AS onerosterId_7, n0_.onerosterArchived AS onerosterArchived_8, n0_.flags AS flags_9, n0_.alias AS alias_10, n0_.conditionQuery AS conditionQuery_11, n0_.discr AS discr_12, n0_.school AS school_13, n0_.tenant AS tenant_14, n0_.createdBy AS createdBy_15, n0_.updatedBy AS updatedBy_16, n0_.touchedBy AS touchedBy_17 FROM notis__list n0_ WHERE ((n0_.id IN (1450, 1449, 1448, 1468, 1467, 1466, 1459, 1458, 1457, 1447, 1446, 1445)) AND (n0_.tenant = 1)) AND n0_.discr IN ('district', 'static', 'school', 'condition') ORDER BY n0_.name ASC;

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?)
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('community')) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?, ?, ?)
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('guardian', 'parent', 'relative')) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?, ?, ?, ?, ?)
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('administrator', 'aide', 'proctor', 'teacher', 'staff')) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?)
          AND JSON_CONTAINS(
            JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'),
            ?
          ) = 1
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('community') AND  JSON_CONTAINS( JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'), '\"ORG-REVIEW\"') = 1) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?, ?, ?)
          AND JSON_CONTAINS(
            JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'),
            ?
          ) = 1
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('guardian', 'parent', 'relative') AND  JSON_CONTAINS( JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'), '\"ORG-REVIEW\"') = 1) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?, ?, ?, ?, ?)
          AND JSON_CONTAINS(
            JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'),
            ?
          ) = 1
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)

SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 1) LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id AND n2_.discr IN ('email', 'phone', 'app') AND (n2_.tenant = 1) WHERE (n0_.id IN (SELECT n3_.id FROM notis__profile n3_ WHERE (n3_.role IN ('administrator', 'aide', 'proctor', 'teacher', 'staff') AND  JSON_CONTAINS( JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'), '\"ORG-REVIEW\"') = 1) AND (n3_.discarded = 0) AND (n3_.tenant = 1))) AND (n0_.discarded = 0) AND (n0_.tenant = 1);

SELECT
  t0.yaml AS yaml_1,
  t0.customConfig AS customConfig_2,
  t0.baseConfig AS baseConfig_3,
  t0.translationLocales AS translationLocales_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.tenant AS tenant_10,
  t0.createdBy AS createdBy_11,
  t0.updatedBy AS updatedBy_12,
  t0.touchedBy AS touchedBy_13
FROM
  notis__notification_config t0
WHERE
  t0.tenant = ?
  AND (
    (t0.tenant = 1)
  )
LIMIT
  1

SELECT t0.yaml AS yaml_1, t0.customConfig AS customConfig_2, t0.baseConfig AS baseConfig_3, t0.translationLocales AS translationLocales_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.tenant AS tenant_10, t0.createdBy AS createdBy_11, t0.updatedBy AS updatedBy_12, t0.touchedBy AS touchedBy_13 FROM notis__notification_config t0 WHERE t0.tenant = 1 AND ((t0.tenant = 1)) LIMIT 1;

SELECT
  COUNT(DISTINCT n0_.id) AS sclr_0
FROM
  notis__profile n0_
  LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile
  AND (n1_.discarded = 0)
  AND (n1_.tenant = 1)
  LEFT JOIN notis__recipient n2_ ON n1_.recipient = n2_.id
  AND n2_.discr IN ('email', 'phone', 'app')
  AND (n2_.tenant = 1)
WHERE
  (
    n0_.id IN (
      SELECT
        n3_.id
      FROM
        notis__profile n3_
      WHERE
        (
          n3_.role IN (?)
          AND JSON_CONTAINS(
            JSON_EXTRACT(n3_.metadata, '$.\"_orgs\"'),
            ?
          ) = 1
        )
        AND (n3_.discarded = 0)
        AND (n3_.tenant = 1)
    )
  )
  AND (n0_.discarded = 0)
  AND (n0_.tenant = 1)