WikiProject Palestine

SQL

/*
select page.page_title from page
inner join templatelinks on templatelinks.tl_from = page.page_id
inner join linktarget on templatelinks.tl_target_id = linktarget.lt_id
where  tl_from_namespace = 1 and lt_namespace = 10 and lt_title like "WikiProject_Palestine"
# this line will skip redirect pages< you can comment it
and page_is_redirect = 0
*/

select page.page_title from page
inner join templatelinks on templatelinks.tl_from = page.page_id
inner join linktarget on templatelinks.tl_target_id = linktarget.lt_id
LEFT JOIN langlinks ON page.page_id = langlinks.ll_from AND langlinks.ll_lang = 'ar'
where  tl_from_namespace = 1 and lt_namespace = 10 and lt_title like "WikiProject_Palestine"
# this line will skip redirect pages< you can comment it
and page_is_redirect = 0

select * from langlinks limit 10
SQL

Checking query status...
