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

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;
select concat("[[",page_title,"]]"), concat("[[:en:",(select ll_title from langlinks
                                                                                  where ll_from = rev_page
                                                                                  and ll_lang = "en"
                                                                                  limit 1),"]]"), page_len
from revision
inner join comment
on comment_id = rev_comment_id
inner join page
on page_id = rev_page
where  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
and rev_user <> 0
limit 10;

SQL

Checking query status...