SQL
AخA
use wikidatawiki_p;
SELECT CONCAT('*\\',ips_site_page,' \\ [[Q',ips_item_id,']]')
FROM wb_items_per_site
JOIN (SELECT * FROM pagelinks JOIN wb_entity_per_page ON epp_page_id = pl_from
WHERE pl_namespace = 120 and pl_title = "P625") as pl
ON ips_item_id = pl.epp_entity_id
where ips_site_id = "svwiki"
and ips_site_page in (SELECT REPLACE(page_title, '_', ' ')
FROM svwiki_p.page
join svwiki_p.categorylinks on cl_from=page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
and cl_to = "Robotskapade_Kinaartiklar")
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.