$899.00 Hybrid GT2 Intercooler Kit, polished panel, coolant tank

Hybrid GT2 Intercooler Kit, polished panel, coolant tank
This kit includes an OEM Toyota mini-coolant overflow tank and a Titan Motorsports polished upper radiator panel. It requires the use of an aftermarket air filter, as the #1 intercooler pipe interferes with the stock air box. The size of the intercooler is 80mm thick x 780mm wide x 290mm high. Rated for up to 800 horsepower.

After years of manufacturing intercoolers and multiple revisions, Hybrid is proud to announce a revolution in intercooler design and technology. The GT2 intercooler offers a strong extruded tube and fin core with 16 rows for maximum flow and cooling efficiency. Our latest design incorporates transverse aero dynamic offset fins. This allows air to directionally pass between the fins to improve cooling plus allows plenty of air to reach the Supra’s radiator. The tubes also incorporate internal fins to further improve cooling efficiency.

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 = '543' and opa.orders_id = opb.orders_id and opb.products_id != '543' 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