SELECT store_filter_groups.name AS group_name, store_filters.*, COUNT(DISTINCT store_products.id) AS counter FROM store_products INNER JOIN store_products2categories ON store_products2categories.productid = store_products.id INNER JOIN store_categories ON store_categories.id = store_products2categories.categoryid AND store_categories.id = '6339' INNER JOIN store_product_types ON store_product_types.id = store_products.typeid INNER JOIN store_product_types2customer_types ON store_product_types2customer_types.producttypeid = store_product_types.id INNER JOIN customer_types ON customer_types.id = store_product_types2customer_types.customertypeid INNER JOIN store_warehouses ON store_warehouses.id = store_products.warehouseid INNER JOIN store_products2filters ON store_products2filters.productid = store_products.id INNER JOIN store_filters ON store_filters.id = store_products2filters.filterid INNER JOIN store_filter_groups ON store_filter_groups.id = store_filters.groupid WHERE ( store_filters.code = 'F1' OR store_filters.code = 'F2' ) AND store_products.active = '1' AND store_products.approved = '1' AND store_products.totallyhidden = '0' AND customer_types.id = '1' GROUP BY store_filters.id ORDER BY store_filter_groups.sort_order ASC, store_filters.sort_order ASC
Parts Fuel System
Parts Fuel System
Freelander Parts: Fuel System Nobody in the world has a wider selection of Freelander parts than John Craddock with well over 100,000 products currently available. We have everything you need to improve your Freelanders fuel system including air and breather hoses, cooling/heating, air filters, fuel pipes, fittings, clippings, fuel tanks as well as injector pumps to name just a few. All of our Freelander parts are sourced from the leading global manufacturers so you can be assured of the quality. And, we offer free uk delivery on all orders of Freelander parts over 50. You can also keep an eye on the progress of your order with our state of the art GPS tracking system.