نساء

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 <= 1 AND e.updated_in > 1) 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 = 5 WHERE (e.entity_id IN (58571, 58567, 58649, 58525, 58537, 58566)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 126, 129, 178, 184, 189, 190, 213)) 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 <= 1 AND e.updated_in > 1) 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 = 5 WHERE (e.entity_id IN (58571, 58567, 58649, 58525, 58537, 58566)) AND (t_d.attribute_id IN (76, 217, 218, 229)) 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 <= 1 AND e.updated_in > 1) 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 = 5 WHERE (e.entity_id IN (58571, 58567, 58649, 58525, 58537, 58566)) AND (t_d.attribute_id IN (78, 128, 134, 136, 137)) 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 <= 1 AND e.updated_in > 1) 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 = 5 WHERE (e.entity_id IN (58571, 58567, 58649, 58525, 58537, 58566)) AND (t_d.attribute_id IN (79, 80, 206)) 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 <= 1 AND e.updated_in > 1) 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 = 5 WHERE (e.entity_id IN (58571, 58567, 58649, 58525, 58537, 58566)) AND (t_d.attribute_id IN (93, 97, 119, 121, 122, 123, 130, 133, 135, 151, 182, 185, 192, 195, 196, 198, 199, 200, 201, 202, 204, 205, 212)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))