Categorized user pages (cswiki)

SQL

USE wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS entity, ips_site_id, ips_site_page
FROM wb_items_per_site
LEFT JOIN wb_terms
ON term_full_entity_id = CONCAT('Q', ips_item_id) AND term_type = 'label' AND SUBSTRING_INDEX(ips_site_id, 'wik', 1) = term_language
WHERE term_text IS NULL
AND ips_site_id NOT LIKE '%&_%' ESCAPE '&'
AND ips_site_id NOT LIKE 'alswik%'
#AND ips_site_id NOT LIKE 'bhwik%'
#AND ips_site_id NOT LIKE 'simplewik%'
#AND ips_site_id <> 'commonswiki'
#AND ips_site_id <> 'specieswiki'
LIMIT 100;

SQL

Checking query status...