Straight shank twist drills
{"index":"live_product_1","type":"document","body":{"from":0,"size":24,"stored_fields":["_id","_score"],"docvalue_fields":["_id","_score"],"sort":[{"name.sort_name":{"order":"asc"}}],"query":{"bool":{"must":[{"bool":{"should":[{"bool":{"must":[{"term":{"category_ids":"8490"}},{"terms":{"visibility":["2","4"]}},{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}]}},{"bool":{"must":[{"has_child":{"type":"childproduct","query":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}}}},{"term":{"join_field":"parentproduct"}}]}}],"minimum_should_match":1}},{"term":{"category_ids":"8490"}},{"terms":{"visibility":["2","4"]}}]}},"aggregations":{"price_bucket":{"extended_stats":{"field":"price_0_1"}},"category_bucket":{"terms":{"field":"category_ids","size":1200}},"manufacturer_bucket":{"terms":{"field":"manufacturer","size":1200}},"color_bucket":{"terms":{"field":"color","size":1200}},"equipment_bucket":{"terms":{"field":"equipment","size":1200}},"guehring_drilling_depth_bucket":{"terms":{"field":"guehring_drilling_depth","size":1200}},"guehring_form_bucket":{"terms":{"field":"guehring_form","size":1200}},"guehring_thread_type_bucket":{"terms":{"field":"guehring_thread_type","size":1200}},"guehring_norm_bucket":{"terms":{"field":"guehring_norm","size":1200}},"guehring_surface_bucket":{"terms":{"field":"guehring_surface","size":1200}},"guehring_shaft_bucket":{"terms":{"field":"guehring_shaft","size":1200}},"guehring_cut_direction_bucket":{"terms":{"field":"guehring_cut_direction","size":1200}},"guehring_cut_mat_bucket":{"terms":{"field":"guehring_cut_mat","size":1200}},"guehring_square_bucket":{"terms":{"field":"guehring_square","size":1200}},"guehring_spiral_point_bucket":{"terms":{"field":"guehring_spiral_point","size":1200}},"guehring_cooling_bucket":{"terms":{"field":"guehring_cooling","size":1200}},"guehring_tolerance_zone_bucket":{"terms":{"field":"guehring_tolerance_zone","size":1200}},"guehring_productline_bucket":{"terms":{"field":"guehring_productline","size":1200}},"guehring_productline_sorte_bucket":{"terms":{"field":"guehring_productline_sorte","size":1200}},"guehring_type_bucket":{"terms":{"field":"guehring_type","size":1200}},"guehring_farbring_bucket":{"terms":{"field":"guehring_farbring","size":1200}},"guehring_gewinde_toleranzklasse_bucket":{"terms":{"field":"guehring_gewinde_toleranzklasse","size":1200}},"guehring_radius_bucket":{"terms":{"field":"guehring_radius","size":1200}},"guehring_lgansch_bucket":{"terms":{"field":"guehring_lgansch","size":1200}},"guehring_material_suitability_filter_bucket":{"terms":{"field":"guehring_material_suitability_filter","size":1200}},"guehring_norm_shop_bucket":{"terms":{"field":"guehring_norm_shop","size":1200}},"guehring_tooth_count_bucket":{"terms":{"field":"guehring_tooth_count","size":1200}},"guehring_dinnen_bucket":{"terms":{"field":"guehring_dinnen","size":1200}},"guehring_lgkrag_bucket":{"terms":{"field":"guehring_lgkrag","size":1200}},"guehring_dnenn_bucket":{"terms":{"field":"guehring_dnenn","size":1200}},"guehring_gewinde_bucket":{"terms":{"field":"guehring_gewinde","size":1200}},"guehring_angle_level_bucket":{"terms":{"field":"guehring_angle_level","size":1200}},"guehring_umfangsform_bucket":{"terms":{"field":"guehring_umfangsform","size":1200}},"category_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"category_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"category_bucket_child":{"terms":{"field":"category_ids","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"manufacturer_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"manufacturer_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"manufacturer_bucket_child":{"terms":{"field":"manufacturer","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"color_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"color_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"color_bucket_child":{"terms":{"field":"color","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"equipment_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"equipment_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"equipment_bucket_child":{"terms":{"field":"equipment","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_drilling_depth_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_drilling_depth_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_drilling_depth_bucket_child":{"terms":{"field":"guehring_drilling_depth","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_form_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_form_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_form_bucket_child":{"terms":{"field":"guehring_form","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_thread_type_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_thread_type_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_thread_type_bucket_child":{"terms":{"field":"guehring_thread_type","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_norm_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_norm_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_norm_bucket_child":{"terms":{"field":"guehring_norm","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_surface_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_surface_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_surface_bucket_child":{"terms":{"field":"guehring_surface","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_shaft_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_shaft_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_shaft_bucket_child":{"terms":{"field":"guehring_shaft","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cut_direction_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cut_direction_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cut_direction_bucket_child":{"terms":{"field":"guehring_cut_direction","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cut_mat_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cut_mat_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cut_mat_bucket_child":{"terms":{"field":"guehring_cut_mat","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_square_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_square_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_square_bucket_child":{"terms":{"field":"guehring_square","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_spiral_point_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_spiral_point_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_spiral_point_bucket_child":{"terms":{"field":"guehring_spiral_point","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cooling_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cooling_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cooling_bucket_child":{"terms":{"field":"guehring_cooling","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_tolerance_zone_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_tolerance_zone_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_tolerance_zone_bucket_child":{"terms":{"field":"guehring_tolerance_zone","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_productline_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_productline_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_productline_bucket_child":{"terms":{"field":"guehring_productline","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_productline_sorte_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_productline_sorte_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_productline_sorte_bucket_child":{"terms":{"field":"guehring_productline_sorte","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_type_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_type_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_type_bucket_child":{"terms":{"field":"guehring_type","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_farbring_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_farbring_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_farbring_bucket_child":{"terms":{"field":"guehring_farbring","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_gewinde_toleranzklasse_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_gewinde_toleranzklasse_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_gewinde_toleranzklasse_bucket_child":{"terms":{"field":"guehring_gewinde_toleranzklasse","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_radius_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_radius_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_radius_bucket_child":{"terms":{"field":"guehring_radius","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_lgansch_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_lgansch_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_lgansch_bucket_child":{"terms":{"field":"guehring_lgansch","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_material_suitability_filter_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_material_suitability_filter_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_material_suitability_filter_bucket_child":{"terms":{"field":"guehring_material_suitability_filter","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_norm_shop_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_norm_shop_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_norm_shop_bucket_child":{"terms":{"field":"guehring_norm_shop","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_tooth_count_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_tooth_count_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_tooth_count_bucket_child":{"terms":{"field":"guehring_tooth_count","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_dinnen_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_dinnen_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_dinnen_bucket_child":{"terms":{"field":"guehring_dinnen","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_lgkrag_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_lgkrag_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_lgkrag_bucket_child":{"terms":{"field":"guehring_lgkrag","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_dnenn_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_dnenn_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_dnenn_bucket_child":{"terms":{"field":"guehring_dnenn","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_gewinde_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_gewinde_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_gewinde_bucket_child":{"terms":{"field":"guehring_gewinde","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_angle_level_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_angle_level_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_angle_level_bucket_child":{"terms":{"field":"guehring_angle_level","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_umfangsform_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_umfangsform_bucket_child":{"filter":{"bool":{"must":[{"terms":{"guehring_surface":["9618","8317","9217"]}},{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_umfangsform_bucket_child":{"terms":{"field":"guehring_umfangsform","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}}}},"track_total_hits":true}{"index":"live_product_1","type":"document","body":{"from":"0","size":"10000","stored_fields":["_id","_score"],"docvalue_fields":["_id","_score"],"sort":[],"query":{"bool":{"must":[{"bool":{"should":[{"bool":{"must":[{"term":{"category_ids":"8490"}},{"terms":{"visibility":["2","4"]}},{"term":{"guehring_dnenn":"24003"}}]}},{"bool":{"must":[{"has_child":{"type":"childproduct","query":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}}}},{"term":{"join_field":"parentproduct"}}]}}],"minimum_should_match":1}},{"term":{"category_ids":"8490"}},{"terms":{"visibility":["2","4"]}}]}},"aggregations":{"price_bucket":{"extended_stats":{"field":"price_0_1"}},"category_bucket":{"terms":{"field":"category_ids","size":1200}},"manufacturer_bucket":{"terms":{"field":"manufacturer","size":1200}},"color_bucket":{"terms":{"field":"color","size":1200}},"equipment_bucket":{"terms":{"field":"equipment","size":1200}},"guehring_drilling_depth_bucket":{"terms":{"field":"guehring_drilling_depth","size":1200}},"guehring_form_bucket":{"terms":{"field":"guehring_form","size":1200}},"guehring_thread_type_bucket":{"terms":{"field":"guehring_thread_type","size":1200}},"guehring_norm_bucket":{"terms":{"field":"guehring_norm","size":1200}},"guehring_surface_bucket":{"terms":{"field":"guehring_surface","size":1200}},"guehring_shaft_bucket":{"terms":{"field":"guehring_shaft","size":1200}},"guehring_cut_direction_bucket":{"terms":{"field":"guehring_cut_direction","size":1200}},"guehring_cut_mat_bucket":{"terms":{"field":"guehring_cut_mat","size":1200}},"guehring_square_bucket":{"terms":{"field":"guehring_square","size":1200}},"guehring_spiral_point_bucket":{"terms":{"field":"guehring_spiral_point","size":1200}},"guehring_cooling_bucket":{"terms":{"field":"guehring_cooling","size":1200}},"guehring_tolerance_zone_bucket":{"terms":{"field":"guehring_tolerance_zone","size":1200}},"guehring_productline_bucket":{"terms":{"field":"guehring_productline","size":1200}},"guehring_productline_sorte_bucket":{"terms":{"field":"guehring_productline_sorte","size":1200}},"guehring_type_bucket":{"terms":{"field":"guehring_type","size":1200}},"guehring_farbring_bucket":{"terms":{"field":"guehring_farbring","size":1200}},"guehring_gewinde_toleranzklasse_bucket":{"terms":{"field":"guehring_gewinde_toleranzklasse","size":1200}},"guehring_radius_bucket":{"terms":{"field":"guehring_radius","size":1200}},"guehring_lgansch_bucket":{"terms":{"field":"guehring_lgansch","size":1200}},"guehring_material_suitability_filter_bucket":{"terms":{"field":"guehring_material_suitability_filter","size":1200}},"guehring_norm_shop_bucket":{"terms":{"field":"guehring_norm_shop","size":1200}},"guehring_tooth_count_bucket":{"terms":{"field":"guehring_tooth_count","size":1200}},"guehring_dinnen_bucket":{"terms":{"field":"guehring_dinnen","size":1200}},"guehring_lgkrag_bucket":{"terms":{"field":"guehring_lgkrag","size":1200}},"guehring_dnenn_bucket":{"terms":{"field":"guehring_dnenn","size":1200}},"guehring_gewinde_bucket":{"terms":{"field":"guehring_gewinde","size":1200}},"guehring_angle_level_bucket":{"terms":{"field":"guehring_angle_level","size":1200}},"guehring_umfangsform_bucket":{"terms":{"field":"guehring_umfangsform","size":1200}},"category_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"category_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"category_bucket_child":{"terms":{"field":"category_ids","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"manufacturer_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"manufacturer_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"manufacturer_bucket_child":{"terms":{"field":"manufacturer","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"color_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"color_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"color_bucket_child":{"terms":{"field":"color","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"equipment_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"equipment_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"equipment_bucket_child":{"terms":{"field":"equipment","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_drilling_depth_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_drilling_depth_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_drilling_depth_bucket_child":{"terms":{"field":"guehring_drilling_depth","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_form_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_form_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_form_bucket_child":{"terms":{"field":"guehring_form","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_thread_type_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_thread_type_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_thread_type_bucket_child":{"terms":{"field":"guehring_thread_type","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_norm_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_norm_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_norm_bucket_child":{"terms":{"field":"guehring_norm","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_surface_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_surface_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_surface_bucket_child":{"terms":{"field":"guehring_surface","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_shaft_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_shaft_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_shaft_bucket_child":{"terms":{"field":"guehring_shaft","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cut_direction_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cut_direction_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cut_direction_bucket_child":{"terms":{"field":"guehring_cut_direction","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cut_mat_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cut_mat_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cut_mat_bucket_child":{"terms":{"field":"guehring_cut_mat","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_square_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_square_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_square_bucket_child":{"terms":{"field":"guehring_square","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_spiral_point_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_spiral_point_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_spiral_point_bucket_child":{"terms":{"field":"guehring_spiral_point","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_cooling_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_cooling_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_cooling_bucket_child":{"terms":{"field":"guehring_cooling","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_tolerance_zone_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_tolerance_zone_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_tolerance_zone_bucket_child":{"terms":{"field":"guehring_tolerance_zone","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_productline_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_productline_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_productline_bucket_child":{"terms":{"field":"guehring_productline","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_productline_sorte_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_productline_sorte_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_productline_sorte_bucket_child":{"terms":{"field":"guehring_productline_sorte","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_type_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_type_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_type_bucket_child":{"terms":{"field":"guehring_type","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_farbring_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_farbring_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_farbring_bucket_child":{"terms":{"field":"guehring_farbring","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_gewinde_toleranzklasse_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_gewinde_toleranzklasse_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_gewinde_toleranzklasse_bucket_child":{"terms":{"field":"guehring_gewinde_toleranzklasse","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_radius_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_radius_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_radius_bucket_child":{"terms":{"field":"guehring_radius","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_lgansch_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_lgansch_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_lgansch_bucket_child":{"terms":{"field":"guehring_lgansch","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_material_suitability_filter_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_material_suitability_filter_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_material_suitability_filter_bucket_child":{"terms":{"field":"guehring_material_suitability_filter","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_norm_shop_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_norm_shop_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_norm_shop_bucket_child":{"terms":{"field":"guehring_norm_shop","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_tooth_count_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_tooth_count_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_tooth_count_bucket_child":{"terms":{"field":"guehring_tooth_count","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_dinnen_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_dinnen_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_dinnen_bucket_child":{"terms":{"field":"guehring_dinnen","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_lgkrag_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_lgkrag_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_lgkrag_bucket_child":{"terms":{"field":"guehring_lgkrag","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_dnenn_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_dnenn_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_dnenn_bucket_child":{"terms":{"field":"guehring_dnenn","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_gewinde_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_gewinde_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_gewinde_bucket_child":{"terms":{"field":"guehring_gewinde","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_angle_level_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_angle_level_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_angle_level_bucket_child":{"terms":{"field":"guehring_angle_level","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}},"guehring_umfangsform_bucket_child":{"children":{"type":"childproduct"},"aggregations":{"guehring_umfangsform_bucket_child":{"filter":{"bool":{"must":[{"term":{"guehring_dnenn":"24003"}}],"should":[]}},"aggregations":{"guehring_umfangsform_bucket_child":{"terms":{"field":"guehring_umfangsform","size":1200},"aggregations":{"parents_count":{"cardinality":{"field":"proline_product_table_sku"}}}}}}}}}},"track_total_hits":true}
Shop By
Active filtering
Open / Close
Skip to product list
Material suitability filter
Connection code machine side filter
Nominal Ø tolerance field filter
Product range (Article No.) filter
To see prices, please log in.
New customers can create a user account
HERE or add the desired products to the shopping cart and then send a request for quotation.
