SELECT

    user_name,

    page_title,

    page_namespace,

    rev_timestamp

FROM

    user,

    user_groups,

    actor

        LEFT JOIN revision

        INNER JOIN page

            ON rev_page = page_id

            ON rev_id = (

              SELECT

                  MAX(maxR.rev_id)

              FROM

                  revision_userindex AS maxR,

                  page AS maxP

              WHERE

                  (maxP.page_content_model IN ('css', 'javascript')

                    AND (

                      maxP.page_title NOT LIKE CONCAT(REPLACE(actor_name, ' ', '_'), '/%')

                      OR maxP.page_namespace NOT IN (2,3)

                    )

                    OR maxP.page_namespace IN (8, 2302) /* MediaWiki, Gadget-Definition */

                  )

                  AND maxR.rev_page = maxP.page_id

                  AND maxR.rev_actor = actor_id

                  AND rev_id >= 719000000 /* > timestamp roughly 20180800000000 */

            )

WHERE

    ug_group = 'interface-admin'

    AND ug_user = user_id

    AND user_id = actor_user

;