Statistics of editing MediaWiki JS/CSS in ruwiki (all-time)

Fork of Statistics of editing MediaWiki JS/CSS in ruwiki (all-time) by Stjn

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

SQL

USE ruwiki_p;
SELECT
	rev_user_text,
    rev_comment, -- если правка одна, видно, что
    page_title, -- и где,
    rev_timestamp -- и когда,
    -- если много - отображается случайная
FROM revision
JOIN page ON page_id = rev_page
WHERE 
    page_namespace != 8 AND
    (page_title LIKE '%.css' OR
    page_title LIKE '%.js')
and not rev_comment like "переименовал%"
and not rev_comment like "%быстрое удаление%"
and not page_title like "%common.%"
and exists
 (select * from user
  where rev_user_text = user_name
  and exists
  (select * from user_groups
   where user_id = ug_user
   and ug_group = 'sysop'))
and rev_user_text in ("Wanderer777", "A.Vajrapani", "Grebenkov", "TenBaseT")hk

SQL

Checking query status...