Lugnuts article restrictions

Mainspace edits by Lugnuts at or after 2022-07-01 00:00:00 UTC which are either new pages or to pages created by someone else.

For [[WT:Arbitration/Requests/Case/Conduct in deletion-related editing/Proposed decision#Comments by Cryptic]] circa 2022 July 31.

SQL

SELECT CONCAT('[[Special:Diff/', revedit.rev_id, ']]') AS diff,
       DATE_FORMAT(revedit.rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
       CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS pagename,
       actcreator.actor_name AS creator,
       CAST(revedit.rev_len - revparent.rev_len AS INT) AS delta,
       comment_text AS 'edit summary'
FROM revision_userindex AS revedit
JOIN actor_revision AS actedit
  ON actedit.actor_id = revedit.rev_actor
LEFT JOIN revision AS revparent
  ON revparent.rev_id = revedit.rev_parent_id
LEFT JOIN comment_revision
  ON comment_id = revedit.rev_comment_id
JOIN page
  ON page_id = revedit.rev_page
LEFT JOIN revision AS revcreator
  ON revcreator.rev_page = revedit.rev_page
    AND revcreator.rev_parent_id = 0
LEFT JOIN actor_revision AS actcreator
  ON actcreator.actor_id = revcreator.rev_actor
WHERE page_namespace = 0
  AND revedit.rev_timestamp >= '20220730'
  AND actedit.actor_name = 'Lugnuts'
  AND (COALESCE(actcreator.actor_name, '') != 'Lugnuts'
       OR revedit.rev_id = revcreator.rev_id);

SQL

Checking query status...