From f86cf5f2d8ebfe124a8791eb06b29a886c91af9c Mon Sep 17 00:00:00 2001
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Mon, 8 Apr 2013 16:22:05 -0700
Subject: [PATCH] CSPACE-5943: Remove now-extraneous JOIN.

---
 .../services/nuxeo/client/java/RepositoryJavaClientImpl.java   | 3 ---
 1 file changed, 3 deletions(-)

diff --git a/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java b/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
index 9834720c6..96eaf72cb 100644
--- a/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
+++ b/services/common/src/main/java/org/collectionspace/services/nuxeo/client/java/RepositoryJavaClientImpl.java
@@ -1029,9 +1029,6 @@ public class RepositoryJavaClientImpl implements RepositoryClient<PoxPayloadIn,
             if (inAuthorityValue.equals(PARENT_WILDCARD)) {
                 // Add nothing to the query here if it should match within all authorities
             } else {
-                joinClauses = joinClauses
-                    + " INNER JOIN " + handler.getServiceContext().getCommonPartLabel() + " commonschema"
-                    + "  ON commonschema.id = hierarchy_termgroup.parentid";
                 whereClause = whereClause
                     + "  AND (commonschema.inauthority = ?)";
                 params.add(inAuthorityValue); // Value for replaceable parameter 2 in the query
-- 
2.47.3