SELECT `package_sources`.`pkgbase`,`package_sources`.`git_revision`,`package_sources`.`mod_git_revision`,`upstream_repositories`.`name`,`binary_packages`.`sub_pkgrel`,`architectures`.`name` FROM `upstream_repositories` JOIN `package_sources` ON `upstream_repositories`.`id`=`package_sources`.`upstream_package_repository` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` JOIN `architectures` ON `build_assignments`.`architecture`=`architectures`.`id` JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE `binary_packages_in_repositories`.`repository`=9 AND `build_assignments`.`id`=286834 LIMIT 1;
SELECT CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.tar.xz") FROM `binary_packages` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE `binary_packages`.`build_assignment`=286834 AND `binary_packages_in_repositories`.`repository`=9;
UPDATE `build_slaves` SET `build_slaves`.`currently_building`=286834, `build_slaves`.`is_sane`=1 WHERE `build_slaves`.`id`=from_base64("MTg=");
UPDATE `build_assignments` SET `build_assignments`.`priority`=0 WHERE `build_assignments`.`id`=286834;