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