summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2020-04-19 16:50:50 +0200
committerDaniel Friesel <derf@finalrewind.org>2020-04-19 16:50:50 +0200
commit0a87135e35132fc6442add641b7862fbae294862 (patch)
treed267b5c5823bd350d8c12ca58cebf60d36d8e325
parent94932c410290081461eecb2819bc187335452672 (diff)
get_top_destinations: order by count desc
order is ascending by default, resulting in flop instead of top destinations.
-rwxr-xr-xlib/Travelynx.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Travelynx.pm b/lib/Travelynx.pm
index 36a3998..37499b1 100755
--- a/lib/Travelynx.pm
+++ b/lib/Travelynx.pm
@@ -2733,7 +2733,7 @@ sub startup {
where user_id = ?
and real_dep_ts between ? and ?
group by arr_eva
- order by count
+ order by count desc
limit 5
}, $uid, $opt{after}->epoch, $opt{before}->epoch
);