INSERT IGNORE INTO `statistics` (`pending_tasks_count`,`pending_packages_count`,`broken_tasks_count`,`dependency_loops_count`,`dependency_looped_tasks_count`,`locked_tasks_count`,`blocked_tasks_count`,`next_tasks_count`,`stable_packages_count`,`staging_packages_count`,`testing_packages_count`,`tested_packages_count`,`architecture`) SELECT `ba_q`.`pending_tasks_count`,`ba_q`.`pending_packages_count`,`ba_q`.`broken_tasks_count`,`ba_q`.`dependency_loops_count`,`ba_q`.`dependency_looped_tasks_count`,`ba_q`.`locked_tasks_count`,`ba_q`.`blocked_tasks_count`,`ba_q`.`next_tasks_count`,`bp_q`.`stable_packages_count`,`bp_q`.`staging_packages_count`,`bp_q`.`testing_packages_count`,`bp_q`.`tested_packages_count`,`architectures`.`id` FROM `architectures` LEFT JOIN (SELECT COUNT(DISTINCT `build_assignments`.`id`) AS `pending_tasks_count`, COUNT(DISTINCT `binary_packages`.`id`) AS `pending_packages_count`, COUNT(DISTINCT IF(`build_assignments`.`is_broken`,`build_assignments`.`id`,NULL)) AS `broken_tasks_count`, COUNT(DISTINCT `build_dependency_loops`.`loop`) AS `dependency_loops_count`, COUNT(DISTINCT `build_dependency_loops`.`build_assignment`) AS `dependency_looped_tasks_count`, COUNT(DISTINCT `build_slaves`.`currently_building`) AS `locked_tasks_count`, COUNT(DISTINCT IF(`build_assignments`.`is_blocked` IS NULL,NULL,`build_assignments`.`id`)) AS `blocked_tasks_count`, COUNT(DISTINCT IF(EXISTS (SELECT 1 FROM `binary_packages` AS `todos` JOIN `binary_packages_in_repositories` AS `todo_bpirs` ON `todos`.`id`=`todo_bpirs`.`package` AND `todo_bpirs`.`repository`=9 JOIN `dependencies` AS `l_deps` ON `todos`.`id`=`l_deps`.`dependent` JOIN `versions` AS `l_dep_vs` ON `l_deps`.`version`=`l_dep_vs`.`id` JOIN `dependency_types` AS `l_dep_ts` ON `l_deps`.`dependency_type`=`l_dep_ts`.`id` JOIN `install_targets` ON `l_deps`.`depending_on`=`install_targets`.`id` AND `l_dep_ts`.`relevant_for_building` WHERE `todos`.`build_assignment`=`build_assignments`.`id` AND IF(`l_dep_ts`.`relevant_for_binary_packages`,EXISTS (SELECT 1 FROM `install_target_providers` AS `l_itps` JOIN `versions` AS `l_itp_vs` ON `l_itps`.`version`=`l_itp_vs`.`id` JOIN `binary_packages` AS `dep_bp` ON `l_itps`.`package`=`dep_bp`.`id` JOIN `binary_packages_in_repositories` AS `dep_bpir` ON `dep_bp`.`id`=`dep_bpir`.`package` AND `dep_bpir`.`repository`=9 JOIN `build_assignments` AS `dep_ba` ON `dep_bp`.`build_assignment`=`dep_ba`.`id` AND (NOT EXISTS (SELECT 1 FROM `failed_builds` WHERE `failed_builds`.`date`<=ADDTIME(NOW(),"-1 00:00:00") AND `failed_builds`.`build_assignment`=`dep_ba`.`id`) OR `dep_bp`.`pkgname` LIKE "haskell-%") JOIN `architecture_compatibilities` ON `architecture_compatibilities`.`built_for`=`dep_bp`.`architecture` AND `architecture_compatibilities`.`fully_compatible` WHERE `l_itps`.`install_target`=`l_deps`.`depending_on` AND `dep_bp`.`build_assignment`!=`build_assignments`.`id` AND `architecture_compatibilities`.`runs_on`=IF(`build_assignments`.`architecture`=1,2,`build_assignments`.`architecture`)),NOT EXISTS (SELECT 1 FROM `install_target_providers` AS `l_itps` JOIN `versions` AS `l_itp_vs` ON `l_itps`.`version`=`l_itp_vs`.`id` JOIN `binary_packages` AS `dep_bp` ON `l_itps`.`package`=`dep_bp`.`id` JOIN `binary_packages_in_repositories` AS `dep_bpir` ON `dep_bp`.`id`=`dep_bpir`.`package` JOIN `repositories` AS `dep_r` ON `dep_bpir`.`repository`=`dep_r`.`id` WHERE `l_itps`.`install_target`=`l_deps`.`depending_on` AND (`dep_r`.`is_on_master_mirror` OR `dep_bp`.`build_assignment`=`build_assignments`.`id`) AND `dep_r`.`architecture`=IF(`build_assignments`.`architecture`=1,2,`build_assignments`.`architecture`) AND ((`l_deps`.`version_relation`="<" AND `l_itp_vs`.`order`<`l_dep_vs`.`order`) OR (`l_deps`.`version_relation`="<=" AND `l_itp_vs`.`order`<=`l_dep_vs`.`order`) OR (`l_deps`.`version_relation`=">" AND `l_itp_vs`.`order`>`l_dep_vs`.`order`) OR (`l_deps`.`version_relation`=">=" AND `l_itp_vs`.`order`>=`l_dep_vs`.`order`) OR (`l_deps`.`version_relation`="=" AND `l_itp_vs`.`order`=`l_dep_vs`.`order`))))),NULL,`build_assignments`.`id`)) AS `next_tasks_count`, `build_assignments`.`architecture` FROM `build_assignments` JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` JOIN (SELECT `binary_packages`.`build_assignment` FROM `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE `binary_packages_in_repositories`.`repository`=9 GROUP BY `binary_packages`.`build_assignment`) AS `bp_subq` ON `bp_subq`.`build_assignment`=`build_assignments`.`id` LEFT JOIN `build_slaves` ON `build_assignments`.`id`=`build_slaves`.`currently_building` LEFT JOIN `build_dependency_loops` ON `build_assignments`.`id`=`build_dependency_loops`.`build_assignment` GROUP BY `build_assignments`.`architecture`) AS `ba_q` ON `ba_q`.`architecture`=`architectures`.`id` LEFT JOIN (SELECT SUM(IF(`repositories`.`stability`=1,1,0)) AS `stable_packages_count`, SUM(IF(`repositories`.`stability`=3,1,0)) AS `staging_packages_count`, SUM(IF(`repositories`.`stability`=2 AND NOT `binary_packages`.`is_tested`,1,0)) AS `testing_packages_count`, SUM(IF(`repositories`.`stability`=2 AND `binary_packages`.`is_tested`,1,0)) AS `tested_packages_count`, `repositories`.`architecture` FROM `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` GROUP BY `repositories`.`architecture`) AS `bp_q` ON `bp_q`.`architecture`=`architectures`.`id`;