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 rev_comment NOT 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 rev_timestamp >20160625000000

#  AND rev_user_text='MammothBot' #rev_user=user_id

LIMIT 5;