Zion draft - Quarry

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

SQL

set @category = "People from Dublin (city)";

select page_title as "ערך", page_is_redirect as "הפניה", page_len as "גודל", ll_title as "שם בעברית"
from enwiki_p.page join enwiki_p.categorylinks join enwiki_p.langlinks
on cl_to = replace(@category, " ", "_")
and cl_from = page_id
and page_namespace = 0
and page_id = ll_from
and ll_lang = "he"

​x
 
set @category = "People from Dublin (city)";​select page_title as "ערך", page_is_redirect as "הפניה", page_len as "גודל", ll_title as "שם בעברית"from enwiki_p.page join enwiki_p.categorylinks join enwiki_p.langlinkson cl_to = replace(@category, " ", "_")and cl_from = page_idand page_namespace = 0and page_id = ll_fromand ll_lang = "he"​

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.

Checking query status...