oracle8.1.6 select l.list_id, l.name from ml_mailing_lists l, ml_mailing_list_user_map m where l.package_id = :package_id and l.list_id = m.list_id and l.expiration_date > sysdate and m.user_id = :user_id and m.subscribed_p = 't' order by lower(l.name) select l.list_id, l.name, l.teaser, c.tree_id, c.category_id, nvl(m.subscribed_p, 'f') as subscribed_p from ml_mailing_lists l, ml_mailing_list_user_map m, category_object_map cm, categories c, ml_category_trees_visible v where l.package_id = :package_id and l.list_id = m.list_id(+) and m.user_id(+) = :user_id and l.public_p = 't' and l.locale = :locale and l.expiration_date > sysdate and cm.object_id = l.list_id and cm.category_id = c.category_id and v.package_id = :package_id and v.tree_id = c.tree_id order by c.tree_id, c.category_id, lower(l.name)