oracle8.1.6 select u.user_id from cc_users u, acs_objects relo where relo.object_id = u.rel_id and last_visit < sysdate - :days and relo.last_modified < sysdate - :days and u.member_state = 'approved'