AfD closes by SoWhy

Fork of AfD closes by SoWhy by MusikAnimal

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

SQL

SELECT page_title, revs.rev_timestamp, revs.rev_comment,
       (CAST(revs.rev_len AS SIGNED) - IFNULL(parentrevs.rev_len, 0)) AS diff_size
FROM revision_userindex AS revs
LEFT JOIN revision_userindex AS parentrevs ON (revs.rev_parent_id = parentrevs.rev_id)
JOIN page ON revs.rev_page = page_id
WHERE revs.rev_user = 54890
AND page_namespace = 4
AND page_title RLIKE "Articles_for_deletion"
AND (
  (revs.rev_comment RLIKE "Closed as" AND revs.rev_comment RLIKE "XFDcloser") OR
  revs.rev_comment RLIKE "result was"
)
ORDER BY revs.rev_timestamp DESC
LIMIT 500

SQL

Checking query status...