Split subquery into multiple lines
authorMatthias Schmidt <gravatronics@live.com>
Thu, 4 Feb 2021 13:13:20 +0000 (14:13 +0100)
committerMatthias Schmidt <gravatronics@live.com>
Thu, 4 Feb 2021 13:13:20 +0000 (14:13 +0100)
files/lib/system/worker/ConversationMessageRebuildDataWorker.class.php

index db32f51f33b9e7305c7d3b50f0eb310e3186143d..5e044a144b77d2013c13a885d012c3631adb35d5 100644 (file)
@@ -58,7 +58,11 @@ class ConversationMessageRebuildDataWorker extends AbstractRebuildDataWorker
     {
         $this->objectList = new ConversationMessageList();
         $this->objectList->sqlOrderBy = 'conversation_message.messageID';
-        $this->objectList->sqlSelects = '(SELECT subject FROM wcf' . WCF_N . '_conversation WHERE conversationID = conversation_message.conversationID) AS subject';
+        $this->objectList->sqlSelects = '(
+            SELECT  subject
+            FROM    wcf' . WCF_N . '_conversation
+            WHERE   conversationID = conversation_message.conversationID
+        ) AS subject';
     }
 
     /**