Fork of
مقالات بدون عنصر ويكي بيانات
by ASammour
This query is marked as a draft
This query has been published
by ASammour.
SQL
AخA
use arwiki_p;
select p.page_title
from page p
where p.page_namespace = 14
and p.page_is_redirect = 0
and p.page_title not like "%/%"
and p.page_id not in (select ll_from from langlinks where ll_from = p.page_id and ll_lang = "en")
and p.page_title in (select p2.page_title from page p2 where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = p.page_title)
and (select count(p2.page_id) from page p2
inner join langlinks
on ll_from = p2.page_id
where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = p.page_title
and replace(ll_title," ","_") in (select page_title from page where page_namespace = 14
and page_is_redirect = 0)
and ll_lang = "en"
> 0)
and p.page_id not in (select cl_from from categorylinks where cl_to = 'تحويلات_تصنيفات_ويكيبيديا')
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.