Moodle 3.5 logs 16. Oct 2018

SET NAMES utf8mb4
SET SESSION sql_mode = 'STRICT_ALL_TABLES'
SELECT value FROM mdl_config WHERE name = 'siteidentifier'
SELECT * FROM mdl_context WHERE contextlevel = '10'
SELECT * FROM mdl_course WHERE category = '0'
SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = 'o7h7r1b250p43jqcb2t57kle12'
UPDATE mdl_sessions SET timemodified = '1539747630' WHERE id='4'
SELECT * FROM mdl_course WHERE id = '1'
SELECT name,value FROM mdl_user_preferences WHERE userid = '2'
SELECT f.id
              FROM mdl_user_info_field f
         LEFT JOIN mdl_user_info_data d ON (d.fieldid = f.id AND d.userid = '2')
             WHERE f.required = 1 AND f.visible > 0 AND f.locked = 0 AND d.id IS NULL LIMIT 0, 1
SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1'
UPDATE mdl_user SET lastip = '0:0:0:0:0:0:0:1',lastaccess = '1539747630' WHERE id='2'
SELECT f.id
              FROM mdl_user_info_field f
         LEFT JOIN mdl_user_info_data d ON (d.fieldid = f.id AND d.userid = '2')
             WHERE f.required = 1 AND f.visible > 0 AND f.locked = 0 AND d.id IS NULL LIMIT 0, 1
SELECT * FROM mdl_role   ORDER BY sortorder ASC
SELECT * FROM mdl_user WHERE id = '2' AND deleted = '0'
SELECT name, id, enabled FROM mdl_message_processors   ORDER BY name DESC
SELECT active.filter, fc.name, fc.value
         FROM (SELECT f.filter, MAX(f.sortorder) AS sortorder
             FROM mdl_filter_active f
             JOIN mdl_context ctx ON f.contextid = ctx.id
             WHERE ctx.id IN (1,2)
             GROUP BY filter
             HAVING MAX(f.active * ctx.depth) > -MIN(f.active * ctx.depth)
         ) active
         LEFT JOIN mdl_filter_config fc ON fc.filter = active.filter AND fc.contextid = 2
         ORDER BY active.sortorder
SELECT ctx.*
                  FROM mdl_context ctx
                 WHERE ctx.path LIKE '/1/2/%'
SELECT * FROM mdl_oauth2_issuer   ORDER BY sortorder ASC
SELECT * FROM mdl_portfolio_instance ORDER BY name
SELECT r.*
              FROM mdl_role r
             WHERE r.id IN (SELECT rc.roleid
                              FROM mdl_role_capabilities rc
                             WHERE rc.capability = 'tool/dataprivacy:managedatarequests'

                                   )
SELECT u.*
              FROM mdl_user u
             WHERE u.deleted = 0 AND u.id IN (2)
SELECT * FROM mdl_context WHERE contextlevel = '30' AND instanceid = '2'
SELECT id,name,value FROM mdl_course_format_options WHERE courseid = '1' AND format = 'site' AND sectionid = '0'
SELECT c.* , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
              FROM mdl_course c
              JOIN (
                SELECT DISTINCT e.courseid
                  FROM mdl_enrol e
                  JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2')
                 WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1539747600
                       AND (ue.timeend = 0 OR ue.timeend > 1539747600)) en ON (en.courseid = c.id)
           LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50')
             WHERE c.id <> '1'
          ORDER BY c.visible DESC,c.sortorder ASC
SELECT c.id,c.category,c.sortorder,c.shortname,c.fullname,c.idnumber,c.startdate,c.visible,c.defaultgroupingid,c.groupmode,c.groupmodeforce , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
              FROM mdl_course c
              JOIN (SELECT DISTINCT e.courseid
                      FROM mdl_enrol e
                      JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2')
                 WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1539747600 AND (ue.timeend = 0 OR ue.timeend > 1539747600)
                   ) en ON (en.courseid = c.id)
           LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50')
             WHERE c.id <> '1'
          ORDER BY c.visible DESC,c.sortorder ASC
SELECT parent_states.filter,
                CASE WHEN fa.active IS NULL THEN 0
                ELSE fa.active END AS localstate,
             parent_states.inheritedstate
         FROM (SELECT f.filter, MAX(f.sortorder) AS sortorder,
                    CASE WHEN MAX(f.active * ctx.depth) > -MIN(f.active * ctx.depth) THEN 1
                    ELSE -1 END AS inheritedstate
             FROM mdl_filter_active f
             JOIN mdl_context ctx ON f.contextid = ctx.id
             WHERE ctx.id IN (1)
             GROUP BY f.filter
             HAVING MIN(f.active) > -9999
         ) parent_states
         LEFT JOIN mdl_filter_active fa ON fa.filter = parent_states.filter AND fa.contextid = 2
         ORDER BY parent_states.sortorder
SELECT * FROM mdl_enrol WHERE courseid = '1' AND status = '0'  ORDER BY sortorder,id
SELECT r.id, r.name, r.shortname, rn.name AS coursealias
              FROM mdl_role r

              JOIN mdl_role_context_levels rcl ON (rcl.contextlevel = '30' AND r.id = rcl.roleid)
         LEFT JOIN mdl_role_names rn ON (rn.contextid = '0' AND rn.roleid = r.id)
          ORDER BY r.sortorder ASC
