Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
use wikidatawiki_p; 

SELECT CONCAT("Q",ips_item_id) as item, COUNT(ips_site_id) as cnt, GROUP_CONCAT(REPLACE(ips_site_id,"wiki","") ORDER BY ips_site_id) as sites FROM pagelinks AS pl1, pagelinks AS pl2, wb_items_per_site, wb_entity_per_page WHERE pl1.pl_from_namespace=0 AND pl1.pl_namespace=120 AND pl1.pl_title="P21" AND pl2.pl_from_namespace=0 AND pl2.pl_namespace=0 AND pl2.pl_title="Q5" AND pl1.pl_from NOT IN (SELECT pl_from FROM wikidatawiki_p.page JOIN wikidatawiki_p.pagelinks ON page_id=pl_from WHERE pl_title in ("P19","P20","P551","P119","P937") AND pl_namespace = 120) AND epp_page_id = pl1.pl_from AND pl1.pl_from = pl2.pl_from AND epp_entity_id = ips_item_id GROUP BY pl1.pl_from HAVING COUNT(ips_site_id) >5 ORDER BY COUNT(ips_site_id) DESC LIMIT 650
SQL

Checking query status...
