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 AND page_namespace = 0 AND page_is_redirect = 0
    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 cp.page_title from cebwiki_p.page cp 
                                                JOIN cebwiki_p.categorylinks ON cl_from = cp.page_id
                            where cp.page_namespace = 0 AND cp.page_is_redirect = 0 AND cl_to = "Geobox_usage_tracking_for_other_type" )
#GROUP BY total.pl_from
SQL

Checking query status...
