CREATE OR REPLACE VIEW vCategoryExploded AS
  SELECT
    b.id   AS fatherId,
    b.slug AS fatherSlug,
    a.id   AS descendantId,
    a.slug AS descendantSlug
  FROM ProductCategory a, ProductCategory b
  WHERE a.lft BETWEEN b.lft AND b.rght
  GROUP BY a.id, b.id;