flarum/sql/flarum_users/flarum_users_page_count.tpl

-- Code generated by dol build. Only Generate by tools if not existed.
-- 1. You must specify the appropriate field name, instead of the *, field can be referenced in sql/sqlmap/.xml.
-- 2. You must load user information from the code level if you need, because the user information is present in another table.
select
    count(*) records
from
	flarum_users
where
	flarum_users.id {{.ne}} ""
	and
	flarum_users.del_flag {{.ne}} 1
{{if ne .role_rule ""}}
	and {{.role_rule}}
{{end}}