User:Akkakk/issues/deprecated-languages/de-formal

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 = "de" and def.term_language = "de-formal" and de.term_type != "alias" and de.term_text != def.term_text limit 100;