Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Culotte Escante : Laçage Sexy et Maintien Parfait
Double-cliquez pour agrandir
SKU: SBGA9101
Culotte Escante : Laçage Sexy et Maintien Parfait
Nouveau Promo
Stock:

Découvrez la culotte Escante, superbement conçue pour maintenir le ventre et mettre vos fesses en valeur.

Son laçage sur les fesses et sa coupe haute créent une silhouette irrésistible.

Points forts

  • Maintien du ventre grâce à sa coupe haute sculptante
  • Laçage sur les fesses ultra sexy et provocant
  • Met les fesses en valeur de façon spectaculaire
  • Dentelle élastique solide et de qualité supérieure
  • Coupe haute qui sublime la silhouette
  • Design noir intemporel et terriblement sexy
Taille:

Vous ne savez pas quelle taille choisir? Consultez notre guide des tailles

Couleur:
Quantité:
24.95 € 17.95 €
Conseils avisés
par chat, facebook ou par e-mail
Retours gratuits
sous 15 jours *

Culotte haute grande taille Escante laçage fesses maintien ventre

Description du produit

La culotte Escante révèle toute sa beauté dans sa conception superbement pensée pour sublimer vos courbes généreuses.

Sa coupe haute maintient parfaitement le ventre tout en créant une silhouette sculptée qui ne laisse personne indifférent. Le véritable atout d'Escante réside dans son laçage sur les fesses qui transforme chaque mouvement en invitation à la séduction.

Cette création met vos fesses en valeur de façon spectaculaire, créant un effet visuel saisissant qui révèle votre audace assumée. Sa dentelle élastique solide garantit une qualité supérieure qui résiste au temps tout en épousant parfaitement vos formes. Chaque détail a été pensé pour créer une culotte qui allie maintien optimal et séduction provocante.

Cette pièce noire intemporelle transforme chaque jour en occasion de vous sentir irrésistiblement sexy et confiante, révélant votre sensualité la plus authentique.

Détails techniques

  • Matière : Dentelle élastique de qualité supérieure (92% polyamide, 8% élasthanne)
  • Couleur : Noir
  • Style : Culotte haute avec laçage fesses
  • Maintien : Ventre maintenu par la coupe haute
  • Entretien : Lavage délicat à la main recommandé

Tailles disponibles

Disponible du 38-40 au 48-50

Couleur disponible

Noir

Guide de taille

Vérifiez la taille qui vous convient

International
  • Poitrine
  • Taille
  • Hanches
38-40
  • 92-100
  • 74-82
  • 98-106
44-46
  • 102-108
  • 86-92
  • 108-114
48-50
  • 110-116
  • 96-102
  • 116-122

Conseils d'entretien

  • Lavage à la main recommandé avec savon doux ou cycle délicat en machine (30°C max) dans un filet de protection
  • Séchage à plat à l'ombre, jamais au sèche-linge
  • Repassage déconseillé ou à très basse température si nécessaire
  • Rangement à plat dans un endroit sec
  • Pour préserver l'élasticité et le maintien de vos pièces (tailles 42-64), alternez leur port
  • Lavage délicat à la main à l'eau tiède (30°C maximum)
  • Utiliser une lessive douce sans agents blanchissants
  • Séchage à plat à l'abri de la lumière directe
  • Ne pas tirer sur le laçage lors du lavage

Conseils d'utilisation

La culotte Escante est parfaite pour les moments où vous souhaitez allier maintien optimal et séduction provocante. Sa coupe haute maintient délicatement le ventre tout en mettant spectaculairement vos fesses en valeur.

Le laçage sur les fesses permet un ajustement personnalisé tout en créant un effet visuel terriblement sexy. Portez-la avec assurance pour révéler votre côté le plus audacieux et faire sensation à chaque regard.

Conseils de style

La culotte Escante avec son laçage provocant se suffit à elle-même pour créer un look terriblement sexy. Pour un ensemble parfait, associez-la à des pièces qui prolongent son effet sculptant. Cette création noire révèle votre audace et votre sensualité débridée. Complétez votre silhouette avec nos redresse-seins pour un maintien parfait du décolleté, ou découvrez nos déshabillés pour une séduction progressive qui culminera avec la découverte de cette culotte terriblement excitante.

