Perceuse Visseuse BOSCH à -18% ! | Durée et Quantités Limitées !  J'en profite >

Évier à poser

Affiner la sélection (0)

Marques

Offres

Prix (€)

  • Min: 79

    Max: 128

Nombre de cuves

Dimensions mm

Debug

es raw query

{
    "_source": [
        "_id",
        "catalog_code"
    ],
    "aggregations": {
        "brand": {
            "terms": {
                "field": "brand.untouched",
                "size": 1000
            }
        },
        "categories": {
            "terms": {
                "field": "categories_parents_catalog_codes",
                "size": 1000
            }
        },
        "continuum_price": {
            "range": {
                "field": "lowest_public_price_with_vat",
                "keyed": true,
                "ranges": [
                    {
                        "gte": 0
                    }
                ]
            }
        },
        "continuum_price_stats": {
            "aggs": {
                "continuum_price_stats": {
                    "stats": {
                        "field": "lowest_public_price_with_vat"
                    }
                }
            },
            "filter": {
                "match_all": {}
            }
        },
        "continuum_price_stats_with_include_self_filter": {
            "aggs": {
                "continuum_price_stats": {
                    "stats": {
                        "field": "lowest_public_price_with_vat"
                    }
                }
            },
            "filter": {
                "match_all": {}
            }
        },
        "dimensions": {
            "aggs": {
                "dimensions_nested": {
                    "aggs": {
                        "dimensions_nested_filtered": {
                            "aggs": {
                                "dimensions_reverse_nested": {
                                    "aggs": {
                                        "dimensions_reverse_nested_parent_filter": {
                                            "filter": {
                                                "match_all": {}
                                            }
                                        }
                                    },
                                    "reverse_nested": {}
                                },
                                "dimensions_unit": {
                                    "terms": {
                                        "field": "articles.characteristics.unit.untouched",
                                        "size": 1
                                    }
                                }
                            },
                            "terms": {
                                "field": "articles.characteristics.value.untouched",
                                "size": 1000
                            }
                        }
                    },
                    "filter": {
                        "term": {
                            "articles.characteristics.name.untouched": "Dimensions"
                        }
                    }
                }
            },
            "nested": {
                "path": "articles.characteristics"
            }
        },
        "nombre-de-cuves": {
            "aggs": {
                "nombre-de-cuves_nested": {
                    "aggs": {
                        "nombre-de-cuves_nested_filtered": {
                            "aggs": {
                                "nombre-de-cuves_reverse_nested": {
                                    "aggs": {
                                        "nombre-de-cuves_reverse_nested_parent_filter": {
                                            "filter": {
                                                "match_all": {}
                                            }
                                        }
                                    },
                                    "reverse_nested": {}
                                },
                                "nombre-de-cuves_unit": {
                                    "terms": {
                                        "field": "articles.characteristics.unit.untouched",
                                        "size": 1
                                    }
                                }
                            },
                            "terms": {
                                "field": "articles.characteristics.value.untouched",
                                "size": 1000
                            }
                        }
                    },
                    "filter": {
                        "term": {
                            "articles.characteristics.name.untouched": "Nombre de cuves"
                        }
                    }
                }
            },
            "nested": {
                "path": "articles.characteristics"
            }
        },
        "offers": {
            "terms": {
                "field": "offers.untouched",
                "size": 1000
            }
        }
    },
    "from": 0,
    "query": {
        "function_score": {
            "functions": [
                {
                    "field_value_factor": {
                        "factor": 2,
                        "field": "availability",
                        "modifier": "square"
                    }
                },
                {
                    "gauss": {
                        "first_published_at": {
                            "decay": 0.5,
                            "offset": "30d",
                            "scale": "90d"
                        }
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 1,
                        "field": "availability"
                    },
                    "filter": {
                        "term": {
                            "discount": 1
                        }
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 1,
                        "field": "sales_stat.ct_last_month",
                        "modifier": "log1p"
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 0.75,
                        "field": "sales_stat.ct_last_three_months",
                        "modifier": "log1p"
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 0.5,
                        "field": "sales_stat.ct_last_year",
                        "modifier": "log1p"
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 0.3,
                        "field": "comments_stat.ct",
                        "modifier": "log1p"
                    }
                },
                {
                    "field_value_factor": {
                        "factor": 0.1,
                        "field": "comments_stat.avg_note",
                        "modifier": "log1p"
                    }
                }
            ],
            "query": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "categories_parents_catalog_codes": "4f75b5c9625f9523338350"
                            }
                        }
                    ],
                    "must": {
                        "match_all": {}
                    }
                }
            },
            "score_mode": "sum"
        }
    },
    "size": 40
}

