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
WHERE rd_namespace = 0 # 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 -7 DAY)
AND rc_namespace = 0 # 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)
)
LIMIT 5;

SQL

Checking query status...