buildmaster/mysql-issues.php, buildmaster/status.php, buildmaster/to-delete.php: read `is_to_be_deleted` and `last_moves` from `binary_packages_in_repositories`

1 files changed, 3 insertions, 2 deletions

diff --git a/buildmaster/status.php b/buildmaster/status.php
index 46c2fc1..2b1bd11 100644
--- a/buildmaster/status.php
+++ b/buildmaster/status.php
@@ -24,10 +24,11 @@ if ($result -> num_rows > 0) {
 }
 
 $result = mysql_run_query(
-  "SELECT MAX(`binary_packages`.`last_moved`) AS `last_moved`" .
+  "SELECT MAX(`binary_packages_in_repositories`.`last_moved`) AS `last_moved`" .
   " FROM `binary_packages`" .
+  " JOIN `binary_packages_in_repositories` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id`" .
   " JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id`" .
-  " WHERE `binary_packages`.`last_moved`>`build_assignments`.`return_date`"
+  " WHERE `binary_packages_in_repositories`.`last_moved`>`build_assignments`.`return_date`"
 );
 
 if ($result -> num_rows > 0) {