es raw result

{
    "_shards": {
        "failed": 0,
        "skipped": 0,
        "successful": 5,
        "total": 5
    },
    "aggregations": {
        "brand": {
            "buckets": [
                {
                    "doc_count": 4,
                    "key": "FRANKE"
                },
                {
                    "doc_count": 1,
                    "key": "MODERNA"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "categories": {
            "buckets": [
                {
                    "doc_count": 5,
                    "key": "4f75b5c9625f9523338350"
                },
                {
                    "doc_count": 5,
                    "key": "543e3b8b3746b410428977"
                },
                {
                    "doc_count": 5,
                    "key": "e7513fad3e41f597b1786f1f6294e57e"
                },
                {
                    "doc_count": 5,
                    "key": "root"
                },
                {
                    "doc_count": 1,
                    "key": "4fb38f5aa0eeb713707284"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "continuum_price": {
            "buckets": {
                "*-*": {
                    "doc_count": 5
                }
            }
        },
        "continuum_price_stats": {
            "continuum_price_stats": {
                "avg": 98.17920000000001,
                "count": 5,
                "max": 127.296,
                "min": 79.596,
                "sum": 490.896
            },
            "doc_count": 5
        },
        "continuum_price_stats_with_include_self_filter": {
            "continuum_price_stats": {
                "avg": 98.17920000000001,
                "count": 5,
                "max": 127.296,
                "min": 79.596,
                "sum": 490.896
            },
            "doc_count": 5
        },
        "dimensions": {
            "dimensions_nested": {
                "dimensions_nested_filtered": {
                    "buckets": [
                        {
                            "dimensions_reverse_nested": {
                                "dimensions_reverse_nested_parent_filter": {
                                    "doc_count": 2
                                },
                                "doc_count": 2
                            },
                            "dimensions_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 2,
                                        "key": "mm"
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            },
                            "doc_count": 2,
                            "key": "1200 x 600"
                        },
                        {
                            "dimensions_reverse_nested": {
                                "dimensions_reverse_nested_parent_filter": {
                                    "doc_count": 1
                                },
                                "doc_count": 1
                            },
                            "dimensions_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 1,
                                        "key": "mm"
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            },
                            "doc_count": 1,
                            "key": "1000 x 600"
                        },
                        {
                            "dimensions_reverse_nested": {
                                "dimensions_reverse_nested_parent_filter": {
                                    "doc_count": 1
                                },
                                "doc_count": 1
                            },
                            "dimensions_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 1,
                                        "key": "mm"
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            },
                            "doc_count": 1,
                            "key": "800 x 600 x 160"
                        },
                        {
                            "dimensions_reverse_nested": {
                                "dimensions_reverse_nested_parent_filter": {
                                    "doc_count": 1
                                },
                                "doc_count": 1
                            },
                            "dimensions_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 1,
                                        "key": "mm"
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            },
                            "doc_count": 1,
                            "key": "900 x 600"
                        }
                    ],
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0
                },
                "doc_count": 5
            },
            "doc_count": 39
        },
        "nombre-de-cuves": {
            "doc_count": 39,
            "nombre-de-cuves_nested": {
                "doc_count": 5,
                "nombre-de-cuves_nested_filtered": {
                    "buckets": [
                        {
                            "doc_count": 3,
                            "key": "1",
                            "nombre-de-cuves_reverse_nested": {
                                "doc_count": 3,
                                "nombre-de-cuves_reverse_nested_parent_filter": {
                                    "doc_count": 3
                                }
                            },
                            "nombre-de-cuves_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 3,
                                        "key": ""
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            }
                        },
                        {
                            "doc_count": 2,
                            "key": "2",
                            "nombre-de-cuves_reverse_nested": {
                                "doc_count": 2,
                                "nombre-de-cuves_reverse_nested_parent_filter": {
                                    "doc_count": 2
                                }
                            },
                            "nombre-de-cuves_unit": {
                                "buckets": [
                                    {
                                        "doc_count": 2,
                                        "key": ""
                                    }
                                ],
                                "doc_count_error_upper_bound": 0,
                                "sum_other_doc_count": 0
                            }
                        }
                    ],
                    "doc_count_error_upper_bound": 0,
                    "sum_other_doc_count": 0
                }
            }
        },
        "offers": {
            "buckets": [
                {
                    "doc_count": 3,
                    "key": "Fond de rayon Sanitaire"
                },
                {
                    "doc_count": 2,
                    "key": "Fond de rayon Sanitaire 2"
                },
                {
                    "doc_count": 2,
                    "key": "Promos ete"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        }
    },
    "hits": {
        "hits": [
            {
                "_id": "p-49390",
                "_index": "catalog_2025_01",
                "_score": 20.691116,
                "_source": {
                    "catalog_code": "fdb85bbc209904e61d2d79a523042fa8"
                },
                "_type": "product"
            },
            {
                "_id": "p-52528",
                "_index": "catalog_2025_01",
                "_score": 19.407629,
                "_source": {
                    "catalog_code": "fdb85bbc209904e61d2d79a523042fa8.961"
                },
                "_type": "product"
            },
            {
                "_id": "p-49391",
                "_index": "catalog_2025_01",
                "_score": 19.216694,
                "_source": {
                    "catalog_code": "0ac41ac6c7a18862e9d36ad54c9a9b22"
                },
                "_type": "product"
            },
            {
                "_id": "p-98535",
                "_index": "catalog_2025_01",
                "_score": 17.816572,
                "_source": {
                    "catalog_code": "b69cc469ce901b9456ede2472bef0fe3_6180f22475ece"
                },
                "_type": "product"
            },
            {
                "_id": "p-25906",
                "_index": "catalog_2025_01",
                "_score": 16.676693,
                "_source": {
                    "catalog_code": "z5722.224"
                },
                "_type": "product"
            }
        ],
        "max_score": 20.691116,
        "total": 5
    },
    "timed_out": false,
    "took": 2
}

flattened ui facets

[
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 98.17920000000001,
                    "count": 5,
                    "max": 127.296,
                    "min": 79.596,
                    "sum": 490.896
                },
                "doc_count": 5
            }
        ],
        "name": "continuum_price_stats_with_include_self_filter",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 3,
                "key": "Fond de rayon Sanitaire"
            },
            {
                "doc_count": 2,
                "key": "Fond de rayon Sanitaire 2"
            },
            {
                "doc_count": 2,
                "key": "Promos ete"
            }
        ],
        "name": "offers",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 5,
                "key": "4f75b5c9625f9523338350"
            },
            {
                "doc_count": 5,
                "key": "543e3b8b3746b410428977"
            },
            {
                "doc_count": 5,
                "key": "e7513fad3e41f597b1786f1f6294e57e"
            },
            {
                "doc_count": 5,
                "key": "root"
            },
            {
                "doc_count": 1,
                "key": "4fb38f5aa0eeb713707284"
            }
        ],
        "name": "categories",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 98.17920000000001,
                    "count": 5,
                    "max": 127.296,
                    "min": 79.596,
                    "sum": 490.896
                },
                "doc_count": 5
            }
        ],
        "name": "continuum_price_stats",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 4,
                "key": "FRANKE"
            },
            {
                "doc_count": 1,
                "key": "MODERNA"
            }
        ],
        "name": "brand",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 3,
                "key": "1"
            },
            {
                "doc_count": 2,
                "key": "2"
            }
        ],
        "name": "nombre-de-cuves",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 2,
                "key": "1200 x 600"
            },
            {
                "doc_count": 1,
                "key": "1000 x 600"
            },
            {
                "doc_count": 1,
                "key": "800 x 600 x 160"
            },
            {
                "doc_count": 1,
                "key": "900 x 600"
            }
        ],
        "name": "dimensions",
        "unit": "mm"
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 98.17920000000001,
                    "count": 5,
                    "max": 127.296,
                    "min": 79.596,
                    "sum": 490.896
                },
                "doc_count": 5
            },
            {
                "continuum_price_stats": {
                    "avg": 98.17920000000001,
                    "count": 5,
                    "max": 127.296,
                    "min": 79.596,
                    "sum": 490.896
                },
                "doc_count": 5
            }
        ],
        "name": "continuum_price",
        "unit": null
    }
]

flattened suggestions

[]