Untitled query #51829

SQL

use tewiki_p;

SELECT DISTINCT page.page_title, iwlinks.iwl_prefix, iwlinks.iwl_title
FROM page
# 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...
