Untitled query #15454

SQL

USE wikidatawiki_p; 
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 NOT RLIKE "\p{Han}"
AND wbx_text = 'scientific article' limit 10
SQL

Checking query status...
