select distinct t1.codevepar,apepar,nompar,cedpar,IFNULL((select stapattra from gevmdeventosparticipantes where (stapattra='S') and (codpar=t2.codpar)  and (codpat='@2') and (codeve='@1') limit 1
),'') as transporte,IFNULL((select stapathos from gevmdeventosparticipantes where (stapathos='S') and (codpar=t2.codpar)  and (codpat='@2') and (codeve='@1') limit 1
),'') as hospedaje,IFNULL((select stapatinc from gevmdeventosparticipantes where (stapatinc='S') and (codpar=t2.codpar)  and (codpat='@2') and (codeve='@1') limit 1
),'') as inscripcion from gevmdeventosparticipantes as t1,gevtparticipantes as t2 where (codeve='@1') and (t1.codpar=t2.codpar) and (codpat='@2') and (tippre<>'N') order by cedpar