nlwiki East Java desas without language links

SQL

SELECT page_title, REPLACE(cl_sortkey_prefix,' ','') AS 'desacode'
FROM categorylinks, page
WHERE cl_to='Wikipedia:Indonesische_plaats_naar_code' AND cl_from=page_id AND page_namespace=0 AND cl_sortkey_prefix REGEXP '^35'
	AND NOT EXISTS (SELECT * FROM langlinks WHERE page_id=ll_from)
ORDER BY page_title;

SELECT
	page_title, 
    (SELECT REPLACE(cl_sortkey_prefix,' ','') FROM categorylinks WHERE cl_to='Wikipedia:Indonesische_plaats_naar_code' AND cl_from=page_id) AS 'desacode'
FROM categorylinks, page
WHERE page_namespace=0 AND cl_from=page_id AND cl_to='Plaats_in_Oost-Java' AND NOT EXISTS (SELECT * FROM langlinks WHERE page_id=ll_from)
ORDER BY page_title;

SQL

Checking query status...