kategori bazlı eksik sayfalar

SQL

USE trwiki_p;
SELECT (SELECT ll_title FROM langlinks WHERE ll_from = page_id AND ll_lang != "tr") AS "Ad"
FROM page
WHERE page_namespace = 0
AND (SELECT cl_to FROM categorylinks WHERE cl_from = LIKE "Online_food_ordering")
AND EXISTS (SELECT * FROM langlinks WHERE ll_from = page_id AND ll_lang = "en"
AND EXISTS (SELECT * FROM enwiki_p.page AS p1 WHERE p1.page_namespace = 0 AND p1.page_title = replace(ll_title, " ", "_")
            AND p1.page_len > 5119))
AND NOT EXISTS (SELECT * FROM langlinks WHERE ll_from = page_id AND ll_lang = "tr")
ORDER BY page_title
SQL

Checking query status...
