Fix unprocessed_builds_with_derived_priorities

A couple of the queries were wrong, this fixes it.

1 files changed, 5 insertions, 5 deletions

diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm
index bc349d9..7cc66fe 100644
--- a/guix-build-coordinator/datastore/sqlite.scm
+++ b/guix-build-coordinator/datastore/sqlite.scm
@@ -3662,17 +3662,17 @@ UNION
   FROM relevant_builds
   INNER JOIN builds AS relevant_builds_full
     ON relevant_builds.id = relevant_builds_full.id
+  INNER JOIN derivation_inputs
+    ON relevant_builds_full.derivation_id = derivation_inputs.derivation_id
   INNER JOIN derivation_outputs
-    ON relevant_builds_full.derivation_id = derivation_outputs.derivation_id
+    ON derivation_inputs.derivation_output_id = derivation_outputs.id
   INNER JOIN unbuilt_outputs
     ON unbuilt_outputs.output_id = derivation_outputs.output_id
   INNER JOIN derivation_outputs AS all_derivation_outputs
-    ON all_derivation_outputs.output_id = derivation_outputs.output_id
-  INNER JOIN derivation_inputs
-    ON derivation_inputs.derivation_output_id = all_derivation_outputs.id
+    ON all_derivation_outputs.output_id = unbuilt_outputs.output_id
   INNER JOIN builds
     ON builds.processed = 0
-   AND builds.derivation_id = derivation_inputs.derivation_id
+   AND builds.derivation_id = all_derivation_outputs.derivation_id
 )
 SELECT build_id
 FROM relevant_builds