Oberflächenadmin-Aktionen

SQL

USE dewiki_p;
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(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 */
                                             )
 WHERE ug_group = 'interface-admin'
   AND ug_user = user_id
   AND user_id = actor_user
SQL

Checking query status...
