CREATE TEMPORARY TABLE `pkgbases` (`pkgbase` VARCHAR (64),UNIQUE KEY `pkgbase`(`pkgbase`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.was_insane_query.2023-02-18T15:54:27.OKIyhn.infile.1" INTO TABLE `pkgbases`(`pkgbase`);
DELETE `d_bpir` FROM `pkgbases` JOIN `package_sources` AS `d_ps` ON `pkgbases`.`pkgbase`=`d_ps`.`pkgbase` JOIN `build_assignments` AS `d_ba` ON `d_ps`.`id`=`d_ba`.`package_source` JOIN `binary_packages` AS `d_bp` ON `d_ba`.`id`=`d_bp`.`build_assignment` JOIN `binary_packages_in_repositories` AS `d_bpir` ON `d_bp`.`id`=`d_bpir`.`package` JOIN `repositories` AS `d_r` ON `d_bpir`.`repository`=`d_r`.`id` AND `d_r`.`stability`=6 JOIN `package_sources` AS `a_ps` ON `d_ps`.`pkgbase`=`a_ps`.`pkgbase` JOIN `build_assignments` AS `a_ba` ON `a_ps`.`id`=`a_ba`.`package_source` JOIN `binary_packages` AS `a_bp` ON `a_ba`.`id`=`a_bp`.`build_assignment` JOIN `architecture_compatibilities` AS `ac` ON `ac`.`built_for`=`a_bp`.`architecture` AND `ac`.`runs_on`=`d_r`.`architecture` AND `ac`.`fully_compatible` JOIN `binary_packages_in_repositories` AS `a_bpir` ON `a_bp`.`id`=`a_bpir`.`package` AND `a_bpir`.`repository`=9;
CREATE TEMPORARY TABLE `blacklist` (`architecture` VARCHAR (16),`pkgbase` VARCHAR (64),UNIQUE KEY `content`(`architecture`,`pkgbase`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.was_insane_query.2023-02-18T15:54:27.OKIyhn.infile.2" INTO TABLE `blacklist` COLUMNS TERMINATED BY " " (`architecture`,`pkgbase`);
INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`,`is_to_be_deleted`) SELECT `binary_packages`.`id`,`dl_r`.`id`,1 FROM `blacklist` JOIN `package_sources` ON `blacklist`.`pkgbase`=`package_sources`.`pkgbase` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` JOIN `architectures` ON `build_assignments`.`architecture`=`architectures`.`id` AND `architectures`.`name`=`blacklist`.`architecture` 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 `binary_packages_in_repositories`.`repository`=9 JOIN `architecture_compatibilities` AS `ac` ON `ac`.`built_for`=`binary_packages`.`architecture` AND `ac`.`fully_compatible` JOIN `repositories` AS `dl_r` ON `ac`.`runs_on`=`dl_r`.`architecture` AND `dl_r`.`stability`=6;
DELETE `binary_packages_in_repositories` FROM `blacklist` JOIN `package_sources` ON `blacklist`.`pkgbase`=`package_sources`.`pkgbase` JOIN `build_assignments` ON `package_sources`.`id`=`build_assignments`.`package_source` JOIN `architectures` ON `build_assignments`.`architecture`=`architectures`.`id` AND `architectures`.`name`=`blacklist`.`architecture` 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 `binary_packages_in_repositories`.`repository`=9 AND (`binary_packages`.`architecture`=`architectures`.`id` OR `architectures`.`id`=1);
DELETE `package_sources`,`build_assignments`,`binary_packages`,`binary_packages_in_repositories` FROM `repositories` JOIN `binary_packages_in_repositories` ON `repositories`.`id`=`binary_packages_in_repositories`.`repository` AND `repositories`.`stability`=6 JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND 1 JOIN `binary_packages` AS `j_bp` ON `j_bp`.`pkgname`=`binary_packages`.`pkgname` JOIN `architecture_compatibilities` AS `ac` ON `ac`.`fully_compatible` AND `ac`.`built_for`=`binary_packages`.`architecture` JOIN `architecture_compatibilities` AS `ac_j` ON `ac_j`.`fully_compatible` AND `ac_j`.`built_for`=`j_bp`.`architecture` AND `ac_j`.`runs_on`=`ac`.`runs_on` JOIN `binary_packages_in_repositories` AS `j_bpir` ON `j_bp`.`id`=`j_bpir`.`package` AND `j_bpir`.`repository`=9 LEFT JOIN (`build_assignments` AS `keep_ba` JOIN `binary_packages` AS `keep_bp` ON `keep_ba`.`id`=`keep_bp`.`build_assignment` JOIN `binary_packages_in_repositories` AS `keep_bpir` ON `keep_bp`.`id`=`keep_bpir`.`package` JOIN `repositories` AS `keep_r` ON `keep_bpir`.`repository`=`keep_r`.`id` AND `keep_r`.`stability`=6) ON `keep_ba`.`package_source`=`package_sources`.`id` WHERE `keep_r`.`id` IS NULL;
DELETE `build_assignments`,`binary_packages`,`binary_packages_in_repositories` FROM `repositories` JOIN `binary_packages_in_repositories` ON `repositories`.`id`=`binary_packages_in_repositories`.`repository` AND `repositories`.`stability`=6 JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND 1 JOIN `binary_packages` AS `j_bp` ON `j_bp`.`pkgname`=`binary_packages`.`pkgname` JOIN `architecture_compatibilities` AS `ac` ON `ac`.`fully_compatible` AND `ac`.`built_for`=`binary_packages`.`architecture` JOIN `architecture_compatibilities` AS `ac_j` ON `ac_j`.`fully_compatible` AND `ac_j`.`built_for`=`j_bp`.`architecture` AND `ac_j`.`runs_on`=`ac`.`runs_on` JOIN `binary_packages_in_repositories` AS `j_bpir` ON `j_bp`.`id`=`j_bpir`.`package` AND `j_bpir`.`repository`=9 LEFT JOIN (`binary_packages` AS `keep_bp` JOIN `binary_packages_in_repositories` AS `keep_bpir` ON `keep_bp`.`id`=`keep_bpir`.`package` JOIN `repositories` AS `keep_r` ON `keep_bpir`.`repository`=`keep_r`.`id` AND NOT (`keep_r`.`stability`=6)) ON `keep_bp`.`build_assignment`=`build_assignments`.`id` WHERE `keep_r`.`id` IS NULL;
DELETE `binary_packages`,`binary_packages_in_repositories` FROM `repositories` JOIN `binary_packages_in_repositories` ON `repositories`.`id`=`binary_packages_in_repositories`.`repository` AND `repositories`.`stability`=6 JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND 1 JOIN `binary_packages` AS `j_bp` ON `j_bp`.`pkgname`=`binary_packages`.`pkgname` JOIN `architecture_compatibilities` AS `ac` ON `ac`.`fully_compatible` AND `ac`.`built_for`=`binary_packages`.`architecture` JOIN `architecture_compatibilities` AS `ac_j` ON `ac_j`.`fully_compatible` AND `ac_j`.`built_for`=`j_bp`.`architecture` AND `ac_j`.`runs_on`=`ac`.`runs_on` JOIN `binary_packages_in_repositories` AS `j_bpir` ON `j_bp`.`id`=`j_bpir`.`package` AND `j_bpir`.`repository`=9 LEFT JOIN (`binary_packages_in_repositories` AS `keep_bpir` JOIN `repositories` AS `keep_r` ON `keep_bpir`.`repository`=`keep_r`.`id` AND `keep_r`.`stability`=6) ON `keep_bpir`.`package`=`binary_packages`.`id` WHERE `keep_r`.`id` IS NULL;
DELETE `binary_packages_in_repositories` FROM `repositories` JOIN `binary_packages_in_repositories` ON `repositories`.`id`=`binary_packages_in_repositories`.`repository` AND `repositories`.`stability`=6 JOIN `binary_packages` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` AND 1 JOIN `binary_packages` AS `j_bp` ON `j_bp`.`pkgname`=`binary_packages`.`pkgname` JOIN `architecture_compatibilities` AS `ac` ON `ac`.`fully_compatible` AND `ac`.`built_for`=`binary_packages`.`architecture` JOIN `architecture_compatibilities` AS `ac_j` ON `ac_j`.`fully_compatible` AND `ac_j`.`built_for`=`j_bp`.`architecture` AND `ac_j`.`runs_on`=`ac`.`runs_on` JOIN `binary_packages_in_repositories` AS `j_bpir` ON `j_bp`.`id`=`j_bpir`.`package` AND `j_bpir`.`repository`=9;