Formulate Fabric

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 `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1755003600' AND e.updated_in > '1755003600') LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 62 WHERE (e.entity_id IN (9612, 9615)) AND (t_d.attribute_id IN (221, 263, 266, 269, 329, 332, 335, 374, 383, 527, 838, 865, 1415, 1418, 1421)) 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 `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1755003600' AND e.updated_in > '1755003600') LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 62 WHERE (e.entity_id IN (9612, 9615)) AND (t_d.attribute_id IN (230, 637, 661, 730, 984, 998, 1040, 1043, 1052, 1152)) 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 `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1755003600' AND e.updated_in > '1755003600') LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 62 WHERE (e.entity_id IN (9612, 9615)) AND (t_d.attribute_id IN (233, 236, 380, 398, 404, 407)) 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 `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1755003600' AND e.updated_in > '1755003600') LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 62 WHERE (e.entity_id IN (9612, 9615)) AND (t_d.attribute_id IN (239, 242, 284, 287)) 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 `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1755003600' AND e.updated_in > '1755003600') LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 62 WHERE (e.entity_id IN (9612, 9615)) AND (t_d.attribute_id IN (293, 353, 359, 362, 365, 386, 395, 401, 449, 640, 733, 995, 1007, 1149, 1242, 1381, 1409, 1412)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))

Get a Quote for

Customer Name

Customer Email

Phone Number

Comment

Submit