Untitled query #75379

SQL

USE zhwiki_p;
-- https://zh.wikipedia.org/w/index.php?title=%E6%9B%BE%E6%9D%8E%E9%9D%92&diff=prev&oldid=75627061

SELECT
  CONCAT('https://en.wikipedia.org/w/index.php?diff=', rev_id) AS diff_link,
  CONCAT('https://en.wikipedia.org/wiki/', page_title) AS article_link,
  page_title AS article_name,
  old_text.text AS old_text,
  new_text.text AS new_text
FROM
  revision
JOIN
  page ON rev_page = page_id
JOIN
  text AS old_text ON rev_text_id = old_text_id
JOIN
  text AS new_text ON rev_text_id = new_text_id
WHERE
  rev_user_text = 'Hbqxahz' -- 替换为要搜索的用户名称
  AND rev_timestamp > '20230700' -- 替换为要搜索的日期，格式为YYYYMMDD
  AND page_namespace = 0 -- 限制为条目空间
  AND (
    rev_comment LIKE '%{{birth %'
    OR rev_comment LIKE '%{{bd|%'
  )
ORDER BY
  rev_timestamp DESC;
SQL

Checking query status...
