Symfony Profiler

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          subscription_course_disabled s2_
        WHERE
          s2_.disabled_course_id = t0_.id
          AND s2_.subscription_id = ?
      )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND (NOT (EXISTS (SELECT 1 AS sclr_1 FROM subscription_course_disabled s2_ WHERE s2_.disabled_course_id = t0_.id AND s2_.subscription_id = 'COP10020767')));

SELECT
  COUNT(DISTINCT f0_.id) AS sclr_0
FROM
  fact_sheet f0_
  INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id
WHERE
  f0_.is_active = 1
  AND f0_.subscription_id IS NULL

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fact_sheet f0_ INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id WHERE f0_.is_active = 1 AND f0_.subscription_id IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.connected_at AS connected_at_2,
  c0_.subscription_id AS subscription_id_3
FROM
  connection_log c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.connected_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.connected_at AS connected_at_2, c0_.subscription_id AS subscription_id_3 FROM connection_log c0_ WHERE c0_.user_id = 5 ORDER BY c0_.connected_at DESC LIMIT 1;

SELECT
  SUM(
    CASE WHEN p0_.is_trapped_link = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN p0_.is_trapped_form = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COUNT(p0_.id) AS sclr_2
FROM
  phishing_user p0_
  INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id
WHERE
  p0_.user_id = ?
  AND p1_.subscription = ?

SELECT SUM(CASE WHEN p0_.is_trapped_link = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN p0_.is_trapped_form = 1 THEN 1 ELSE 0 END) AS sclr_1, COUNT(p0_.id) AS sclr_2 FROM phishing_user p0_ INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id WHERE p0_.user_id = 5 AND p1_.subscription = 'COP10020767';

SELECT
  q0_.id AS id_0,
  q0_.date AS date_1,
  q0_.questions_id AS questions_id_2,
  q0_.ended_at AS ended_at_3,
  q0_.answers AS answers_4,
  q0_.scores AS scores_5,
  q0_.canceled_at AS canceled_at_6,
  q0_.model_id AS model_id_7,
  q0_.quiz_user_registration_id AS quiz_user_registration_id_8
FROM
  quiz_user q0_
  INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id
  INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id
WHERE
  q1_.user_id = ?
  AND q2_.type_mission = 0
  AND q0_.ended_at IS NOT NULL
  AND q0_.canceled_at IS NULL

SELECT q0_.id AS id_0, q0_.date AS date_1, q0_.questions_id AS questions_id_2, q0_.ended_at AS ended_at_3, q0_.answers AS answers_4, q0_.scores AS scores_5, q0_.canceled_at AS canceled_at_6, q0_.model_id AS model_id_7, q0_.quiz_user_registration_id AS quiz_user_registration_id_8 FROM quiz_user q0_ INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id WHERE q1_.user_id = 5 AND q2_.type_mission = 0 AND q0_.ended_at IS NOT NULL AND q0_.canceled_at IS NULL;

SELECT
  SUM(
    CASE WHEN m0_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  COUNT(m1_.id) AS sclr_1
FROM
  mission_user_registration m1_
  LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id
  INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id
WHERE
  m1_.user_id = ?
  AND m2_.subscription = ?

SELECT SUM(CASE WHEN m0_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_0, COUNT(m1_.id) AS sclr_1 FROM mission_user_registration m1_ LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id WHERE m1_.user_id = 5 AND m2_.subscription = 'COP10020767';

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 5)));

SELECT
  f0_.fact_sheet_id AS sclr_0
FROM
  fact_sheet_user_log f0_
  INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id
  LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id
WHERE
  f0_.user_id = ?
  AND f1_.is_active = 1
  AND f1_.subscription_id IS NULL
GROUP BY
  f0_.fact_sheet_id
HAVING
  COUNT(f2_.id) > 0

SELECT f0_.fact_sheet_id AS sclr_0 FROM fact_sheet_user_log f0_ INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id WHERE f0_.user_id = 5 AND f1_.is_active = 1 AND f1_.subscription_id IS NULL GROUP BY f0_.fact_sheet_id HAVING COUNT(f2_.id) > 0;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.connected_at AS connected_at_2,
  c0_.subscription_id AS subscription_id_3
FROM
  connection_log c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.connected_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.connected_at AS connected_at_2, c0_.subscription_id AS subscription_id_3 FROM connection_log c0_ WHERE c0_.user_id = 79116 ORDER BY c0_.connected_at DESC LIMIT 1;

