2 files changed, 1 insertions, 11 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Nearby.pm b/perllib/FixMyStreet/DB/ResultSet/Nearby.pm
index 4039ec6e7..91c44d5f4 100644
--- a/perllib/FixMyStreet/DB/ResultSet/Nearby.pm
+++ b/perllib/FixMyStreet/DB/ResultSet/Nearby.pm
@@ -21,12 +21,7 @@ sub nearby {
     } if $c->cobrand->problems_clause;
 
     my $attrs = {
-        join => 'problem',
-        columns => [
-            'problem.id', 'problem.title', 'problem.latitude',
-            'problem.longitude', 'distance', 'problem.state',
-            'problem.created', 'problem.confirmed', { 'problem.photo' => 'problem.photo is not null' },
-        ],
+        prefetch => 'problem',
         bind => [ $mid_lat, $mid_lon, $dist ],
         order_by => [ 'distance', { -desc => 'created' } ],
         rows => $limit,
diff --git a/perllib/FixMyStreet/DB/ResultSet/Problem.pm b/perllib/FixMyStreet/DB/ResultSet/Problem.pm
index a694c45f2..6cecdea7e 100644
--- a/perllib/FixMyStreet/DB/ResultSet/Problem.pm
+++ b/perllib/FixMyStreet/DB/ResultSet/Problem.pm
@@ -93,7 +93,6 @@ sub _recent {
     $query->{photo} = { '!=', undef } if $photos;
 
     my $attrs = {
-        columns => [ 'id', 'title', 'created', 'confirmed', 'state' ],
         order_by => { -desc => 'coalesce(confirmed, created)' },
         rows => $num,
     };
@@ -136,10 +135,6 @@ sub around_map {
     my ( $rs, $min_lat, $max_lat, $min_lon, $max_lon, $interval, $limit ) = @_;
     my $attr = {
         order_by => { -desc => 'created' },
-        columns => [
-            'id', 'title', 'latitude', 'longitude', 'state', 'created', 'confirmed',
-            { photo => 'photo is not null' },
-        ],
     };
     $attr->{rows} = $limit if $limit;