SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
		FROM `ps_category` c
		 INNER JOIN ps_category_shop category_shop
        ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
		LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE `id_parent` = 3849
		AND `active` = 1
		AND cg.`id_group` =1
		GROUP BY c.`id_category`
		ORDER BY `level_depth` ASC, category_shop.`position` ASC