Untitled query #51829

SQL

use tewiki_p;

SELECT DISTINCT page.page_title
FROM page 
where page.page_id NOT IN (SELECT iwl_from FROM iwlinks)
	and page.page_namespace = 10
/*where 
# INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
# INNER JOIN templatelinks ON page.page_id = templatelinks.tl_from
INNER JOIN iwlinks ON page.page_id = iwlinks.iwl_from
WHERE page.page_namespace = 10
	-- AND page.page_title LIKE 'A%'
	-- AND iwlinks.iwl_prefix = "en"
	AND page.page_title NOT LIKE "%/%"
	AND page.page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Interlanguage_link")
ORDER BY page.page_title
SQL

Checking query status...
