DELETE `d_bpir` FROM `binary_packages_in_repositories` AS `d_bpir` JOIN `binary_packages` AS `d_bp` ON `d_bpir`.`package`=`d_bp`.`id` JOIN `versions` as `d_v` ON `d_bp`.`epoch`=`d_v`.`epoch` AND `d_bp`.`pkgver`=`d_v`.`version` JOIN `binary_packages` AS `n_bp` ON `d_bp`.`pkgname`=`n_bp`.`pkgname` JOIN `versions` as `n_v` ON `n_bp`.`epoch`=`n_v`.`epoch` AND `n_bp`.`pkgver`=`n_v`.`version` JOIN `binary_packages_in_repositories` AS `n_bpir` ON `n_bp`.`id`=`n_bpir`.`package` WHERE `d_bpir`.`repository`=9 AND `n_bpir`.`repository`=9 AND (`n_v`.`order`>`d_v`.`order` OR (`n_v`.`order`=`d_v`.`order` AND (`n_bp`.`pkgrel`>`d_bp`.`pkgrel` OR (`n_bp`.`pkgrel`=`d_bp`.`pkgrel` AND `n_bp`.`sub_pkgrel`>`d_bp`.`sub_pkgrel`))));
COMMIT;
DELETE `binary_packages` FROM `binary_packages` WHERE NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);