$179.00 S4S WaterNeck modified for Single Turbo

S4S WaterNeck modified for Single Turbo

This is another EXCLUSIVE item that we offer! If you have a 1993-98 Supra and have upgraded your turbo(s), this SpeedForSale WaterNeck is the perfect solution for those of you who do not want to worry about either putting caps or a recirculated hose on the two male barbed nipples that act as the stock twin turbo coolant returns only to have them rip, come off, or crack and leak as more time and mileage pass! This package also includes NEW OEM Toyota O-rings and gasket. We do this to all Supras that we modify here with turbo upgrades, so we decided to offer them to the public either outright. We will also offer you $25 shipped for your old waterneck if you would like to mail it back to us so you have NO down time!

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