wikidatawiki Entity redirects with text terms in DB

SQL

SELECT page_title AS 'item-id', page_links_updated AS 'links-updated', wby_name AS type, wbxl_language AS lang, wbx_text AS text
FROM page, wbt_item_terms, wbt_term_in_lang, wbt_type, wbt_text_in_lang, wbt_text
WHERE page_namespace=0 AND page_is_redirect=1 AND page_links_updated NOT REGEXP '^2023' AND 
	CAST(SUBSTRING(page_title,2) AS INTEGER)=wbit_item_id AND wbit_term_in_lang_id=wbtl_id AND wbtl_type_id=wby_id AND 
    wbtl_text_in_lang_id=wbxl_id AND wbxl_text_id=wbx_id
;
SELECT page_title AS 'item-id', page_links_updated AS 'links-updated', wby_name AS type, wbxl_language AS lang, wbx_text AS text
FROM page, wbt_property_terms, wbt_term_in_lang, wbt_type, wbt_text_in_lang, wbt_text
WHERE page_namespace=120 AND page_is_redirect=1 AND page_links_updated NOT REGEXP '^2023' AND 
	CAST(SUBSTRING(page_title,2) AS INTEGER)=wbpt_item_id AND wbpt_term_in_lang_id=wbtl_id AND wbtl_type_id=wby_id AND 
    wbtl_text_in_lang_id=wbxl_id AND wbxl_text_id=wbx_id
SQL

Checking query status...
