CREATE TEMPORARY TABLE `ignore_packages` (`priority` SMALLINT,`pkgbase` VARCHAR(64),UNIQUE KEY `content`(`priority`,`pkgbase`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2019-08-07T14:08:10.d0KxLd.infile.1" INTO TABLE `ignore_packages`(`priority`,`pkgbase`);
CREATE TEMPORARY TABLE `pkgbases` (`priority` SMALLINT,`pkgbase` VARCHAR(64),`repo` VARCHAR(64),UNIQUE KEY `pkgbase`(`pkgbase`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2019-08-07T14:08:10.d0KxLd.infile.2" INTO TABLE `pkgbases`(`priority`,`pkgbase`,`repo`);
INSERT IGNORE INTO `ignore_packages`(`priority`,`pkgbase`) SELECT 2,`sub_q`.`pkgbase`,`sub_q`.`architectures` FROM (SELECT `package_sources`.`pkgbase`,GROUP_CONCAT(DISTINCT `build_assignments`.`architecture` ORDER BY `build_assignments`.`architecture`) AS `architectures` FROM `package_sources` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` 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` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `build_assignments`.`is_black_listed` IS NOT NULL OR `package_sources`.`pkgbase` LIKE "lib32-%" OR `repositories`.`is_on_master_mirror` OR `binary_packages_in_repositories`.`repository`=9 GROUP BY `package_sources`.`pkgbase`) AS `sub_q` WHERE `sub_q`.`architectures` NOT IN ("1","2,3,4");
INSERT IGNORE INTO `ignore_packages`(`priority`,`pkgbase`) SELECT 1,`package_sources`.`pkgbase` FROM `package_sources` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` 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`.`is_to_be_deleted`;
SELECT `pkgbases`.`pkgbase`,`git_repositories`.`head`,(SELECT `al32`.`head` FROM `git_repositories` AS `al32` WHERE `al32`.`name`="archlinux32"),`pkgbases`.`repo` FROM `pkgbases` JOIN `upstream_repositories` ON `upstream_repositories`.`name`=`pkgbases`.`repo` JOIN `git_repositories` ON `upstream_repositories`.`git_repository`=`git_repositories`.`id` WHERE NOT EXISTS (SELECT 1 FROM `ignore_packages` WHERE `ignore_packages`.`pkgbase`=`pkgbases`.`pkgbase` AND `ignore_packages`.`priority`>=`pkgbases`.`priority`) AND (`pkgbases`.`priority`!=2 OR NOT EXISTS (SELECT 1 FROM `package_sources` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` 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` AND NOT `binary_packages_in_repositories`.`is_to_be_deleted` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` AND (`repositories`.`is_on_master_mirror` OR `repositories`.`name`="build-list") WHERE `package_sources`.`pkgbase`=`pkgbases`.`pkgbase`));