Bulltear Index Bulltear E-Store jeep forums contact


534 Tri-flow oil filter relocation and dry sump pickup AMC V8

534 Tri-flow oil filter relocation and dry sump pickup AMC V8
534 replaces all dry sump pickups and allows the pickup tube (in the oil pan) hole to be plugged. This plate also outflows all pickups as it has CNC port matched holes. No tapping of the block is needed and this adaptor has provisions for running external coolers, oil filters, oil prelubers or/and oil volume meters or pressure sensors. Inlet port will flow to the equivalent of a -12 AN line Replaces entire oil filter adaptor. Plate has 1/2 pipe tapped holes and a large .702 throat for high flow. Easy installation and comes with pre-markings for hassle free plumbing! ***Fittings not included***
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'bulltear_store.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 where opa.products_id = '132' and opa.orders_id = opb.orders_id and opb.products_id != '132' 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 12