Untitled query #6156

SQL

USE wikidatawiki_p;

SELECT CONCAT('Q',ukvoy.ips_item_id) AS ID, count(ukvoy.ips_site_id) AS Qty, ukvoy.ips_site_page AS Art
FROM   (SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id LIKE '%wikivoyage') AS allvoy,
(SELECT ips_item_id, ips_site_page, ips_site_id FROM wb_items_per_site WHERE ips_site_id = 'ukwikivoyage') AS ukvoy
WHERE allvoy.ips_item_id NOT IN (SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'itwikivoyage')
AND allvoy.ips_item_id = ukvoy.ips_item_id
AND ips_site_page NOT LIKE '%:%'
GROUP BY ukvoy.ips_item_id
ORDER BY Qty DESC
SQL

Checking query status...
