From 17d09f4b993767e7ad794d155cf66112a9bf3be2 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Sun, 19 Jan 2025 19:46:18 +0200 Subject: feat(models/webpage): Fix logic for get_all --- models/webpage.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'models/webpage.php') diff --git a/models/webpage.php b/models/webpage.php index 9dcc5ae..a7fa1b9 100644 --- a/models/webpage.php +++ b/models/webpage.php @@ -29,7 +29,8 @@ class Webpage extends Table { return Table::_get_all( 'Webpages', 'Database\Webpage', - "GROUP BY URL ORDER BY Visits DESC, Date DESC LIMIT $count" + "GROUP BY URL ORDER BY Visits DESC, Date DESC LIMIT $count", + 'WID,Path,URL,Date,MAX(Visits) as Visits,RequesterUID' ); } -- cgit v1.2.3