Top Street Performance has just about everything in the way of air and fuel delivery components, from air cleaners to fuel pumps. Our catalog is constantly expanding with the addition of high-quality parts.
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 = 'Blue', 'Red')