my $sth = $dbh->prepare(q{
SELECT *
FROM letter
WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '') AND message_transport_type = ?
WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '')
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 );
-