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 CURRENT_DATE As updated;

SELECT CONCAT('Q',ips_item_id), COUNT(ips_site_id)
FROM pagelinks, wb_items_per_site, wb_entity_per_page
WHERE 	pl_from_namespace=0 AND pl_namespace=120 AND pl_title='P21'
        AND pl_from NOT IN (SELECT pl_from FROM wikidatawiki_p.page JOIN wikidatawiki_p.pagelinks 
        			ON page_id=pl_from WHERE pl_title = "P569" AND pl_namespace = 120)         
AND epp_page_id = pl_from
AND epp_entity_id = ips_item_id 
GROUP BY pl_from
ORDER BY COUNT(ips_site_id) DESC
HAVING COUNT(ips_site_id) >3
LIMIT 100
SQL

Checking query status...
