nlwiki brokenimages

SQL

use nlwiki_p;

SELECT page_namespace, page_title, il_to
	FROM imagelinks
	JOIN page on page_id = il_from
	WHERE
# Not an image on the local wiki...
		NOT EXISTS (SELECT * FROM image WHERE img_name = il_to)
# Not an image on commons...
		AND NOT EXISTS (SELECT * FROM commonswiki_p.image WHERE img_name = il_to)
# Not a redirect on the local wiki...
		AND NOT EXISTS (SELECT * FROM page WHERE page_namespace = 6
					AND page_title = il_to)
# Not a redirect on commons...
		AND NOT EXISTS (SELECT * FROM commonswiki_p.page WHERE page_namespace = 6
					AND page_title = il_to)
	ORDER BY page_namespace ASC LIMIT 1000
SQL

Checking query status...
