Rosace de plomberie
Rosace plate chromée - diamètre 65 mm - vendu par paire DELABIE
- Rosace plate
- Cache éclat
- Vendu par paire
- Garantie 30 ans
24,90 € 20,75 € HT
Paire de raccords droits avec rosaces - mâle/mâle RIQUIER
- Longueur totale 43 mm.
- Rosace Ø 50 mm
- 15x21 - 20x27
27,30 € 22,75 € HT
Rosace de finition blanche - Pour PER RIQUIER
- Rosace en plastique
- Pour PER
- Un modèle 1 tube
- Un modèle 2 tubes
À partir de 1,00 € 0,83 € HT
2 versions
Paire de raccords droits avec rosaces - mâle / femelle - Laiton chromé RIQUIER
- La paire
- Pour robinet standard ou en rénovation
- Ø de la rosace 50 mm
39,20 € 32,67 € HT
Paire de raccords excentrés 45mm avec rosaces -M15x21 - M20x27 -Laiton RIQUIER
- Vendu par deux pièces
- Entraxe 45 mm sur chaque raccord
- Raccord excentré + enjoliveur
- Mâle 15X21 /Mâle 20X27 mm
93,40 € 77,83 € HT
2,40 € 2,00 € HT
Paire de raccords excentrés de 40 mm - M15x21 - M15x21 RIQUIER
Bientôt disponible
- Vendu par paire
- Mâle 15x21 / Mâle 20x27
- Entraxe pour chaque raccord de 40 mm
- Capacité d'excentrage totale 80 mm pour la paire
26,90 € 22,42 € HT
20,50 € 17,08 € HT
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_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"
}
},
"filetage": {
"aggs": {
"filetage_nested": {
"aggs": {
"filetage_nested_filtered": {
"aggs": {
"filetage_reverse_nested": {
"aggs": {
"filetage_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"filetage_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Filetage"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"matiere": {
"aggs": {
"matiere_nested": {
"aggs": {
"matiere_nested_filtered": {
"aggs": {
"matiere_reverse_nested": {
"aggs": {
"matiere_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"matiere_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Mati\u00e8re"
}
}
}
},
"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": "655231a7da581337540377"
}
}
],
"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": 9,
"key": "RIQUIER"
},
{
"doc_count": 1,
"key": "DELABIE"
},
{
"doc_count": 1,
"key": "PBTUB"
},
{
"doc_count": 1,
"key": "RBM"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 12,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 12,
"key": "508e9475abc79409512645"
},
{
"doc_count": 12,
"key": "655231a7da581337540377"
},
{
"doc_count": 12,
"key": "root"
},
{
"doc_count": 9,
"key": "508e7968bc7a9902462159"
},
{
"doc_count": 9,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 9,
"key": "58b949afcec9c211177689"
},
{
"doc_count": 5,
"key": "593006e178f9b270753966"
},
{
"doc_count": 5,
"key": "5937d0d3bbd67124110299"
},
{
"doc_count": 2,
"key": "store_root"
},
{
"doc_count": 1,
"key": "517a75423b984098405701"
},
{
"doc_count": 1,
"key": "51ecf18d126ef645940675"
},
{
"doc_count": 1,
"key": "53f4c2bb27d7b105261505"
},
{
"doc_count": 1,
"key": "559bf314afd67895325308"
},
{
"doc_count": 1,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 1,
"key": "65522abe79eaf585775709"
},
{
"doc_count": 1,
"key": "65522ad0bf6e0330232395"
},
{
"doc_count": 1,
"key": "9876bfe796e5266a5a5f374c75036897"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 11
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
},
"continuum_price_stats_filtered": {
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
},
"delivery24h": {
"buckets": [
{
"doc_count": 9,
"key": 1
},
{
"doc_count": 3,
"key": 0
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"diametre": {
"diametre_nested": {
"diametre_nested_filtered": {
"buckets": [
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "12"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "14"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "16"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "40"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "45"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "50"
},
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 1,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 1,
"key": "60"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 7
},
"doc_count": 124
},
"filetage": {
"doc_count": 124,
"filetage_nested": {
"doc_count": 6,
"filetage_nested_filtered": {
"buckets": [
{
"doc_count": 2,
"filetage_reverse_nested": {
"doc_count": 2,
"filetage_reverse_nested_parent_filter": {
"doc_count": 2
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 2,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "15x21"
},
{
"doc_count": 2,
"filetage_reverse_nested": {
"doc_count": 2,
"filetage_reverse_nested_parent_filter": {
"doc_count": 2
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 2,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "15x21 - 20x27"
},
{
"doc_count": 1,
"filetage_reverse_nested": {
"doc_count": 1,
"filetage_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 1,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "15x21 - 15x21"
},
{
"doc_count": 1,
"filetage_reverse_nested": {
"doc_count": 1,
"filetage_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 1,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "20x27"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"matiere": {
"doc_count": 124,
"matiere_nested": {
"doc_count": 8,
"matiere_nested_filtered": {
"buckets": [
{
"doc_count": 7,
"key": "acier inoxydable",
"matiere_reverse_nested": {
"doc_count": 1,
"matiere_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 7,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 1,
"key": "Laiton chrom\u00e9",
"matiere_reverse_nested": {
"doc_count": 1,
"matiere_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 1,
"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": 2,
"key": "Fabrication Fran\u00e7aise"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
"hits": {
"hits": [
{
"_id": "p-8377",
"_index": "catalog_2025_01",
"_score": 23.15292,
"_source": {
"catalog_code": "z2152"
},
"_type": "product"
},
{
"_id": "p-8382",
"_index": "catalog_2025_01",
"_score": 20.29025,
"_source": {
"catalog_code": "z3313"
},
"_type": "product"
},
{
"_id": "p-8378",
"_index": "catalog_2025_01",
"_score": 19.702496,
"_source": {
"catalog_code": "z2153"
},
"_type": "product"
},
{
"_id": "p-9412",
"_index": "catalog_2025_01",
"_score": 19.56443,
"_source": {
"catalog_code": "z1103"
},
"_type": "product"
},
{
"_id": "p-8368",
"_index": "catalog_2025_01",
"_score": 17.619616,
"_source": {
"catalog_code": "z2139"
},
"_type": "product"
},
{
"_id": "p-9417",
"_index": "catalog_2025_01",
"_score": 17.290035,
"_source": {
"catalog_code": "z1771"
},
"_type": "product"
},
{
"_id": "p-8369",
"_index": "catalog_2025_01",
"_score": 17.010195,
"_source": {
"catalog_code": "z2140"
},
"_type": "product"
},
{
"_id": "p-8371",
"_index": "catalog_2025_01",
"_score": 16.902002,
"_source": {
"catalog_code": "z2143"
},
"_type": "product"
},
{
"_id": "p-9400",
"_index": "catalog_2025_01",
"_score": 16.0,
"_source": {
"catalog_code": "z1104"
},
"_type": "product"
},
{
"_id": "p-8364",
"_index": "catalog_2025_01",
"_score": 4.6589646,
"_source": {
"catalog_code": "z2132"
},
"_type": "product"
},
{
"_id": "p-8380",
"_index": "catalog_2025_01",
"_score": 4.0,
"_source": {
"catalog_code": "z2141"
},
"_type": "product"
},
{
"_id": "p-8370",
"_index": "catalog_2025_01",
"_score": 0.0,
"_source": {
"catalog_code": "z2142"
},
"_type": "product"
}
],
"max_score": 23.15292,
"total": 12
},
"timed_out": false,
"took": 2
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 2,
"key": "15x21"
},
{
"doc_count": 2,
"key": "15x21 - 20x27"
},
{
"doc_count": 1,
"key": "15x21 - 15x21"
},
{
"doc_count": 1,
"key": "20x27"
}
],
"name": "filetage",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [
{
"doc_count": 2,
"key": "Fabrication Fran\u00e7aise"
}
],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"doc_count": 9,
"key": 1
},
{
"doc_count": 3,
"key": 0
}
],
"name": "delivery24h",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
}
],
"name": "continuum_price_stats_filtered",
"unit": null
},
{
"buckets": [
{
"doc_count": 1,
"key": "12"
},
{
"doc_count": 1,
"key": "14"
},
{
"doc_count": 1,
"key": "16"
},
{
"doc_count": 1,
"key": "40"
},
{
"doc_count": 1,
"key": "45"
},
{
"doc_count": 1,
"key": "50"
},
{
"doc_count": 1,
"key": "60"
}
],
"name": "diametre",
"unit": "mm"
},
{
"buckets": [
{
"doc_count": 12,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 12,
"key": "508e9475abc79409512645"
},
{
"doc_count": 12,
"key": "655231a7da581337540377"
},
{
"doc_count": 12,
"key": "root"
},
{
"doc_count": 9,
"key": "508e7968bc7a9902462159"
},
{
"doc_count": 9,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 9,
"key": "58b949afcec9c211177689"
},
{
"doc_count": 5,
"key": "593006e178f9b270753966"
},
{
"doc_count": 5,
"key": "5937d0d3bbd67124110299"
},
{
"doc_count": 2,
"key": "store_root"
},
{
"doc_count": 1,
"key": "517a75423b984098405701"
},
{
"doc_count": 1,
"key": "51ecf18d126ef645940675"
},
{
"doc_count": 1,
"key": "53f4c2bb27d7b105261505"
},
{
"doc_count": 1,
"key": "559bf314afd67895325308"
},
{
"doc_count": 1,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 1,
"key": "65522abe79eaf585775709"
},
{
"doc_count": 1,
"key": "65522ad0bf6e0330232395"
},
{
"doc_count": 1,
"key": "9876bfe796e5266a5a5f374c75036897"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 9,
"key": "RIQUIER"
},
{
"doc_count": 1,
"key": "DELABIE"
},
{
"doc_count": 1,
"key": "PBTUB"
},
{
"doc_count": 1,
"key": "RBM"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"doc_count": 1,
"key": "acier inoxydable"
},
{
"doc_count": 1,
"key": "Laiton chrom\u00e9"
}
],
"name": "matiere",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
},
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
},
{
"continuum_price_stats": {
"avg": 21.89018181818182,
"count": 11,
"max": 93.396,
"min": 0.6,
"sum": 240.792
},
"doc_count": 12
}
],
"name": "continuum_price",
"unit": null
}
]
flattened suggestions
[]