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