Экспорт категорий с изображениями
SELECT cl.id_category, active, cl.name, cl2.name AS parent_name, is_root_category, cl.description, cl.meta_title, cl.meta_keywords, cl.meta_description, cl.link_rewrite, concat( "http://", ifnull( conf.value, "site.com" ) , "/img/c/", c.id_category, ".jpg" ) AS url_image, cl.id_lang
FROM ps_category c
INNER JOIN ps_category_lang cl ON cl.id_category = c.id_category
INNER JOIN ps_category_lang cl2 ON cl2.id_category = c.id_parent
AND cl2.id_lang = cl.id_lang
LEFT JOIN ps_configuration conf ON conf.name = "PS_SHOP_DOMAIN"
ORDER BY cl.id_lang, c.level_depth;