تعديلات ذات ملخص تعديل محدد

Fork of Wikiproject Cleanup Contributions (Copy)-**edit** by ASammour

This query is marked as a draft This query has been published by ASammour.

SQL

use arwiki_p;
set @num := 0;
select @num := @num + 1 as "العدد", concat("[[",page_title,"]]"), concat("[[:en:",ll_title,"]]"), page_len, ll_lang
from revision
inner join comment
on comment_id = rev_comment_id
inner join page
on page_id = rev_page
inner join langlinks
on ll_from = page_id
where 
ll_lang like "en"
and comment_text like "%This article was translated by I Believe in Science & Ideas beyond borders & Beit al Hikma%" or rev_comment like "%This article was translated by I Believe in Science & Ideas beyond borders & Beit al Hikma%"
and page_is_redirect = 0
and page_namespace = 0
limit 50;

SQL

Checking query status...