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

SQL

​x
 
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 AS INT) - CAST(COALESCE(revparent.rev_len, 0) 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 >= '20220701'
  AND actedit.actor_name = 'Lugnuts'
  AND (COALESCE(actcreator.actor_name, '') != 'Lugnuts'
       OR revedit.rev_id = revcreator.rev_id);
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...