select nomhot,'@1' as codeve,codhot from gevtchoteles where (codhot in (select codhot from gevmdeventosparticipantes where (codeve='@1') and ((((gevmdeventosparticipantes.tippre='S') or (gevmdeventosparticipantes.tippre='P')) and (stapatinc='S')) or ((tippre='N')))    ))
