Bricozor, 70 444 produits pour les passionnés de bricolage
Bricoleurs : 02 61 53 05 65 / Pro : 02 61 53 07 97
Livraison Express 24h :
Commandez avant 17h, soyez livré demain !
Voir la sélection >
43,80 € 36,50 € HT
Ces chevilles en polyéthylène A-ISOL s'incèrent dans des plaques isolantes de polystyrène ou des plaques…
Livraison rapide
285,30 € 237,75 € HT
Bientôt disponible
74,50 € 62,08 € HT
Épuisé
Épuisé
Épuisé
{
"_source": [
"_id",
"catalog_code"
],
"aggregations": {
"brand": {
"terms": {
"field": "brand.untouched",
"size": 1000
}
},
"categories": {
"terms": {
"field": "categories_parents_catalog_codes",
"size": 1000
}
},
"charge": {
"aggs": {
"charge_nested": {
"aggs": {
"charge_nested_filtered": {
"aggs": {
"charge_reverse_nested": {
"aggs": {
"charge_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"charge_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Charge"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"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_filtered": {
"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": {}
}
},
"delivery24h": {
"terms": {
"field": "is_delivery_24h",
"size": 1000
}
},
"diametre": {
"aggs": {
"diametre_nested": {
"aggs": {
"diametre_nested_filtered": {
"aggs": {
"diametre_reverse_nested": {
"aggs": {
"diametre_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"diametre_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Diam\u00e8tre"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"longueur": {
"aggs": {
"longueur_nested": {
"aggs": {
"longueur_nested_filtered": {
"aggs": {
"longueur_reverse_nested": {
"aggs": {
"longueur_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"longueur_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Longueur"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"nature-du-support": {
"aggs": {
"nature-du-support_nested": {
"aggs": {
"nature-du-support_nested_filtered": {
"aggs": {
"nature-du-support_reverse_nested": {
"aggs": {
"nature-du-support_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"nature-du-support_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Nature du support"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"offers": {
"terms": {
"field": "offers.untouched",
"size": 1000
}
},
"type-de-cheville": {
"aggs": {
"type-de-cheville_nested": {
"aggs": {
"type-de-cheville_nested_filtered": {
"aggs": {
"type-de-cheville_reverse_nested": {
"aggs": {
"type-de-cheville_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"type-de-cheville_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Type de cheville"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
}
},
"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": "5b17d15edee70721416581"
}
}
],
"must": {
"match_all": {}
}
}
},
"score_mode": "sum"
}
},
"size": 40
}
{
"_shards": {
"failed": 0,
"skipped": 0,
"successful": 5,
"total": 5
},
"aggregations": {
"brand": {
"buckets": [
{
"doc_count": 6,
"key": "RAWL"
},
{
"doc_count": 2,
"key": "FISCHER"
},
{
"doc_count": 2,
"key": "TOX"
},
{
"doc_count": 1,
"key": "ING FIXATIONS"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 11,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 11,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 11,
"key": "5b17d15edee70721416581"
},
{
"doc_count": 11,
"key": "root"
},
{
"doc_count": 3,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 2,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 2,
"key": "508e9a77eec8a976383346"
},
{
"doc_count": 2,
"key": "5b17d216e3779985069820"
},
{
"doc_count": 1,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 1,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 1,
"key": "68dce7915477c073461338"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"charge": {
"charge_nested": {
"charge_nested_filtered": {
"buckets": [
{
"charge_reverse_nested": {
"charge_reverse_nested_parent_filter": {
"doc_count": 7
},
"doc_count": 7
},
"charge_unit": {
"buckets": [
{
"doc_count": 19,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 19,
"key": "L\u00e9g\u00e8re"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 19
},
"doc_count": 175
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 8
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
},
"continuum_price_stats_filtered": {
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
},
"delivery24h": {
"buckets": [
{
"doc_count": 6,
"key": 1
},
{
"doc_count": 5,
"key": 0
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"diametre": {
"diametre_nested": {
"diametre_nested_filtered": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 0
},
"doc_count": 175
},
"longueur": {
"doc_count": 175,
"longueur_nested": {
"doc_count": 18,
"longueur_nested_filtered": {
"buckets": [
{
"doc_count": 2,
"key": "110",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 2,
"key": "120",
"longueur_reverse_nested": {
"doc_count": 2,
"longueur_reverse_nested_parent_filter": {
"doc_count": 2
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 2,
"key": "170",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 2,
"key": "85",
"longueur_reverse_nested": {
"doc_count": 2,
"longueur_reverse_nested_parent_filter": {
"doc_count": 2
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "135",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "140",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "160",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "175",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "180",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "200",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "220",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "50",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "55",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "90",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"nature-du-support": {
"doc_count": 175,
"nature-du-support_nested": {
"doc_count": 0,
"nature-du-support_nested_filtered": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"offers": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"type-de-cheville": {
"doc_count": 175,
"type-de-cheville_nested": {
"doc_count": 9,
"type-de-cheville_nested_filtered": {
"buckets": [
{
"doc_count": 9,
"key": "A frapper",
"type-de-cheville_reverse_nested": {
"doc_count": 3,
"type-de-cheville_reverse_nested_parent_filter": {
"doc_count": 3
}
},
"type-de-cheville_unit": {
"buckets": [
{
"doc_count": 9,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
}
},
"hits": {
"hits": [
{
"_id": "p-24476",
"_index": "catalog_2025_01",
"_score": 17.649578,
"_source": {
"catalog_code": "dd7ea0e5dbd316a244e8a246b87e9df7"
},
"_type": "product"
},
{
"_id": "p-24479",
"_index": "catalog_2025_01",
"_score": 17.026941,
"_source": {
"catalog_code": "58b129da4f2268bddb9c798fc9cdf0ec"
},
"_type": "product"
},
{
"_id": "p-10234",
"_index": "catalog_2025_01",
"_score": 16.773787,
"_source": {
"catalog_code": "4f08155b259ae"
},
"_type": "product"
},
{
"_id": "p-24478",
"_index": "catalog_2025_01",
"_score": 16.676693,
"_source": {
"catalog_code": "453ccae20e7b5ec37eead69af204a152"
},
"_type": "product"
},
{
"_id": "p-24237",
"_index": "catalog_2025_01",
"_score": 16.482874,
"_source": {
"catalog_code": "34d5dc44181c62849197954ed81f2247"
},
"_type": "product"
},
{
"_id": "p-10235",
"_index": "catalog_2025_01",
"_score": 16.436163,
"_source": {
"catalog_code": "4f08155ddaa5f"
},
"_type": "product"
},
{
"_id": "p-24477",
"_index": "catalog_2025_01",
"_score": 16.0,
"_source": {
"catalog_code": "cadc4136aacb485b5a01856de2256456"
},
"_type": "product"
},
{
"_id": "p-129662",
"_index": "catalog_2025_01",
"_score": 4.127203,
"_source": {
"catalog_code": "de6e667bb5ee0a10bd3184f8f6b5e493_68ae933cd5fb3"
},
"_type": "product"
},
{
"_id": "p-86560",
"_index": "catalog_2025_01",
"_score": 1.783011e-12,
"_source": {
"catalog_code": "f1166978e0aae090572c815c5794005b_5df377d5bbc8a"
},
"_type": "product"
},
{
"_id": "p-24480",
"_index": "catalog_2025_01",
"_score": 0.0,
"_source": {
"catalog_code": "84524b42613380e56bb6f883df4310fe"
},
"_type": "product"
},
{
"_id": "p-4759",
"_index": "catalog_2025_01",
"_score": 0.0,
"_source": {
"catalog_code": "id_C03A4G026P001"
},
"_type": "product"
}
],
"max_score": 17.649578,
"total": 11
},
"timed_out": false,
"took": 3
}
[
{
"buckets": [
{
"doc_count": 1,
"key": "110"
},
{
"doc_count": 2,
"key": "120"
},
{
"doc_count": 1,
"key": "170"
},
{
"doc_count": 2,
"key": "85"
},
{
"doc_count": 1,
"key": "135"
},
{
"doc_count": 1,
"key": "140"
},
{
"doc_count": 1,
"key": "160"
},
{
"doc_count": 1,
"key": "175"
},
{
"doc_count": 1,
"key": "180"
},
{
"doc_count": 1,
"key": "200"
},
{
"doc_count": 1,
"key": "220"
},
{
"doc_count": 1,
"key": "50"
},
{
"doc_count": 1,
"key": "55"
},
{
"doc_count": 1,
"key": "90"
}
],
"name": "longueur",
"unit": "mm"
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"doc_count": 7,
"key": "L\u00e9g\u00e8re"
}
],
"name": "charge",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
}
],
"name": "continuum_price_stats_filtered",
"unit": null
},
{
"buckets": [],
"name": "diametre",
"unit": null
},
{
"buckets": [
{
"doc_count": 6,
"key": 1
},
{
"doc_count": 5,
"key": 0
}
],
"name": "delivery24h",
"unit": null
},
{
"buckets": [
{
"doc_count": 3,
"key": "A frapper"
}
],
"name": "type-de-cheville",
"unit": null
},
{
"buckets": [],
"name": "nature-du-support",
"unit": null
},
{
"buckets": [
{
"doc_count": 11,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 11,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 11,
"key": "5b17d15edee70721416581"
},
{
"doc_count": 11,
"key": "root"
},
{
"doc_count": 3,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 2,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 2,
"key": "508e9a77eec8a976383346"
},
{
"doc_count": 2,
"key": "5b17d216e3779985069820"
},
{
"doc_count": 1,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 1,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 1,
"key": "68dce7915477c073461338"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 6,
"key": "RAWL"
},
{
"doc_count": 2,
"key": "FISCHER"
},
{
"doc_count": 2,
"key": "TOX"
},
{
"doc_count": 1,
"key": "ING FIXATIONS"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
},
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
},
{
"continuum_price_stats": {
"avg": 95.6625,
"count": 8,
"max": 285.3,
"min": 43.8,
"sum": 765.3
},
"doc_count": 11
}
],
"name": "continuum_price",
"unit": null
}
]
[]