SQL
AخA
USE fawiki_p;
SELECT CONCAT ('# [[',page_title,']]')#,rev_comment
FROM page JOIN pagelinks ON page_id=pl_from JOIN revision ON rev_page=page_id
WHERE pl_title='زندگی_زیباست_(فیلم_۱۹۹۷)'
#AND page_title LIKE 'اورانگوتان'
#AND rev_user_text='Fatranslator'#rev_user=user_id
AND rev_comment LIKE '%[[وپ:داپ|اصلاح پیوند]]> [[زندگی زیباست]] > [[زندگی زیباست (فیلم ۱۹۹۷)]]%'
ORDER BY page_title;
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.