openrat-cms

commit 73f712e583d767031be5ba24883c692ab7600a39
parent b869dfb1e2fae8f55d8c348de7a91af1ddecc2a1
Author: Jan Dankert <develop@jandankert.de>
Date:   Wed, 17 Nov 2021 23:39:22 +0100

Fix: Reading descendent pages with the content id.

Diffstat:
M
modules/cms/model/BaseObject.class.php
 | 
4
+++-

1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/modules/cms/model/BaseObject.class.php b/modules/cms/model/BaseObject.class.php
@@ -1254,8 +1254,10 @@ SQL
         $stmt = DB::sql( <<<SQL
 
 SELECT {{page}}.objectid FROM {{value}}
+              LEFT JOIN {{pagecontent}}
+                ON {{value}}.contentid = {{pagecontent}}.contentid
               LEFT JOIN {{page}}
-                ON {{value}}.pageid = {{page}}.id
+                ON {{pagecontent}}.pageid = {{page}}.id
               WHERE linkobjectid={myobjectid1}
 UNION
        SELECT objectid FROM {{link}}