Mercurial > lbo > hg > analyrics

view schema/queries.sql @ 35:7a64e348786d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Move schema
author Lewin Bormann <lbo@spheniscida.de>
date Sat, 16 Jul 2022 10:45:28 -0700
parents queries.sql@195d92c0e106
children
line wrap: on
line source


-- Find all sessions and sort by request count
select sessions.id, start, count(*) from sessions join requestlog on
(sessions.id = requestlog.session) group by sessions.id order by 3;