Untitled query #46203

SQL

USE dewiki_p;
SELECT user_name, page_title, page_namespace, rev_timestamp
  FROM user, user_groups, actor, page, revision
 WHERE ug_group = 'interface-admin'
   AND ug_user = user_id
   AND user_id = actor_user
   AND rev_page = page_id
   AND 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(user_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_timestamp > '20180801000000' /* seit August 2018 */
                    AND rev_id >= 179624157 /* timestamp = 20180801000009 */
                )
SQL

Checking query status...
