use dewiki_p;

SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last edit', log_timestamp AS 'Last log', ug1.ug_group AS 'user_group'

FROM `user`

LEFT JOIN user_groups ug1

    ON user_id = ug1.ug_user AND ug1.ug_group IN ('sysop')

​

JOIN actor

    ON actor_user = user_id

​

JOIN revision_userindex

    ON rev_id = (SELECT rev_id FROM revision_userindex

                 WHERE actor_id = rev_actor

                 ORDER BY rev_timestamp DESC

                 LIMIT 1)

JOIN logging_userindex

    ON log_id = (SELECT log_id FROM logging_userindex

                 WHERE actor_id = log_actor

                 ORDER BY log_timestamp DESC

                 LIMIT 1)

​

WHERE ( 

        (log_timestamp < (DATE_FORMAT((NOW() - INTERVAL 360 DAY),'%Y%m%d%H%i%S')))

        AND      

        (ug1.ug_group IS NOT NULL)

      )

  ORDER BY log_timestamp

;