select
    sys_area_template.*
from
    sys_area_template
where
{{if ne .del_flag ""}}
	sys_area_template.del_flag = {{.del_flag}}
{{else}}
    sys_area_template.del_flag = 0
{{end}}
{{if ne .name ""}}
	and sys_area_template.name like '%{{.name}}%'
{{end}}
LIMIT {{.rows}} OFFSET {{.offset}}