Untitled query #4162

SQL

USE wikidatawiki_p;




SELECT ips_item_id, ips_site_id, ips_site_page, term_text

FROM wb_items_per_site
JOIN wb_terms AS label ON label.term_entity_id = ips_item_id AND label.term_type = 'description'

WHERE ips_site_page LIKE 'Now That''s What I Call Music%'
AND term_language = 'en'
AND ips_site_id = 'enwiki'

AND NOT (ips_site_page LIKE '%Israel%' AND term_text LIKE '%Israel%')
AND NOT (ips_site_page LIKE '%UK%' AND term_text LIKE '%UK%')
AND NOT (ips_site_page LIKE '%U.S.%' AND term_text LIKE '%USA%')
AND NOT (ips_site_page LIKE '%N.Z.%' AND term_text LIKE '%New Zealand%')
AND NOT (ips_site_page LIKE '%Asia%' AND term_text LIKE '%Asia%')
AND NOT (ips_site_page LIKE '%Canada%' AND term_text LIKE '%Canada%')
AND NOT (ips_site_page LIKE '%South Africa%' AND term_text LIKE '%South Africa%')

;
SQL

Checking query status...
