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 = '6331' 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
Freelander Parts: Brakes When it comes to Freelander parts, nobody offers you a wider selection than John Craddock with more than 100,000 products currently in stock. We have everything you need to improve the brakes on your vehicle including brake controls, discs, calipers, pads, shoes and hundreds of other miscellaneous brake accessories. We also have all the Freelander parts needed to fit, fix or repair your brakes at home. And, we also offer free UK delivery on all orders over 50 and you can also keep an eye on the progress of your order with our state of the art GPS tracking system.