SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.