SQL
AخA
USE svwiki_p;
SELECT page_title, pp_value
FROM (SELECT * FROM page WHERE page_is_redirect = 1 AND page_namespace = 0) AS page
JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = page_id
JOIN categorylinks on page_id = cl_from
#JOIN templatelinks ON tl_from = page_id
WHERE cl_to = "Omdirigeringar_kopplade_till_Wikidata"
#and tl_namespace = 10 and tl_title like "Wikidata-omdirigering"
ORDER BY page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.