wikidata: search for terms (new schema)

SQL

# https://doc.wikimedia.org/Wikibase/master/php/md_docs_storage_terms.html
SELECT
  CONCAT('Q', wbit_item_id) AS qid,
  wby_name AS type,
  wbxl_language AS lang,
  wbx_text AS text
FROM
  wbt_item_terms
    LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id=wbtl_id
    LEFT JOIN wbt_type ON wbtl_type_id=wby_id
    LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id=wbxl_id
    LEFT JOIN wbt_text ON wbxl_text_id=wbx_id
WHERE
  #wby_name='description'
  #AND
  wbxl_language='en'
  AND
  #wbx_text REGEXP '.*\\.org\\/w\\/index\\.php\\?title=.*';
  wbx_text REGEXP '.*a r c h i v e.*';
  #wbx_text REGEXP '.*eißrussische.*';
SQL

Checking query status...
