UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=1 WHERE `repositories`.`stability`=1 AND `binary_packages`.`pkgname` IN (from_base64("ZmZtcGVn"),from_base64("cGFt"),from_base64("YXVkaXQ="),from_base64("d2lyZWd1YXJk"),from_base64("cXQ1LXN0eWxlcGx1Z2lucw=="),from_base64("bXBk"),from_base64("Z2FqaW0="),"");
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=0 WHERE `repositories`.`stability`=1 AND `binary_packages`.`pkgname` NOT IN (from_base64("ZmZtcGVn"),from_base64("cGFt"),from_base64("YXVkaXQ="),from_base64("d2lyZWd1YXJk"),from_base64("cXQ1LXN0eWxlcGx1Z2lucw=="),from_base64("bXBk"),from_base64("Z2FqaW0="),"");
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=1 WHERE `repositories`.`stability`=2 AND `binary_packages`.`pkgname` IN ("");
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=0 WHERE `repositories`.`stability`=2 AND `binary_packages`.`pkgname` NOT IN ("");
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=1 WHERE `repositories`.`stability`=5 AND `binary_packages`.`pkgname` IN (from_base64("cHl0aG9uLXNldHVwdG9vbHM="),from_base64("YW5kcm9pZC10b29scw=="),from_base64("c2FnZW1hdGgtZG9j"),from_base64("aGFza2VsbC1oc2x1YQ=="),"");
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` SET `has_issues`=0 WHERE `repositories`.`stability`=5 AND `binary_packages`.`pkgname` NOT IN (from_base64("cHl0aG9uLXNldHVwdG9vbHM="),from_base64("YW5kcm9pZC10b29scw=="),from_base64("c2FnZW1hdGgtZG9j"),from_base64("aGFza2VsbC1oc2x1YQ=="),"");