SELECT
  SUM(
    CASE WHEN p0_.is_trapped_link = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN p0_.is_trapped_form = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COUNT(p0_.id) AS sclr_2
FROM
  phishing_user p0_
  INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id
WHERE
  p0_.user_id = ?
  AND p1_.subscription = ?

SELECT SUM(CASE WHEN p0_.is_trapped_link = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN p0_.is_trapped_form = 1 THEN 1 ELSE 0 END) AS sclr_1, COUNT(p0_.id) AS sclr_2 FROM phishing_user p0_ INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id WHERE p0_.user_id = 79116 AND p1_.subscription = 'COP10020767';

SELECT
  q0_.id AS id_0,
  q0_.date AS date_1,
  q0_.questions_id AS questions_id_2,
  q0_.ended_at AS ended_at_3,
  q0_.answers AS answers_4,
  q0_.scores AS scores_5,
  q0_.canceled_at AS canceled_at_6,
  q0_.model_id AS model_id_7,
  q0_.quiz_user_registration_id AS quiz_user_registration_id_8
FROM
  quiz_user q0_
  INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id
  INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id
WHERE
  q1_.user_id = ?
  AND q2_.type_mission = 0
  AND q0_.ended_at IS NOT NULL
  AND q0_.canceled_at IS NULL

SELECT q0_.id AS id_0, q0_.date AS date_1, q0_.questions_id AS questions_id_2, q0_.ended_at AS ended_at_3, q0_.answers AS answers_4, q0_.scores AS scores_5, q0_.canceled_at AS canceled_at_6, q0_.model_id AS model_id_7, q0_.quiz_user_registration_id AS quiz_user_registration_id_8 FROM quiz_user q0_ INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id WHERE q1_.user_id = 79116 AND q2_.type_mission = 0 AND q0_.ended_at IS NOT NULL AND q0_.canceled_at IS NULL;

SELECT
  SUM(
    CASE WHEN m0_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  COUNT(m1_.id) AS sclr_1
FROM
  mission_user_registration m1_
  LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id
  INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id
WHERE
  m1_.user_id = ?
  AND m2_.subscription = ?

SELECT SUM(CASE WHEN m0_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_0, COUNT(m1_.id) AS sclr_1 FROM mission_user_registration m1_ LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id WHERE m1_.user_id = 79116 AND m2_.subscription = 'COP10020767';

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 79116)));

SELECT
  f0_.fact_sheet_id AS sclr_0
FROM
  fact_sheet_user_log f0_
  INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id
  LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id
WHERE
  f0_.user_id = ?
  AND f1_.is_active = 1
  AND f1_.subscription_id IS NULL
GROUP BY
  f0_.fact_sheet_id
HAVING
  COUNT(f2_.id) > 0

SELECT f0_.fact_sheet_id AS sclr_0 FROM fact_sheet_user_log f0_ INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id WHERE f0_.user_id = 79116 AND f1_.is_active = 1 AND f1_.subscription_id IS NULL GROUP BY f0_.fact_sheet_id HAVING COUNT(f2_.id) > 0;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.connected_at AS connected_at_2,
  c0_.subscription_id AS subscription_id_3
FROM
  connection_log c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.connected_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.connected_at AS connected_at_2, c0_.subscription_id AS subscription_id_3 FROM connection_log c0_ WHERE c0_.user_id = 11 ORDER BY c0_.connected_at DESC LIMIT 1;

SELECT
  SUM(
    CASE WHEN p0_.is_trapped_link = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN p0_.is_trapped_form = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COUNT(p0_.id) AS sclr_2
FROM
  phishing_user p0_
  INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id
WHERE
  p0_.user_id = ?
  AND p1_.subscription = ?

SELECT SUM(CASE WHEN p0_.is_trapped_link = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN p0_.is_trapped_form = 1 THEN 1 ELSE 0 END) AS sclr_1, COUNT(p0_.id) AS sclr_2 FROM phishing_user p0_ INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id WHERE p0_.user_id = 11 AND p1_.subscription = 'COP10020767';

SELECT
  q0_.id AS id_0,
  q0_.date AS date_1,
  q0_.questions_id AS questions_id_2,
  q0_.ended_at AS ended_at_3,
  q0_.answers AS answers_4,
  q0_.scores AS scores_5,
  q0_.canceled_at AS canceled_at_6,
  q0_.model_id AS model_id_7,
  q0_.quiz_user_registration_id AS quiz_user_registration_id_8
FROM
  quiz_user q0_
  INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id
  INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id
WHERE
  q1_.user_id = ?
  AND q2_.type_mission = 0
  AND q0_.ended_at IS NOT NULL
  AND q0_.canceled_at IS NULL

SELECT q0_.id AS id_0, q0_.date AS date_1, q0_.questions_id AS questions_id_2, q0_.ended_at AS ended_at_3, q0_.answers AS answers_4, q0_.scores AS scores_5, q0_.canceled_at AS canceled_at_6, q0_.model_id AS model_id_7, q0_.quiz_user_registration_id AS quiz_user_registration_id_8 FROM quiz_user q0_ INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id WHERE q1_.user_id = 11 AND q2_.type_mission = 0 AND q0_.ended_at IS NOT NULL AND q0_.canceled_at IS NULL;

SELECT
  SUM(
    CASE WHEN m0_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  COUNT(m1_.id) AS sclr_1
FROM
  mission_user_registration m1_
  LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id
  INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id
WHERE
  m1_.user_id = ?
  AND m2_.subscription = ?

SELECT SUM(CASE WHEN m0_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_0, COUNT(m1_.id) AS sclr_1 FROM mission_user_registration m1_ LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id WHERE m1_.user_id = 11 AND m2_.subscription = 'COP10020767';

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 11)));

