user = __DB_RO_USER__ password = __DB_RO_PASS__ hosts = __DB_HOST__:__DB_PORT__ dbname = __DB_NAME__ # keep_copy=1 expands to external target + original mailbox address (requires a real account). query = SELECT IF(COALESCE(r.keep_copy,0)=1, CONCAT(r.target_email,',',r.source_local,'@',d.name), r.target_email) FROM redirects r JOIN domains d ON r.domain_id=d.id WHERE CONCAT(r.source_local,'@',d.name)='%s' AND r.is_active=1 AND d.is_active=1