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 ips_site_id, Count(*)
#plfrom, ips_site_id, ips_site_page 
FROM pagelinks AS pl1, wb_items_per_site, wb_entity_per_page 
WHERE pl1.pl_from_namespace=0 AND pl1.pl_namespace=0 AND pl1.pl_title="Q21160456" 
AND epp_page_id = pl1.pl_from 
AND epp_entity_id = ips_item_id 
AND ips_site_id NOT LIKE '%quote%'
AND ips_site_id NOT LIKE '%news%'
AND ips_site_id NOT LIKE '%source%'
AND ips_site_id NOT LIKE '%commons%'
GROUP BY ips_site_id
ORDER BY COUNT(*) DESC
#GROUP BY pl1.pl_from
#LIMIT 10
SQL

Checking query status...
