pmp patrols per user in the last 7 days

Fork of pmp patrols per user in the last 24 hrs by Saeidpourbabak

This query is marked as a draft This query has been published by Saeidpourbabak.

SQL

USE fawiki_p;
SELECT user_name, COUNT(log_id) cnt
FROM user JOIN logging ON log_user = user_id LEFT JOIN user_groups ON log_user = ug_user AND ug_group = 'bot'
WHERE log_type ='patrol'
AND log_action='patrol'
AND (
  log_params LIKE '%auto";i:0;}'
  OR log_params LIKE '%0'
  )
AND log_title IN (
  SELECT page_title
  FROM page
  WHERE page_namespace = 0
)
AND ug_group IS NULL
AND NOW() - INTERVAL 7 DAY < log_timestamp
#AND CURRENT_TIMESTAMP - log_timestamp < 00000007000000;
/*AND log_timestamp > '20140101000000'
AND log_timestamp < '20171028000000';*/;
GROUP BY user_name
ORDER BY cnt DESC;

SQL

Checking query status...