CREATE TEMPORARY TABLE `deps`(`bp` BIGINT,`dep` VARCHAR(128),UNIQUE KEY `content`(`bp`,`dep`));
LOAD DATA LOCAL INFILE "/home/master/builder/bin/../work/tmp.mysql-functions.query.2019-01-21T11:43:30.718xuV.infile.1" INTO TABLE `deps`(`bp`,`dep`);
CREATE TEMPORARY TABLE `bps`(`bp` BIGINT,UNIQUE KEY `bp`(`bp`));
INSERT IGNORE INTO `bps`(`bp`) SELECT `deps`.`bp` FROM `deps`;
SELECT * FROM `dependencies` FROM `bps` JOIN `dependencies` ON `dependencies`.`dependent`=`bps`.`bp` JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id` AND `dependency_types`.`relevant_for_binary_packages` AND `dependency_types`.`relevant_for_building` JOIN `install_targets` ON `dependencies`.`depending_on`=`install_targets`.`id` AND `install_targets`.`name` NOT IN ("base","base-devel") LEFT JOIN `deps` ON `deps`.`dep`=`install_targets`.`name` AND `deps`.`bp`=`dependencies`.`dependent` WHERE `deps`.`dep` IS NULL;