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

Checking query status...
