DROP  TABLE  if exists  vasy_pidor;
CREATE TEMP TABLE vasy_pidor AS
SELECT

     "Performer".*
FROM "MusicianSearchBulletin"
                 inner join  "Performer" on "MusicianSearchBulletin"."PerformerId" = "Performer"."Id"
                 inner join  "GenresPerfomer" on "Performer"."Id" = "GenresPerfomer"."PerformerId"
                 inner join "Genre" on "GenresPerfomer"."GenreId" = "Genre"."Id"
where  "GenreId" = 804;


select daroh_petooh."Id"  from vasy_pidor
                              inner join  "GenresPerfomer" on vasy_pidor."Id" = "GenresPerfomer"."PerformerId"
                              inner join  "Genre" daroh_petooh on "GenresPerfomer"."GenreId" = daroh_petooh."Id"