Last active
August 29, 2015 14:07
-
-
Save tessguefen/ae6ab12fdb169ef15ffe to your computer and use it in GitHub Desktop.
Magento -- Categories
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Check for 111 and 149 to make sure it's correct. | |
SELECT DISTINCT cc.entity_id as id, cc.value as path, cc1.value as name | |
FROM catalog_category_entity_varchar cc | |
JOIN catalog_category_entity_varchar cc1 ON cc.entity_id=cc1.entity_id | |
JOIN eav_entity_type ee ON cc.entity_type_id=ee.entity_type_id | |
JOIN catalog_category_entity cce ON cc.entity_id=cce.entity_id | |
WHERE cc.attribute_id = '111' AND cc1.attribute_id = '479' AND ee.entity_model = 'catalog/category'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment