Untitled query #21087

SQL

USE wikidatawiki_p;
SELECT DISTINCT
	CONCAT("Q", molabel.term_entity_id) AS qid,
	molabel.term_type,
	molabel.term_text AS molabel,
	rolabel.term_text AS rolabel
FROM wb_terms molabel
LEFT JOIN wb_terms rolabel ON rolabel.term_entity_id = molabel.term_entity_id

WHERE molabel.term_entity_type = 'item'
AND molabel.term_language = 'mo'
AND molabel.term_type = 'label'

AND rolabel.term_type = molabel.term_type
AND rolabel.term_entity_type = 'item'
AND rolabel.term_language = 'ro'

AND (
	rolabel.term_text IS NULL
	OR rolabel.term_text != molabel.term_text
)

ORDER BY molabel.term_entity_id;
SQL

Checking query status...
