multiple where conditions
customer and location conditions are required