select count(1) from $table_and_group select count(1) from $table_and_group $where_clause dir_all_users m where 1=1 dir_group_members m where group_id = :group_id order by lower(last_name) order by lower(email) order by lower(last_name) desc order by lower(email) desc and (lower(first_names) like '%' || lower(:search) || '%' or lower(last_name) like '%' || lower(:search) || '%' or lower(email) like '%' || lower(:search) || '%') and upper(last_name) like :letter || '%' select m.* from $table_and_group $where_clause $order_clause