SELECT t.date as `Date`,
 t.description as `Description`,
 m.modname as `Module name`,
 t.trans_id as `Transaction ID`,
 sql_currency(t.in,t.currency_id,0) as `In`,
 REPLACE(g.output,'\n','<br>')  as `Output`
FROM hb_gateway2trans g2t
LEFT JOIN hb_gateway_log g ON g2t.gateway_log_id = g.id
LEFT JOIN hb_transactions t ON g2t.transaction_id = t.id
INNER JOIN hb_modules_configuration m ON t.module = m.id
WHERE
 t.client_id = :client_id