<#list subTables as subTab> <#assign originalForeignKeys = subTab.originalForeignKeys> #segment#${subTab.entityName}Mapper.xml DELETE FROM ${subTab.tableName} WHERE <#list originalForeignKeys as key> <#if key?lower_case?index_of("${primaryKeyField}")!=-1> ${key} = ${r'#'}{${primaryKeyField}} <#rt/> <#else> ${key} = ${r'#'}{${key}} <#rt/> <#if key_has_next>AND SELECT * FROM ${subTab.tableName} WHERE <#list originalForeignKeys as key> <#if key?lower_case?index_of("${primaryKeyField}")!=-1> ${key} = ${r'#'}{${primaryKeyField}} <#rt/> <#else> ${key} = ${r'#'}{${key}} <#rt/> <#if key_has_next>AND