Article titles starting with "popis" (shwiki)

SQL

SELECT u.user_name
FROM user u
LEFT JOIN actor a ON u.user_id = a.actor_user
LEFT JOIN revision r ON a.actor_id = r.rev_actor
LEFT JOIN recentchanges rc ON u.user_id = rc.rc_user
LEFT JOIN user_groups ug ON u.user_id = ug.ug_user
WHERE ug.ug_group = 'patroller'
  AND (r.rev_timestamp IS NULL OR r.rev_timestamp < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 2 YEAR), '%Y%m%d%H%i%s'))
  AND (rc.rc_timestamp IS NULL OR rc.rc_timestamp < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 2 YEAR), '%Y%m%d%H%i%s'))
GROUP BY u.user_id
HAVING COUNT(r.rev_id) = 0 AND COUNT(rc.rc_id) = 0;

SQL

Checking query status...