Wikidata items with their own item ID as label, description or alias

SQL

SELECT wbx_text, wby_name, wbxl_language
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
JOIN wbt_type ON wbtl_type_id = wby_id
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE (
  wbx_text LIKE 'Q1%'
  OR wbx_text LIKE 'Q2%'
  OR wbx_text LIKE 'Q3%'
  OR wbx_text LIKE 'Q4%'
  OR wbx_text LIKE 'Q5%'
  OR wbx_text LIKE 'Q6%'
  OR wbx_text LIKE 'Q7%'
  OR wbx_text LIKE 'Q8%'
  OR wbx_text LIKE 'Q9%'
)
AND CONCAT('Q', wbit_item_id) = wbx_text;

SQL

Checking query status...