OPEN Cart Find Parent Categories and there Child Categories list in Ms Excel export
OPEN Cart Find Parent Categories and there Child Categories list in Ms Excel export SELECT pd . `name` , cd . `name` FROM `oc_category` as ct left JOIN `oc_category` as pt ON ct . `parent_id` = pt . `category_id` left JOIN `oc_category_description` cd ON ct . `category_id` = cd . `category_id` left JOIN `oc_category_description` pd ON pt . `category_id` = pd . `category_id` ORDER BY pd .name