USE ruwiki_p;

SELECT

    rev_user_text,

    rev_comment, -- если правка одна, видно, что

    page_namespace,

    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 not page_title like "%vector.%"

and not page_title like "%monobook.%"

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")