Mercurial > lbo > hg > analyrics
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