SELECT TemplateCode, Package, Channel, Subject,
Body, Layout, Description, Active,
TemplateEngine, Module
FROM `def_email_template`
WHERE TemplateCode = '{template_code}'
AND Package IN ('', '{package}')
ORDER BY CASE WHEN Package = '{package}'
THEN 0 ELSE 1 END
LIMIT 1
SELECT TemplateCode, Package, Channel, Active,
TemplateEngine, Description
FROM `def_email_template`
WHERE Package IN ('', '{package}')
ORDER BY TemplateCode
REPLACE INTO `def_email_template` ({columns})
VALUES ({values})