jaguerra

SELECT sys_template.config, REPLACE(config, ' HTML', ' TEXT')
FROM `sys_template`
INNER JOIN pages ON pages.uid = sys_template.pid
WHERE `config` REGEXP BINARY 'HTML' 
AND  sys_template.deleted = 0 AND sys_template.pid >= '0'
AND pages.deleted = 0