SELECT *
FROM letter
WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '')
AND message_transport_type = ?
AND ( message_transport_type = ? OR message_transport_type IN (SELECT message_transport_type FROM message_transport_types))
ORDER BY branchcode DESC LIMIT 1
});
$sth->execute( $module, $code, $branchcode, $message_transport_type );
-