select
    cu.id as user_id,
    id_to_time(cu.id) as created_at,
    usr.phone_number,
    co.name as company,
    cu.payment_processor__token,
    cu.consent_from_reby,
    acc.balance__amount/100 as balance_euros,
    up.driving_licence,
    up.national_id,
    email
from company_user cu --tabla principal de usuarios
left join user_profile up on up.company_user_id = cu.id --tabla con información adicional del usuario/a
left join public.user usr on cu.user_id = usr.id
left join company co on cu.company_id = co.id --tabla de compañias
left join account acc on cu.balance_account_id = acc.id
where usr.phone_number = '+34674780704'