Untitled query #4162

SQL

USE wikidatawiki_p;




SELECT CONCAT("* [[Q",ips_item_id,"]]"), ips_site_id, ips_site_page, term_text

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

WHERE ips_site_page LIKE 'Now% Music%'
AND (term_language IS NULL OR term_language = 'en')
AND ips_site_id = 'enwiki'

AND (term_text IS NULL OR (
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%')

AND term_text NOT LIKE 'Wiki_edia disambiguation page'
)
)
;




SELECT * from revision
-- min(rc_timestamp) FROM recentchanges
-- WHERE rc_comment LIKE '%Now%Music%N.Z.%'
LIMIT 10;

;
SQL

Checking query status...
