Untitled query #8270

SQL

USE wikidatawiki_p;

SELECT CONCAT('Q', otherlang.term_entity_id) AS 'qid', otherlang.term_text AS 'otherlang'
FROM wb_terms AS otherlang
LEFT JOIN wb_terms AS en ON (
	en.term_entity_id = otherlang.term_entity_id
	AND en.term_language = 'en'
	AND en.term_entity_type = 'item'
	AND en.term_type = 'label'
)
WHERE otherlang.term_language = 'mt'
AND otherlang.term_entity_type = 'item'
AND otherlang.term_type = 'label'
AND en.term_text IS NULL
limit 50 ;

-- use commonswiki_p;
-- select * from page
-- where page_title like "%ћ%"
-- -- and not page_namespace in (2, 3)
-- -- and not ((page_namespace = 0 and page_title="/")
-- ;
SQL

Checking query status...
