select attribute_id from eav_attribute
where entity_type_id = 4 and attribute_code = 'name';

select attribute_id from eav_attribute
where entity_type_id = 3 and attribute_code = 'name';

select cpe.sku 'Sku', ccev.value 'Category Name', cpev.value 'Product Name'
from catalog_product_entity cpe
join catalog_product_entity_varchar cpev
on cpe.entity_id = cpev.entity_id
join catalog_category_product ccp
on ccp.product_id = cpe.entity_id
join catalog_category_entity_varchar ccev
on ccev.entity_id = ccp.category_id
where cpev.attribute_id = 71 -- THIS IS THE PRODUCT NAME
and ccev.attribute_id = 41; -- THIS IS THE CATEGORY NAME