wikidatawiki Entity redirects with text terms in DB

Fork of wikidatawiki Entity redirects with text terms in DB by Bdijkstra

This query is marked as a draft This query has been published by Arjunaraoc.

SQL

SELECT
	page_title AS 'item-id',
    page_links_updated AS 'links-updated',
    GROUP_CONCAT(DISTINCT wby_name) AS type,
    GROUP_CONCAT(DISTINCT 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
GROUP BY page_title

SQL

Checking query status...