Untitled query #3259

SQL

USE wikidatawiki_p;
/* DESCRIBE wb_entity_per_page;*/
SELECT pagelinks1.pl_from, pagelinks2.pl_from, ips1.ips_site_id, ips1.ips_site_page, ips2.ips_site_id, ips2.ips_site_page
FROM wb_entity_per_page AS epp1
	JOIN wb_entity_per_page AS epp2 ON epp2.epp_entity_id = epp1.epp_entity_id
	JOIN pagelinks AS pagelinks1 ON pagelinks1.pl_from = epp1.epp_page_id AND pagelinks1.pl_title = "Q4167836"
	JOIN wb_items_per_site AS ips1 ON ips1.ips_item_id = epp1.epp_entity_id AND ips1.ips_site_id = "cswiki"
	JOIN pagelinks AS pagelinks2 ON pagelinks2.pl_from = epp2.epp_page_id AND pagelinks2.pl_title = pagelinks1.pl_title
	JOIN wb_items_per_site AS ips2 ON ips2.ips_item_id = epp2.epp_entity_id AND ips2.ips_site_id = "skwiki"
WHERE REPLACE(ips1.ips_site_page,"Kategorie:","") = REPLACE(ips2.ips_site_page,"Kategória:","")
LIMIT 10;
SQL

Checking query status...
