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

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.

Checking query status...