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, page_title, 
	pl_namespace, pl_title
FROM (
	SELECT *
	FROM `pagelinks`
	WHERE 
		pl_namespace=0 AND 			# only links to main namespace
		pl_title REGEXP '^Ij' AND	# target title starts with 'Ij'
		NOT EXISTS (					# target page doesn't exist
			SELECT * FROM `page` WHERE page_namespace=pl_namespace AND page_title=pl_title
		) AND
		EXISTS (							# correctly capitalized target does exist
			SELECT * FROM (
				SELECT page_namespace, page_title FROM `page` WHERE page_namespace=0 AND page_title REGEXP '^I[Jj]'
			) ijpage WHERE page_title=BINARY CONCAT(_UTF8MB4 'IJ', SUBSTRING(pl_title, 3))
		)
	) pl, `page`
WHERE pl_from=page_id 				# join to acquire source page title
ORDER BY pl_title

SQL

Checking query status...