postgresql7.1 select f.community_key as key, f.community_id as id, f.pretty_name as name, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from dotlrn_classes c, dotlrn_communities_full f, acs_objects o where f.community_type = c.class_key and f.community_id= :community_id and o.object_id= :community_id select distinct h.community_key as key, h.community_id as id, h.pretty_name as name, h.parent_community_id as parent_id, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from dotlrn_communities h, dotlrn_clubs c, acs_objects o where h.community_id= c.club_id and h.community_id= :community_id and o.object_id= :community_id select distinct h.community_key as key, h.community_id as id, h.pretty_name as name, h.parent_community_id as parent_id, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from dotlrn_communities h, acs_objects o where h.community_id= :community_id and o.object_id= :community_id select count(distinct community_id) from dotlrn_communities where parent_community_id= :community_id select count (*) from acs_rels where acs_rels.object_id_one= :community_id select count (*) from acs_rels where acs_rels.object_id_one= :community_id and acs_rels.rel_type in ('[join $rels "\', \'"]') select count(distinct forums.forum_id) from forums_forums_enabled forums, dotlrn_communities com where com.community_id= :community_id and apm_package__parent_id(forums.package_id) = com.package_id select count(distinct f.faq_id) from faqs f, dotlrn_communities com, acs_objects o where com.community_id= :community_id and o.object_id=f.faq_id and apm_package__parent_id(o.context_id) = com.package_id select count(n.item_id) from news_items_approved n, dotlrn_communities com where com.community_id= :community_id and apm_package__parent_id(n.package_id) = com.package_id select count(s.survey_id) from surveys s, dotlrn_communities com where com.community_id= :community_id and apm_package__parent_id(s.package_id) = com.package_id select count (*) from dotlrn_communities h, dotlrn_clubs c where h.parent_community_id is not null or c.club_id = h.community_id select count (*) from dotlrn_classes, dotlrn_communities_full where dotlrn_communities_full.community_type = dotlrn_classes.class_key select cr_items.live_revision as revision_id, coalesce(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 select distinct package_key from apm_packages where package_key= :package_key