problem.non_public = 'f' and problem.state in
        ('confirmed', 'investigating', 'planned', 'in progress',
         'fixed', 'fixed - council', 'fixed - user', 'closed'
         'action scheduled', 'not responsible', 'duplicate', 'unable to fix',
         'internal referral' )