$170.99 Turbosmart Universal Kompact Dual Port

Turbosmart Universal Kompact Dual Port

DESCRIPTION: Dual outlet-type BOV. Dual Port vents both to the atmosphere and back into the air intake. Ports with sequential timing allow quieter operation during normal driving, while getting all the benefits of a vent-to-atmosphere BOV under race conditions. Easily converted to a full atmospheric or full bypass unit by using supplied port blanking plug.

APPLICATION: Fits most cars using the factory BOSCH or DENSO bypass valves.

Available in 20mm, 25mm or 34mm outlet

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'speedfor_newstore.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' AND opa.products_id = '1650' and opa.orders_id = opb.orders_id and opb.products_id != '1650' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6