Untitled query #85895

SQL

SELECT
  p1.page_namespace,
  CASE 
    WHEN p1.page_namespace = 0 THEN CONCAT('https://wikidata.org/wiki/', p1.page_title)
    WHEN p1.page_namespace = 1 THEN CONCAT('https://wikidata.org/wiki/Talk:', p1.page_title)
    ELSE CONCAT('https://wikidata.org/wiki/', p1.page_title)
  END AS page_title
FROM redirect AS rd
JOIN page p1
ON rd.rd_from = p1.page_id
LEFT JOIN page AS p2
ON rd.rd_namespace = p2.page_namespace
AND rd.rd_title = p2.page_title
WHERE rd.rd_namespace >= 0
AND p2.page_namespace IS NULL
ORDER BY p1.page_namespace ASC;
SQL

Checking query status...
