UPDATE `binary_packages` JOIN (SELECT `binary_packages_in_repositories`.`package`,MIN(`binary_packages_in_repositories`.`last_moved`) AS `first_last_moved` FROM `binary_packages_in_repositories` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `repositories`.`stability`=2 GROUP BY `binary_packages_in_repositories`.`package`) AS `binary_packages_in_repositories` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` SET `binary_packages`.`is_tested`=1 WHERE NOT `binary_packages`.`has_issues` AND NOT `binary_packages`.`is_tested` AND `binary_packages_in_repositories`.`first_last_moved`<SUBDATE(NOW(),from_base64("Nw=="))