From 8c97ba28924a0ef1446b5d272f3c1119ba3fc981 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Joshua=20R=C3=BCsweg?= Date: Tue, 14 Aug 2018 10:09:44 +0200 Subject: [PATCH] Use explicit join type See #2650 --- ...ntPageCommentUserNotificationObjectType.class.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientPageCommentUserNotificationObjectType.class.php b/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientPageCommentUserNotificationObjectType.class.php index 207fc7aa4c..4500b54c25 100644 --- a/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientPageCommentUserNotificationObjectType.class.php +++ b/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientPageCommentUserNotificationObjectType.class.php @@ -21,12 +21,12 @@ trait TMultiRecipientPageCommentUserNotificationObjectType { // find all userIDs with the permission to manage pages $sql = "SELECT userID FROM wcf".WCF_N."_user_to_group - JOIN wcf".WCF_N."_user_group_option_value - ON wcf".WCF_N."_user_to_group.groupID = wcf".WCF_N."_user_group_option_value.groupID - AND wcf".WCF_N."_user_group_option_value.optionValue = ? - JOIN wcf".WCF_N."_user_group_option - ON wcf".WCF_N."_user_group_option_value.optionID = wcf".WCF_N."_user_group_option.optionID - AND wcf".WCF_N."_user_group_option.optionName = ?"; + INNER JOIN wcf".WCF_N."_user_group_option_value + ON wcf".WCF_N."_user_to_group.groupID = wcf".WCF_N."_user_group_option_value.groupID + AND wcf".WCF_N."_user_group_option_value.optionValue = ? + INNER JOIN wcf".WCF_N."_user_group_option + ON wcf".WCF_N."_user_group_option_value.optionID = wcf".WCF_N."_user_group_option.optionID + AND wcf".WCF_N."_user_group_option.optionName = ?"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute([ 1, -- 2.20.1