1

Get Category Name SELECT entity_id AS "CATEGORY ID", ccev1.value as "CATEGORY NAME" FROM `catalog_category_entity_varchar`as ccev1 JOIN eav_attribute AS ea1 ON ea1.attribute_id = ccev1.attribute_id WHERE ea1.attribute_code = 'name' AND ea1.entity_type_id = 3 Get Category Description SELECT entity_id AS "CATEGORY ID", ccev1....


Only top voted, non community-wiki answers of a minimum length are eligible