From 07b8a38b2958bb8afff5db4a3e32b76311decc54 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Fri, 27 May 2022 14:21:03 +0200 Subject: [PATCH] Use INNER JOIN in RoutingCacheBuilder::getCustomUrls() The FOREIGN KEY guarantees that the row in wcf1_page exists. --- .../lib/system/cache/builder/RoutingCacheBuilder.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/cache/builder/RoutingCacheBuilder.class.php b/wcfsetup/install/files/lib/system/cache/builder/RoutingCacheBuilder.class.php index 49026d194f..24255f66c1 100644 --- a/wcfsetup/install/files/lib/system/cache/builder/RoutingCacheBuilder.class.php +++ b/wcfsetup/install/files/lib/system/cache/builder/RoutingCacheBuilder.class.php @@ -257,7 +257,7 @@ class RoutingCacheBuilder extends AbstractCacheBuilder page_content.languageID, page.applicationPackageID FROM wcf1_page_content page_content - LEFT JOIN wcf1_page page + INNER JOIN wcf1_page page ON page.pageID = page_content.pageID"; $statement = WCF::getDB()->prepare($sql); $statement->execute(); -- 2.20.1