select department_key, pretty_name as department_name, (select count(*) from dotlrn_classes where department_key = dotlrn_departments_full.department_key) as n_classes from dotlrn_departments_full $keyword_clause [template::list::page_where_clause -and -name "departments" -key "dotlrn_departments_full.department_key"] [template::list::orderby_clause -orderby -name "departments"] select department_key, pretty_name as department_name, (select count(*) from dotlrn_classes where department_key = dotlrn_departments_full.department_key) as n_classes from dotlrn_departments_full $keyword_clause [template::list::orderby_clause -orderby -name "departments"] where lower(pretty_name) like '%'||lower(:keyword)||'%' where 1 = 1