Untitled query #21091

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",stl.ips_item_id) AS item, stl.ips_site_page
	FROM (SELECT * FROM pagelinks WHERE pl_title = "Q4167410" AND pl_from_namespace = 0) AS total
    JOIN page ON page_id = pl_from
    JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cebwiki") AS stl on CONCAT("Q",ips_item_id) = page_title
WHERE stl.ips_site_page in (select c.page_title from cebwiki_p.page c JOIN cebwiki_p.categorylinks where 
                            c.cl_to = "Geobox_usage_tracking_for_other_type" )
GROUP BY total.pl_from
SQL

Checking query status...
