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