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.