~ - Quarry

SQL

use cswiki_p;
SELECT page_namespace, page_title FROM page WHERE page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to LIKE "Monitoring:Články_přeložené_z_%wiki" AND NOT EXISTS (SELECT * FROM langlinks WHERE ll_from = cl_from AND ll_lang = SUBSTRING_INDEX(SUBSTRING_INDEX(cl_to, "_", -1), "wiki", 1))) AND page_namespace = 0 ORDER BY page_id DESC;
select page_namespace, page_title from page where page_id in (select cl_from from categorylinks where cl_to like 'Monitoring:Články_přeložené_z_%wiki' and not exists (select * from langlinks where ll_from like cl_from and ll_lang like substring_index(substring_index(cl_to, '_', -1), 'wiki', 1))) and page_namespace like 0 order by page_id desc;
SQL

Checking query status...
