select CONCAT(RWTYP,'-' ,RWNAME) as MOID,IFNULL(RWVALUE,RWNAME) as MOTEXT, IFNULL(RWDESC,CONCAT('keine Beschreibung für ',RWNAME)) as MODESC  
  from CCRW 
where RWNAME is not null and ((RWTYP='DQUERY' and RWPARENT='QUERIES') or (RWTYP='TYPE' and RWPARENT='TYPES')) 
union 
select CONCAT('MFILE-',MFILEID) as MOID, CONCAT('Managed File ',MFILEID) as MOTEXT, CONCAT(MFILETYPE,' managed file, Originalname ',MFILENAME) as MODESC from CCMFILES
union
select bo.BOID as BOID, CONCAT('Business Object ',bo.BONAME) as BOTEXT,bo.BODESC as BODESC 
  from BOBOBJS bo