SQL
AخA
SELECT
*
FROM
page
INNER JOIN revision ON page_id = rev_page
INNER JOIN comment_logging c1 ON rev_comment_id = c1.comment_id
INNER JOIN logging_logindex ON log_page = page_id
INNER JOIN comment_revision c2 ON log_comment_id = c2.comment_id
WHERE
(
page_id = 13425800 -- [[War on terror]]
OR page_id = 26636311 -- [[War on Terrorism]]
OR page_id = 62438986 -- [[War on Terror]]
)
AND (
c1.comment_text LIKE "% moved page % to %"
OR c2.comment_text LIKE "% moved page % to %"
);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.