Joined: Jan 2, 2007 Messages: 727 Location: 台北 Offline
select * from jforum_users where user_id not in (select session_user_id from jforum_sessions) and user_actkey is not null and date_part('day',current_timestamp-user_regdate) > 90 order by user_id