enwiki: Translated pages with no language links

Fork of enwiki: Translated pages with no language links by Vahurzpu

This query is marked as a draft This query has been published by Kasyap.

SQL

USE tewiki_p;
SET max_statement_time = 300;

SELECT DISTINCT mainpage.page_title
FROM templatelinks
INNER JOIN page talkpage ON talkpage.page_id = templatelinks.tl_from
INNER JOIN page mainpage ON talkpage.page_title = mainpage.page_title
WHERE templatelinks.tl_title = "%మూలాలు లేవు%"
AND templatelinks.tl_namespace = 10
AND templatelinks.tl_from_namespace = 1
AND mainpage.page_namespace = 0
AND mainpage.page_is_redirect = 0
AND mainpage.page_id NOT IN (SELECT ll_from FROM langlinks)

SQL

Checking query status...