SELECT
  f0_.fact_sheet_id AS sclr_0
FROM
  fact_sheet_user_log f0_
  INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id
  LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id
WHERE
  f0_.user_id = ?
  AND f1_.is_active = 1
  AND f1_.subscription_id IS NULL
GROUP BY
  f0_.fact_sheet_id
HAVING
  COUNT(f2_.id) > 0

SELECT f0_.fact_sheet_id AS sclr_0 FROM fact_sheet_user_log f0_ INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id WHERE f0_.user_id = 11 AND f1_.is_active = 1 AND f1_.subscription_id IS NULL GROUP BY f0_.fact_sheet_id HAVING COUNT(f2_.id) > 0;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.connected_at AS connected_at_2,
  c0_.subscription_id AS subscription_id_3
FROM
  connection_log c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.connected_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.connected_at AS connected_at_2, c0_.subscription_id AS subscription_id_3 FROM connection_log c0_ WHERE c0_.user_id = 74818 ORDER BY c0_.connected_at DESC LIMIT 1;

SELECT
  SUM(
    CASE WHEN p0_.is_trapped_link = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN p0_.is_trapped_form = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COUNT(p0_.id) AS sclr_2
FROM
  phishing_user p0_
  INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id
WHERE
  p0_.user_id = ?
  AND p1_.subscription = ?

SELECT SUM(CASE WHEN p0_.is_trapped_link = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN p0_.is_trapped_form = 1 THEN 1 ELSE 0 END) AS sclr_1, COUNT(p0_.id) AS sclr_2 FROM phishing_user p0_ INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id WHERE p0_.user_id = 74818 AND p1_.subscription = 'COP10020767';

SELECT
  q0_.id AS id_0,
  q0_.date AS date_1,
  q0_.questions_id AS questions_id_2,
  q0_.ended_at AS ended_at_3,
  q0_.answers AS answers_4,
  q0_.scores AS scores_5,
  q0_.canceled_at AS canceled_at_6,
  q0_.model_id AS model_id_7,
  q0_.quiz_user_registration_id AS quiz_user_registration_id_8
FROM
  quiz_user q0_
  INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id
  INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id
WHERE
  q1_.user_id = ?
  AND q2_.type_mission = 0
  AND q0_.ended_at IS NOT NULL
  AND q0_.canceled_at IS NULL

SELECT q0_.id AS id_0, q0_.date AS date_1, q0_.questions_id AS questions_id_2, q0_.ended_at AS ended_at_3, q0_.answers AS answers_4, q0_.scores AS scores_5, q0_.canceled_at AS canceled_at_6, q0_.model_id AS model_id_7, q0_.quiz_user_registration_id AS quiz_user_registration_id_8 FROM quiz_user q0_ INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id WHERE q1_.user_id = 74818 AND q2_.type_mission = 0 AND q0_.ended_at IS NOT NULL AND q0_.canceled_at IS NULL;

SELECT
  SUM(
    CASE WHEN m0_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  COUNT(m1_.id) AS sclr_1
FROM
  mission_user_registration m1_
  LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id
  INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id
WHERE
  m1_.user_id = ?
  AND m2_.subscription = ?

SELECT SUM(CASE WHEN m0_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_0, COUNT(m1_.id) AS sclr_1 FROM mission_user_registration m1_ LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id WHERE m1_.user_id = 74818 AND m2_.subscription = 'COP10020767';

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 74818)));

SELECT
  f0_.fact_sheet_id AS sclr_0
FROM
  fact_sheet_user_log f0_
  INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id
  LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id
WHERE
  f0_.user_id = ?
  AND f1_.is_active = 1
  AND f1_.subscription_id IS NULL
GROUP BY
  f0_.fact_sheet_id
