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