Posts

Showing posts from December, 2017

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