Links to redirects on Wikidata (recent)

SQL

USE wikidatawiki_p;
SELECT page_namespace, page_title
FROM redirect
JOIN revision ON rev_page = rd_from
JOIN page ON page_id = rev_page
WHERE rd_namespace = 0 # IN (0, 146)
AND rev_id = page_latest
AND rev_timestamp BETWEEN DATE_ADD(NOW(), INTERVAL -28 DAY) AND DATE_ADD(NOW(), INTERVAL -14 DAY)
AND page_namespace = 0 # IN (0, 146)
#AND page_is_redirect = 1
AND EXISTS (
  SELECT 1 FROM pagelinks WHERE pl_title = page_title AND pl_namespace = page_namespace AND pl_from_namespace IN (0, 120) #, 146)
)
LIMIT 5;

SQL

Checking query status...