I have a list of 250 Wikidata Item ID which I suspect of being redirects. What would be the easiest way to check if they are and to what page they are redirecting. For example for Q817614 I would like to get Q15123417
Topic on Talk:Quarry
Something like this:
USE wikidatawiki_p;
SELECT page_title, rd_title FROM page
LEFT JOIN redirect ON rd_from = page_id
WHERE page_namespace = 0
AND page_title IN (
"Q1", "Q2", # ...
)
Excellent, That worked great. Thanks