inactive patrollers in the last year

SQL

#user_ids of patrollers
SELECT user_id  
FROM user 
JOIN user_groups 
ON user_id = ug_user 
WHERE ug_group = 'patroller'
AND user_id NOT IN (
  SELECT DISTINCT user_id 
  FROM user_groups JOIN user ON user_id = ug_user 
  LEFT JOIN logging ON user_id = log_user 
  WHERE ug_group = 'patroller'
  AND log_action = 'reviewed' 
  AND log_timestamp > (NOW() - INTERVAL 180 DAY)
  )

# user_ids of users who patrolled in the last day
#SELECT DISTINCT user_id 
#FROM user_groups JOIN user ON user_id = ug_user 
#LEFT JOIN logging ON user_id = log_user 
#WHERE ug_group = 'patroller'
#AND log_action = 'reviewed'
#AND log_timestamp > (NOW() - INTERVAL 1 DAY);
SQL

Checking query status...
