Created
January 12, 2017 13:01
-
-
Save varpa89/ab36f13144b8580d146379a7b016a6b9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment