Cooling & Heating

Error filtering template: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s), query was: SELECT `e`.*, `pr`.*, `at_c2c_c2c_color`.`value` AS `c2c_c2c_color`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_relation` AS `pr` ON e.entity_id = pr.child_id INNER JOIN `catalog_product_entity_int` AS `at_c2c_c2c_color` ON (`at_c2c_c2c_color`.`entity_id` = `e`.`entity_id`) AND (`at_c2c_c2c_color`.`attribute_id` = '216') AND (`at_c2c_c2c_color`.`store_id` = 0) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (pr.parent_id = '3679') AND (at_c2c_c2c_color.value = 'Green', 'Natural')