SELECT
    rbalias3.idnumber AS c0_idnumber,
    rbalias3.shortname AS c1_shortname,
    rbalias3.id AS c1_courseid,
    rbalias4.id AS c1_ctxid,
    rbalias4.path AS c1_ctxpath,
    rbalias4.depth AS c1_ctxdepth,
    rbalias4.contextlevel AS c1_ctxlevel,
    rbalias4.instanceid AS c1_ctxinstance,
    rbalias4.locked AS c1_ctxlocked,
    rbalias3.fullname AS c2_fullname,
    rbalias3.id AS c2_courseid,
    rbalias4.id AS c2_ctxid,
    rbalias4.path AS c2_ctxpath,
    rbalias4.depth AS c2_ctxdepth,
    rbalias4.contextlevel AS c2_ctxlevel,
    rbalias4.instanceid AS c2_ctxinstance,
    rbalias4.locked AS c2_ctxlocked,
    rbalias8.enrol AS c3_enrol,
    rbalias8.name AS c3_name,
    rbalias8.courseid AS c3_courseid,
    rbalias8.roleid AS c3_roleid,
    rbalias8.customint1 AS c3_customint1,
    rbalias48.id AS c4_id,
    rbalias48.name AS c4_name,
    rbalias8.enrol AS c5_enrol,
    COUNT(DISTINCT rbalias15.username) AS c6_username,
    rbalias3.shortname AS c7_courseshortnamewithlink,
    rbalias3.id AS c7_id,
    rbalias3.fullname AS c8_coursefullnamewithlink,
    rbalias3.id AS c8_id,
    rbalias4.id AS c8_ctxid,
    rbalias4.path AS c8_ctxpath,
    rbalias4.depth AS c8_ctxdepth,
    rbalias4.contextlevel AS c8_ctxlevel,
    rbalias4.instanceid AS c8_ctxinstance,
    rbalias4.locked AS c8_ctxlocked
FROM
    mdl_course rbalias3
LEFT JOIN
    mdl_context rbalias4 ON rbalias4.contextlevel = 50 AND rbalias4.instanceid = rbalias3.id
LEFT JOIN
    mdl_enrol rbalias8 ON rbalias8.courseid = rbalias3.id
LEFT JOIN
    mdl_user_enrolments rbalias9 ON rbalias9.userid <> 1
    AND rbalias9.userid NOT IN (
        SELECT rbalias10.userid
        FROM mdl_tool_tenant_user rbalias10
        JOIN mdl_tool_tenant rbalias11 ON rbalias10.tenantid = rbalias11.id AND rbalias11.archived = 0
        WHERE rbalias10.tenantid <> 1
    )
    AND rbalias9.enrolid = rbalias8.id
LEFT JOIN
    mdl_user rbalias15 ON rbalias15.id = rbalias9.userid AND rbalias15.deleted = 0
LEFT JOIN
    mdl_tool_tenant_user rbalias46 ON rbalias46.userid = rbalias15.id
LEFT JOIN
    mdl_tool_tenant rbalias47 ON rbalias47.id = rbalias46.tenantid AND rbalias47.archived = 0
LEFT JOIN
    mdl_tool_tenant rbalias48 ON rbalias48.id = COALESCE(rbalias47.id, 1) AND rbalias15.id IS NOT NULL
WHERE
    rbalias3.id != 1
    AND (rbalias3.category IN (52, 50, 15, 8, 16, 31, 55, 49, 51, 54, 48, 7, 1, 3, 4, 14, 5, 17, 18, 30, 45, 44, 53, 46)
        OR rbalias3.category IN (
            SELECT rbalias7.id
            FROM mdl_course_categories rbalias7
            WHERE rbalias7.id = 24
            OR rbalias7.path LIKE '/24/%' COLLATE utf8mb4_bin ESCAPE '\\'
        )
    )
    AND (
        CASE
            WHEN rbalias9.status = 0 THEN
                CASE
                    WHEN (rbalias9.timestart > 1729120436) OR (rbalias9.timeend > 0 AND rbalias9.timeend < 1729120436) OR (rbalias8.status = 1)
                    THEN 2
                    ELSE 0
                END
            ELSE rbalias9.status
        END = 0
    )
GROUP BY
    c0_idnumber, c1_shortname, c1_courseid, c1_ctxid, c1_ctxpath, c1_ctxdepth, c1_ctxlevel, c1_ctxinstance, c1_ctxlocked,
    c2_fullname, c2_courseid, c2_ctxid, c2_ctxpath, c2_ctxdepth, c2_ctxlevel, c2_ctxinstance, c2_ctxlocked,
    c3_enrol, c3_name, c3_courseid, c3_roleid, c3_customint1, c4_id, c4_name, c5_enrol,
    c7_courseshortnamewithlink, c7_id, c8_coursefullnamewithlink, c8_id, c8_ctxid, c8_ctxpath, c8_ctxdepth, c8_ctxlevel, c8_ctxinstance, c8_ctxlocked
ORDER BY
    c3_enrol ASC;