Select the Account ID, Name and Parent ID and Name for all Sugar Accounts with Parents

account_parent_export.sql

select
  accounts.id as account_guid,
  accounts.name as account_name,
  accounts.parent_id as parent_account_guid,
  parents.name as parent_account_name
from accounts
join accounts parents
  on parents.deleted = 0
  and accounts.parent_id = parents.id
where accounts.deleted = 0
and accounts.parent_id is not null
and accounts.parent_id <> ''
order by parent_account_name asc;