تصانيف بنفس عنوان المقالة من ويكيبيديا الإنجليزية، وغير موجودة في العربية

SQL

select p1.page_title from
page p1
inner join page p2
on p2.page_title = p1.page_title
inner join page p3
on p3.page_title = p2.page_title
where p1.page_namespace = 14
and p1.page_is_redirect = 0
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and p3.page_namespace = 0
and p4.page_is_redirect = 0
and p1.page_id not in (select ll_from from langlinks where ll_from = p1.page_id and ll_lang = "ar")
and p3.page_id
	in
    (select ll_from from langlinks where ll_from = p3.page_id and ll_lang = "ar")
limit 10;

SQL

Checking query status...