oracle8.1.6 select dotlrn_users.*, guest_p from dotlrn_users, dotlrn_guest_status where dotlrn_users.user_id = :user_id and dotlrn_guest_status.user_id(+) = dotlrn_users.user_id select cr_items.live_revision as revision_id, nvl(cr_revisions.title, 'view this portrait') as portrait_title from acs_rels, cr_items, cr_revisions where acs_rels.object_id_two = cr_items.item_id and cr_items.live_revision = cr_revisions.revision_id and acs_rels.object_id_one = :user_id and acs_rels.rel_type = 'user_portrait_rel' select dotlrn_class_instances_full.*, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, '' as role_pretty_name from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_clubs_full.*, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, '' as role_pretty_name from dotlrn_clubs_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id order by dotlrn_clubs_full.pretty_name, dotlrn_clubs_full.community_key select dotlrn_communities.*, dotlrn_community.url(dotlrn_communities.community_id) as url, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, '' as role_pretty_name from dotlrn_communities, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id and dotlrn_communities.community_type = 'dotlrn_community' order by dotlrn_communities.pretty_name, dotlrn_communities.community_key