Individually Wrapped
-
-
-
Smiles and Sun Pick & Mix Box - 20 piece
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 <= '1767243540' AND e.updated_in > '1767243540') 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 = 3 WHERE (e.entity_id IN (5431, 5434, 5437, 5440, 5443, 5446, 5449, 5452, 5455, 5458, 5461, 5464, 5467, 6574, 5494, 6005, 6008, 6002, 5999, 5996, 8660, 8663, 8675, 8684, 8687, 5978, 5984, 5981)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 129, 160, 185, 186, 187, 189, 195, 232, 244, 309, 346, 499, 544, 613, 622, 625, 705, 708, 771, 774, 780, 861, 912)) 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 <= '1767243540' AND e.updated_in > '1767243540') 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 = 3 WHERE (e.entity_id IN (5431, 5434, 5437, 5440, 5443, 5446, 5449, 5452, 5455, 5458, 5461, 5464, 5467, 6574, 5494, 6005, 6008, 6002, 5999, 5996, 8660, 8663, 8675, 8684, 8687, 5978, 5984, 5981)) AND (t_d.attribute_id IN (76, 163, 164, 166, 167, 169, 194, 228, 252, 361, 493, 562, 565, 574, 621, 679)) 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 <= '1767243540' AND e.updated_in > '1767243540') 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 = 0 WHERE (e.entity_id IN (5431, 5434, 5437, 5440, 5443, 5446, 5449, 5452, 5455, 5458, 5461, 5464, 5467, 6574, 5494, 6005, 6008, 6002, 5999, 5996, 8660, 8663, 8675, 8684, 8687, 5978, 5984, 5981)) AND (t_d.attribute_id IN (77, 78, 128, 134, 136, 137, 840, 867, 896)) 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 <= '1767243540' AND e.updated_in > '1767243540') 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 = 3 WHERE (e.entity_id IN (5431, 5434, 5437, 5440, 5443, 5446, 5449, 5452, 5455, 5458, 5461, 5464, 5467, 6574, 5494, 6005, 6008, 6002, 5999, 5996, 8660, 8663, 8675, 8684, 8687, 5978, 5984, 5981)) AND (t_d.attribute_id IN (79, 80, 94, 95)) 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 <= '1767243540' AND e.updated_in > '1767243540') 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 = 3 WHERE (e.entity_id IN (5431, 5434, 5437, 5440, 5443, 5446, 5449, 5452, 5455, 5458, 5461, 5464, 5467, 6574, 5494, 6005, 6008, 6002, 5999, 5996, 8660, 8663, 8675, 8684, 8687, 5978, 5984, 5981)) AND (t_d.attribute_id IN (97, 119, 121, 122, 123, 130, 133, 135, 147, 161, 179, 180, 181, 182, 183, 184, 188, 190, 191, 192, 193, 321, 347, 586, 609, 612, 616, 691, 702, 777, 837, 864, 870, 891, 902, 905, 909)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) $14.99