SELECT * FROM mdl_repository   ORDER BY sortorder
SELECT f.filter, fc.name, fc.value
              FROM mdl_filter_active f
         LEFT JOIN mdl_filter_config fc
                ON fc.filter = f.filter
               AND fc.contextid = f.contextid
             WHERE f.contextid = '1'
               AND f.active != '-9999'
          ORDER BY f.sortorder
SELECT
                    bi.id,
                    COALESCE(bp.id, bs.id) AS blockpositionid,
                    bi.blockname,
                    bi.parentcontextid,
                    bi.showinsubcontexts,
                    bi.pagetypepattern,
                    bi.requiredbytheme,
                    bi.subpagepattern,
                    bi.defaultregion,
                    bi.defaultweight,
                    COALESCE(bp.visible, bs.visible, 1) AS visible,
                    COALESCE(bp.region, bs.region, bi.defaultregion) AS region,
                    COALESCE(bp.weight, bs.weight, bi.defaultweight) AS weight,
                    bi.configdata
                    , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance

                FROM mdl_block_instances bi
                JOIN mdl_block b ON bi.blockname = b.name
                LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id
                                                  AND bp.contextid = '2'
                                                  AND bp.pagetype = 'admin-report-log-index'
                                                  AND bp.subpage = ''
                LEFT JOIN mdl_block_positions bs ON bs.blockinstanceid = bi.id
                                                  AND bs.contextid = '1'
                                                  AND bs.pagetype = 'admin-report-log-index'
                                                  AND bs.subpage = ''
                LEFT JOIN mdl_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = '80')

                WHERE
                (bi.parentcontextid IN ('2', '1') OR (bi.showinsubcontexts = 1 AND bi.parentcontextid = '1'))
                AND bi.pagetypepattern IN ('admin-report-log-index','admin-report-log-index-*','admin-report-log-*','admin-report-*','admin-*','*')
                AND (bi.subpagepattern IS NULL OR bi.subpagepattern = '')
                AND (bp.visible = 1 OR bp.visible IS NULL) AND (bs.visible = 1 OR bs.visible IS NULL)
                AND b.visible = 1
                AND (bi.requiredbytheme = 0)

                ORDER BY
                    COALESCE(bp.region, bs.region, bi.defaultregion),
                    COALESCE(bp.weight, bs.weight, bi.defaultweight),
                    bi.id
SELECT f.id
              FROM mdl_user_info_field f
         LEFT JOIN mdl_user_info_data d ON (d.fieldid = f.id AND d.userid = '2')
             WHERE f.required = 1 AND f.visible > 0 AND f.locked = 0 AND d.id IS NULL LIMIT 0, 1
SELECT COUNT(DISTINCT(m.conversationid))
                  FROM mdl_messages m
            INNER JOIN mdl_message_conversations mc
                    ON m.conversationid = mc.id
            INNER JOIN mdl_message_conversation_members mcm
                    ON mc.id = mcm.conversationid
             LEFT JOIN mdl_message_user_actions mua
                    ON (mua.messageid = m.id AND mua.userid = '2' AND mua.action = '1')
                 WHERE mcm.userid = '2'
                   AND mcm.userid != m.useridfrom
                   AND mua.id is NULL
SELECT count(id)
               FROM mdl_notifications
              WHERE id IN (SELECT notificationid FROM mdl_message_popup_notifications)
                AND useridto = '2'
                AND timeread is NULL
SELECT r.id, r.name, r.shortname, rn.name AS coursealias
          FROM (SELECT DISTINCT rc.roleid
                  FROM mdl_role_capabilities rc

                  ) idlist
          JOIN mdl_role r ON r.id = idlist.roleid
     LEFT JOIN mdl_role_names rn ON (rn.contextid = '2' AND rn.roleid = r.id)
      ORDER BY r.sortorder
SELECT COUNT('x') FROM mdl_course
SELECT id,shortname,fullname,category FROM mdl_course   ORDER BY fullname
SELECT u.id, u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.firstname,u.lastname
              FROM mdl_user u
              JOIN (SELECT DISTINCT eu1_u.id
              FROM mdl_user eu1_u

             WHERE 1 = 1 AND eu1_u.deleted = 0) je ON je.id = u.id
             WHERE u.deleted = 0 ORDER BY u.lastname, u.firstname, u.id LIMIT 0, 1001
SELECT COUNT('x') FROM mdl_logstore_standard_log WHERE anonymous = 0
SELECT * FROM mdl_logstore_standard_log WHERE anonymous = 0 ORDER BY timecreated DESC, id DESC LIMIT 0, 100
SELECT id,firstnamephonetic,lastnamephonetic,middlename,alternatename,firstname,lastname FROM mdl_user WHERE id = '2'
SELECT * FROM mdl_logstore_standard_log WHERE anonymous = 0 ORDER BY timecreated DESC, id DESC LIMIT 0, 100
SELECT * FROM mdl_user WHERE id = '2' AND deleted = '0'