Elation SSO User

select
    s.elation_billing_user_id
  , s.user_id
  , u.first_name
  , u.last_name
  , s.last_login
from elation_sso_user s
  left join user u on u.id = s.user_id
where s.is_deleted = false;

select
    p.id as payment_id
  , p.amount
  , s.user_id as created_by_user_id
  , u.first_name
  , u.last_name
from payment p
  left join elation_sso_user s
    on s.elation_billing_user_id = p.created_by_elation_billing_user_id
   and s.warehouse_id = p.warehouse_id
  left join user u on u.id = s.user_id
where p.is_deleted = false;