From 0a87135e35132fc6442add641b7862fbae294862 Mon Sep 17 00:00:00 2001
From: Daniel Friesel <derf@finalrewind.org>
Date: Sun, 19 Apr 2020 16:50:50 +0200
Subject: get_top_destinations: order by count desc
order is ascending by default, resulting in flop instead of top destinations.
---
lib/Travelynx.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
(limited to 'lib')
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
);
--
cgit v1.2.3