Untitled query #28299

SQL

USE wikidatawiki_p;
SELECT
  rc_namespace,
  rc_title
FROM
  recentchanges
  JOIN page ON rc_cur_id = page_id
  JOIN comment ON rc_comment_id = comment_id
WHERE
  rc_namespace = 0
  AND page_is_redirect = 0
  AND (
    rc_source = 'mw.new'
    OR COALESCE(rc_comment, comment_text, '') LIKE '%wbsetsitelink-add%'
    OR COALESCE(rc_comment, comment_text, '') LIKE '%wbeditentity-update%dded%[[%:%]]%'
  )
  AND rc_timestamp BETWEEN DATE_ADD(NOW(), INTERVAL -14 DAY)
  AND DATE_ADD(NOW(), INTERVAL -7 DAY)
#ORDER BY rc_timestamp
LIMIT 1;
SQL

Checking query status...
