select (select *
from transactions
left join cards on transactions.card = cards.card
left join accounts on cards.account = accounts.account
left join clients on accounts.client = clients.client
left join terminals on transactions.terminal = terminals.terminal) as other
where other.card = t1.card 
and other.city <> t1.city 
and other.trans_date between datetime(t1.trans_date, '- 1 hour') and datetime(t1.trans_date, '+ 1 hour')
from (select * from transactions
left join cards on transactions.card = cards.card
left join accounts on cards.account = accounts.account
left join clients on accounts.client = clients.client
left join terminals on transactions.terminal = terminals.terminal) as t1