CREATE TEMPORARY TABLE `searches` (`search` VARCHAR(64));
INSERT INTO `searches` VALUES (from_base64("cHl0aG9uLW9wZW5zdGFja3Nkaw=="));
SELECT DISTINCT replace(to_base64(`searches`.`search`),"\n","")`to_build`.`ba_id`,`to_build`.`baa_name`,If(`to_build`.`is_broken`,1,0),(SELECT COUNT(1) FROM `failed_builds`WHERE `failed_builds`.`build_assignment`=`to_build`.`ba_id`),replace(to_base64(`to_build`.`is_blocked`),"\n",""),replace(to_base64(`deps`.`pkgbase`),"\n",""),replace(to_base64(`build_slaves`.`name`),"\n",""),replace(to_base64(`to_build`.`pkgbase`),"\n","") FROM `searches` LEFT JOIN (SELECT DISTINCT `tb_ps`.`pkgbase`,`tb_bin`.`id` AS `bin_id`,`tb_ba`.`id` AS `ba_id`,`tb_ba`.`is_blocked`,`tb_ba`.`is_broken`,`tb_baa`.`name` AS `baa_name` FROM `package_sources` AS `tb_ps` JOIN `build_assignments` AS `tb_ba` ON `tb_ps`.`id`=`tb_ba`.`package_source` JOIN `architectures` AS `tb_baa` ON `tb_ba`.`architecture`=`tb_baa`.`id` JOIN `binary_packages` AS `tb_bin` ON `tb_ba`.`id`=`tb_bin`.`build_assignment` JOIN `binary_packages_in_repositories` AS `tb_bir` ON `tb_bin`.`id`=`tb_bir`.`package` WHERE `tb_bir`.`repository`=9) AS `to_build` ON (`to_build`.`pkgbase`=`searches`.`search` OR `searches`.`search`=CONCAT(`to_build`.`baa_name`,"/",`to_build`.`pkgbase`)) LEFT JOIN (SELECT DISTINCT `dep_ps`.`pkgbase`,`dependencies`.`dependent` FROM `package_sources` AS `dep_ps` JOIN `build_assignments` AS `dep_ba` ON `dep_ps`.`id`=`dep_ba`.`package_source` JOIN `binary_packages` AS `dep_bin` ON `dep_ba`.`id`=`dep_bin`.`build_assignment` JOIN `binary_packages_in_repositories` AS `dep_bir` ON `dep_bin`.`id`=`dep_bir`.`package` JOIN `install_target_providers` ON `dep_bin`.`id`=`install_target_providers`.`package` JOIN `dependencies` ON `install_target_providers`.`install_target`=`dependencies`.`depending_on` JOIN `versions` AS `install_target_providers_versions` ON `install_target_providers`.`version`=`install_target_providers_versions`.`id` JOIN `versions` AS `dependencies_versions` ON `dependencies`.`version`=`dependencies_versions`.`id` AND ((`dependencies`.`version_relation`="<" AND `install_target_providers_versions`.`order`<`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="<=" AND `install_target_providers_versions`.`order`<=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">" AND `install_target_providers_versions`.`order`>`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">=" AND `install_target_providers_versions`.`order`>=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="=" AND `install_target_providers_versions`.`order`=`dependencies_versions`.`order`)) JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id` WHERE `dep_bir`.`repository`=9 AND `dependency_types`.`relevant_for_building`) AS `deps` ON `deps`.`dependent`=`to_build`.`bin_id` LEFT JOIN `build_slaves` ON `build_slaves`.`currently_building`=`to_build`.`ba_id`;