Mercurial > lbo > hg > analyrics

changeset 58:2e5b0e49efe1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use left join for session log
author Lewin Bormann <lbo@spheniscida.de>
date Fri, 22 Jul 2022 21:34:34 -0700
parents ad0625965942
children 8476f6028ee9
files src/logsdb.rs
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/src/logsdb.rs	Fri Jul 22 20:56:13 2022 -0700
+++ b/src/logsdb.rs	Fri Jul 22 21:34:34 2022 -0700
@@ -424,10 +424,10 @@
     Sessions.origin_country AS origin_country,
     Sessions.origin_city AS origin_city,
     RequestLog.ua AS ua,
-    GROUP_CONCAT(IIF(value, PRINTF("%s=%s", key, value), key)) AS alltags
+    GROUP_CONCAT(IIF(value, PRINTF("%s=%s", IIF(key, key, ""), value), key)) AS alltags
 FROM RequestLog
 JOIN Sessions ON (RequestLog.session = Sessions.id)
-JOIN RequestTags ON (RequestLog.id = RequestTags.requestid)
+LEFT JOIN RequestTags ON (RequestLog.id = RequestTags.requestid)
 WHERE Sessions.is_bot <= ?
 GROUP BY Sessions.id
 ORDER BY Sessions.start DESC, RequestLog.atime DESC