Find articles linking to redirects with misspellings on nlwiki

SQL

SELECT DISTINCT
  CONVERT(p2.page_title USING utf8) AS "VerwijzendArtikel"
FROM page AS p1
JOIN categorylinks
  ON p1.page_id = cl_from
JOIN linktarget
  ON p1.page_title = lt_title
  AND lt_namespace = 0
JOIN pagelinks
  ON lt_id = pl_target_id
JOIN page AS p2
  ON pl_from = p2.page_id
  AND p2.page_namespace = 0
WHERE p1.page_namespace = 0
  AND p1.page_is_redirect = 1
  AND cl_to = 'Wikipedia:Redirect_voor_spelfout'
LIMIT 1000;

​x
 
SELECT DISTINCT  CONVERT(p2.page_title USING utf8) AS "VerwijzendArtikel"FROM page AS p1JOIN categorylinks  ON p1.page_id = cl_fromJOIN linktarget  ON p1.page_title = lt_title  AND lt_namespace = 0JOIN pagelinks  ON lt_id = pl_target_idJOIN page AS p2  ON pl_from = p2.page_id  AND p2.page_namespace = 0WHERE p1.page_namespace = 0  AND p1.page_is_redirect = 1  AND cl_to = 'Wikipedia:Redirect_voor_spelfout'LIMIT 1000;​

SQL

Checking query status...