# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1726850212 -7200
# Node ID 3a83c434b284c8342b36579e6be8c92586cb0199
# Parent  cf6aea0bf438740a67c25674aff3e84d127b73b5
fix

diff -r cf6aea0bf438 -r 3a83c434b284 Framework/Plugins/IndexBackend.cpp
--- a/Framework/Plugins/IndexBackend.cpp	Fri Sep 20 18:19:16 2024 +0200
+++ b/Framework/Plugins/IndexBackend.cpp	Fri Sep 20 18:36:52 2024 +0200
@@ -3590,8 +3590,8 @@
              "  NULL::BIGINT AS c8_big_int1, "
              "  NULL::BIGINT AS c9_big_int2 "
              "FROM Lookup "
-             "  INNER JOIN Resources ON currentLevel.internalId = Lookup.internalId "
-             "  INNER JOIN Resources parentLevel ON Lookup.parentId = parentLevel.internalId ";
+             "  INNER JOIN Resources currentLevel ON currentLevel.internalId = Lookup.internalId "
+             "  INNER JOIN Resources parentLevel ON currentLevel.parentId = parentLevel.internalId ";
     }
 
     // need one instance info ?