SELECT count(users_ID) AS TotalUsers FROM  `users` INNER JOIN `orders` ON orders.orders_users_ID = users.users_ID LEFT OUTER JOIN `users_notes` ON users_notes.n_user = users.users_ID LEFT OUTER JOIN `distributors_users_assignment` ON distributors_users_assignment.distributors_user_ID = users.users_ID WHERE users.users_relationship =  '3' AND distributors_users_assignment.distributors_ua_distributor_ID = '86' AND users.users_last_contact_made IS NOT NULL AND users.users_relationship =  '3' AND users.users_acct_type =  '0' AND users.users_keep_on_dash =  '0' AND orders.orders_delivery_name != 'WORK ORDER' GROUP BY users.users_ID HAVING MAX(orders.orders_date_purchased) < NOW( ) - INTERVAL 45 DAY AND MAX(users_notes.n_time) < NOW( ) - INTERVAL 7 DAY OR MAX(orders.orders_date_purchased) < NOW( ) - INTERVAL 45 DAY AND MAX(users_notes.n_time) IS NULL ORDER BY orders.orders_date_purchased DESC