Edits by Wikisaurus using engineer flag in ruwiki

Fork of Statistics of editing MediaWiki JS/CSS in ruwiki by Wikisaurus

This query is marked as a draft This query has been published by Wikisaurus.

SQL

USE ruwiki_p;
SELECT rev_timestamp,
  CONCAT(SELECT page_namespace, (CASE
	WHEN page_namespace = 10 THEN 'Template'
	WHEN page_namespace = 828 THEN 'Module'
	END) AS nsnm, ':', page_title),
  (SELECT comment_text FROM comment WHERE comment_id = rev_comment_id) AS cmnt
FROM (SELECT *
FROM revision_userindex
WHERE rev_actor = 5758
   AND rev_timestamp > "20200927"
   ) AS revs
JOIN (SELECT *
FROM page
WHERE (page_namespace = 10
   OR page_namespace = 828)
   AND EXISTS (
        SELECT
            1
        FROM page_restrictions
        WHERE pr_page = page_id
            AND pr_type = 'edit'
            AND pr_level = 'sysop'
        )
   ) AS pgs
ON page_id = rev_page
LIMIT 1000

SQL

Checking query status...