Esportar categorias/subcategorias en Prestashop

[quimfv]

Código MySQL:

SELECT c.id_category, c.active, cl.name, c.id_parent, clp.name, c.description, c.link_rewrite
FROM (ps_category c
LEFT JOIN ps_category_lang cl ON ( c.id_category = cl.id_category ))
LEFT JOIN (ps_category cp
LEFT JOIN ps_category_lang clp ON ( cp.id_category = clp.id_category ))
WHERE c.id_category >2
AND cl.id_lang =4
ORDER BY c.id_category ASC
 

Creo