Recent Logins and Edits to Drupal

recent-edits.sql

# users without any recent edits
select u.name, u.mail, n1.uid, n1.vid, n1.nid, from_unixtime(n1.timestamp) changed
from node_revision n1, users u
where n1.uid = u.uid
    and timestamp=
    (select max(timestamp)
     from node_revision n2 
     where n2.uid=n1.uid) # this selects the most recent revision for each person
    and from_unixtime(n1.timestamp) < date_sub(now(), interval 30 day)
    and u.status = 1 # ignore people who are blocked
    and u.login != 0 # ignore people who haven't ever logged in
group by uid
order by changed;