User:Akkakk/issues/deprecated-languages/zh-min-nan

From Wikidata
Jump to navigation Jump to search

select concat("[[Q", de.term_entity_id, "]]") as item, de.term_type, de.term_language, de.term_text, def.term_language, def.term_text from wb_terms as de join wb_terms as def on de.term_entity_id = def.term_entity_id and de.term_type = def.term_type where de.term_entity_type = "item" and def.term_entity_type = "item" and de.term_language = "nan" and def.term_language = "zh-min-nan" and de.term_type != "alias" and de.term_text != def.term_text order by de.term_entity_id limit 100;