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 = '6335' 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: Electricals We have a huge range of Freelander parts in stock now and have a wide selection of electrical products available. Our range includes alternators, dynamos, cable clips, ties, grommets, ECUs, fuses, relays, cables, harnesses, lights, lenses, bulbs and starter motors to name just a few. Whether you want to improve the quality of your in car entertainment or want to add in a parking sensor, we have all the Freelander parts you could ever need. And, if you make an order of 50 or more, we will deliver your Freelander parts totally free of charge anywhere in the UK. John Craddock also offer worldwide shipping and you can keep an eye on the progress of it with our state of the art tracking system.