Untitled query #71426

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=wbt_term_in_lang.wbtl_id
    LEFT JOIN wbt_type ON wbtl_type_id=wbt_type.wby_id
    LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id=wbt_text_in_lang.wbxl_id
    LEFT JOIN wbt_text ON wbxl_text_id=wbt_text.wbx_id
WHERE
  wbt_type.wby_name='label' OR wbt_type.wby_name='alias'
  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 LIKE 'xxx%'
  #wbx_text REGEXP '.*eißrussische.*';
  #wbx_text REGEXP '.*verified handles.*';
  
limit 10
SQL

Checking query status...
