1 files changed, 6 insertions, 0 deletions
diff --git a/database/run.lisp b/database/run.lisp
index 30b8342..21d278a 100644
--- a/database/run.lisp
+++ b/database/run.lisp
@@ -15,3 +15,9 @@
   (mito:select-dao 'run-split
                    (sxql:order-by :category_split_id)
                    (sxql:where (:= :run run))))
+
+;; Returns stuff like PB, best of each split, etc.
+(defun run-statistics (category)
+  `((asdf . 1)))
+
+;; select *, sum(julianday(end_time)-julianday(start_time))*24*60*60 as total_time from run_split group by run_id order by total_time;