06/06: Remove unnecessary join in select-outputs-without-known-nar-entries

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit 7936ca2e54f84d9d9d545c845c1536c3417ab217
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Oct 13 19:45:41 2020 +0100

    Remove unnecessary join in select-outputs-without-known-nar-entries
---
 guix-data-service/model/nar.scm | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

diff --git a/guix-data-service/model/nar.scm b/guix-data-service/model/nar.scm
index a0be879..b9fe215 100644
--- a/guix-data-service/model/nar.scm
+++ b/guix-data-service/model/nar.scm
@@ -378,9 +378,7 @@ ORDER BY COUNT(*) DESC")
     (string-append
      "
 SELECT DISTINCT derivation_output_details.path, derivation_output_details.id
-FROM derivations
-INNER JOIN derivation_outputs
-  ON derivations.id = derivation_outputs.derivation_id
+FROM derivation_outputs
 INNER JOIN derivation_output_details
   ON derivation_outputs.derivation_output_details_id = 
derivation_output_details.id
 WHERE derivation_output_details.path NOT IN (
@@ -400,7 +398,7 @@ WHERE derivation_output_details.path NOT IN (
          ""
          (string-append
           "
-  AND derivations.id IN (
+  AND derivation_outputs.derivation_id IN (
     -- Select outputs that are in the relevant revisions
     SELECT derivation_id
     FROM package_derivations