Untitled query #62065

SQL

SELECT CONCAT('* ', COUNT(ips_item_id), ' - [[',ips_site_page,']] - [[d:Q', ips_item_id, ']]') 
FROM wb_items_per_site 
WHERE ips_site_id LIKE '%wikivoyage'
AND NOT ips_site_id='wikidatawiki'
AND NOT ips_site_id='commonswiki'
GROUP BY ips_item_id 
HAVING COUNT(ips_item_id) > 10
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_id='itwikivoyage')
AND ips_item_id IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Help:%')
/*
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Template:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Category:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Module:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Wikimedia:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Special:%')
*/
ORDER BY COUNT(ips_item_id) DESC;
SQL

Checking query status...
