Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.59 KB | None | 0 0
  1. SELECT
  2.   user_joined.email_decrypted,
  3.   user_joined.facebook_uid_decrypted
  4. FROM
  5.   [di-bigquery-data-commons:user_entity_decrypted.user_entity_decrypted_20170123] AS ua
  6. JOIN (
  7.   SELECT
  8.     user_id
  9.   FROM
  10.     [artist-insights:segment_listener28day.segment_listener28day_20170123]
  11.   WHERE
  12.     artist_gid = (
  13.     SELECT
  14.       artist_gid
  15.     FROM
  16.       [di-bigquery-data-commons:artist_entity.artist_entity_20161123] /*UPDATE THIS */
  17.     WHERE
  18.       metadata_artist.name = "Åse Kleveland")) AS userlist
  19. ON
  20.   ua.user_id = userlist.user_id
  21. WHERE
  22.   ua.user_account_cleaned.country IN ('NO')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement