mirror of
https://github.com/grocy/grocy.git
synced 2025-09-16 17:56:51 +00:00
6 lines
120 B
MySQL
6 lines
120 B
MySQL
|
CREATE VIEW habits_current
|
||
|
|
AS
|
||
|
|
SELECT habit_id, MAX(tracked_time) AS last_tracked_time
|
||
|
|
FROM habits_log
|
||
|
|
GROUP BY habit_id
|