Untitled query #3259

SQL

USE wikidatawiki_p;
/* DESCRIBE wb_entity_per_page;*/
SELECT epp1.epp_entity_id, epp2.epp_entity_id, pagelinks1.pl_from, /* pagelinks2.pl_from, */ ips1.ips_site_page /* , 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 = "Q4167836"
	JOIN wb_items_per_site AS ips2 ON ips2.ips_item_id = epp2.epp_entity_id AND ips2.ips_site_id = "skwiki"*/
LIMIT 1;
SQL

Checking query status...
