From 6c971d56e23433870935b020059631079afb300f Mon Sep 17 00:00:00 2001 From: Matthias Schmidt Date: Sun, 20 Mar 2016 14:10:49 +0100 Subject: [PATCH] Use INNER JOIN instead of LEFT JOIN --- ...ntModerationQueueCommentUserNotificationObjectType.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientModerationQueueCommentUserNotificationObjectType.class.php b/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientModerationQueueCommentUserNotificationObjectType.class.php index 0891a2971f..9500f58918 100644 --- a/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientModerationQueueCommentUserNotificationObjectType.class.php +++ b/wcfsetup/install/files/lib/system/user/notification/object/type/TMultiRecipientModerationQueueCommentUserNotificationObjectType.class.php @@ -52,7 +52,7 @@ trait TMultiRecipientModerationQueueCommentUserNotificationObjectType { ( SELECT DISTINCT comment_response.userID FROM wcf".WCF_N."_comment_response comment_response - LEFT JOIN wcf".WCF_N."_comment comment + INNER JOIN wcf".WCF_N."_comment comment ON (comment.commentID = comment_response.commentID) WHERE comment.objectID = ? AND comment.objectTypeID = ? -- 2.20.1