CREATE TEMPORARY TABLE `names` (`name` VARCHAR(64));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2023-06-18T17:26:16.ElLPoA.infile.1" INTO TABLE `names` (`name`);
SELECT DISTINCT "any",`package_sources`.`pkgbase`,`package_sources`.`git_revision`,`upstream_repositories`.`name` FROM `names` JOIN `package_sources` ON `package_sources`.`pkgbase` REGEXP `names`.`name` JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`;
SELECT DISTINCT "any",`package_sources`.`pkgbase`,`package_sources`.`git_revision`,`upstream_repositories`.`name` FROM `binary_packages`