From e0b33b36a21d7803353692372d7ceb90683d8888 Mon Sep 17 00:00:00 2001 From: Hypolite Petovan Date: Sun, 22 Apr 2018 04:41:53 -0400 Subject: [PATCH] Decrease scope of query in Profile::getEventsReminderHTML - Use specific SELECT fields - Use INNER JOIN --- src/Model/Profile.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/Model/Profile.php b/src/Model/Profile.php index 2238b3aac5..1088ea600e 100644 --- a/src/Model/Profile.php +++ b/src/Model/Profile.php @@ -646,9 +646,9 @@ class Profile $self = dba::selectFirst('contact', ['id'], ['uid' => local_user(), 'self' => true]); $s = dba::p( - "SELECT * + "SELECT `event`.* FROM `event` - JOIN `item` + INNER JOIN `item` ON `item`.`uid` = `event`.`uid` AND `item`.`parent-uri` = `event`.`uri` WHERE `event`.`uid` = ? -- 2.39.5