select bfs.forum_id, short_name as name from bboard_forum_subscribers bfs, bboard_forums bf where bfs.forum_id = bf.forum_id and bfs.subscriber_id = :user_id and bf.bboard_id= :package_id order by forum_id asc select bcs.category_id, bc.short_name as name, bf.forum_id from bboard_category_subscribers bcs, bboard_categories bc, bboard_forums bf where bcs.category_id = bc.category_id and bcs.subscriber_id = :user_id and bc.forum_id = bf.forum_id and bf.bboard_id= :package_id order by category_id asc select thread_id, title as name, forum_id from bboard_thread_subscribers bts, bboard_messages_all bma where bts.thread_id = bma.message_id and bts.subscriber_id = :user_id order by thread_id asc