This query is marked as a draft This query has been published by ערן.

SQL

AخA
 
use wikidatawiki_p;
select ips_item_id, ips_site_page, term_text 
from wb_terms 
inner join wb_items_per_site 
on ips_item_id=term_entity_id
where 
    ips_site_id='hewiki' and
    term_language='he' and 
    term_type='label' and 
    lower(term_text)!=lower(ips_site_page )
    and ips_site_page not like '%(%' and
    ips_site_page not like '%:%'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...