Untitled query #38974

SQL

USE fawiki_p;
SELECT distinct concat('[[', page_title ,']]'), replace(replace(replace(comment_text,"»",""),"«",""),'ایجاد شده توسط ترجمهٔ صفحهٔ','')
FROM revision JOIN page join comment  ON rev_page=page_id and rev_comment_id=comment_id
WHERE page_namespace = 0
and page_is_redirect = 0
and comment_text LIKE '%شده توسط ترجمهٔ صفحهٔ%' AND page_id NOT IN (
                SELECT ll_from
                FROM langlinks
  WHERE ll_lang in ("en", "ar", "de","fr","it","ja","glk","mzn","ru","tr","ckb","es","pl","tg","nl","eo")
                );
SQL

Checking query status...