HAVING
  COUNT(f2_.id) > 0

SELECT f0_.fact_sheet_id AS sclr_0 FROM fact_sheet_user_log f0_ INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id WHERE f0_.user_id = 74818 AND f1_.is_active = 1 AND f1_.subscription_id IS NULL GROUP BY f0_.fact_sheet_id HAVING COUNT(f2_.id) > 0;

SELECT
  c0_.id AS id_0,
  c0_.user_id AS user_id_1,
  c0_.connected_at AS connected_at_2,
  c0_.subscription_id AS subscription_id_3
FROM
  connection_log c0_
WHERE
  c0_.user_id = ?
ORDER BY
  c0_.connected_at DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.user_id AS user_id_1, c0_.connected_at AS connected_at_2, c0_.subscription_id AS subscription_id_3 FROM connection_log c0_ WHERE c0_.user_id = 74855 ORDER BY c0_.connected_at DESC LIMIT 1;

SELECT
  SUM(
    CASE WHEN p0_.is_trapped_link = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN p0_.is_trapped_form = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COUNT(p0_.id) AS sclr_2
FROM
  phishing_user p0_
  INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id
WHERE
  p0_.user_id = ?
  AND p1_.subscription = ?

SELECT SUM(CASE WHEN p0_.is_trapped_link = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN p0_.is_trapped_form = 1 THEN 1 ELSE 0 END) AS sclr_1, COUNT(p0_.id) AS sclr_2 FROM phishing_user p0_ INNER JOIN phishing_campaign p1_ ON p0_.phishing_campaign_id = p1_.id WHERE p0_.user_id = 74855 AND p1_.subscription = 'COP10020767';

SELECT
  q0_.id AS id_0,
  q0_.date AS date_1,
  q0_.questions_id AS questions_id_2,
  q0_.ended_at AS ended_at_3,
  q0_.answers AS answers_4,
  q0_.scores AS scores_5,
  q0_.canceled_at AS canceled_at_6,
  q0_.model_id AS model_id_7,
  q0_.quiz_user_registration_id AS quiz_user_registration_id_8
FROM
  quiz_user q0_
  INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id
  INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id
WHERE
  q1_.user_id = ?
  AND q2_.type_mission = 0
  AND q0_.ended_at IS NOT NULL
  AND q0_.canceled_at IS NULL

SELECT q0_.id AS id_0, q0_.date AS date_1, q0_.questions_id AS questions_id_2, q0_.ended_at AS ended_at_3, q0_.answers AS answers_4, q0_.scores AS scores_5, q0_.canceled_at AS canceled_at_6, q0_.model_id AS model_id_7, q0_.quiz_user_registration_id AS quiz_user_registration_id_8 FROM quiz_user q0_ INNER JOIN quiz_user_registration q1_ ON q0_.quiz_user_registration_id = q1_.id INNER JOIN quiz_campaign q2_ ON q1_.quiz_campaign_id = q2_.id WHERE q1_.user_id = 74855 AND q2_.type_mission = 0 AND q0_.ended_at IS NOT NULL AND q0_.canceled_at IS NULL;

SELECT
  SUM(
    CASE WHEN m0_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  COUNT(m1_.id) AS sclr_1
FROM
  mission_user_registration m1_
  LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id
  INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id
WHERE
  m1_.user_id = ?
  AND m2_.subscription = ?

SELECT SUM(CASE WHEN m0_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_0, COUNT(m1_.id) AS sclr_1 FROM mission_user_registration m1_ LEFT JOIN mission_user m0_ ON m1_.id = m0_.mission_user_registration_id INNER JOIN mission_campaign m2_ ON m1_.mission_campaign_id = m2_.id WHERE m1_.user_id = 74855 AND m2_.subscription = 'COP10020767';

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 74855)));

SELECT
  f0_.fact_sheet_id AS sclr_0
FROM
  fact_sheet_user_log f0_
  INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id
  LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id
WHERE
  f0_.user_id = ?
  AND f1_.is_active = 1
  AND f1_.subscription_id IS NULL
GROUP BY
  f0_.fact_sheet_id
HAVING
  COUNT(f2_.id) > 0

SELECT f0_.fact_sheet_id AS sclr_0 FROM fact_sheet_user_log f0_ INNER JOIN fact_sheet f1_ ON f0_.fact_sheet_id = f1_.id LEFT JOIN fact_sheet_step f2_ ON f1_.id = f2_.fact_sheet_id WHERE f0_.user_id = 74855 AND f1_.is_active = 1 AND f1_.subscription_id IS NULL GROUP BY f0_.fact_sheet_id HAVING COUNT(f2_.id) > 0;