postgresql7.1 SELECT t.term_name,t.term_id FROM dotlrn_terms t WHERE t.term_id = t.term_id SELECT c.pretty_name FROM dotlrn_communities_all c, dotlrn_terms t WHERE c.active_start_date = t.start_date AND c.active_end_date = t.end_date select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.term_id = :term_id [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.term_id = :term_id [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.term_id = :term_id and dotlrn_class_instances_full.department_key = :department_key [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.term_id = :term_id and dotlrn_class_instances_full.department_key = :department_key [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.department_key = :department_key [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_class_instances_full.*, v.n_members from dotlrn_class_instances_full left outer join (select dotlrn_class_instances_full.class_instance_id, count(1) as n_members from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id group by dotlrn_class_instances_full.class_instance_id) v on dotlrn_class_instances_full.class_instance_id = v.class_instance_id $keyword_clause and dotlrn_class_instances_full.department_key = :department_key [template::list::orderby_clause -orderby -name "classes"] select term_name, term_year, to_char(start_date, 'Mon DD YYYY') as start_date, to_char(end_date, 'Mon DD YYYY') as end_date from dotlrn_terms where term_id = :term_id where lower(dotlrn_class_instances_full.pretty_name) like '%'||lower(:keyword)||'%' where 1 = 1