Map category name in hewiki to Wikidata QID

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

SQL

select pp_value,hepage.page_title from page hepage inner join enwiki_p.page enpage on enpage.page_namespace=14 and enpage.page_title=concat('Plants_described_in_', right(hepage.page_title,4)) inner join enwiki_p.page_props on pp_page=enpage.page_id and pp_propname='wikibase_item' left join langlinks on ll_from=hepage.page_id where  hepage.page_title like 'צמחים_שתואר%' and hepage.page_namespace=14 and ll_from is NULL

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...