customer_client view not working with where clause as define here.
$query = 'SELECT
customer.time_zone,
customer.currency_code,
customer.descriptive_name,
customer.manager,
customer_client.resource_name,
customer_client.client_customer,
customer_client.hidden,
customer_client.level
FROM
customer_client
WHERE
customer.test_account != TRUE'