# 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='de'

  AND wbx_text LIKE '%Landkeis%';

  #AND wbx_text REGEXP '.* \\| ([A-Za-z0-9\\(\\)\\-\\. ]) View Book'

#LIMIT 10;