Evier à poser - inox 90 x 60 cm - 1 cuve et 1 égouttoir FRANKE
En stock
- Fabrication Française
- Isolation phonique par plaques
- Bonde et siphon inclus
- Garantie 15 ans
97,20 € au lieu de 108,00 € 81,00 € HT
Bricozor, 69 483 produits pour les passionnés de bricolage
Bricoleurs : 02 61 53 05 65 / Pro : 02 61 53 07 97
En stock
97,20 € au lieu de 108,00 € 81,00 € HT
En stock
79,60 € 66,33 € HT
En stock
86,90 € 72,42 € HT
En stock
127,30 € 106,08 € HT
En stock
99,90 € 83,25 € HT
{ "_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 }
{ "_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 }
[ { "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 } ]
[]