select sig.insertionsStrings
from generated.generatedFiles.SignaledEvents sig
where sig.insertionsStrings in
   (select signa.insertionsStrings
    from generated.generatedFiles.SignaledEvents signa
    inner join signa.insertionsStrings ins
    where ins.id.index=1 and ins.insertionStr='hhhhh')
and
sig.insertionsStrings in
   (select signa.insertionsStrings
    from generated.generatedFiles.SignaledEvents signa
    inner join signa.insertionsStrings ins
    where ins.id.index=2 and ins.insertionStr='gggg')

  insertions1_.id as id28_,
  insertions1_.index as index28_,
  insertions1_.insertion_str as insertion3_28_
from
  public.signaled_events signaledev0_
inner join
  public.insertions_string insertions1_
   on signaledev0_.id=insertions1_.id,
  public.insertions_string insertions2_,
  public.insertions_string insertions6_
where
  signaledev0_.id=insertions2_.id
  and signaledev0_.id=insertions6_.id
  and (
   . in (
    select
     .
    from
     public.signaled_events signaledev3_
    inner join
     public.insertions_string insertions4_
      on signaledev3_.id=insertions4_.id,
     public.insertions_string insertions5_
    where
     signaledev3_.id=insertions5_.id
     and insertions4_.index=1
     and insertions4_.insertion_str='hhhhh'
   )
  )
  and (
   . in (
    select
     .
    from
     public.signaled_events signaledev7_
    inner join
     public.insertions_string insertions8_
      on signaledev7_.id=insertions8_.id,
     public.insertions_string insertions9_
    where
     signaledev7_.id=insertions9_.id
     and insertions8_.index=2
     and insertions8_.insertion_str='gggg'
   )
  )