>>>>>>>>>>>>>>>>>>>>>AAA>>>>>>>>>>>>

SELECT 0 as filter_id, seo.keyword as seo_category_parent, cp.level, cp.path_id, cst.store_id, (SELECT `keyword` FROM `oc_url_alias` WHERE `query` = CONCAT('category_id=', c1.category_id) LIMIT 1) as seo_category, cp.category_id AS category_id, cd2.name as main_name, (( SELECT GROUP_CONCAT(DISTINCT CONCAT('' , cd1.name,'') ORDER BY cp_bc.level SEPARATOR ' > ' ) FROM oc_category_path cp_bc LEFT JOIN oc_category c1_bc ON (cp_bc.category_id = c1_bc.category_id) LEFT JOIN oc_category c2_bc ON (cp_bc.path_id = c2_bc.category_id) LEFT JOIN oc_category_description cd1 ON (cp_bc.path_id = cd1.category_id) LEFT JOIN oc_category_description cd2 ON (cp_bc.category_id = cd2.category_id) LEFT JOIN oc_category_to_store cst ON (cp_bc.category_id = cst.category_id) WHERE c1_bc.status = 1 and c1_bc.category_id = 456 GROUP BY cp_bc.category_id ORDER BY cp_bc.level, cd1.category_id LIMIT 0, 1 ) ) as breadcrumb, (SELECT CONCAT('[', GROUP_CONCAT(DISTINCT CONCAT('"', c_images.image,'"')), ']') FROM `oc_category_image` c_images WHERE `category_id` = '456') as images , cd2.*, c1.linkto, c1.parent_id, c1.image, c1.status, c1.sort_order FROM oc_category_path cp LEFT JOIN oc_category c1 ON (cp.category_id = c1.category_id) LEFT JOIN oc_category c2 ON (cp.path_id = c2.category_id) LEFT JOIN oc_category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN oc_category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN oc_category_to_store cst ON (cp.category_id = cst.category_id) LEFT JOIN `oc_url_alias` seo ON (query = CONCAT('category_id=', c2.category_id)) LEFT JOIN `oc_category_image` c_images ON ( c_images.category_id = c1.category_id) WHERE c1.status = 1 AND cst.store_id = 0 AND (c1.parent_id = 456 OR c1.category_id = 456 ) GROUP BY cp.category_id ORDER BY c1.sort_order, cd2.name <<<<<<<<<<<<<< AAA