SQL
AخA
USE fawiki_p;
SELECT DISTINCT concat('# ',MID(rev_comment,locate('صفحهٔ [[',rev_comment)+11,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-9))
FROM revision JOIN pagelinks ON REPLACE(pl_title,'_',' ') = MID(rev_comment,locate('صفحهٔ [[',rev_comment)+13,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-13)
WHERE rev_comment LIKE '%را_بدون_برجای•گذاشتن_تغییرمسیر_به%'
AND pl_namespace = 0
AND NOT EXISTS (
SELECT null
FROM page
WHERE REPLACE(page_title,'_',' ') = MID(rev_comment,locate('صفحهٔ [[',rev_comment)+13,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-13)
AND page_namespace=0
)
# AND rev_timestamp >20160625000000
# AND rev_user_text='MammothBot' #rev_user=user_id
LIMIT 3;
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.