postgresql7.1 select request_id, type_id, (select pretty_name from notification_types where notification_types.type_id = notification_requests.type_id) as type, acs_object__name(notification_requests.object_id) as object_name, (select name from notification_intervals where notification_intervals.interval_id = notification_requests.interval_id) as interval, object_id from notification_requests where user_id = :user_id select request_id, type_id, (select pretty_name from notification_types where notification_types.type_id = notification_requests.type_id) as type, case when (select short_name from notification_types where notification_types.type_id = notification_requests.type_id) = 'forums_forum_notif' then (select name from forums_forums where forum_id = notification_requests.object_id) when (select short_name from notification_types where notification_types.type_id = notification_requests.type_id) = 'forums_message_notif' then (select subject from forums_messages where message_id = notification_requests.object_id) else acs_object__name(notification_requests.object_id) end as object_name, (select name from notification_intervals where notification_intervals.interval_id = notification_requests.interval_id) as interval, object_id from notification_requests where user_id = :user_id