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 enwiki_p.cl_to FROM enwiki_p.categorylinks WHERE enwiki_p.cl_from = RLIKE "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...
