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

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,"]]"), page_namespace, rev_len, ll_title
from revision
inner join comment
on comment_id = rev_comment_id
inner join langlinks
on ll_from = page_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 ll_lang = "en"
limit 1000;

SQL

Checking query status...