أكثر مقالات حسب عدد التعديلات

SQL

select page_title, substring_index(page_title, "_", -1) , substring_index(page_title, "_", 1) , ll1.ll_title ,
ll2.ll_title
from
page 
inner join langlinks ll1
on substring_index(page_title, "_", -1) = ll1.ll_title
inner join langlinks ll2
on substring_index(page_title, "_", 1) = ll2.ll_title
where page_namespace  = 0 and page_is_redirect = 0
and page_id not in (select ll_from from langlinks where ll_from = page_id)
and ll1.ll_lang = "en"
and ll2.ll_lang = "en"
and page_title not like "%_%_%"
limit 100;

SQL

Checking query status...