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 = '6326' 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
Accessories Miscellaneous Accessories
Accessories Miscellaneous Accessories
Freelander Accessories: Miscellaneous
In this section you will find all the other Freelander accessories that dont fall into any other particular category. Youll find Freelander accessories such as the reversing camera kit and parking sensors allowing you to squeeze your vehicle into even the tightest of spots with ease. Theres also door lights, carbon fibre heated seats, head rests, digital TV tuners and so much more to choose from. We are the biggest supplier of Freelander accessories in the world, and if you cant find the exact product you are looking for, please let us know and we will do our best to source it for you from our global network of suppliers.