This is a demo store. No orders will be fulfilled.

Bras & Tanks

SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `mgde_catalog_product_entity_varchar` AS `t_d` INNER JOIN `mgde_catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `mgde_catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1785)) AND (t_d.attribute_id IN (70, 84, 85, 86, 106, 107, 108, 114, 122, 150)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `mgde_catalog_product_entity_text` AS `t_d` INNER JOIN `mgde_catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `mgde_catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1785)) AND (t_d.attribute_id IN (73)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `mgde_catalog_product_entity_decimal` AS `t_d` INNER JOIN `mgde_catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `mgde_catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1785)) AND (t_d.attribute_id IN (75, 113)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `mgde_catalog_product_entity_datetime` AS `t_d` INNER JOIN `mgde_catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `mgde_catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1785)) AND (t_d.attribute_id IN (76, 77, 91, 92)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `mgde_catalog_product_entity_int` AS `t_d` INNER JOIN `mgde_catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `mgde_catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (1785)) AND (t_d.attribute_id IN (90, 94, 115, 117, 118, 119, 124, 127, 129, 137)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
Copyright © 2015 Magento. All rights reserved.