select dotlrn_classes_full.class_key, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, dotlrn_departments_full.pretty_name as department_name, (select count(*) from dotlrn_class_instances, dotlrn_communities_all where dotlrn_class_instances.class_key = dotlrn_classes_full.class_key and dotlrn_class_instances.class_instance_id = dotlrn_communities_all.community_id and dotlrn_communities_all.archived_p = 'f') as n_instances from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = dotlrn_departments_full.department_key $keyword_clause [template::list::page_where_clause -and -name "classes" -key "dotlrn_classes_full.class_key"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_classes_full.class_key, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, dotlrn_departments_full.pretty_name as department_name, (select count(*) from dotlrn_class_instances, dotlrn_communities_all where dotlrn_class_instances.class_key = dotlrn_classes_full.class_key and dotlrn_class_instances.class_instance_id = dotlrn_communities_all.community_id and dotlrn_communities_all.archived_p = 'f') as n_instances from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = dotlrn_departments_full.department_key $keyword_clause [template::list::orderby_clause -orderby -name "classes"] select dotlrn_classes_full.class_key, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, dotlrn_departments_full.pretty_name as department_name, (select count(*) from dotlrn_class_instances, dotlrn_communities_all where dotlrn_class_instances.class_key = dotlrn_classes_full.class_key and dotlrn_class_instances.class_instance_id = dotlrn_communities_all.community_id and dotlrn_communities_all.archived_p = 'f') as n_instances from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = :department_key $keyword_clause and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key [template::list::page_where_clause -and -name "classes" -key "dotlrn_classes_full.class_key"] [template::list::orderby_clause -orderby -name "classes"] select dotlrn_classes_full.class_key, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, dotlrn_departments_full.pretty_name as department_name, (select count(*) from dotlrn_class_instances, dotlrn_communities_all where dotlrn_class_instances.class_key = dotlrn_classes_full.class_key and dotlrn_class_instances.class_instance_id = dotlrn_communities_all.community_id and dotlrn_communities_all.archived_p = 'f') as n_instances from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = :department_key $keyword_clause and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key [template::list::orderby_clause -orderby -name "classes"] and lower(dotlrn_classes_full.pretty_name) like '%'||lower(:keyword)||'%'