Untitled query #68098

SQL

SELECT page_title, page_namespace, il_to
FROM page
JOIN imagelinks
ON page_id = il_from
WHERE (NOT EXISTS(
SELECT 1
FROM image
WHERE img_name = il_to))
AND (NOT EXISTS(
SELECT
1
FROM commonswiki_p.page
WHERE page_title = il_to
AND page_namespace = 6))
AND (page_namespace = 0 or page_namespace%2 = 1 or page_namespace = 2 or page_namespace = 10 or page_namespace = 100)
AND il_to not in (select page_title from page where page_title = il_to and page_is_redirect = 1 and page_namespace = 6)"
AND page_title not like "%.js""
AND page_title not like "%.css";
SQL

Checking query status...
