<#import "function.ftl" as func> <#assign package=model.variables.package> <#assign class=model.variables.class> <#assign system=vars.system> <#assign domain=vars.domain> <#assign type="${domain}."+system+"."+ package +".entity." +class> <#assign tableName=model.tableName> <#assign foreignKey=model.foreignKey> <#assign sub=model.sub> <#assign colList=model.columnList> <#assign commonList=model.commonList> <#assign pk=func.getPk(model) > <#assign pkModel=model.pkModel > <#assign pkVar=func.getPkVar(model) > <#list colList as col> <#assign colName=func.convertUnderLine(col.columnName)> <#if (col.isPK) > <#list colList as col> <#assign colName=func.convertUnderLine(col.columnName)> <#if (!col.isPK) > select <#list colList as col>${col.columnName}<#if col_has_next>, from ${tableName} <#noparse> ${w.whereSql} ORDER BY ${w.orderBySql} ORDER BY ${pk} DESC