flarum/sql/flarum_posts/flarum_posts_page_select.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
    flarum_posts.id
from
	flarum_posts
where
	flarum_posts.id {{.ne}} ""
	and
	flarum_posts.del_flag {{.ne}} 1
{{if ne .role_rule ""}}
	and {{.role_rule}}
{{end}}
	LIMIT {{.size}} OFFSET {{.offset}}