gistfile1.txt

select
	personids0_.person_guid as person_g1_92_0_,
	personids0_.origin_id as origin_i2_98_0_,
	personids0_.provider_guid as provider3_0_,
	provider1_.guid as guid1_110_1_,
	provider1_.createdTs as createdT2_110_1_,
	provider1_.updatedTs as updatedT3_110_1_,
	provider1_.active as active4_110_1_,
	provider1_.all_access as all_acce5_110_1_,
	provider1_.apiKey as apiKey6_110_1_,
	provider1_.author_user as author_13_110_1_,
	provider1_. comment as comment7_110_1_,
	provider1_.is_consumer as is_consu8_110_1_,
	provider1_. login as login9_110_1_,
	provider1_. name as name10_110_1_,
	provider1_.private_key as private11_110_1_,
	provider1_.public_key as public_12_110_1_,
	provider1_.region_code_guid as region_14_110_1_,
	(
		provider1_.apikey IS NOT NULL
		AND length(provider1_.apikey) > 0
	) as formula12_1_,
	provider1_.is_consumer as formula13_1_,
	(
		coalesce(provider1_. name, '') || ' ' || provider1_. login
	) as formula14_1_
from
	person_ids personids0_
inner join provider provider1_ on personids0_.provider_guid = provider1_.guid
where
	personids0_.person_guid = 'f3e95622-ed1c-4e9b-8737-1d1bc7e93ed5'