Voci né in en.wiki né in it.wiki per numero di interlink

SQL

USE wikidatawiki_p;
SELECT CONCAT('* ', COUNT(ips_item_id), ' - [[Q', ips_item_id, ']]') 
FROM wb_items_per_site 
WHERE ips_site_id LIKE '%wiki'
AND NOT ips_site_id='wikidatawiki'
AND NOT ips_site_id='commonswiki'
GROUP BY ips_item_id 
HAVING COUNT(ips_item_id) > 19
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_id='itwiki')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_id='enwiki')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Template:%', 'Category:%', 'Module:%', 'Wikimedia:%')
ORDER BY COUNT(ips_item_id) DESC;

SQL

Checking query status...