TEST 7 - Quarry

SQL

SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id, '?action=history') AS item, wbxl_language, wbx_text, page_latest
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
JOIN page ON page_namespace = 0 AND CONCAT('Q', wbit_item_id) = page_title
WHERE wby_name = 'description'
#AND LENGTH(wbx_text) = 1
#AND wbx_text LIKE "_"
#AND wbx_text RLIKE "^.$"
#AND wbx_text NOT RLIKE "\p{Han}"
AND wbx_text IN (
  'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', 'é',
  'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'é',
  '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '.', ',', ':', ';', '!', '?', '(', ')', '_', '-', '*', '&', '@', '#', '~', '/', '\\',
  "'", '"', '$', '×', '÷', '´', 'ˇ', '%'
)
 LIMIT 5;
SQL

Checking query status...
