pmp pages edited (excluding bots and autopatrolled) in the last 24 hrs

SQL

USE fawiki_p;
SELECT 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 = 'autopatrolled'
    OR ug_group = 'bureaucrat'
    OR ug_group = 'sysop'
    OR ug_group = 'bot'
    OR ug_group = 'eliminator'
    OR ug_group = 'patroller'
    OR ug_group = 'botadmin'
  )
)

AND NOW() - INTERVAL 6 MONTH < rev_timestamp
#AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000;
/*AND rev_timestamp > '20140101000000'
AND rev_timestamp < '20171028000000';*/
GROUP BY page_title;

SQL

Checking query status...