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
*/
SET @row_number = 0;


select
    (@row_number:=@row_number + 1) AS id,
concat("[[",page.page_title,"]]") as "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
inner join page main_page on main_page.page_title = page.page_title
where  tl_from_namespace = 1 and lt_namespace = 10 and lt_title like "WikiProject_Palestine"
and main_page.page_namespace = 0
AND main_page.page_id NOT IN (
    SELECT ll_from
    FROM langlinks
    WHERE ll_lang = 'ar'
)
# this line will skip redirect pages< you can comment it
and main_page.page_is_redirect = 0
SQL

Checking query status...
