Links to redirects on Wikidata (recent)

SQL

USE wikidatawiki_p;
SELECT rc_namespace, rc_title
FROM redirect
JOIN recentchanges ON rc_cur_id = rd_from
JOIN page ON page_id = rc_cur_id
WHERE rd_namespace IN (0, 146)
AND rc_this_oldid = page_latest
#AND rc_timestamp BETWEEN DATE_ADD(NOW(), INTERVAL -28 DAY) AND DATE_ADD(NOW(), INTERVAL -14 DAY)
AND rc_timestamp < DATE_ADD(NOW(), INTERVAL -14 DAY)
AND rc_namespace IN (0, 146)
AND EXISTS (
  SELECT 1 FROM pagelinks WHERE pl_title = rc_title AND pl_namespace = rc_namespace AND pl_from_namespace IN (0, 120, 146)
);

SQL

Checking query status...