oldhowl

Untitled

Dec 6th, 2019
94
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP TABLE if exists vasy_pidor;
  2. CREATE TEMP TABLE vasy_pidor AS
  3. SELECT
  4.  
  5. "Performer".*
  6. FROM "MusicianSearchBulletin"
  7. inner join "Performer" on "MusicianSearchBulletin"."PerformerId" = "Performer"."Id"
  8. inner join "GenresPerfomer" on "Performer"."Id" = "GenresPerfomer"."PerformerId"
  9. inner join "Genre" on "GenresPerfomer"."GenreId" = "Genre"."Id"
  10. where "GenreId" = 804;
  11.  
  12.  
  13. select daroh_petooh."Id" from vasy_pidor
  14. inner join "GenresPerfomer" on vasy_pidor."Id" = "GenresPerfomer"."PerformerId"
  15. inner join "Genre" daroh_petooh on "GenresPerfomer"."GenreId" = daroh_petooh."Id"
RAW Paste Data