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%" 

AND page_is_redirect = 0 

AND page_namespace = 0 

AND rev_actor <> 0 

LIMIT  500;