To Top
Voir le panier
Articles
Total articles
Struct
Entries: 108
actions
Array
available
number-1
brand
stringparishollywood
brandcode
stringpuun
branding
stringdivasboudoir,legsboudoir
brandmedias
string{"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}}
brandmetas
Struct
de
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
el
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
en
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
es
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
fr
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
it
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
nl
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
pt
Struct
currentseouri
string
description
string
metas
Struct
description
string
keywords
string
title
string
name
string
seotitle
string
seouri
string
subtitle
string
summary
string
brandname
stringParis Hollywood
breasts
stringna
careinstructions
stringlace
categories
stringdivasboudoir.lingerie.briefs.sexypanty
category
stringbriefs
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string331
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/sexypanty.jpg
type
stringimg
width
string719
divasboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
fetishboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
latexboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
legsboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
lustboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
private
Struct
height
string1016
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/private/default.jpg
type
stringimg
width
string703
smboudoir
Struct
plus
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
small
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
standard
Struct
alt
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
back
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
variations
Struct
colors
Struct
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
categorysizerange
stringauto
colorinfos
Query
Template: /system/api/product/colors.cfc:13
Execution Time: 1 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2021-12-16 14:05:23'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number3
instockvariations
number0
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number1
isonline
number0
isoutletprice
number0
itemprice
number20.7917
itempromo
number14.9583
key
string5139
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-09-11 10:48:06'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.99 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select cart_actions.*
from cart_actions
where cart_actions.branding IN ('all','divasboudoir')
and cart_actions.language IN ('all','fr')
and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas))
and cart_actions.isactive = 1
and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null)
and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null)
and (
FIND_IN_SET('9a9a21a3-c6e2-4b98-8c19771ad27f1354',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null
)
id_actionbrandinglanguagenamecodetypeminimumOrdermaximumOrderminimumItemsmaximumItemsmaximumUseallowedItemsquotasusedCountlinkedproductslinkedthemeslinkedbrandslinkeditemparamsactiveFromactiveToisActive
linkedproducts
Query
Template: /system/api/products.cfc:1305
Execution Time: 1.6 ms
Record Count: 0
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name,
product_links.linkuid,
products.colors, products.vatrate, products.metadatas, products.dimensions,
products.mediadatas, products.tags, products.themes, products.isdivasize,
count(distinct product_variations.variationuid) as totalvariations,
group_concat(distinct product_variations.variationuid) as variationlist,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo,
if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo,
IFNULL(min(product_variations.itemprice),0) as itemprice,
(select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice,
count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices,
(select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil,
products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations,
products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display,
product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange,
product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory
from products
left outer join product_categorymap on products.productuid = product_categorymap.productuid
left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key)
left outer join product_sizes on product_sizes.id_size IN (products.sizes)
left outer join brands on products.brand = brands.brand
left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_links on product_links.reference = products.reference
where products.isactive = 1 and products.isdeleted = 0
and brands.isactive = 1 and brands.isdeleted = 0
and product_categories.isactive = 1 and product_categories.isdeleted = 0
and product_variations.isactive = 1
and FIND_IN_SET('divasboudoir',products.branding)
and product_categories.branding IN ('all','divasboudoir')
and product_categorymap.branding IN ('all','divasboudoir')
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and products.language in ('all','fr')
and product_categories.language in ('all','fr')
and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null)
and (products.displayTo >= DATE(NOW()) or products.displayTo IS null)
and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> ''
and products.reference <> 'SBGA9101'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga9101/culotte_grande_taille_escante.jpg
type
stringimg
width
string1312
back
Struct
height
string1536
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga9101/heidi-panties-naked-curve-185.jpg
type
stringimg
width
string1024
default
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga9101/culotte_grande_taille_escante_dos.jpg
type
stringimg
width
string1312
variations
Struct
colors
Struct
black
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga9101/culotte_grande_taille_escante_dos.jpg
type
stringimg
width
string1312
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Feinw&auml;sche per Hand in lauwarmem Wasser (maximal 30&deg;C)</li> <li>Verwende ein mildes Waschmittel ohne Bleichmittel</li> <li>Flach trocknen und vor direktem Licht sch&uuml;tzen</li> <li>Beim Waschen nicht an der Schn&uuml;rung ziehen</li> </ul>
description
string<p>Der Escante Slip offenbart seine ganze Sch&ouml;nheit in seinem <strong>hervorragend durchdachten</strong> Design, das Ihre &uuml;ppigen Kurven hervorhebt.</p> <p>Der <strong>hohe Schnitt</strong> sorgt f&uuml;r einen perfekten Halt des Bauches und schafft eine wohlgeformte Silhouette, die niemanden gleichg&uuml;ltig l&auml;sst. Der wahre Trumpf von Escante ist die <strong>Schn&uuml;rung &uuml;ber dem Ges&auml;&szlig;</strong>, die jede Bewegung in eine Einladung zur Verf&uuml;hrung verwandelt.</p> <p>Diese Kreation betont Ihren Po auf spektakul&auml;re Weise und erzeugt einen atemberaubenden visuellen Effekt, der Ihre selbstbewusste K&uuml;hnheit offenbart. Die <strong>feste, elastische Spitze</strong> garantiert eine hochwertige Qualit&auml;t, die der Zeit standh&auml;lt und sich gleichzeitig perfekt an Ihre Formen anpasst. Jedes Detail wurde durchdacht, um einen Slip zu kreieren, der optimalen Halt und provokante Verf&uuml;hrung vereint.</p> <p>Dieses zeitlose schwarze St&uuml;ck verwandelt jeden Tag in eine Gelegenheit, sich unwiderstehlich sexy und selbstbewusst zu f&uuml;hlen und enth&uuml;llt Ihre authentischste Sinnlichkeit.</p>
guid
stringhttps://dev.divasboudoir.com/de/escante-hoschen-grosse-grosse-schnurung-gesass/sbga9101.htm
highlights
string<ul> <li><strong>St&uuml;tzt den Bauch</strong> dank des hohen, formenden Schnitts</li> <li><strong>Schn&uuml;rung am Ges&auml;&szlig;</strong> ultra-sexy und provokativ</li> <li><strong>Betont das Ges&auml;&szlig;</strong> auf spektakul&auml;re Weise</li> <li>Starke,<strong>elastische Spitze</strong> von h&ouml;chster Qualit&auml;t</li> <li><strong>Hoher Schnitt</strong>, der die Silhouette sublimiert</li> <li>Zeitloses<strong>schwarzes Design</strong>, das unheimlich sexy ist</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringEscante Slip in großen Größen mit sexy Schnürung am Gesäß. Stützt den Bauch, hoch geschnitten, hochwertige Spitze. Provozierendes Schwarz. Schnelle Lieferung. Diva's Boudoir.
keywords
string
title
stringEscante Slip in großer Größe mit Gesäßschnürung | Diva's Boudoir
seotitle
stringHoher Slip Große Größen Escante Schnürung Gesäß Bauch-haltend
seouri
stringescante-hoschen-grosse-grosse-schnurung-gesass
specifications
string<ul> <li><strong>Material:</strong> Hochwertige, elastische Spitze (92% Polyamid, 8% Elasthan)</li> <li><strong>Farbe:</strong> Schwarz</li> <li><strong>Stil:</strong> Hoher Slip mit Ges&auml;&szlig;schn&uuml;rung</li> <li><strong>Halt:</strong> Bauch wird durch den hohen Schnitt gehalten</li> <li><strong>Pflege:</strong> Schonende Handw&auml;sche empfohlen</li> </ul>
stylingtips
string<p>Der Escante-Slip mit seiner <strong>aufreizenden Schn&uuml;rung</strong> ist schon f&uuml;r sich allein genommen ein unglaublich sexy Look. F&uuml;r ein perfektes Outfit kombinieren Sie es mit Teilen, die seine formende Wirkung verl&auml;ngern. Diese schwarze Kreation offenbart Ihre K&uuml;hnheit und ungez&uuml;gelte Sinnlichkeit. Vervollst&auml;ndigen Sie Ihre Silhouette mit unseren <a href="https://www.divasboudoir.com/de/bruststraffer-in-ubergrosse/">B&uuml;stenhaltern</a> f&uuml;r ein perfektes Dekollet&eacute; oder entdecken Sie unsere <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Negligees</a> f&uuml;r eine schrittweise Verf&uuml;hrung, die mit der Entdeckung dieses aufregenden Slips ihren H&ouml;hepunkt erreicht.</p>
summary
string<p>Entdecken Sie den Escante Slip, der <strong>wundersch&ouml;n entworfen wurde</strong>, um den Bauch zu st&uuml;tzen und Ihren Po zu betonen.</p> <p>Seine <strong>Schn&uuml;rung &uuml;ber dem Ges&auml;&szlig;</strong> und der <strong>hohe Schnitt</strong> sorgen f&uuml;r eine unwiderstehliche Silhouette.</p>
title
stringEscante Slip : Sexy Schnürung und perfekter Halt
usageinstructions
string<p>Der Escante Slip ist perfekt f&uuml;r Momente, in denen Sie <strong>optimalen Halt</strong> mit provokativer Verf&uuml;hrung kombinieren m&ouml;chten. Der hohe Schnitt st&uuml;tzt sanft den Bauch, w&auml;hrend Ihr Ges&auml;&szlig; spektakul&auml;r betont wird.</p> <p>Die <strong>Schn&uuml;rung &uuml;ber dem Ges&auml;&szlig;</strong> erm&ouml;glicht eine individuelle Passform und sorgt gleichzeitig f&uuml;r einen furchtbar sexy optischen Effekt. Tragen Sie es selbstbewusst, um Ihre k&uuml;hnste Seite zu enth&uuml;llen und mit jedem Blick f&uuml;r Aufsehen zu sorgen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλένετε στο χέρι με χλιαρό νερό (30&deg;C το πολύ)</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li> <li>Στεγνώνετε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li> <li>Μην τραβάτε τα κορδόνια κατά το πλύσιμο</li> </ul>
description
string<p>Το εσώρουχο Escante αποκαλύπτει όλη την ομορφιά του σε ένα σχέδιο <strong>εξαιρετικά μελετημένο</strong> για να αναδεικνύει τις γενναιόδωρες καμπύλες σας.</p> <p>Το <strong>ψηλό</strong> του <strong>κόψιμο</strong> υποστηρίζει τέλεια την κοιλιά, ενώ δημιουργεί μια σμιλευμένη σιλουέτα που δεν αφήνει κανέναν αδιάφορο. Το πραγματικό πλεονέκτημα του Escante είναι τα <strong>κορδόνια στα οπίσθια</strong>, τα οποία μετατρέπουν κάθε κίνηση σε πρόσκληση για αποπλάνηση.</p> <p>Αυτό το σχέδιο αναδεικνύει δραματικά τους γλουτούς σας, δημιουργώντας ένα εντυπωσιακό οπτικό αποτέλεσμα που αποκαλύπτει την τόλμη σας. Η <strong>συμπαγής ελαστική δαντέλα</strong> του εγγυάται ανώτερη ποιότητα που θα αντέξει στη δοκιμασία του χρόνου, ενώ προσαρμόζεται τέλεια στο σχήμα σας. Κάθε λεπτομέρεια έχει μελετηθεί για να δημιουργηθεί ένα εσώρουχο που συνδυάζει τη βέλτιστη στήριξη με την προκλητική αποπλάνηση.</p> <p>Αυτό το διαχρονικό μαύρο κομμάτι μετατρέπει κάθε μέρα σε μια ευκαιρία να νιώσετε ακαταμάχητα σέξι και σίγουροι, αποκαλύπτοντας τον πιο αυθεντικό σας αισθησιασμό.</p>
guid
stringhttps://dev.divasboudoir.com/el/megalo-eswroycho-escante-dantela-mechri-toys-gloytoys/sbga9101.htm
highlights
string<ul> <li>Υψηλό κόψιμο<strong>για στήριξη της κοιλιάς</strong> </li> <li>Εξαιρετικά σέξι και προκλητικά<strong>κορδόνια στους γλουτούς</strong> </li> <li><strong>Ενισχύει</strong> δραματικά<strong>τους γλουτούς</strong> </li> <li>Ισχυρή, υψηλής ποιότητας<strong>ελαστική δαντέλα</strong> </li> <li><strong>Υψηλό κόψιμο</strong> που ενισχύει τη σιλουέτα</li> <li>Διαχρονικό, σέξι<strong>μαύρο σχέδιο</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο εσώρουχο Escante με σέξι κορδόνια στα οπίσθια. Υποστήριξη της κοιλιάς, ψηλό κόψιμο, ποιοτική δαντέλα. Προκλητικό μαύρο. Γρήγορη παράδοση. Μπουντουάρ της Ντίβας.
keywords
string
title
stringEscante σλιπ μεγάλου μεγέθους με κορδόνια στους γλουτούς | Diva's Boudoir
seotitle
stringEscante μεγάλο σλιπ υψηλής μέσης με δαντέλα για υποστήριξη της κοιλιάς των γλουτών
seouri
stringmegalo-eswroycho-escante-dantela-mechri-toys-gloytoys
specifications
string<ul> <li><strong>Υλικό:</strong> Ελαστική δαντέλα υψηλής ποιότητας (92% πολυαμίδιο, 8% ελαστάν)</li> <li><strong>Χρώμα:</strong> Μαύρο</li> <li><strong>Στυλ:</strong> Εσώρουχα με ψηλόμεσο σλιπ και δαντέλα στο οπίσθιο μέρος</li> <li><strong>Στήριξη:</strong> Υψηλό κόψιμο για στήριξη της κοιλιάς</li> <li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li> </ul>
stylingtips
string<p>Το εσώρουχο Escante, με τα <strong>προκλητικά κορδόνια</strong> του, στέκεται μόνο του και δημιουργεί μια απίστευτα σέξι εμφάνιση. Για το τέλειο σύνολο, συνδυάστε τα με κομμάτια που επεκτείνουν το σμιλευτικό τους αποτέλεσμα. Αυτή η μαύρη δημιουργία αποκαλύπτει την τόλμη και τον αχαλίνωτο αισθησιασμό σας. Ολοκληρώστε τη σιλουέτα σας με τις <a href="https://www.divasboudoir.com/el/megalo-megethos-enischyth-sththoys/">τιράντες σουτιέν</a> μας για τέλεια στήριξη του ντεκολτέ ή ανακαλύψτε <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">τα νεγκλιζέ</a> μας για μια σταδιακή αποπλάνηση που θα κορυφωθεί με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p>
summary
string<p>Ανακαλύψτε τα εσώρουχα Escante, <strong>εξαιρετικά σχεδιασμένα</strong> για να στηρίζουν την κοιλιά σας και να αναδεικνύουν τον πισινό σας.</p> <p>Τα <strong>κορδόνια στα οπίσθια</strong> και το <strong>ψηλό κόψιμο</strong> δημιουργούν μια ακαταμάχητη σιλουέτα.</p>
title
stringΕσώρουχα Escante : Σέξι κορδόνια και τέλεια στήριξη
usageinstructions
string<p>Τα εσώρουχα Escante είναι ιδανικά για τις στιγμές εκείνες που θέλετε να συνδυάσετε <strong>τη βέλτιστη στήριξη</strong> με την προκλητική αποπλάνηση. Το ψηλό κόψιμο στηρίζει απαλά την κοιλιά, ενώ αναδεικνύει τους γλουτούς σας με θεαματικό αποτέλεσμα.</p> <p>Τα <strong>κορδόνια στα οπίσθια</strong> επιτρέπουν μια εξατομικευμένη εφαρμογή, ενώ δημιουργούν ένα τρομερά σέξι οπτικό αποτέλεσμα. Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε την πιο τολμηρή πλευρά σας και να κάνετε μια δήλωση με κάθε σας εμφάνιση.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in lukewarm water (30&deg;C maximum)</li> <li>Use a mild detergent without bleaching agents</li> <li>Dry flat away from direct light</li> <li>Do not pull on lacing when washing</li> </ul>
description
string<p>The Escante panty reveals all its beauty in its <strong>superbly thought-out</strong> design to sublimate your generous curves.</p> <p>Its <strong>high cut</strong> perfectly supports the tummy while creating a sculpted silhouette that leaves no one indifferent. Escante's real trump card is its <strong>buttock lacing</strong>, which turns every movement into an invitation to seduction.</p> <p>This creation showcases your buttocks in spectacular fashion, creating a striking visual effect that reveals your assumed audacity. Its <strong>solid, elastic lace</strong> guarantees superior quality that will stand the test of time, while hugging your shape perfectly. Every detail has been thought through to create a panty that combines optimal support with provocative seduction.</p> <p>This timeless black piece transforms every day into an opportunity to feel irresistibly sexy and confident, revealing your most authentic sensuality.</p>
guid
stringhttps://dev.divasboudoir.com/en/panty-escante-plus-size-lace-up-buttocks/sbga9101.htm
highlights
string<ul> <li><strong>Tummy support</strong> thanks to sculpting high cut</li> <li>Ultra-sexy, provocative<strong>buttock lacing</strong> </li> <li>Dramatically<strong>enhances the buttocks</strong> </li> <li>Strong, high-quality<strong>elastic lace</strong> </li> <li><strong>High cut</strong> that enhances the silhouette</li> <li>Timeless, sexy<strong>black design</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringPlus size Escante panties with sexy lacing on the buttocks. Tummy support, high cut, quality lace. Provocative black. Fast delivery. Diva's Boudoir.
keywords
string
title
stringEscante plus size lace-up panties | Diva's Boudoir
seotitle
stringEscante plus size high waist briefs lace-up buttocks tummy support
seouri
stringpanty-escante-plus-size-lace-up-buttocks
specifications
string<ul> <li><strong>Material:</strong> High-quality elastic lace (92% polyamide, 8% elastane)</li> <li><strong>Color:</strong> Black</li> <li><strong>Style:</strong> High-cut panties with lace-up buttocks</li> <li><strong>Support:</strong> High-cut tummy support</li> <li><strong>Care:</strong> Delicate hand wash recommended</li> </ul>
stylingtips
string<p>The Escante panty with its <strong>provocative lacing</strong> stands alone to create a terribly sexy look. For the perfect ensemble, pair them with pieces that extend their sculpting effect. This black creation reveals your audacity and unbridled sensuality. Complement your silhouette with our <a href="https://www.divasboudoir.com/en/large-size-breast-stand/">breast straighteners</a> for perfect cleavage support, or discover our <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a> for a gradual seduction that culminates in the discovery of these terribly exciting panties.</p>
summary
string<p>Discover Escante panties, <strong>superbly designed</strong> to support your tummy and enhance your buttocks.</p> <p>Their <strong>buttock lacing</strong> and <strong>high cut</strong> create an irresistible silhouette.</p>
title
stringEscante panties: Sexy lacing and perfect support
usageinstructions
string<p>Escante panties are perfect for those moments when you want to combine <strong>optimal support</strong> with provocative seduction. Their high cut gently holds your tummy in place while dramatically enhancing your buttocks.</p> <p>The <strong>lacing on the buttocks</strong> allows a personalized fit while creating a terribly sexy visual effect. Wear it with confidence to reveal your most daring side and make a sensation with every glance.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano suavemente en agua tibia (30&deg;C máximo)</li> <li>Utilizar un detergente suave sin blanqueantes</li> <li>Secar en plano lejos de la luz directa</li> <li>No tirar del cordón durante el lavado</li> </ul>
description
string<p>La braguita Escante revela toda su belleza en un diseño <strong>magníficamente pensado</strong> para realzar tus generosas curvas.</p> <p>Su <strong>corte alto</strong> sujeta perfectamente el vientre al tiempo que crea una silueta esculpida que no deja indiferente a nadie. La verdadera baza de Escante es la <strong>lazada en las nalgas</strong>, que convierte cada movimiento en una invitación a la seducción.</p> <p>Este diseño muestra tu trasero de forma espectacular, creando un llamativo efecto visual que revela tu actitud atrevida. Su <strong>sólido encaje elástico</strong> garantiza una calidad superior que resistirá el paso del tiempo, al tiempo que se amolda perfectamente a tu figura. Cada detalle ha sido pensado para crear una braguita que combina una sujeción óptima con una seducción provocativa.</p> <p>Esta pieza negra atemporal convierte cada día en una oportunidad para sentirte irresistiblemente sexy y segura de ti misma, revelando tu sensualidad más auténtica.</p>
guid
stringhttps://dev.divasboudoir.com/es/talla-grande-bragas-escante-encaje-nalgas/sbga9101.htm
highlights
string<ul> <li>Corte alto esculpido<strong>para sujetar el vientre</strong> </li> <li><strong>Cordón</strong> ultra sexy y provocativo<strong>en los glúteos</strong> </li> <li><strong>Realza los glúteos</strong> de forma espectacular</li> <li><strong>Encaje elástico</strong> resistente y de alta calidad</li> <li><strong>Corte alto</strong> que realza la silueta</li> <li><strong>Diseño</strong> atemporal y sexy<strong>en negro</strong> </li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBragas de talla grande con sexy lazada en las nalgas. Sujeción del vientre, corte alto, encaje de calidad. Negro provocativo. Entrega rápida. Diva's Boudoir.
keywords
string
title
stringEscante calzoncillos talla grande cordón nalgas | Diva's Boudoir
seotitle
stringEscante talla grande calzoncillos encaje nalgas soporte barriga
seouri
stringtalla-grande-bragas-escante-encaje-nalgas
specifications
string<ul> <li><strong>Material:</strong> Encaje elástico de alta calidad (92% poliamida, 8% elastán)</li> <li><strong>Color:</strong> Negro</li> <li><strong>Estilo:</strong> Braguita de talle alto con lazada en el culote</li> <li><strong>Sujeción:</strong> Corte alto para sujetar el vientre</li> <li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li> </ul>
stylingtips
string<p>La braguita Escante, con sus <strong>provocativos lazos</strong>, se sostiene por sí sola para crear un look increíblemente sexy. Para un conjunto perfecto, combínalas con piezas que amplíen su efecto escultural. Esta creación negra revela tu audacia y sensualidad desenfrenada. Completa tu silueta con nuestros <a href="https://www.divasboudoir.com/es/medias-abiertos-curvys/">tirantes de sujetador</a> para una sujeción perfecta del escote, o descubre nuestros <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para una seducción gradual que culminará con el descubrimiento de estas bragas terriblemente excitantes.</p>
summary
string<p>Descubre las braguitas Escante, <strong>magníficamente diseñadas</strong> para sujetar tu vientre y realzar tus nalgas.</p> <p>El <strong>cordón en las nalgas</strong> y el <strong>corte alto</strong> crean una silueta irresistible.</p>
title
stringBraga Escante : Lazada sexy y sujeción perfecta
usageinstructions
string<p>Las braguitas Escante son perfectas para esos momentos en los que quieres combinar <strong>una sujeción óptima</strong> con una seducción provocativa. El corte alto sujeta suavemente el vientre a la vez que muestra tus nalgas con un efecto espectacular.</p> <p>El <strong>cordón en las nalgas</strong> permite un ajuste personalizado a la vez que crea un efecto visual terriblemente sexy. Llévalo con confianza para revelar tu lado más atrevido y causar sensación con cada look.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage d&eacute;licat &agrave; la main &agrave; l'eau ti&egrave;de (30&deg;C maximum)</li> <li>Utiliser une lessive douce sans agents blanchissants</li> <li>S&eacute;chage &agrave; plat &agrave; l'abri de la lumi&egrave;re directe</li> <li>Ne pas tirer sur le la&ccedil;age lors du lavage</li> </ul>
description
string<p>La culotte Escante r&eacute;v&egrave;le toute sa beaut&eacute; dans sa conception <strong>superbement pens&eacute;e</strong> pour sublimer vos courbes g&eacute;n&eacute;reuses.</p> <p>Sa&nbsp;<strong>coupe haute</strong> maintient parfaitement le ventre tout en cr&eacute;ant une silhouette sculpt&eacute;e qui ne laisse personne indiff&eacute;rent. Le v&eacute;ritable atout d'Escante r&eacute;side dans son <strong>la&ccedil;age sur les fesses</strong> qui transforme chaque mouvement en invitation &agrave; la s&eacute;duction.</p> <p>Cette cr&eacute;ation met vos fesses en valeur de fa&ccedil;on spectaculaire, cr&eacute;ant un effet visuel saisissant qui r&eacute;v&egrave;le votre audace assum&eacute;e. Sa&nbsp;<strong>dentelle &eacute;lastique solide</strong> garantit une qualit&eacute; sup&eacute;rieure qui r&eacute;siste au temps tout en &eacute;pousant parfaitement vos formes. Chaque d&eacute;tail a &eacute;t&eacute; pens&eacute; pour cr&eacute;er une culotte qui allie maintien optimal et s&eacute;duction provocante.</p> <p>Cette pi&egrave;ce noire intemporelle transforme chaque jour en occasion de vous sentir irr&eacute;sistiblement sexy et confiante, r&eacute;v&eacute;lant votre sensualit&eacute; la plus authentique.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-escante-grande-taille-lacage-fesses/sbga9101.htm
highlights
string<ul> <li><strong>Maintien du ventre</strong> gr&acirc;ce &agrave; sa coupe haute sculptante</li> <li><strong>La&ccedil;age sur les fesses</strong> ultra sexy et provocant</li> <li><strong>Met les fesses en valeur</strong> de fa&ccedil;on spectaculaire</li> <li><strong>Dentelle &eacute;lastique</strong> solide et de qualit&eacute; sup&eacute;rieure</li> <li><strong>Coupe haute</strong> qui sublime la silhouette</li> <li><strong>Design noir</strong> intemporel et terriblement sexy</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte Escante grande taille avec laçage sexy sur les fesses. Maintien ventre, coupe haute, dentelle qualité. Noir provocant. Livraison rapide. Diva's Boudoir.
keywords
string
title
stringCulotte Escante grande taille laçage fesses | Diva's Boudoir
seotitle
stringCulotte haute grande taille Escante laçage fesses maintien ventre
seouri
stringculotte-escante-grande-taille-lacage-fesses
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Dentelle &eacute;lastique de qualit&eacute; sup&eacute;rieure (92% polyamide, 8% &eacute;lasthanne)</li> <li><strong>Couleur :</strong> Noir</li> <li><strong>Style :</strong> Culotte haute avec la&ccedil;age fesses</li> <li><strong>Maintien :</strong> Ventre maintenu par la coupe haute</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat &agrave; la main recommand&eacute;</li> </ul>
stylingtips
string<p>La culotte Escante avec son <strong>la&ccedil;age provocant</strong> se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look terriblement sexy. Pour un ensemble parfait, associez-la &agrave; des pi&egrave;ces qui prolongent son effet sculptant. Cette cr&eacute;ation noire r&eacute;v&egrave;le votre audace et votre sensualit&eacute; d&eacute;brid&eacute;e. Compl&eacute;tez votre silhouette avec nos <a href="https://www.divasboudoir.com/fr/redresse-seins-grande-taille/">redresse-seins</a> pour un maintien parfait du d&eacute;collet&eacute;, ou d&eacute;couvrez nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;s</a>&nbsp;pour une s&eacute;duction progressive qui culminera avec la d&eacute;couverte de cette culotte terriblement excitante.</p>
summary
string<p>D&eacute;couvrez la culotte Escante, <strong>superbement con&ccedil;ue</strong> pour maintenir le ventre et mettre vos fesses en valeur.</p> <p>Son&nbsp;<strong>la&ccedil;age sur les fesses</strong> et sa <strong>coupe haute</strong> cr&eacute;ent une silhouette irr&eacute;sistible.</p>
title
stringCulotte Escante : Laçage Sexy et Maintien Parfait
usageinstructions
string<p>La culotte Escante est parfaite pour les moments o&ugrave; vous souhaitez allier <strong>maintien optimal</strong> et s&eacute;duction provocante. Sa coupe haute maintient d&eacute;licatement le ventre tout en mettant spectaculairement vos fesses en valeur.</p> <p>Le&nbsp;<strong>la&ccedil;age sur les fesses</strong> permet un ajustement personnalis&eacute; tout en cr&eacute;ant un effet visuel terriblement sexy. Portez-la avec assurance pour r&eacute;v&eacute;ler votre c&ocirc;t&eacute; le plus audacieux et faire sensation &agrave; chaque regard.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare delicatamente a mano in acqua tiepida (massimo 30&deg;C)</li> <li>Utilizzare un detergente delicato senza agenti sbiancanti</li> <li>Asciugare in piano lontano dalla luce diretta</li> <li>Non tirare l'allacciatura durante il lavaggio</li> </ul>
description
string<p>La mutandina Escante rivela tutta la sua bellezza in un design <strong>superbamente pensato</strong> per esaltare le vostre curve generose.</p> <p>Il suo <strong>taglio alto</strong> sostiene perfettamente la pancia e crea una silhouette scolpita che non lascia indifferenti. Il vero punto di forza di Escante &egrave; l'<strong>allacciatura sui glutei</strong>, che trasforma ogni movimento in un invito alla seduzione.</p> <p>Questo design mette in risalto i glutei, creando un effetto visivo sorprendente che rivela la vostra audacia. Il <strong>solido pizzo elastico</strong> garantisce una qualit&agrave; superiore che resiste alla prova del tempo, modellandosi perfettamente alle vostre forme. Ogni dettaglio &egrave; stato pensato per creare un panty che unisce un sostegno ottimale a una seduzione provocante.</p> <p>Questo intramontabile capo nero trasforma ogni giorno in un'occasione per sentirsi irresistibilmente sexy e sicure di s&eacute;, rivelando la propria sensualit&agrave; pi&ugrave; autentica.</p>
guid
stringhttps://dev.divasboudoir.com/it/mutandine-escante-di-taglia-grande-con-lacci-sui-glutei/sbga9101.htm
highlights
string<ul> <li>Taglio alto scolpente<strong>per sostenere la pancia</strong></li> <li><strong>Allacciatura</strong> ultra sexy e provocante<strong>sui glutei</strong></li> <li><strong>Valorizza</strong> drasticamente<strong>i glutei</strong></li> <li><strong>Pizzo elastico</strong> forte e di alta qualit&agrave;</li> <li><strong>Taglio alto</strong> che valorizza la figura</li> <li><strong>Design nero</strong> sexy e senza tempo</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMutandine Escante di grande taglia con allacciatura sexy sui glutei. Sostegno per il ventre, taglio alto, pizzo di qualità. Nero provocante. Consegna rapida. Diva's Boudoir.
keywords
string
title
stringSlip Escante taglia grande allacciatura glutei | Diva's Boudoir
seotitle
stringEscante slip a vita alta grande con lacci per il sostegno dei glutei e della pancia
seouri
stringmutandine-escante-di-taglia-grande-con-lacci-sui-glutei
specifications
string<ul> <li><strong>Materiale:</strong> pizzo elastico di alta qualit&agrave; (92% poliammide, 8% elastan)</li> <li><strong>Colore:</strong> nero</li> <li><strong>Stile:</strong> mutandina a vita alta con sedere allacciato</li> <li><strong>Sostegno:</strong> Taglio alto per sostenere la pancia</li> <li><strong>Cura:</strong> Si consiglia un lavaggio delicato a mano</li> </ul>
stylingtips
string<p>Le mutandine Escante, con la loro <strong>provocante allacciatura</strong>, sono in grado di creare da sole un look incredibilmente sexy. Per un insieme perfetto, abbinatele a capi che ne prolunghino l'effetto scultoreo. Questa creazione nera rivela la vostra audacia e la vostra sensualit&agrave; sfrenata. Completate la vostra silhouette con i nostri <a href="https://www.divasboudoir.com/it/reggiseni-di-grandi-dimensioni/">reggiseni</a> per un perfetto sostegno del d&eacute;collet&eacute;, oppure scoprite i nostri <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">neglig&eacute;</a> per una seduzione graduale che culminer&agrave; con la scoperta di queste mutandine terribilmente eccitanti.</p>
summary
string<p>Scoprite le mutandine Escante, <strong>superbamente progettate</strong> per sostenere la pancia e valorizzare il sedere.</p> <p>L'<strong>allacciatura sui glutei</strong> e il <strong>taglio alto</strong> creano una silhouette irresistibile.</p>
title
stringMutandine Escante : Allacciatura sexy e sostegno perfetto
usageinstructions
string<p>Le mutandine Escante sono perfette per i momenti in cui si desidera combinare un <strong>sostegno ottimale</strong> con una seduzione provocante. Il taglio alto sostiene delicatamente la pancia e mette in mostra i glutei con un effetto spettacolare.</p> <p>L'<strong>allacciatura sui glutei</strong> consente una vestibilit&agrave; personalizzata e crea un effetto visivo terribilmente sexy. Indossatelo con disinvoltura per rivelare il vostro lato pi&ugrave; audace e fare una dichiarazione con ogni look.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Voorzichtig met de hand wassen in lauw water (maximaal 30&deg;C)</li> <li>Gebruik een mild wasmiddel zonder bleekmiddelen</li> <li>Plat drogen uit de buurt van direct licht</li> <li>Niet aan de veters trekken tijdens het wassen</li> </ul>
description
string<p>De Escante panty onthult al haar schoonheid in een ontwerp <strong>dat perfect is uitgedacht</strong> om je royale rondingen te benadrukken.</p> <p>De <strong>hoge snit</strong> ondersteunt de buik perfect en cre&euml;ert een gebeeldhouwd silhouet dat niemand onverschillig laat. De echte troef van Escante is de <strong>vetersluiting op de billen</strong>, die van elke beweging een uitnodiging tot verleiding maakt.</p> <p>Dit ontwerp pronkt op spectaculaire wijze met je billen en cre&euml;ert een opvallend visueel effect dat je gedurfde houding onthult. De <strong>stevige elastische kant</strong> garandeert superieure kwaliteit die de tand des tijds zal doorstaan en zich perfect naar je vorm zal vormen. Over elk detail is nagedacht om een panty te cre&euml;ren die optimale ondersteuning combineert met provocerende verleiding.</p> <p>Dit tijdloze zwarte model maakt van elke dag een kans om je onweerstaanbaar sexy en zelfverzekerd te voelen en je meest authentieke sensualiteit te onthullen.</p>
guid
stringhttps://dev.divasboudoir.com/nl/grote-maat-escante-slip-kanten-billen/sbga9101.htm
highlights
string<ul> <li>Sculpting hoge snit<strong>voor ondersteuning van de buik</strong></li> <li>Uiterst sexy en uitdagende<strong>vetersluiting op de billen</strong></li> <li>Dramatische<strong>verbetering van de billen</strong></li> <li>Sterk, hoogwaardig<strong>elastisch kant</strong></li> <li><strong>Hoge snit</strong> die het figuur verbetert</li> <li>Tijdloos, sexy<strong>zwart ontwerp</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote maat Escante slip met sexy vetersluiting op de billen. Ondersteuning voor de buik, hoge snit, kwaliteitskant. Provocerend zwart. Snelle levering. Diva's Boudoir.
keywords
string
title
stringEscante slip grote maat vetersluiting billen | Diva's Boudoir
seotitle
stringEscante grote maat slip met lace-up billen buik ondersteuning
seouri
stringgrote-maat-escante-slip-kanten-billen
specifications
string<ul> <li><strong>Materiaal:</strong> Hoogwaardig elastisch kant (92% polyamide, 8% elastaan)</li> <li><strong>Kleur:</strong> Zwart</li> <li><strong>Stijl:</strong> Hoog uitgesneden slip met kanten bips</li> <li><strong>Ondersteuning:</strong> Hoog model ter ondersteuning van de buik</li> <li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li> </ul>
stylingtips
string<p>De Escante onderbroek, met zijn <strong>provocerende vetersluiting</strong>, staat op zichzelf en cre&euml;ert een ongelooflijk sexy look. Voor het perfecte ensemble combineer je ze met stukken die hun sculpturale effect verlengen. Deze zwarte creatie onthult je durf en ongebreidelde sensualiteit. Maak je silhouet compleet met onze <a href="https://www.divasboudoir.com/nl/grote-maat-borstvergroter/">bh-bandjes</a> voor een perfecte ondersteuning van je decollet&eacute;, of ontdek onze <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">neglig&eacute;s</a> voor een geleidelijke verleiding die zal culmineren in de ontdekking van deze vreselijk opwindende slips.</p>
summary
string<p>Ontdek de Escante slips, <strong>prachtig ontworpen</strong> om je buik te ondersteunen en je billen te verbeteren.</p> <p>De <strong>vetersluiting op de billen</strong> en de <strong>hoge snit</strong> zorgen voor een onweerstaanbaar silhouet.</p>
title
stringEscante Slipje : Sexy vetersluiting en perfecte ondersteuning
usageinstructions
string<p>Escante slips zijn perfect voor die momenten waarop je <strong>optimale ondersteuning</strong> wilt combineren met uitdagende verleiding. De hoge snit ondersteunt zachtjes de buik en laat je billen zien met een spectaculair effect.</p> <p>De <strong>vetersluiting op de billen</strong> zorgt voor een persoonlijke pasvorm en een vreselijk sexy visueel effect. Draag het met vertrouwen om je van je meest gewaagde kant te laten zien en maak een statement bij elke look.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar suavemente &agrave; m&atilde;o em &aacute;gua morna (30&deg;C no m&aacute;ximo)</li> <li>Utilizar um detergente suave sem agentes branqueadores</li> <li>Secar ao ar livre, longe da luz direta</li> <li>N&atilde;o puxar o cord&atilde;o durante a lavagem</li> </ul>
description
string<p>A calcinha Escante revela toda a sua beleza num design <strong>soberbamente pensado</strong> para real&ccedil;ar as suas curvas generosas.</p> <p>O <strong>corte alto</strong> sustenta perfeitamente a barriga, criando uma silhueta esculpida que n&atilde;o deixa ningu&eacute;m indiferente. O verdadeiro trunfo de Escante &eacute; o <strong>la&ccedil;o nas n&aacute;degas</strong>, que transforma cada movimento num convite &agrave; sedu&ccedil;&atilde;o.</p> <p>Este design real&ccedil;a dramaticamente as suas n&aacute;degas, criando um efeito visual marcante que revela a sua ousadia. A sua <strong>renda el&aacute;stica s&oacute;lida</strong> garante uma qualidade superior que resiste ao tempo, adaptando-se perfeitamente &agrave; sua forma. Todos os detalhes foram pensados para criar uma cueca que combina um suporte &oacute;timo com uma sedu&ccedil;&atilde;o provocante.</p> <p>Esta pe&ccedil;a preta intemporal transforma cada dia numa oportunidade para se sentir irresistivelmente sexy e confiante, revelando a sua sensualidade mais aut&ecirc;ntica.</p>
guid
stringhttps://dev.divasboudoir.com/pt/cuecas-escanteadas-grandes-com-renda-para-as-nadegas/sbga9101.htm
highlights
string<ul> <li>Corte alto esculpido<strong>para apoio da barriga</strong></li> <li><strong>La&ccedil;o</strong> ultra sexy e provocante<strong>nas n&aacute;degas</strong></li> <li><strong>Real&ccedil;a</strong> dramaticamente<strong>as n&aacute;degas</strong></li> <li><strong>Renda el&aacute;stica</strong> forte e de alta qualidade</li> <li><strong>Corte alto</strong> que real&ccedil;a a figura</li> <li><strong>Design</strong> intemporal e sexy<strong>em preto</strong></li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCalcinhas Escante grandes com laço sexy nas nádegas. Apoio para a barriga, corte alto, renda de qualidade. Preto provocante. Entrega rápida. Diva's Boudoir.
keywords
string
title
stringCuecas Escante tamanho grande com laço para as nádegas | Diva's Boudoir
seotitle
stringEscante cuecas grandes de cintura alta com cordões para apoiar as nádegas e a barriga
seouri
stringcuecas-escanteadas-grandes-com-renda-para-as-nadegas
specifications
string<ul> <li><strong>Material:</strong> Renda el&aacute;stica de alta qualidade (92% poliamida, 8% elastano)</li> <li><strong>Cor:</strong> Preto</li> <li><strong>Estilo:</strong> Cuecas de cintura subida com rabo de renda</li> <li><strong>Apoio:</strong> Corte alto para apoiar a barriga</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada &agrave; m&atilde;o</li> </ul>
stylingtips
string<p>As cuecas Escante, com o seu <strong>la&ccedil;o provocante</strong>, s&atilde;o aut&oacute;nomas para criar um visual incrivelmente sexy. Para um conjunto perfeito, combine-as com pe&ccedil;as que aumentem o seu efeito escultural. Esta cria&ccedil;&atilde;o preta revela a sua aud&aacute;cia e sensualidade desenfreada. Complete a sua silhueta com os nossos soutiens <a href="https://www.divasboudoir.com/pt/sutias-abertos-curvys/">de al&ccedil;as</a> para um apoio perfeito do decote, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees</a> para uma sedu&ccedil;&atilde;o gradual que culminar&aacute; na descoberta destas cuecas terrivelmente excitantes.</p>
summary
string<p>Descubra as cuecas Escante, <strong>concebidas de forma soberba</strong> para sustentar a sua barriga e real&ccedil;ar o seu traseiro.</p> <p>O <strong>la&ccedil;o nas n&aacute;degas</strong> e o <strong>corte alto</strong> criam uma silhueta irresist&iacute;vel.</p>
title
stringCalcinhas Escante : Laço sexy e suporte perfeito
usageinstructions
string<p>As cuecas Escante s&atilde;o perfeitas para aqueles momentos em que se quer combinar <strong>um apoio &oacute;timo</strong> com uma sedu&ccedil;&atilde;o provocante. O corte alto sustenta suavemente a barriga enquanto mostra as suas n&aacute;degas com um efeito espetacular.</p> <p>O <strong>la&ccedil;o nas n&aacute;degas</strong> permite um ajuste personalizado, criando um efeito visual extremamente sexy. Use-o com confian&ccedil;a para revelar o seu lado mais ousado e fazer uma declara&ccedil;&atilde;o em cada look.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string<p>La culotte Escante r&eacute;v&egrave;le toute sa beaut&eacute; dans sa conception <strong>superbement pens&eacute;e</strong> pour sculpter votre silhouette avec &eacute;l&eacute;gance. Sa <strong>coupe haute</strong> offre un maintien d&eacute;licat du ventre tout en cr&eacute;ant une ligne &eacute;pur&eacute;e qui met en valeur vos courbes naturelles. Le v&eacute;ritable atout d'Escante r&eacute;side dans son <strong>la&ccedil;age sur les fesses</strong> qui apporte une touche de sophistication raffin&eacute;e.</p> <p>Ce d&eacute;tail subtil transforme chaque mouvement en une expression de gr&acirc;ce et de sensualit&eacute;. Sa&nbsp;<strong>dentelle &eacute;lastique de qualit&eacute; sup&eacute;rieure</strong> garantit un confort optimal tout en conservant une finition impeccable. Chaque d&eacute;tail a &eacute;t&eacute; pens&eacute; pour cr&eacute;er une culotte qui allie raffinement technique et &eacute;l&eacute;gance naturelle.</p>
highlights
string<ul> <li><strong>Maintien du ventre</strong> gr&acirc;ce &agrave; sa coupe haute structurante</li> <li><strong>La&ccedil;age sur les fesses</strong> &eacute;l&eacute;gant et raffin&eacute;</li> <li><strong>Coupe qui souligne la silhouette</strong> avec sophistication</li> <li><strong>Dentelle &eacute;lastique</strong> de qualit&eacute; sup&eacute;rieure</li> <li><strong>Finitions soign&eacute;es</strong> avec d&eacute;tails raffin&eacute;s</li> <li><strong>Design noir</strong> intemporel et chic</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte Escante avec laçage fesses et maintien ventre. Coupe haute sophistiquée, noir élégant. Confort et raffinement chez Leg's Boudoir. Grande Taille.
keywords
string
title
stringCulotte grande taille Escante Laçage Élégant | Leg's Boudoir
seotitle
stringCulotte grande taille haute laçage fesses maintien ventre
seouri
stringculotte-grande-taille-escante-laçage-fesses
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Dentelle &eacute;lastique de qualit&eacute; (92% polyamide, 8% &eacute;lasthanne)</li> <li><strong>Couleur :</strong> Noir</li> <li><strong>Style :</strong> Culotte haute avec la&ccedil;age fesses</li> <li><strong>Finition :</strong> D&eacute;tails soign&eacute;s, la&ccedil;age d&eacute;licat</li> </ul>
stylingtips
string<p>La culotte Escante se distingue par son <strong>la&ccedil;age raffin&eacute;</strong> qui cr&eacute;e un style sophistiqu&eacute;. Pour une harmonie parfaite, associez-la &agrave; des pi&egrave;ces qui prolongeront son &eacute;l&eacute;gance. Compl&eacute;tez votre look&nbsp;&nbsp;nos <a href="https://www.legsboudoir.com/fr/bas-et-bas-autofixants/">bas</a> et <a href="https://www.legsboudoir.com/fr/bas-et-bas-autofixants-grande-taille/">bas grande taille</a> qui sublimeront votre ensemble.</p>
summary
string<p>D&eacute;couvrez la culotte Escante, <strong>superbement con&ccedil;ue</strong> pour sculpter votre silhouette.</p> <p>Son&nbsp;<strong>la&ccedil;age sur les fesses</strong> et sa <strong>coupe haute</strong> cr&eacute;ent une ligne &eacute;l&eacute;gante qui met en valeur vos courbes.</p>
title
stringCulotte Escante : Élégance et Maintien Sculptant
usageinstructions
string<p>La culotte Escante est con&ccedil;ue pour offrir un <strong>maintien &eacute;l&eacute;gant</strong>. Son la&ccedil;age arri&egrave;re permet un ajustement personnalis&eacute; qui met en valeur votre silhouette avec subtilit&eacute;. Portez-la avec assurance, laissant chaque d&eacute;tail r&eacute;v&eacute;ler votre sophistication naturelle.</p>
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
string5139
netweight
string
nextshipment
stringtoday
ordered
number97
orderidx
number0
origin
string
originalsize
string
packaging
number1
productshipment
stringauto
productuid
string9A9A21A3-C6E2-4B98-8C19771AD27F1354
promountil
string
rating
stringnone
recorduid
string9A9A21A3-C6E2-4B98-8C19771AD27F1354
reference
stringSBGA9101
related
string
reserved
number5
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.68 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype,
product_variations.color,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED ))
,
SUBSTRING_INDEX(intlsize,'-',1)
) as param1,
if(product_sizes.sizegroup = 'bra',
if(intlsize <> '',
MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)),
MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize))
)
,
SUBSTRING_INDEX(intlsize,'-',-1)
) as param2,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
999999,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as groupavailable,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize,
product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight
from product_sizes
left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_sizes.id_size,'1093,1137,1136,1888') > 0
and product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and intlsize <> 'na'
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_sizes.id_size, product_variations.color
order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
recorduidsizesizetypecolorparam1param2availablegroupavailablestockgendersizerangesizegroupsuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizebustwaisthipunderbustcupthighlegheightbodyheightbodyweight
1109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2113744-46intlsizeblack4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
3113648-50intlsizeblack4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
sizeranges
stringplus,standard
sizes
string1093,1137,1136,1888
sizetype
stringauto
specifications
Struct
Entries: 23
belly
string
bones
string
bra
string
breasts
string
bust
string
closing
string
crochtless
string
cups
string
cut
string
garter
string
halter
string
lacing
string
lining
string
modestypanel
string
panty
string
sheathing
string
sleeves
string
stocking
string
straps
string
stretch
string
suspenders
string
transparency
string
underwires
string
stock
number0
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 6.62 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
UNION
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
and product_stocks.stockuid = 'STOCK01'
GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid
) tbl
group by productuid, variationuid, stockuid
order by stockuid, FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
productuidvariationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockdisplaycomments
19A9A21A3-C6E2-4B98-8C19771AD27F1354AB6390A7-F2AD-45B1-93192B4AE6BEA4691093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize20.791714.9583STOCK01000-12400P5139-1PP5139-1P1115-10all
29A9A21A3-C6E2-4B98-8C19771AD27F13547EFE6C6E-B929-4D3E-8FBABA213E6D66E11137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize20.791714.9583STOCK01000-103600P5139-1PP5139-1P1117-10all
39A9A21A3-C6E2-4B98-8C19771AD27F13540622BD96-A5B9-4337-8706F92EAB8823B81136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize20.791714.9583STOCK01001-135700P5139-1PP5139-1P1119-10all
subcategory
stringsexypanty
supplier
number-1
supplierreference
string5139
tags
string
themes
stringsexystrings
totalvariations
number4
type
stringdefault
unitprice
number14.9583
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 10.1 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1093
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1137
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1136
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
UNION
select product_variations.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
(if(
(select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size and b.supplier < 0) > 0,
-1,
(select
sum(distinct if(b.supplier >= 0,b.supplier,0)) +
if((sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved))>=0,sum(bb.warehouse)+sum(bb.packaging)-sum(bb.reserved),0)
from product_variations b left outer join product_stocks bb on bb.productuid = b.productuid and bb.variationuid = b.variationuid and bb.stockuid = 'STOCK01'
where b.isactive = 1 and b.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and b.size = product_variations.size)
)) as availablepersize,
(
select if((sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved))>=0,sum(cc.warehouse)+sum(cc.packaging)-sum(cc.reserved),0)
from product_variations c left outer join product_stocks cc on cc.productuid = c.productuid and cc.variationuid = c.variationuid and cc.stockuid = 'STOCK01'
where c.isactive = 1 and c.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and c.size = product_variations.size
) as stockpersize,
(if(
(select count(distinct d.variationuid) from product_variations d where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color and d.supplier < 0) > 0,
-1,
(select sum(distinct if(d.supplier >= 0,d.supplier,0)) +
if((sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved))>=0,sum(dd.warehouse)+sum(dd.packaging)-sum(dd.reserved),0)
from product_variations d left outer join product_stocks dd on dd.productuid = d.productuid and dd.variationuid = d.variationuid and dd.stockuid = 'STOCK01'
where d.isactive = 1 and d.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and d.color = product_variations.color)
)) as availablepercolor,
(
select if((sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved))>=0,sum(ee.warehouse)+sum(ee.packaging)-sum(ee.reserved),0)
from product_variations e left outer join product_stocks ee on ee.productuid = e.productuid and ee.variationuid = e.variationuid and ee.stockuid = 'STOCK01'
where e.isactive = 1 and e.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354' and e.color = product_variations.color
) as stockpercolor,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),1,0) as haspromo,
if((product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null)),product_variations.itempromo,product_variations.itemprice) as unitprice,
'all' as display,
product_variations.comments
from product_variations
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_variations.productuid = '9A9A21A3-C6E2-4B98-8C19771AD27F1354'
and product_variations.isactive = 1
and product_sizes.id_size = 1888
and FIND_IN_SET(product_sizes.sizerange,"all,plus")
group by product_variations.variationuid
order by FIELD(gender,'w','m'), sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), color
variationuidrecorduidcolorhexvaluesuppliersizeintlsizeincheseusizeussizeuksizefrsizeessizedesizeitsizeptsizeelsizegendersizegroupcupsizesizetypeitempriceitempromopromoUntilstockuidwarehouseontourpackagingsupplierreservedorderedreturneddefectmanufacturerreferenceeanavailablestockavailablepersizestockpersizeavailablepercolorstockpercolorhaspromounitpricedisplaycomments
1AB6390A7-F2AD-45B1-93192B4AE6BEA4691093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize20.791714.9583STOCK01000-12400P5139-1PP5139-1P1115-10-10-10114.9583all
27EFE6C6E-B929-4D3E-8FBABA213E6D66E11137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize20.791714.9583STOCK01000-103600P5139-1PP5139-1P1117-10-10-10114.9583all
30622BD96-A5B9-4337-8706F92EAB8823B81136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize20.791714.9583STOCK01001-135700P5139-1PP5139-1P1119-10-10-10114.9583all
vatrate
number20
warehouse
number0