Bulltear Index Bulltear E-Store jeep forums contact


Pro comp Electric fuel pump 115-140GPH

Pro comp Electric fuel pump 115-140GPH
Choose betwen red, blue and black label fuel pumps. Electric fuel pumps free up horsepower and supply fuel at the turn of the key for quick no hassle starts!

Red label 115GPH @ 7psi

Blue label 130GPH @14psi

Black label 140GPH @9psi

Available Options:

Style of pump:

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