Magento-{1.{7-9}|2} simpleCategoryTree sql request > .csv

Magento simpleCategoryTree.md

Magento simpleCategoryTree.csv

command from cli

mysql -uroot -proot magento -e "here sql query" > category_tree.csv; 

sql query

SELECT 
  CONCAT(catalog_category_entity.path, ';') AS 'Chemin;',
  CONCAT(catalog_category_entity.position, ';') AS 'Position;',
  CONCAT(catalog_category_entity.entity_id,';') AS 'ID;',
  CONCAT(catalog_category_entity_varchar.value, ';') AS 'Nom;'
FROM 
  catalog_category_entity, 
  catalog_category_entity_varchar 
WHERE 
  catalog_category_entity.entity_id = catalog_category_entity_varchar.entity_id 
AND 
  catalog_category_entity_varchar.attribute_id = (
    SELECT 
      attribute_id 
    FROM
      eav_attribute 
    WHERE
      eav_attribute.attribute_code = 'name'
    AND
      eav_attribute.entity_type_id = 3
  )
ORDER BY 
  catalog_category_entity.path, 
  catalog_category_entity.position;