Miles: Added query to get all customers in a 'franchise'.