light-apiengine-feature/sqlconfig/system_controller/system_find_area_template_detail_page_select.tpl

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