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 = '6280' 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 = 'D1' OR store_filters.code = 'D2' OR store_filters.code = 'D3' OR store_filters.code = 'D4' OR store_filters.code = 'D5' OR store_filters.code = 'DS' ) 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
Land Rover Brakes To get the very best out of your Land Rover, a good set of brakes is essential to get the very best performance out of your vehicle. We have Land Rover series 1, 2 and 3 brakes in stock right now so no matter whether you are a Discovery, Defender, Range Rover or Freelander driver well have the right parts for you. And, here at our Cannock workshop we can install your brakes or make any modifications while you wait. With over four decades of experience, you are in very safe hands with John Craddock.
Why Choose John Craddock for Land Rover Brakes? We have the largest selection of Land Rover parts in the world and have the knowledge and expertise to find you exactly what you need. At John Craddock, we have Land Rover brake plates, drum brakes, brake hose sets, brakes discs, brakes pedals, brake pipes, brakes shoes and brake springs. No matter the age or model, we will find you the right part and if we dont have it in stock we will source it from one of our many suppliers around the globe. We can help make your Land Rover more suitable for off road activities or simply increase the safety of your vehicle when travelling on the roads.
Get in Touch for Land Rover Brakes You can see for yourself the full range of Land Rover brakes we have online here as well as our full range of parts and accessories. You can also see our special offers and we are continually updating our catalogue with the latest products. If you would like to know more about our Land Rover brakes please dont hesitate to get in touch with us today by phone, email or filling in an enquiry form.