diff options
| author | Dave Whiteland <dave@mysociety.org> | 2013-02-06 15:08:23 +0000 |
|---|---|---|
| committer | Dave Whiteland <dave@mysociety.org> | 2013-02-06 15:08:23 +0000 |
| commit | 0f24a44cd6e8b056db482cb91c85768b6d1e7d1d (patch) | |
| tree | 09a90f38574ee62754f3c8ac077152ed99a38296 /perllib/FixMyStreet/DB/ResultSet/Nearby.pm | |
| parent | c061769ba72f420e2f2c6064fa526648e57339f1 (diff) | |
| parent | 5b2e18389734751165d2eeb21a3b3f2e8d2e8755 (diff) | |
Merge remote branch 'origin/master' into oxfordshire-header
Diffstat (limited to 'perllib/FixMyStreet/DB/ResultSet/Nearby.pm')
| -rw-r--r-- | perllib/FixMyStreet/DB/ResultSet/Nearby.pm | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Nearby.pm b/perllib/FixMyStreet/DB/ResultSet/Nearby.pm index 191223572..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.confirmed', { 'problem.photo' => 'problem.photo is not null' }, - ], + prefetch => 'problem', bind => [ $mid_lat, $mid_lon, $dist ], order_by => [ 'distance', { -desc => 'created' } ], rows => $limit, |