USE fawiki_p;

SELECT DISTINCT page_title#,rev_user_text,rev_timestamp

FROM revision JOIN page ON rev_page=page_id

WHERE rev_user_text NOT LIKE 'پیام_به_کاربر_جدید'

AND rev_user_text NOT LIKE 'FawikiPatroller'

AND page_namespace = 0

​

AND rev_user NOT IN (

  SELECT ug_user

  FROM user_groups

  WHERE (

    ug_group = 'bot'

    OR ug_group = 'eliminator'

    OR ug_group = 'patroller'

    OR ug_group = 'botadmin'

  )

)

​

#AND rev_timestamp > '20171019000000'

#AND rev_timestamp < '20171020000000'

AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000

​

ORDER BY page_title;