CREATE ALGORITHM=UNDEFINED DEFINER="root"@"localhost" SQL SECURITY DEFINER 
VIEW "ccvdbquerygroups" AS 
  select "g"."RWNAME" AS "GRUPPE","g"."RWVALUE" AS "GRUPPENTITEL",
         "g"."RWDESC" AS "GRUPPENBESCHREIBUNG",
		 (case when ("g"."RWPARENT" = 'QUERYGROUPS') then '' else "g"."RWPARENT" end) AS "ELTERNGRUPPE" from "ccrw" "g" where ("g"."RWTYP" = 'QUERYGROUP')