Hebrew-English page info

This query is marked as a draft This query has been published by Livnetata.

SQL

SELECT hebrew_id, hebrew_title, en.page_id as english_id, english_title
FROM 
	(SELECT ll_from as hebrew_id, page_title as hebrew_title, REPLACE(ll_title, ' ','_') as english_title
     FROM hewiki_p.langlinks 
     LEFT JOIN hewiki_p.page
     ON page_id = ll_from
     WHERE page_namespace = 0
     AND ll_lang = "en" 
     AND page_is_redirect = 0) as he
	LEFT JOIN enwiki_p.page as en
	ON he.english_title = en.page_title
	WHERE en.page_namespace = 0
;

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...