oracle8.1.6 select s.subscr_id, s.timeout, person.name(o.creation_user) as creator, nvl(to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS'),'never built') as lastbuild_ansi, s.last_ttb, s.channel_title, s.channel_link from rss_gen_subscrs s, acs_objects o where o.object_id = s.subscr_id $maybe_restrict_to_user order by s.last_ttb desc