;
LOAD DATA LOCAL INFILE "/home/master/builder/bin/../work/tmp.mysql-functions.unimportant_query.2019-03-14T15:26:51.zEtDE8.infile.1" INTO TABLE `td` (`file`,`line`,`description`);
UPDATE `td` JOIN `todos` ON `td`.`file`=`todos`.`file` AND `td`.`line`=`todos`.`line` AND `td`.`description`=`todos`.`description` SET `td`.`id`=`todos`.`id` WHERE `td`.`id` IS NULL;
UPDATE `td` JOIN `todos` ON `td`.`file`=`todos`.`file` AND `td`.`description`=`todos`.`description` SET `td`.`id`=`todos`.`id` WHERE `td`.`id` IS NULL;
UPDATE `td` JOIN `todos` ON `td`.`file`=`todos`.`file` AND `td`.`line`=`todos`.`line` SET `td`.`id`=`todos`.`id` WHERE `td`.`id` IS NULL;
UPDATE `td` JOIN `todos` ON `td`.`description`=`todos`.`description` SET `td`.`id`=`todos`.`id` WHERE `td`.`id` IS NULL;
UPDATE `todos` JOIN `td` ON `todos`.`id`=`td`.`id` SET `todos`.`file`=`td`.`file`,`todos`.`line`=`td`.`line`,`todos`.`description`=`td`.`description`;
INSERT IGNORE INTO `todos` (`file`,`line`,`description`) SELECT `td`.`file`,`td`.`line`,`td`.`description` FROM `td` WHERE `td`.`id` IS NULL;
DELETE FROM `todos` WHERE NOT EXISTS (SELECT 1 FROM `td` WHERE `td`.`file`=`todos`.`file` AND `td`.`line`=`todos`.`line` AND `td`.`description`=`todos`.`description`);
DROP TEMPORARY TABLE `td`;
DELETE FROM `todo_links` WHERE NOT EXISTS (SELECT 1 FROM `todos` WHERE `todos`.`id`=`todo_links`.`depending_on`) OR NOT EXISTS (SELECT 1 FROM `todos` WHERE `todos`.`id`=`todo_links`.`dependent`);