select last_visit FROM users WHERE user_id = :user_id select (last_visit - 1000) as last_visit FROM users WHERE user_id = :user_id SELECT (jrpm.party_id) as party_id , (jrpm.room_id) as room_id , (jcr.name) room_name FROM group_distinct_member_map gdmm , jb_room_party_map jrpm , jb_conference_rooms jcr WHERE gdmm.member_id = :user_id AND gdmm.group_id = jrpm.party_id AND jcr.room_id = jrpm.room_id ORDER BY jcr.name SELECT thread_id , subject , start_time FROM jb_conference_room_threads WHERE room_id = :room_id