Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- user_joined.email_decrypted,
- user_joined.facebook_uid_decrypted
- FROM
- [di-bigquery-data-commons:user_entity_decrypted.user_entity_decrypted_20170123] AS ua
- JOIN (
- SELECT
- user_id
- FROM
- [artist-insights:segment_listener28day.segment_listener28day_20170123]
- WHERE
- artist_gid = (
- SELECT
- artist_gid
- FROM
- [di-bigquery-data-commons:artist_entity.artist_entity_20161123] /*UPDATE THIS */
- WHERE
- metadata_artist.name = "Åse Kleveland")) AS userlist
- ON
- ua.user_id = userlist.user_id
- WHERE
- ua.user_account_cleaned.country IN ('NO')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement