Untitled query #1276

SQL

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   wb_items_per_site, wb_entity_per_page 
WHERE  epp_entity_id <> "Q6293548"
AND 	epp_page_id NOT IN (SELECT pl_from FROM wikidatawiki_p.page 
                    JOIN wikidatawiki_p.pagelinks ON page_id=pl_from 
                        WHERE pl_title in ("P646","Q6256", "Q4167836", "Q20010800", "Q11266439", "Q19842659", "Q14204246", "Q15647814", "Q577", "Q14795564")) 
AND    epp_entity_id = ips_item_id
GROUP BY epp_page_id
HAVING COUNT(ips_site_id) >5 
ORDER BY COUNT(ips_site_id) DESC LIMIT 600
SQL

Checking query status...
