nlwiki Anomalies with "IJ"

1. Finds red links that start with "Ij" while a blue link exists with "IJ".
2. Finds pages that start with "IJ", without a redirect to it(s target) that start with "Ij"

TODO: use pagelinks to find actual links.

SQL

USE nlwiki_p;
SELECT 
	page_namespace AS 'src-ns', page_title AS 'src-title', 
	pl_namespace AS 'tgt-ns', pl_title AS 'tgt-title'
FROM `pagelinks`, `page` ps
WHERE 
	pl_namespace NOT IN (2,3) AND 			# no links to user namespaces
	pl_title REGEXP '^Ij' AND		# target title starts with 'Ij'
	NOT EXISTS (					# target page doesn't exist
		SELECT * FROM `page` pt WHERE pt.page_namespace=pl_namespace AND pt.page_title=pl_title
	) AND
	EXISTS (						# correctly capitalized target does exist
		SELECT * FROM `page` pt WHERE pt.page_namespace=pl_namespace AND pt.page_title=BINARY CONCAT(_UTF8MB4 'IJ', SUBSTRING(pl_title, 3))
	) AND
	pl_from=ps.page_id 				# join to acquire source page title
ORDER BY pl_title

SQL

Checking query status...