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((CASE
	WHEN page_namespace = 8 THEN 'Mediawiki:'
	WHEN page_namespace = 10 THEN 'Шаблон:'
	WHEN page_namespace = 828 THEN 'Модуль:'
	END), page_title) AS page_name,
  (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'
      ))
   OR page_namespace = 8
   ) AS pgs
ON page_id = rev_page
ORDER BY rev_timestamp DESC
LIMIT 1500

SQL

Checking query status...