changeset 67:8b0e474ba90a

fix recent sessions query
author Lewin Bormann <lbo@spheniscida.de>
date Tue, 26 Jul 2022 08:40:12 -0700
parents 26c69030419d
children 2a7b358c2710
files src/logsdb.rs
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/src/logsdb.rs	Mon Jul 25 15:33:48 2022 -0700
+++ b/src/logsdb.rs	Tue Jul 26 08:40:12 2022 -0700
@@ -393,7 +393,7 @@
     Sessions.origin_country AS origin_country,
     Sessions.origin_city AS origin_city,
     RequestLog.ua AS ua,
-    tagstring AS alltags
+    GROUP_CONCAT(tagstring, ",") AS alltags
 FROM RequestLog
 JOIN Sessions ON (RequestLog.session = Sessions.id)
 LEFT JOIN