     CASE        When p.child0 IS NULL         THEN p0.child0         ELSE p.child0     END AS child0p     CASE        When p.child0 IS NULL         THEN p0.child0         ELSE p.child0     END AS child0p  