From 8cad29a2ab3740013c317c0cc94b43a484dbd49d Mon Sep 17 00:00:00 2001
From: gamesguru <mathmuncher11@gmail.com>
Date: Wed, 30 Sep 2020 17:21:24 -0400
Subject: [PATCH] functions

---
 sql/functions.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/sql/functions.sql b/sql/functions.sql
index c77d7e3..d47e9ab 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -151,3 +151,20 @@ WHERE
   OR tricep.value
   OR suprailiac.value;
 
+--------------------------------
+-- Recipes overview
+--------------------------------
+
+SELECT
+  id,
+  name,
+  COUNT(recipe_id) AS n_foods,
+  SUM(grams) AS grams,
+  guid,
+  created
+FROM
+  recipes
+  LEFT JOIN recipe_dat ON recipe_id = id
+GROUP BY
+  id;
+
-- 
2.52.0