Query test 4 - Quarry

SQL

USE wikidatawiki_p;

SELECT page_id FROM page WHERE page_namespace = 120

/*
SELECT CONCAT('* [[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'
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_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:%')
*/
LIMIT 10;
SQL

Checking query status...
