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