Untitled query #21592

SQL

USE mhrwiki_p;
SELECT page_title
FROM page
INNER JOIN categorylinks AS cl ON page_id = cl_from AND cl_to != "Тиштер_почеш_илымверла" AND cl_to != "Еҥ-влак" 
	AND cl_to != "Шрифт"
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
  SELECT ll_from FROM langlinks AS ll WHERE ll_lang = "et")
#AND page_title NOT IN (
#)

#AND page_title NOT IN (SELECT pp_page FROM page_props INNER JOIN page ON page_id = pp_page AND pp_propname = 'disambiguation')

/*AND page_id IN (
  SELECT ll_from FROM langlinks AS ll WHERE ll_lang = "fi")
AND page_id NOT IN (
  SELECT ll_from FROM langlinks AS ll WHERE ll_lang = "en")
AND page_title NOT LIKE "%,%вич" */
GROUP BY page_title
ORDER BY page_title ASC
#ORDER BY page_len DESC
LIMIT 200;
SQL

Checking query status...
