Draft - Quarry

SQL

USE fawiki_p;
SELECT DISTINCT concat('# ',MID(rev_comment,locate('صفحهٔ [[',rev_comment)+11,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-9)),COUNT(pl_title)
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 rev_timestamp >20160625000000
#  AND rev_user_text='MammothBot' #rev_user=user_id
LIMIT 10;
SQL

Checking query status...
