Created
May 10, 2016 11:14
-
-
Save oreales/32853e174af23cde561e43f1a4a0b15a to your computer and use it in GitHub Desktop.
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
#SELECT que nos da las labels de productos configurables que no estan usando el valor por defecto (traducciones) establecido para este atributo / store view en el admin. | |
SELECT * FROM catalog_product_super_attribute_label as sal | |
LEFT JOIN catalog_product_super_attribute as sa USING (product_super_attribute_id) | |
LEFT JOIN eav_attribute_label as al ON (sal.store_id = al.store_id AND sa.attribute_id = al.attribute_id) | |
WHERE sal.store_id != 0 | |
AND sal.value != al.value; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment