USE fawiki_p;

SELECT DISTINCT page_title

    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'

      )

    )

    AND NOW() - INTERVAL 1 DAY <rev_timestamp

    ORDER BY page_title;