System Information PHP Version: 7.1.14 WoltLab Suite Core: 3.0.12 pl 1 Peak Memory Usage: 15.205/256 MiB Request URI: /search/ Referrer: https://www.domain.de/ User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0 SeaMonkey/2.46 Final Error Error Type: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT wcf2_article_content.articleContentID AS objectID, wcf2_article_content.title AS subject, wcf2_article.time AS time, wcf2_article.username AS username, 'com.woltlab.wcf.article' AS objectType, search_index.relevance FROM wcf2_article_content INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (wcf2_article_content.articleContentID = search_index.objectID) INNER JOIN wcf2_article ON (wcf2_article.articleID = wcf2_article_content.articleID) WHERE wcf2_article.categoryID IN (?,?) AND wcf2_article.publicationStatus = ? UNION ALL SELECT wcf2_conversation_message.messageID AS objectID, conversation.subject AS subject, wcf2_conversation_message.time AS time, wcf2_conversation_message.username AS username, 'com.woltlab.wcf.conversation.message' AS objectType, search_index.relevance FROM wcf2_conversation_message INNER JOIN ( SELECT '3625' AS objectID, '25' AS relevance UNION ALL SELECT '3535' AS objectID, '24' AS relevance UNION ALL SELECT '3407' AS objectID, '23' AS relevance UNION ALL SELECT '3366' AS objectID, '22' AS relevance UNION ALL SELECT '3217' AS objectID, '21' AS relevance UNION ALL SELECT '3216' AS objectID, '20' AS relevance UNION ALL SELECT '3203' AS objectID, '19' AS relevance UNION ALL SELECT '3197' AS objectID, '18' AS relevance UNION ALL SELECT '3196' AS objectID, '17' AS relevance UNION ALL SELECT '3195' AS objectID, '16' AS relevance UNION ALL SELECT '3093' AS objectID, '15' AS relevance UNION ALL SELECT '3044' AS objectID, '14' AS relevance UNION ALL SELECT '3031' AS objectID, '13' AS relevance UNION ALL SELECT '3026' AS objectID, '12' AS relevance UNION ALL SELECT '2928' AS objectID, '11' AS relevance UNION ALL SELECT '2915' AS objectID, '10' AS relevance UNION ALL SELECT '2912' AS objectID, '9' AS relevance UNION ALL SELECT '690' AS objectID, '8' AS relevance UNION ALL SELECT '688' AS objectID, '7' AS relevance UNION ALL SELECT '597' AS objectID, '6' AS relevance UNION ALL SELECT '538' AS objectID, '5' AS relevance UNION ALL SELECT '381' AS objectID, '4' AS relevance UNION ALL SELECT '200' AS objectID, '3' AS relevance UNION ALL SELECT '150' AS objectID, '2' AS relevance UNION ALL SELECT '89' AS objectID, '1' AS relevance ) search_index ON (wcf2_conversation_message.messageID = search_index.objectID) JOIN wcf2_conversation_to_user conversation_to_user ON (conversation_to_user.participantID = 1 AND conversation_to_user.conversationID = wcf2_conversation_message.conversationID) LEFT JOIN wcf2_conversation conversation ON (conversation.conversationID = wcf2_conversation_message.conversationID) WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL SELECT wbb2_post.postID AS objectID, wbb2_post.subject AS subject, wbb2_post.time AS time, wbb2_post.username AS username, 'com.woltlab.wbb.post' AS objectType, search_index.relevance FROM wbb2_post INNER JOIN ( SELECT '1172' AS objectID, '17' AS relevance UNION ALL SELECT '1169' AS objectID, '16' AS relevance UNION ALL SELECT '1011' AS objectID, '15' AS relevance UNION ALL SELECT '849' AS objectID, '14' AS relevance UNION ALL SELECT '782' AS objectID, '13' AS relevance UNION ALL SELECT '721' AS objectID, '12' AS relevance UNION ALL SELECT '717' AS objectID, '11' AS relevance UNION ALL SELECT '696' AS objectID, '10' AS relevance UNION ALL SELECT '695' AS objectID, '9' AS relevance UNION ALL SELECT '693' AS objectID, '8' AS relevance UNION ALL SELECT '684' AS objectID, '7' AS relevance UNION ALL SELECT '682' AS objectID, '6' AS relevance UNION ALL SELECT '544' AS objectID, '5' AS relevance UNION ALL SELECT '304' AS objectID, '4' AS relevance UNION ALL SELECT '141' AS objectID, '3' AS relevance UNION ALL SELECT '138' AS objectID, '2' AS relevance UNION ALL SELECT '128' AS objectID, '1' AS relevance ) search_index ON (wbb2_post.postID = search_index.objectID) LEFT JOIN wbb2_thread thread ON (thread.threadID = wbb2_post.threadID) WHERE wbb2_post.isDeleted = 0 AND wbb2_post.isDisabled = 0 UNION ALL SELECT gallery2_image.imageID AS objectID, gallery2_image.title AS subject, gallery2_image.uploadTime AS time, gallery2_image.username AS username, 'com.woltlab.gallery.image' AS objectType, search_index.relevance FROM gallery2_image INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (gallery2_image.imageID = search_index.objectID) WHERE gallery2_image.imageID IN (SELECT imageID FROM gallery2_image_to_category WHERE categoryID IN (?,?,?,?,?)) AND gallery2_image.isDisabled = 0 AND gallery2_image.isDeleted = 0 AND (gallery2_image.accessLevel IN (?, ?) OR (gallery2_image.accessLevel IN (?, ?) AND gallery2_image.userID = ?) OR gallery2_image.accessLevel = ?) UNION ALL SELECT lexicon2_entry.entryID AS objectID, lexicon2_entry.subject AS subject, lexicon2_entry.time AS time, lexicon2_entry.username AS username, 'com.viecode.lexicon.entry' AS objectType, search_index.relevance FROM lexicon2_entry INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (lexicon2_entry.entryID = search_index.objectID) WHERE lexicon2_entry.entryID IN (SELECT entryID FROM lexicon2_entry_to_category WHERE categoryID IN (?,?,?,?,?)) AND lexicon2_entry.isDisabled = 0 UNION ALL SELECT filebase2_file.fileID AS objectID, filebase2_file.subject AS subject, filebase2_file.time AS time, filebase2_file.username AS username, 'com.woltlab.filebase.file' AS objectType, search_index.relevance FROM filebase2_file INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (filebase2_file.fileID = search_index.objectID) WHERE filebase2_file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND filebase2_file.isDisabled = 0 AND filebase2_file.isDeleted = 0 UNION ALL SELECT DISTINCT(news2_news.newsID) AS objectID, news2_news.subject AS subject, news2_news.time AS time, news2_news.username AS username, 'de.wbb-elite.news.search' AS objectType search_index.relevance FROM news2_news INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (news2_news.newsID = search_index.objectID) WHERE news2_news.newsID IN (SELECT newsID FROM news2_news_to_category WHERE categoryID IN (?,?,?,?)) AND news2_news.isDisabled = 0 AND news2_news.isDeleted = 0 UNION ALL SELECT bannerID AS objectID, title AS subject, time AS time, '' AS username, 'com.kittmedia.wcf.partners.partner' AS objectType, search_index.relevance FROM wcf2_partners_banner INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (bannerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT partnerID AS objectID, title AS subject, time AS time, '' AS username, 'com.kittmedia.wcf.partners.banner' AS objectType, search_index.relevance FROM wcf2_partners_partner INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (partnerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT easymedia2_video.videoID AS objectID, easymedia2_video.title AS subject, easymedia2_video.uploadTime AS time, easymedia2_video.username AS username, 'com.cls.easymedia.video' AS objectType, search_index.relevance FROM easymedia2_video INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (easymedia2_video.videoID = search_index.objectID) WHERE easymedia2_video.videoID IN (SELECT videoID FROM easymedia2_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_video.isDisabled = 0 AND easymedia2_video.isDeleted = 0 AND (easymedia2_video.access IN (?, ?) OR (easymedia2_video.access IN (?, ?) AND easymedia2_video.userID = ?)) UNION ALL SELECT easymedia2_image.imageID AS objectID, easymedia2_image.title AS subject, easymedia2_image.uploadTime AS time, easymedia2_image.username AS username, 'com.cls.easymedia.image' AS objectType, search_index.relevance FROM easymedia2_image INNER JOIN ( SELECT '0' AS objectID, '0' AS relevance ) search_index ON (easymedia2_image.imageID = search_index.objectID) WHERE easymedia2_image.imageID IN (SELECT imageID FROM easymedia2_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_image.isDisabled = 0 AND easymedia2_image.isDeleted = 0 AND (easymedia2_image.access IN (?, ?) OR (easymedia2_image.access IN (?, ?) AND easymedia2_image.userID = ?)) ORDER BY time DESC LIMIT 1000' Error Code: 42000 File: */lib/system/database/Database.class.php (240) Stack Trace: #0 */lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (90): wcf\system\database\Database->prepareStatement('SELECT wcf2_article_content.articleContentID AS objectID, wcf2_article_content.title AS subject, wcf2_article.time AS time, wcf2_article.username AS username, \'com.woltlab.wcf.article\' AS objectType, search_index.relevance FROM wcf2_article_content INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (wcf2_article_content.articleContentID = search_index.objectID) INNER JOIN wcf2_article ON (wcf2_article.articleID = wcf2_article_content.articleID) WHERE wcf2_article.categoryID IN (?,?) AND wcf2_article.publicationStatus = ? UNION ALL SELECT wcf2_conversation_message.messageID AS objectID, conversation.subject AS subject, wcf2_conversation_message.time AS time, wcf2_conversation_message.username AS username, \'com.woltlab.wcf.conversation.message\' AS objectType, search_index.relevance FROM wcf2_conversation_message INNER JOIN ( SELECT \'3625\' AS objectID, \'25\' AS relevance UNION ALL SELECT \'3535\' AS objectID, \'24\' AS relevance UNION ALL SELECT \'3407\' AS objectID, \'23\' AS relevance UNION ALL SELECT \'3366\' AS objectID, \'22\' AS relevance UNION ALL SELECT \'3217\' AS objectID, \'21\' AS relevance UNION ALL SELECT \'3216\' AS objectID, \'20\' AS relevance UNION ALL SELECT \'3203\' AS objectID, \'19\' AS relevance UNION ALL SELECT \'3197\' AS objectID, \'18\' AS relevance UNION ALL SELECT \'3196\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'3195\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'3093\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'3044\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'3031\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'3026\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'2928\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'2915\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'2912\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'690\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'688\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'597\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'538\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'381\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'200\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'150\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'89\' AS objectID, \'1\' AS relevance ) search_index ON (wcf2_conversation_message.messageID = search_index.objectID) JOIN wcf2_conversation_to_user conversation_to_user ON (conversation_to_user.participantID = 1 AND conversation_to_user.conversationID = wcf2_conversation_message.conversationID) LEFT JOIN wcf2_conversation conversation ON (conversation.conversationID = wcf2_conversation_message.conversationID) WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL SELECT wbb2_post.postID AS objectID, wbb2_post.subject AS subject, wbb2_post.time AS time, wbb2_post.username AS username, \'com.woltlab.wbb.post\' AS objectType, search_index.relevance FROM wbb2_post INNER JOIN ( SELECT \'1172\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'1169\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'1011\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'849\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'782\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'721\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'717\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'696\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'695\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'693\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'684\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'682\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'544\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'304\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'141\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'138\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'128\' AS objectID, \'1\' AS relevance ) search_index ON (wbb2_post.postID = search_index.objectID) LEFT JOIN wbb2_thread thread ON (thread.threadID = wbb2_post.threadID) WHERE wbb2_post.isDeleted = 0 AND wbb2_post.isDisabled = 0 UNION ALL SELECT gallery2_image.imageID AS objectID, gallery2_image.title AS subject, gallery2_image.uploadTime AS time, gallery2_image.username AS username, \'com.woltlab.gallery.image\' AS objectType, search_index.relevance FROM gallery2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (gallery2_image.imageID = search_index.objectID) WHERE gallery2_image.imageID IN (SELECT imageID FROM gallery2_image_to_category WHERE categoryID IN (?,?,?,?,?)) AND gallery2_image.isDisabled = 0 AND gallery2_image.isDeleted = 0 AND (gallery2_image.accessLevel IN (?, ?) OR (gallery2_image.accessLevel IN (?, ?) AND gallery2_image.userID = ?) OR gallery2_image.accessLevel = ?) UNION ALL SELECT lexicon2_entry.entryID AS objectID, lexicon2_entry.subject AS subject, lexicon2_entry.time AS time, lexicon2_entry.username AS username, \'com.viecode.lexicon.entry\' AS objectType, search_index.relevance FROM lexicon2_entry INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (lexicon2_entry.entryID = search_index.objectID) WHERE lexicon2_entry.entryID IN (SELECT entryID FROM lexicon2_entry_to_category WHERE categoryID IN (?,?,?,?,?)) AND lexicon2_entry.isDisabled = 0 UNION ALL SELECT filebase2_file.fileID AS objectID, filebase2_file.subject AS subject, filebase2_file.time AS time, filebase2_file.username AS username, \'com.woltlab.filebase.file\' AS objectType, search_index.relevance FROM filebase2_file INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (filebase2_file.fileID = search_index.objectID) WHERE filebase2_file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND filebase2_file.isDisabled = 0 AND filebase2_file.isDeleted = 0 UNION ALL SELECT DISTINCT(news2_news.newsID) AS objectID, news2_news.subject AS subject, news2_news.time AS time, news2_news.username AS username, \'de.wbb-elite.news.search\' AS objectType search_index.relevance FROM news2_news INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (news2_news.newsID = search_index.objectID) WHERE news2_news.newsID IN (SELECT newsID FROM news2_news_to_category WHERE categoryID IN (?,?,?,?)) AND news2_news.isDisabled = 0 AND news2_news.isDeleted = 0 UNION ALL SELECT bannerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.partner\' AS objectType, search_index.relevance FROM wcf2_partners_banner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (bannerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT partnerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.banner\' AS objectType, search_index.relevance FROM wcf2_partners_partner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (partnerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT easymedia2_video.videoID AS objectID, easymedia2_video.title AS subject, easymedia2_video.uploadTime AS time, easymedia2_video.username AS username, \'com.cls.easymedia.video\' AS objectType, search_index.relevance FROM easymedia2_video INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_video.videoID = search_index.objectID) WHERE easymedia2_video.videoID IN (SELECT videoID FROM easymedia2_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_video.isDisabled = 0 AND easymedia2_video.isDeleted = 0 AND (easymedia2_video.access IN (?, ?) OR (easymedia2_video.access IN (?, ?) AND easymedia2_video.userID = ?)) UNION ALL SELECT easymedia2_image.imageID AS objectID, easymedia2_image.title AS subject, easymedia2_image.uploadTime AS time, easymedia2_image.username AS username, \'com.cls.easymedia.image\' AS objectType, search_index.relevance FROM easymedia2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_image.imageID = search_index.objectID) WHERE easymedia2_image.imageID IN (SELECT imageID FROM easymedia2_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_image.isDisabled = 0 AND easymedia2_image.isDeleted = 0 AND (easymedia2_image.access IN (?, ?) OR (easymedia2_image.access IN (?, ?) AND easymedia2_image.userID = ?)) ORDER BY time DESC LIMIT 1000', 1000) #1 */lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search('i3d', [ 11 items ], 0, wcf\system\database\util\ElasticsearchPreparedStatementConditionBuilder, [ 11 items ], 'time DESC', 1000) #2 */lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search('i3d', [ 11 items ], 0, wcf\system\database\util\ElasticsearchPreparedStatementConditionBuilder, [ 11 items ], 'time DESC') #3 */lib/form/AbstractForm.class.php (59): wcf\form\SearchForm->validate() #4 */lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit() #5 */lib/form/AbstractForm.class.php (112): wcf\form\SearchForm->submit() #6 */lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData() #7 */lib/page/AbstractPage.class.php (276): wcf\form\AbstractCaptchaForm->readData() #8 */lib/form/SearchForm.class.php (414): wcf\page\AbstractPage->show() #9 */lib/page/AbstractPage.class.php (103): wcf\form\SearchForm->show() #10 */lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run() #11 */lib/system/request/RequestHandler.class.php (94): wcf\system\request\Request->execute() #12 */index.php (9): wcf\system\request\RequestHandler->handle('wcf') Original Error Error Type: PDOException Error Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'search_index.relevance FROM news2_news INNER JOIN ( SELECT '0' at line 66 Error Code: 42000 File: */lib/system/database/Database.class.php (235) Stack Trace: #0 */lib/system/database/Database.class.php (235): PDO->prepare('SELECT wcf2_article_content.articleContentID AS objectID, wcf2_article_content.title AS subject, wcf2_article.time AS time, wcf2_article.username AS username, \'com.woltlab.wcf.article\' AS objectType, search_index.relevance FROM wcf2_article_content INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (wcf2_article_content.articleContentID = search_index.objectID) INNER JOIN wcf2_article ON (wcf2_article.articleID = wcf2_article_content.articleID) WHERE wcf2_article.categoryID IN (?,?) AND wcf2_article.publicationStatus = ? UNION ALL SELECT wcf2_conversation_message.messageID AS objectID, conversation.subject AS subject, wcf2_conversation_message.time AS time, wcf2_conversation_message.username AS username, \'com.woltlab.wcf.conversation.message\' AS objectType, search_index.relevance FROM wcf2_conversation_message INNER JOIN ( SELECT \'3625\' AS objectID, \'25\' AS relevance UNION ALL SELECT \'3535\' AS objectID, \'24\' AS relevance UNION ALL SELECT \'3407\' AS objectID, \'23\' AS relevance UNION ALL SELECT \'3366\' AS objectID, \'22\' AS relevance UNION ALL SELECT \'3217\' AS objectID, \'21\' AS relevance UNION ALL SELECT \'3216\' AS objectID, \'20\' AS relevance UNION ALL SELECT \'3203\' AS objectID, \'19\' AS relevance UNION ALL SELECT \'3197\' AS objectID, \'18\' AS relevance UNION ALL SELECT \'3196\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'3195\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'3093\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'3044\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'3031\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'3026\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'2928\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'2915\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'2912\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'690\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'688\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'597\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'538\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'381\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'200\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'150\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'89\' AS objectID, \'1\' AS relevance ) search_index ON (wcf2_conversation_message.messageID = search_index.objectID) JOIN wcf2_conversation_to_user conversation_to_user ON (conversation_to_user.participantID = 1 AND conversation_to_user.conversationID = wcf2_conversation_message.conversationID) LEFT JOIN wcf2_conversation conversation ON (conversation.conversationID = wcf2_conversation_message.conversationID) WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL SELECT wbb2_post.postID AS objectID, wbb2_post.subject AS subject, wbb2_post.time AS time, wbb2_post.username AS username, \'com.woltlab.wbb.post\' AS objectType, search_index.relevance FROM wbb2_post INNER JOIN ( SELECT \'1172\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'1169\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'1011\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'849\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'782\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'721\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'717\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'696\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'695\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'693\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'684\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'682\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'544\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'304\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'141\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'138\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'128\' AS objectID, \'1\' AS relevance ) search_index ON (wbb2_post.postID = search_index.objectID) LEFT JOIN wbb2_thread thread ON (thread.threadID = wbb2_post.threadID) WHERE wbb2_post.isDeleted = 0 AND wbb2_post.isDisabled = 0 UNION ALL SELECT gallery2_image.imageID AS objectID, gallery2_image.title AS subject, gallery2_image.uploadTime AS time, gallery2_image.username AS username, \'com.woltlab.gallery.image\' AS objectType, search_index.relevance FROM gallery2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (gallery2_image.imageID = search_index.objectID) WHERE gallery2_image.imageID IN (SELECT imageID FROM gallery2_image_to_category WHERE categoryID IN (?,?,?,?,?)) AND gallery2_image.isDisabled = 0 AND gallery2_image.isDeleted = 0 AND (gallery2_image.accessLevel IN (?, ?) OR (gallery2_image.accessLevel IN (?, ?) AND gallery2_image.userID = ?) OR gallery2_image.accessLevel = ?) UNION ALL SELECT lexicon2_entry.entryID AS objectID, lexicon2_entry.subject AS subject, lexicon2_entry.time AS time, lexicon2_entry.username AS username, \'com.viecode.lexicon.entry\' AS objectType, search_index.relevance FROM lexicon2_entry INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (lexicon2_entry.entryID = search_index.objectID) WHERE lexicon2_entry.entryID IN (SELECT entryID FROM lexicon2_entry_to_category WHERE categoryID IN (?,?,?,?,?)) AND lexicon2_entry.isDisabled = 0 UNION ALL SELECT filebase2_file.fileID AS objectID, filebase2_file.subject AS subject, filebase2_file.time AS time, filebase2_file.username AS username, \'com.woltlab.filebase.file\' AS objectType, search_index.relevance FROM filebase2_file INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (filebase2_file.fileID = search_index.objectID) WHERE filebase2_file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND filebase2_file.isDisabled = 0 AND filebase2_file.isDeleted = 0 UNION ALL SELECT DISTINCT(news2_news.newsID) AS objectID, news2_news.subject AS subject, news2_news.time AS time, news2_news.username AS username, \'de.wbb-elite.news.search\' AS objectType search_index.relevance FROM news2_news INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (news2_news.newsID = search_index.objectID) WHERE news2_news.newsID IN (SELECT newsID FROM news2_news_to_category WHERE categoryID IN (?,?,?,?)) AND news2_news.isDisabled = 0 AND news2_news.isDeleted = 0 UNION ALL SELECT bannerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.partner\' AS objectType, search_index.relevance FROM wcf2_partners_banner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (bannerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT partnerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.banner\' AS objectType, search_index.relevance FROM wcf2_partners_partner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (partnerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT easymedia2_video.videoID AS objectID, easymedia2_video.title AS subject, easymedia2_video.uploadTime AS time, easymedia2_video.username AS username, \'com.cls.easymedia.video\' AS objectType, search_index.relevance FROM easymedia2_video INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_video.videoID = search_index.objectID) WHERE easymedia2_video.videoID IN (SELECT videoID FROM easymedia2_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_video.isDisabled = 0 AND easymedia2_video.isDeleted = 0 AND (easymedia2_video.access IN (?, ?) OR (easymedia2_video.access IN (?, ?) AND easymedia2_video.userID = ?)) UNION ALL SELECT easymedia2_image.imageID AS objectID, easymedia2_image.title AS subject, easymedia2_image.uploadTime AS time, easymedia2_image.username AS username, \'com.cls.easymedia.image\' AS objectType, search_index.relevance FROM easymedia2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_image.imageID = search_index.objectID) WHERE easymedia2_image.imageID IN (SELECT imageID FROM easymedia2_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_image.isDisabled = 0 AND easymedia2_image.isDeleted = 0 AND (easymedia2_image.access IN (?, ?) OR (easymedia2_image.access IN (?, ?) AND easymedia2_image.userID = ?)) ORDER BY time DESC LIMIT 1000') #1 */lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (90): wcf\system\database\Database->prepareStatement('SELECT wcf2_article_content.articleContentID AS objectID, wcf2_article_content.title AS subject, wcf2_article.time AS time, wcf2_article.username AS username, \'com.woltlab.wcf.article\' AS objectType, search_index.relevance FROM wcf2_article_content INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (wcf2_article_content.articleContentID = search_index.objectID) INNER JOIN wcf2_article ON (wcf2_article.articleID = wcf2_article_content.articleID) WHERE wcf2_article.categoryID IN (?,?) AND wcf2_article.publicationStatus = ? UNION ALL SELECT wcf2_conversation_message.messageID AS objectID, conversation.subject AS subject, wcf2_conversation_message.time AS time, wcf2_conversation_message.username AS username, \'com.woltlab.wcf.conversation.message\' AS objectType, search_index.relevance FROM wcf2_conversation_message INNER JOIN ( SELECT \'3625\' AS objectID, \'25\' AS relevance UNION ALL SELECT \'3535\' AS objectID, \'24\' AS relevance UNION ALL SELECT \'3407\' AS objectID, \'23\' AS relevance UNION ALL SELECT \'3366\' AS objectID, \'22\' AS relevance UNION ALL SELECT \'3217\' AS objectID, \'21\' AS relevance UNION ALL SELECT \'3216\' AS objectID, \'20\' AS relevance UNION ALL SELECT \'3203\' AS objectID, \'19\' AS relevance UNION ALL SELECT \'3197\' AS objectID, \'18\' AS relevance UNION ALL SELECT \'3196\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'3195\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'3093\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'3044\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'3031\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'3026\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'2928\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'2915\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'2912\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'690\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'688\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'597\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'538\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'381\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'200\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'150\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'89\' AS objectID, \'1\' AS relevance ) search_index ON (wcf2_conversation_message.messageID = search_index.objectID) JOIN wcf2_conversation_to_user conversation_to_user ON (conversation_to_user.participantID = 1 AND conversation_to_user.conversationID = wcf2_conversation_message.conversationID) LEFT JOIN wcf2_conversation conversation ON (conversation.conversationID = wcf2_conversation_message.conversationID) WHERE conversation_to_user.hideConversation IN (0,1) UNION ALL SELECT wbb2_post.postID AS objectID, wbb2_post.subject AS subject, wbb2_post.time AS time, wbb2_post.username AS username, \'com.woltlab.wbb.post\' AS objectType, search_index.relevance FROM wbb2_post INNER JOIN ( SELECT \'1172\' AS objectID, \'17\' AS relevance UNION ALL SELECT \'1169\' AS objectID, \'16\' AS relevance UNION ALL SELECT \'1011\' AS objectID, \'15\' AS relevance UNION ALL SELECT \'849\' AS objectID, \'14\' AS relevance UNION ALL SELECT \'782\' AS objectID, \'13\' AS relevance UNION ALL SELECT \'721\' AS objectID, \'12\' AS relevance UNION ALL SELECT \'717\' AS objectID, \'11\' AS relevance UNION ALL SELECT \'696\' AS objectID, \'10\' AS relevance UNION ALL SELECT \'695\' AS objectID, \'9\' AS relevance UNION ALL SELECT \'693\' AS objectID, \'8\' AS relevance UNION ALL SELECT \'684\' AS objectID, \'7\' AS relevance UNION ALL SELECT \'682\' AS objectID, \'6\' AS relevance UNION ALL SELECT \'544\' AS objectID, \'5\' AS relevance UNION ALL SELECT \'304\' AS objectID, \'4\' AS relevance UNION ALL SELECT \'141\' AS objectID, \'3\' AS relevance UNION ALL SELECT \'138\' AS objectID, \'2\' AS relevance UNION ALL SELECT \'128\' AS objectID, \'1\' AS relevance ) search_index ON (wbb2_post.postID = search_index.objectID) LEFT JOIN wbb2_thread thread ON (thread.threadID = wbb2_post.threadID) WHERE wbb2_post.isDeleted = 0 AND wbb2_post.isDisabled = 0 UNION ALL SELECT gallery2_image.imageID AS objectID, gallery2_image.title AS subject, gallery2_image.uploadTime AS time, gallery2_image.username AS username, \'com.woltlab.gallery.image\' AS objectType, search_index.relevance FROM gallery2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (gallery2_image.imageID = search_index.objectID) WHERE gallery2_image.imageID IN (SELECT imageID FROM gallery2_image_to_category WHERE categoryID IN (?,?,?,?,?)) AND gallery2_image.isDisabled = 0 AND gallery2_image.isDeleted = 0 AND (gallery2_image.accessLevel IN (?, ?) OR (gallery2_image.accessLevel IN (?, ?) AND gallery2_image.userID = ?) OR gallery2_image.accessLevel = ?) UNION ALL SELECT lexicon2_entry.entryID AS objectID, lexicon2_entry.subject AS subject, lexicon2_entry.time AS time, lexicon2_entry.username AS username, \'com.viecode.lexicon.entry\' AS objectType, search_index.relevance FROM lexicon2_entry INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (lexicon2_entry.entryID = search_index.objectID) WHERE lexicon2_entry.entryID IN (SELECT entryID FROM lexicon2_entry_to_category WHERE categoryID IN (?,?,?,?,?)) AND lexicon2_entry.isDisabled = 0 UNION ALL SELECT filebase2_file.fileID AS objectID, filebase2_file.subject AS subject, filebase2_file.time AS time, filebase2_file.username AS username, \'com.woltlab.filebase.file\' AS objectType, search_index.relevance FROM filebase2_file INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (filebase2_file.fileID = search_index.objectID) WHERE filebase2_file.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND filebase2_file.isDisabled = 0 AND filebase2_file.isDeleted = 0 UNION ALL SELECT DISTINCT(news2_news.newsID) AS objectID, news2_news.subject AS subject, news2_news.time AS time, news2_news.username AS username, \'de.wbb-elite.news.search\' AS objectType search_index.relevance FROM news2_news INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (news2_news.newsID = search_index.objectID) WHERE news2_news.newsID IN (SELECT newsID FROM news2_news_to_category WHERE categoryID IN (?,?,?,?)) AND news2_news.isDisabled = 0 AND news2_news.isDeleted = 0 UNION ALL SELECT bannerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.partner\' AS objectType, search_index.relevance FROM wcf2_partners_banner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (bannerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT partnerID AS objectID, title AS subject, time AS time, \'\' AS username, \'com.kittmedia.wcf.partners.banner\' AS objectType, search_index.relevance FROM wcf2_partners_partner INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (partnerID = search_index.objectID) WHERE isDisabled = ? UNION ALL SELECT easymedia2_video.videoID AS objectID, easymedia2_video.title AS subject, easymedia2_video.uploadTime AS time, easymedia2_video.username AS username, \'com.cls.easymedia.video\' AS objectType, search_index.relevance FROM easymedia2_video INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_video.videoID = search_index.objectID) WHERE easymedia2_video.videoID IN (SELECT videoID FROM easymedia2_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_video.isDisabled = 0 AND easymedia2_video.isDeleted = 0 AND (easymedia2_video.access IN (?, ?) OR (easymedia2_video.access IN (?, ?) AND easymedia2_video.userID = ?)) UNION ALL SELECT easymedia2_image.imageID AS objectID, easymedia2_image.title AS subject, easymedia2_image.uploadTime AS time, easymedia2_image.username AS username, \'com.cls.easymedia.image\' AS objectType, search_index.relevance FROM easymedia2_image INNER JOIN ( SELECT \'0\' AS objectID, \'0\' AS relevance ) search_index ON (easymedia2_image.imageID = search_index.objectID) WHERE easymedia2_image.imageID IN (SELECT imageID FROM easymedia2_image_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND easymedia2_image.isDisabled = 0 AND easymedia2_image.isDeleted = 0 AND (easymedia2_image.access IN (?, ?) OR (easymedia2_image.access IN (?, ?) AND easymedia2_image.userID = ?)) ORDER BY time DESC LIMIT 1000', 1000) #2 */lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search('i3d', [ 11 items ], 0, wcf\system\database\util\ElasticsearchPreparedStatementConditionBuilder, [ 11 items ], 'time DESC', 1000) #3 */lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search('i3d', [ 11 items ], 0, wcf\system\database\util\ElasticsearchPreparedStatementConditionBuilder, [ 11 items ], 'time DESC') #4 */lib/form/AbstractForm.class.php (59): wcf\form\SearchForm->validate() #5 */lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit() #6 */lib/form/AbstractForm.class.php (112): wcf\form\SearchForm->submit() #7 */lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData() #8 */lib/page/AbstractPage.class.php (276): wcf\form\AbstractCaptchaForm->readData() #9 */lib/form/SearchForm.class.php (414): wcf\page\AbstractPage->show() #10 */lib/page/AbstractPage.class.php (103): wcf\form\SearchForm->show() #11 */lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run() #12 */lib/system/request/RequestHandler.class.php (94): wcf\system\request\Request->execute() #13 */index.php (9): wcf\system\request\RequestHandler->handle('wcf')