Untitled query #34657

SQL

USE arwiki_p;
select page_title, (select ll_title from langlinks where ll_from = rev_page and ll_lang = "en" limit 1), page_len
from revision rev
inner join comment
on comment_id = rev.comment_id
inner join page
on page_id = rev.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 1000;
SQL

Checking query status...
