Untitled query #46953

SQL

USE dewiki_p;

SELECT p.page_id, p.page_title, el.el_to as link, rev.rev_id as diff, prev_rev.rev_id as oldid
  FROM page as p
  JOIN externallinks as el ON el.el_from = p.page_id
  JOIN revision as rev ON rev.rev_page = p.page_id
  JOIN revision as prev_rev ON prev_rev.rev_id = rev.rev_parent_id
  JOIN text as oldtext ON prev_rev.rev_text_id = oldtext.old_id
  WHERE p.page_namespace = 0
  AND rev.rev_timestamp > 20200726091010 -- YYYYMMDDhhmmss
  AND rev.rev_timestamp < 20200726101010 -- YYYYMMDDhhmmss
  AND CHARINDEX(el.el_to, oldtext.old_id) = 0
  LIMIT 5
SQL

Checking query status...
