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 <= '1672527545' AND e.updated_in > '1672527545') 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 = 6 WHERE (e.entity_id IN (297, 111, 2446, 2455, 2566, 54, 37302, 37320, 17419, 17288, 26552, 17180, 30755, 13323, 16550, 15773, 2380, 40443, 37575, 15863, 41676)) AND (t_d.attribute_id IN (616, 435, 405, 540, 628, 279, 807, 816, 819, 619, 588, 543, 622, 414, 597, 658, 649, 846, 417, 643, 423, 603, 399, 390, 249, 585, 273, 606, 631, 810, 357, 366, 637, 345, 450, 447, 369, 360, 291, 825, 900, 897, 834, 894, 441, 591, 456, 453, 438, 432, 420, 426, 561, 564, 555, 881, 813, 297, 363)) 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 <= '1672527545' AND e.updated_in > '1672527545') 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 = 6 WHERE (e.entity_id IN (297, 111, 2446, 2455, 2566, 54, 37302, 37320, 17419, 17288, 26552, 17180, 30755, 13323, 16550, 15773, 2380, 40443, 37575, 15863, 41676)) AND (t_d.attribute_id IN (600, 309, 225, 675, 726, 765, 702, 690, 687, 756, 684, 771, 738, 798, 786, 678, 777, 720, 744, 693, 732, 780, 735, 714, 750, 741, 789, 792, 681, 717, 753, 711, 705, 801, 708, 768, 723, 774, 729, 795, 696, 747, 699, 762, 783, 759, 655, 667, 661, 664, 876, 670, 255, 576, 857, 549, 609, 625, 228, 579, 567, 570, 573, 558, 582)) 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 <= '1672527545' AND e.updated_in > '1672527545') 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 (297, 111, 2446, 2455, 2566, 54, 37302, 37320, 17419, 17288, 26552, 17180, 30755, 13323, 16550, 15773, 2380, 40443, 37575, 15863, 41676)) AND (t_d.attribute_id IN (243, 402, 462, 294, 384, 411, 408, 231, 652, 234, 837, 276, 246)) 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_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= '1672527545' AND e.updated_in > '1672527545') 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 = 6 WHERE (e.entity_id IN (297, 111, 2446, 2455, 2566, 54, 37302, 37320, 17419, 17288, 26552, 17180, 30755, 13323, 16550, 15773, 2380, 40443, 37575, 15863, 41676)) AND (t_d.attribute_id IN (342, 300, 348, 351, 429, 288, 444, 459, 672, 261, 327, 531, 396, 258, 252, 387, 219, 318, 312, 393, 893, 264, 330, 828, 831, 534, 267, 333, 378, 381)) 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 <= '1672527545' AND e.updated_in > '1672527545') 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 = 6 WHERE (e.entity_id IN (297, 111, 2446, 2455, 2566, 54, 37302, 37320, 17419, 17288, 26552, 17180, 30755, 13323, 16550, 15773, 2380, 40443, 37575, 15863, 41676)) AND (t_d.attribute_id IN (303, 306, 843, 282, 285, 237, 240)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) Anna de Codorníu Cavas. Buy Anna de Codorníu cavas online| 15 Bodegas
Anna de Codorníu Cavas
Anna de Codorníu Cavas

Anna de Codorníu Cavas

Show Filters
  1. Pack
  2. Demi-sec (32-50 g/l of sugar)
Apply filters