1 files changed, 3 insertions, 6 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Problem.pm b/perllib/FixMyStreet/DB/ResultSet/Problem.pm
index 5b2079831..3e48170d8 100644
--- a/perllib/FixMyStreet/DB/ResultSet/Problem.pm
+++ b/perllib/FixMyStreet/DB/ResultSet/Problem.pm
@@ -241,12 +241,9 @@ sub unique_users {
     return $rs->search( {
         state => [ FixMyStreet::DB::Result::Problem->visible_states() ],
     }, {
-        select => [ { distinct => 'user_id' } ],
-        as     => [ 'user_id' ]
-    } )->as_subselect_rs->search( undef, {
-        select => [ { count => 'user_id' } ],
-        as     => [ 'count' ]
-    } )->first->get_column('count');
+        columns => [ 'user_id' ],
+        distinct => 1,
+    } );
 }
 
 sub categories_summary {