Register / Login  |  Desktop view  |  Jump to bottom of page

Database » 找出註冊超過90天尚未啟用的帳號

Author: andowson, 七段學員
2007-10-13 13:56:24

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




Register / Login  |  Desktop view  |  Jump to top of page