Mon panier

❌
Total articles
Voir le panier
Menu
Voir les tailles
Culotte Criss Cross : Laçage Sexy et Confort Absolu
Double-cliquez pour agrandir
SKU: SBGA8281
Culotte Criss Cross : Laçage Sexy et Confort Absolu
Promo
Stock:

Découvrez la culotte Criss Cross, confortable et sexy qui ne boudine absolument pas grâce à ses belles tailles.

Son laçage sur les hanches et sa coupe brésilienne créent une silhouette parfaitement sculptée.

Points forts

  • Ne boudine absolument pas grâce à ses belles tailles
  • Laçage sexy sur les hanches ultra provocant
  • Coupe brésilienne qui met les fesses en valeur
  • Monte sur le ventre pour un maintien parfait
  • Dentelle de qualité confortable toute la journée
  • Trois couleurs : noir, rouge et blanc
Taille:

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

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

Culotte grande taille Criss Cross dentelle laçage hanches

Description du produit

La culotte Criss Cross a tout pour plaire avec sa conception pensée pour ne jamais boudiner. Ses belles tailles s'adaptent parfaitement à vos courbes généreuses, créant une silhouette sculptée sans aucune contrainte.

Son laçage sur les hanches transforme chaque mouvement en invitation à la séduction, tandis que sa coupe brésilienne révèle et met magnifiquement en valeur vos fesses. Cette culotte qui monte sur le ventre offre un maintien optimal tout en conservant ce côté terriblement sexy.

La dentelle de qualité épouse délicatement votre peau pour un confort absolu qui vous accompagne toute la journée. Disponible en trois couleurs incontournables - noir mystérieux, rouge passion et blanc provocant - chaque version révèle une facette différente de votre sensualité. Cette création allie parfaitement confort et provocation, transformant chaque jour en occasion de vous sentir irrésistiblement sexy et confiante.

Détails techniques

  • Matière : Dentelle extensible (92% polyamide, 8% élasthanne)
  • Couleurs : Noir, Rouge, Blanc
  • Style : Culotte avec laçage hanches et coupe brésilienne
  • Coupe : Brésilienne sur les fesses, monte sur le ventre
  • Entretien : Lavage délicat à la main recommandé

Tailles disponibles

Disponible du 38-40 au 50-52

Couleurs disponibles

Noir , Rouge et Blanc

Autres caractéristiques techniques

Matière Dentelle élastique

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
46-48
  • 100-110
  • 82-96
  • 106-116
48-50
  • 110-116
  • 96-102
  • 116-122
50-52
  • 116-126
  • 102-110
  • 122-132

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

Conseils d'utilisation

La culotte Criss Cross est parfaite pour toutes les occasions où vous souhaitez allier confort absolu et séduction. Sa conception qui ne boudine pas garantit un port agréable toute la journée sans aucune gêne.

Le laçage sur les hanches permet un ajustement personnalisé tout en créant un effet visuel terriblement sexy. Portez-la avec assurance, sachant que sa coupe parfaite sublimera vos courbes sans jamais les comprimer.

Conseils de style

La culotte Criss Cross avec son laçage provocant se suffit à elle-même pour créer un look terriblement sexy.

Pour amplifier l'effet de séduction, associez-la à des pièces qui révèlent subtilement sa présence. Le coloris noir apporte une sensualité intemporelle, le rouge révèle une passion ardente, tandis que le blanc joue sur l'innocence provocante.

Complétez votre look avec nos strings sexyspour varier les plaisirs, ou ajoutez un kimonos 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
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: 0.785 ms
Record Count: 3
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,red,white') > 0
and product_variations.productuid = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-10
2redcolorredredred#F50000-10
3whitecolorwhitwhitewhite#FFFFFF-10
colorrange
stringblack
colors
stringblack,red,white
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 '2020-02-10 17:15:36'}
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
booleantrue
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number9
instockvariations
string
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number16.625
itempromo
number11.625
key
stringblack-plus-size-sexy-high-waist-floral-lace-strappy-panty-p5124-1p
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:46:54'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.707 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('952f4d3d-c960-4c3a-b0293edd79b2b08a',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.32 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 <> 'SBGA8281'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
stringstretchlace
mediadatas
Struct
alt
Struct
height
string1962
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_blanc.jpg
type
stringimg
width
string1357
back
Struct
height
string1843
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_rouge.jpg
type
stringimg
width
string1312
default
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_noir.jpg
type
stringimg
width
string1312
variations
Struct
colors
Struct
black
Struct
height
string1897
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_noir_editorial.jpg
type
stringimg
width
string1312
red
Struct
height
string1843
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_rouge.jpg
type
stringimg
width
string1312
white
Struct
height
string1962
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga8281/culotte_grande_taille_lacage_blanc.jpg
type
stringimg
width
string1357
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
description
string<p>Der Criss Cross Slip hat alles, was man sich wünschen kann, mit seinem Design, das so konzipiert ist, dass es niemals beult. Die <strong>schönen Taillen</strong> passen sich perfekt an Ihre üppigen Kurven an und schaffen eine wohlgeformte Silhouette ohne Einschränkungen.</p> <p>Die <strong>Schnürung an den Hüften</strong> verwandelt jede Bewegung in eine Einladung zur Verführung, während der <strong>brasilianische Schnitt</strong> Ihren Po enthüllt und wunderschön betont. Dieser <strong>bauchfreie</strong> Slip bietet optimalen Halt, ohne dabei an Sexyness zu verlieren.</p> <p>Die <strong>hochwertige Spitze</strong> schmiegt sich sanft an Ihre Haut und sorgt für absoluten Komfort, der Sie den ganzen Tag über begleitet. Erhältlich in drei unverzichtbaren Farben - geheimnisvolles Schwarz, leidenschaftliches Rot und provokatives Weiß - zeigt jede Version eine andere Facette Ihrer Sinnlichkeit. Diese Kreation ist die perfekte Kombination aus <strong>Komfort und Provokation</strong> und verwandelt jeden Tag in eine Gelegenheit, sich unwiderstehlich sexy und selbstbewusst zu fühlen.</p>
guid
stringhttps://dev.divasboudoir.com/de/criss-cross-slip,-grosse-grossen-schwarz-schwarz/sbga8281.htm
highlights
string<ul> <li>Dank der schönen Taillen<strong>absolut nicht beult</strong> </li> <li><strong>Sexy Schnürung</strong> an den Hüften ultra provokativ</li> <li><strong>Brasilianischer Schnitt</strong>, der den Po betont</li> <li>Rutscht<strong>am Bauch hoch</strong> für einen perfekten Sitz</li> <li><strong>Hochwertige Spitze, die</strong> den ganzen Tag über bequem ist</li> <li><strong>Drei Farben</strong>: Schwarz, Rot und Weiß</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCriss Cross Slip in großen Größen aus Spitze mit Hüftschnürung. Nicht bauschen, brasilianischer Schnitt. 3 sexy Farben. Diva's Boudoir Lingerie.
keywords
string
title
stringCriss Cross Slip große Größe mit Schnürung | Diva's Boudoir
seotitle
stringSlip große Größen Criss Cross Spitze Schnürung Hüften
seouri
stringcriss-cross-slip,-grosse-grossen-schwarz-schwarz
specifications
string<ul> <li><strong>Material:</strong> Stretchige Spitze (92% Polyamid, 8% Elasthan)</li> <li><strong>Farben:</strong> Schwarz, Rot, Weiß</li> <li><strong>Stil:</strong> Höschen mit Hüftschnürung und brasilianischem Schnitt</li> <li><strong>Schnitt:</strong> Brasilianisch am Gesäß, steigt am Bauch an</li> <li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li> </ul>
stylingtips
string<p>Der Criss Cross Slip mit seiner <strong>aufreizenden Schnürung</strong> ist schon für sich allein genommen ein unglaublich sexy Look.</p> <p>Um den verführerischen Effekt noch zu verstärken, kombinieren Sie es mit Teilen, die seine Präsenz subtil offenbaren. <strong>Schwarz</strong> verleiht zeitlose Sinnlichkeit, <strong>Rot</strong> steht für feurige Leidenschaft und <strong>Weiß</strong> für provokative Unschuld.</p> <p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/string-in-ubergrosse/">sexy Strings, um</a>das Vergnügen zu variieren, oder fügen Sie einen <a href="https://www.divasboudoir.com/de/kimonos-in-grossen-grossen/">Kimono</a> für eine schrittweise Verführung hinzu, die mit der Entdeckung dieses schrecklich aufregenden Slips ihren Höhepunkt erreicht.</p>
summary
string<p>Entdecken Sie den <strong>bequemen und sexy</strong> Criss Cross Slip, der dank seiner <strong>schönen Taillen</strong> absolut nicht beult.</p> <p>Die <strong>Schnürung an den Hüften</strong> und der <strong>brasilianische Schnitt</strong> sorgen für eine perfekt geformte Silhouette.</p>
title
stringCriss Cross Slip: Sexy Schnürung und absoluter Komfort
usageinstructions
string<p>Der Criss Cross Slip ist perfekt für alle Gelegenheiten, bei denen Sie <strong>absoluten Komfort und Verführung</strong> miteinander verbinden möchten. Das nicht beulende Design garantiert den ganzen Tag über ein angenehmes Tragegefühl ohne jegliche Beschwerden.</p> <p>Die <strong>Schnürung an den Hüften</strong> ermöglicht eine individuelle Passform und sorgt gleichzeitig für einen furchtbar sexy optischen Effekt. Tragen Sie es selbstbewusst, denn Sie wissen, dass die perfekte Passform Ihre Kurven betont, ohne sie jemals einzuengen.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>Το εσώρουχο Criss Cross τα έχει όλα, με ένα σχέδιο που δεν είναι ποτέ ογκώδες. Η <strong>όμορφη ζώνη</strong> του προσαρμόζεται τέλεια στις γενναιόδωρες καμπύλες σας, δημιουργώντας μια σμιλεμένη σιλουέτα χωρίς περιορισμούς.</p> <p><strong>Τα κορδόνια</strong> του <strong>στο ισχίο</strong> μετατρέπουν κάθε κίνηση σε πρόσκληση για αποπλάνηση, ενώ το <strong>βραζιλιάνικο κόψιμό</strong> του αποκαλύπτει και αναδεικνύει όμορφα τους γλουτούς σας. Αυτά τα εσώρουχα <strong>που αγκαλιάζουν την κοιλιά</strong> σας προσφέρουν βέλτιστη στήριξη, διατηρώντας παράλληλα αυτή την τρομερά σέξι εμφάνιση.</p> <p>Η <strong>υψηλής ποιότητας δαντέλα</strong> αγκαλιάζει απαλά το δέρμα σας για απόλυτη άνεση που διαρκεί όλη την ημέρα. Διατίθεται σε τρία βασικά χρώματα - το μυστηριώδες μαύρο, το παθιασμένο κόκκινο και το προκλητικό λευκό - κάθε έκδοση αποκαλύπτει μια διαφορετική πτυχή του αισθησιασμού σας. Αυτή η δημιουργία συνδυάζει τέλεια <strong>την άνεση και την πρόκληση</strong>, μετατρέποντας κάθε μέρα σε μια ευκαιρία να νιώσετε ακαταμάχητα σέξι και σίγουροι.</p>
guid
stringhttps://dev.divasboudoir.com/el/eswroycha-megaloy-megethoys-criss-cross-mayro-mayro/sbga8281.htm
highlights
string<ul> <li><strong>Απολύτως καμία χαλάρωση</strong> χάρη στην όμορφη ζώνη μέσης του</li> <li><strong>Σέξι κορδόνια</strong> στους γοφούς, εξαιρετικά προκλητικά</li> <li><strong>Βραζιλιάνικο κόψιμο</strong> για να αναδεικνύει τον πισινό σας</li> <li><strong>Ανεβαίνει πάνω από την κοιλιά</strong> για τέλεια στήριξη</li> <li><strong>Ποιοτική δαντέλα</strong> για άνεση όλη την ημέρα</li> <li><strong>Τρία χρώματα</strong>: μαύρο, κόκκινο και λευκό</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringΜεγάλο δαντελένιο εσώρουχο Criss Cross με κορδόνια στους γοφούς. Μη ογκώδες, βραζιλιάνικο κόψιμο. 3 σέξι χρώματα. Εσώρουχα Diva's Boudoir.
keywords
string
title
stringΕσώρουχο Criss Cross μεγάλο μέγεθος με κορδόνια | Diva's Boudoir
seotitle
stringΕσώρουχα μεγάλου μεγέθους Criss Cross δαντέλα για το ισχίο
seouri
stringeswroycha-megaloy-megethoys-criss-cross-mayro-mayro
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>Τα εσώρουχα Criss Cross, με τα <strong>προκλητικά κορδόνια</strong> τους, είναι ό,τι χρειάζεστε για να δημιουργήσετε μια απίστευτα σέξι εμφάνιση.</p> <p>Για επιπλέον αποπλάνηση, συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την παρουσία τους. <strong>Το μαύρο</strong> φέρνει διαχρονικό αισθησιασμό, το <strong>κόκκινο</strong> αποκαλύπτει φλογερό πάθος, ενώ <strong>το λευκό</strong> παίζει με την προκλητική αθωότητα.</p> <p>Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/stringk-syn-megethos/">σέξι στρινγκ</a>μας <a href="https://www.divasboudoir.com/el/stringk-syn-megethos/">για</a>ποικιλία, ή προσθέστε ένα <a href="https://www.divasboudoir.com/el/megala-kimono/">κιμονό</a> για μια σταδιακή αποπλάνηση που κορυφώνεται με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p>
summary
string<p>Ανακαλύψτε το <strong>άνετο, σέξι</strong> εσώρουχο Criss Cross, το οποίο δεν θα κατσουφιάσει καθόλου χάρη στο <strong>όμορφο ζωνάρι</strong> του.</p> <p>Τα <strong>κορδόνια</strong> του <strong>στους γοφούς</strong> και το <strong>βραζιλιάνικο κόψιμο</strong> δημιουργούν μια τέλεια σμιλεμένη σιλουέτα.</p>
title
stringΕσώρουχα Criss Cross: Σέξι κορδόνια και απόλυτη άνεση
usageinstructions
string<p>Τα εσώρουχα Criss Cross είναι ιδανικά για όλες εκείνες τις περιπτώσεις που θέλετε να συνδυάσετε <strong>την απόλυτη άνεση με την αποπλάνηση</strong>. Ο μη φουσκωτός σχεδιασμός εξασφαλίζει ολοήμερη χρήση χωρίς δυσφορία.</p> <p>Τα <strong>κορδόνια στους γοφούς</strong> επιτρέπουν την εξατομικευμένη εφαρμογή, ενώ παράλληλα δημιουργούν ένα απίστευτα σέξι οπτικό αποτέλεσμα. Φορέστε το με αυτοπεποίθηση, γνωρίζοντας ότι η τέλεια εφαρμογή του θα αναδείξει τις καμπύλες σας χωρίς ποτέ να τις συμπιέζει.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>The Criss Cross panty has it all, with a design that's never bulging. Its <strong>beautiful waistband</strong> adapts perfectly to your generous curves, creating a sculpted silhouette with no constraints.</p> <p><strong>Hip lacing</strong> turns every movement into an invitation to seduction, while the <strong>Brazilian cut</strong> reveals and beautifully enhances your buttocks. These <strong>tummy-hugging</strong> panties offer optimum support while retaining that terribly sexy edge.</p> <p><strong>High-quality lace</strong> gently hugs your skin for absolute comfort that stays with you all day long. Available in three essential colors - mysterious black, passionate red and provocative white - each version reveals a different facet of your sensuality. This creation perfectly combines <strong>comfort and provocation</strong>, turning every day into an opportunity to feel irresistibly sexy and confident.</p>
guid
stringhttps://dev.divasboudoir.com/en/plus-size-panties-criss-cross-black-black/sbga8281.htm
highlights
string<ul> <li><strong>Absolutely no sagging</strong> thanks to its beautiful waistband</li> <li><strong>Sexy lacing</strong> on the ultra-provocative hips</li> <li><strong>Brazilian cut</strong> shows off your buttocks to best advantage</li> <li><strong>Rises over the tummy</strong> for perfect support</li> <li><strong>Quality lace</strong> for all-day comfort</li> <li><strong>Three colors</strong>: black, red and white</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCriss Cross plus size lace panties with hip lacing. Non-shedding, Brazilian cut. 3 sexy colors. Diva's Boudoir Lingerie.
keywords
string
title
stringCriss Cross plus size lace-up panties | Diva's Boudoir
seotitle
stringPlus size panties Criss Cross lace hip lacing
seouri
stringplus-size-panties-criss-cross-black-black
specifications
string<ul> <li><strong>Material:</strong> Stretch lace (92% polyamide, 8% elastane)</li> <li><strong>Colors:</strong> Black, Red, White</li> <li><strong>Style:</strong> Panties with hip lacing and Brazilian cut</li> <li><strong>Cut:</strong> Brazilian on the buttocks, rises on the tummy</li> <li><strong>Care:</strong> Delicate hand wash recommended</li> </ul>
stylingtips
string<p>Criss Cross panties with their <strong>provocative lacing</strong> stand alone to create a terribly sexy look.</p> <p>To amplify the seductive effect, pair them with pieces that subtly reveal their presence. <strong>Black</strong> brings timeless sensuality, <strong>red</strong> reveals fiery passion, while <strong>white</strong> plays on provocative innocence.</p> <p>Complete your look with our <a href="https://www.divasboudoir.com/en/thong-plus-size/">sexy thongs for</a>variety, or add a <a href="https://www.divasboudoir.com/en/plus-size-kimonos/">kimono</a> for a gradual seduction that culminates in the discovery of these terribly exciting panties.</p>
summary
string<p>Discover <strong>comfortable, sexy</strong> Criss Cross panties that won't sulk at all thanks to their <strong>beautiful waistband</strong>.</p> <p><strong>Hip lacing</strong> and a <strong>Brazilian cut</strong> create a perfectly sculpted silhouette.</p>
title
stringCriss Cross panties: Sexy lacing and absolute comfort
usageinstructions
string<p>Criss Cross panties are perfect for all occasions when you want to combine <strong>absolute comfort with seduction</strong>. Their no-kink design guarantees all-day wear without any discomfort.</p> <p>The <strong>lacing on the hips</strong> allows a personalized fit while creating a terribly sexy visual effect. Wear it with confidence, knowing that its perfect fit will sublimate your curves without ever compressing them.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La braguita Criss Cross lo tiene todo, con un diseño que nunca resulta voluminoso. Su <strong>preciosa cinturilla</strong> se adapta perfectamente a tus generosas curvas, creando una silueta esculpida sin limitaciones.</p> <p>Su <strong>lazada en la cadera</strong> convierte cada movimiento en una invitación a la seducción, mientras que su <strong>corte brasileño</strong> revela y realza maravillosamente tus glúteos. Estas braguitas <strong>que se ciñen al vientre</strong> ofrecen una sujeción óptima al tiempo que conservan ese aspecto terriblemente sexy.</p> <p>El <strong>encaje de alta calidad</strong> abraza suavemente tu piel para un confort absoluto que dura todo el día. Disponible en tres colores esenciales -negro misterioso, rojo apasionado y blanco provocativo-, cada versión revela una faceta diferente de tu sensualidad. Esta creación combina a la perfección <strong>comodidad y provocación</strong>, convirtiendo cada día en una oportunidad para sentirse irresistiblemente sexy y segura de sí misma.</p>
guid
stringhttps://dev.divasboudoir.com/es/bragas-talla-grande-criss-cross-negro-negro/sbga8281.htm
highlights
string<ul> <li><strong>No se descuelga en absoluto</strong> gracias a su bonita cinturilla</li> <li><strong>Sexy lazada</strong> en las caderas, ultra provocativa</li> <li><strong>Corte brasileño</strong> para lucir las nalgas</li> <li><strong>Se eleva sobre el vientre</strong> para una sujeción perfecta</li> <li><strong>Encaje de calidad</strong> para una mayor comodidad durante todo el día</li> <li><strong>Tres colores</strong>: negro, rojo y blanco</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBraguita de encaje de talla grande Criss Cross con lazada en la cadera. No voluminosas, corte brasileño. 3 sexys colores. Lencería Diva's Boudoir.
keywords
string
title
stringBraga Criss Cross talla grande lazada | Diva's Boudoir
seotitle
stringBragas talla grande Criss Cross de encaje en la cadera
seouri
stringbragas-talla-grande-criss-cross-negro-negro
specifications
string<ul> <li><strong>Material:</strong> encaje elástico (92% poliamida, 8% elastán)</li> <li><strong>Colores:</strong> negro, rojo y blanco</li> <li><strong>Estilo :</strong> Braguita con lazada en la cadera y corte brasileño</li> <li><strong>Corte :</strong> Brasileño en las nalgas, sube en el vientre</li> <li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li> </ul>
stylingtips
string<p>Las bragas Criss Cross, con sus <strong>provocativos lazos</strong>, son todo lo que necesitas para crear un look increíblemente sexy.</p> <p>Para mayor seducción, combínalas con prendas que revelen su presencia sutilmente. <strong>El negro</strong> aporta una sensualidad atemporal, <strong>el rojo</strong> revela una pasión ardiente, mientras que <strong>el blanco</strong> juega con una inocencia provocativa.</p> <p>Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/tanga-talla-grande/">sexys tangas para</a>variar, o añade un <a href="https://www.divasboudoir.com/es/kimonos-tallas-grandes/">kimono</a> para una seducción gradual que culmine con el descubrimiento de estas bragas terriblemente excitantes.</p>
summary
string<p>Descubre las <strong>cómodas y sexys</strong> braguitas Criss Cross, que no se enfurruñan en absoluto gracias a su <strong>bonita cinturilla</strong>.</p> <p>Su <strong>lazada en las caderas</strong> y su <strong>corte brasileño</strong> crean una silueta perfectamente esculpida.</p>
title
stringBraguitas Criss Cross: lazada sexy y comodidad absoluta
usageinstructions
string<p>Las braguitas Criss Cross son perfectas para todas esas ocasiones en las que quieres combinar <strong>comodidad absoluta con seducción</strong>. Su diseño no abombado garantiza su uso durante todo el día sin molestias.</p> <p>El <strong>cordón en las caderas</strong> permite un ajuste personalizado a la vez que crea un efecto visual increíblemente sexy. Llévalo con confianza, sabiendo que su ajuste perfecto realzará tus curvas sin comprimirlas en ningún momento.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La culotte Criss Cross a tout pour plaire avec sa conception pens&eacute;e pour ne jamais boudiner. Ses <strong>belles tailles</strong> s'adaptent parfaitement &agrave; vos courbes g&eacute;n&eacute;reuses, cr&eacute;ant une silhouette sculpt&eacute;e sans aucune contrainte.</p> <p>Son&nbsp;<strong>la&ccedil;age sur les hanches</strong> transforme chaque mouvement en invitation &agrave; la s&eacute;duction, tandis que sa <strong>coupe br&eacute;silienne</strong> r&eacute;v&egrave;le et met magnifiquement en valeur vos fesses. Cette culotte qui <strong>monte sur le ventre</strong> offre un maintien optimal tout en conservant ce c&ocirc;t&eacute; terriblement sexy.</p> <p>La&nbsp;<strong>dentelle de qualit&eacute;</strong> &eacute;pouse d&eacute;licatement votre peau pour un confort absolu qui vous accompagne toute la journ&eacute;e. Disponible en trois couleurs incontournables - noir myst&eacute;rieux, rouge passion et blanc provocant - chaque version r&eacute;v&egrave;le une facette diff&eacute;rente de votre sensualit&eacute;. Cette cr&eacute;ation allie parfaitement <strong>confort et provocation</strong>, transformant chaque jour en occasion de vous sentir irr&eacute;sistiblement sexy et confiante.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-criss-cross-grande-taille-dentelle-lacage/sbga8281.htm
highlights
string<ul> <li><strong>Ne boudine absolument pas</strong> gr&acirc;ce &agrave; ses belles tailles</li> <li><strong>La&ccedil;age sexy</strong> sur les hanches ultra provocant</li> <li><strong>Coupe br&eacute;silienne</strong> qui met les fesses en valeur</li> <li><strong>Monte sur le ventre</strong> pour un maintien parfait</li> <li><strong>Dentelle de qualit&eacute;</strong> confortable toute la journ&eacute;e</li> <li><strong>Trois couleurs</strong> : noir, rouge et blanc</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte Criss Cross grande taille en dentelle avec laçage hanches. Ne boudine pas, coupe brésilienne. 3 couleurs sexy. Diva's Boudoir Lingerie.
keywords
string
title
stringCulotte Criss Cross grande taille laçage | Diva's Boudoir
seotitle
stringCulotte grande taille Criss Cross dentelle laçage hanches
seouri
stringculotte-criss-cross-grande-taille-dentelle-lacage
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> Dentelle extensible (92% polyamide, 8% &eacute;lasthanne)</li> <li><strong>Couleurs :</strong> Noir, Rouge, Blanc</li> <li><strong>Style :</strong> Culotte avec la&ccedil;age hanches et coupe br&eacute;silienne</li> <li><strong>Coupe :</strong> Br&eacute;silienne sur les fesses, monte sur le ventre</li> <li><strong>Entretien :</strong> Lavage d&eacute;licat &agrave; la main recommand&eacute;</li> </ul>
stylingtips
string<p>La culotte Criss Cross avec son <strong>la&ccedil;age provocant</strong> se suffit &agrave; elle-m&ecirc;me pour cr&eacute;er un look terriblement sexy.</p> <p>Pour amplifier l'effet de s&eacute;duction, associez-la &agrave; des pi&egrave;ces qui r&eacute;v&egrave;lent subtilement sa pr&eacute;sence. Le coloris&nbsp;<strong>noir</strong> apporte une sensualit&eacute; intemporelle, le <strong>rouge</strong> r&eacute;v&egrave;le une passion ardente, tandis que le <strong>blanc</strong> joue sur l'innocence provocante.</p> <p>Compl&eacute;tez votre look avec nos <a href="https://www.divasboudoir.com/fr/string-grande-taille/">strings sexys</a>pour varier les plaisirs, ou ajoutez un <a href="https://www.divasboudoir.com/fr/kimonos-grande-taille/">kimonos</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 Criss Cross, <strong>confortable et sexy</strong> qui ne boudine absolument pas gr&acirc;ce &agrave; ses <strong>belles tailles</strong>.</p> <p>Son&nbsp;<strong>la&ccedil;age sur les hanches</strong> et sa <strong>coupe br&eacute;silienne</strong> cr&eacute;ent une silhouette parfaitement sculpt&eacute;e.</p>
title
stringCulotte Criss Cross : Laçage Sexy et Confort Absolu
usageinstructions
string<p>La culotte Criss Cross est parfaite pour toutes les occasions o&ugrave; vous souhaitez allier <strong>confort absolu et s&eacute;duction</strong>. Sa conception qui ne boudine pas garantit un port agr&eacute;able toute la journ&eacute;e sans aucune g&ecirc;ne.</p> <p>Le&nbsp;<strong>la&ccedil;age sur les hanches</strong> permet un ajustement personnalis&eacute; tout en cr&eacute;ant un effet visuel terriblement sexy. Portez-la avec assurance, sachant que sa coupe parfaite sublimera vos courbes sans jamais les comprimer.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>La mutandina Criss Cross ha tutto, con un design mai ingombrante. La sua <strong>splendida fascia in vita</strong> si adatta perfettamente alle vostre curve generose, creando una silhouette scolpita senza costrizioni.</p> <p>L'<strong>allacciatura sui fianchi</strong> trasforma ogni movimento in un invito alla seduzione, mentre il <strong>taglio brasiliano</strong> rivela ed esalta i vostri glutei. Queste mutandine <strong>aderenti alla pancia</strong> offrono un sostegno ottimale pur mantenendo un look terribilmente sexy.</p> <p>Il <strong>pizzo di alta qualit&agrave;</strong> abbraccia delicatamente la pelle per un comfort assoluto che dura tutto il giorno. Disponibile in tre colori essenziali - nero misterioso, rosso passionale e bianco provocante - ogni versione rivela una diversa sfaccettatura della vostra sensualit&agrave;. Questa creazione combina perfettamente <strong>comfort e provocazione</strong>, trasformando ogni giorno in un'occasione per sentirsi irresistibilmente sexy e sicure di s&eacute;.</p>
guid
stringhttps://dev.divasboudoir.com/it/mutandine-di-taglia-grande-criss-cross-nero-nero/sbga8281.htm
highlights
string<ul> <li><strong>Assolutamente nessun cedimento</strong> grazie alla sua bella fascia in vita</li> <li><strong>Sexy allacciatura</strong> sui fianchi, ultra provocante</li> <li><strong>Taglio brasiliano</strong> per mettere in mostra il sedere</li> <li><strong>Si solleva sulla pancia</strong> per un sostegno perfetto</li> <li><strong>Pizzo di qualit&agrave;</strong> per un comfort che dura tutto il giorno</li> <li><strong>Tre colori</strong>: nero, rosso e bianco</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringMutandine in pizzo di grande taglia Criss Cross con allacciatura sui fianchi. Taglio brasiliano non voluminoso. 3 colori sexy. Diva's Boudoir Lingerie.
keywords
string
title
stringCriss Cross panty taglia grande allacciatura | Diva's Boudoir
seotitle
stringMutandine di taglia grande con allacciatura Criss Cross sui fianchi
seouri
stringmutandine-di-taglia-grande-criss-cross-nero-nero
specifications
string<ul> <li><strong>Materiale:</strong> pizzo elasticizzato (92% poliammide, 8% elastan)</li> <li><strong>Colori:</strong> Nero, Rosso, Bianco</li> <li><strong>Stile :</strong> Mutandina con allacciatura sui fianchi e taglio brasiliano</li> <li><strong>Taglio :</strong> Brasiliano sui glutei, rialzato sul ventre</li> <li><strong>Cura:</strong> Si consiglia un lavaggio delicato a mano</li> </ul>
stylingtips
string<p>Le mutandine Criss Cross, con la loro <strong>provocante allacciatura</strong>, sono tutto ci&ograve; che serve per creare un look incredibilmente sexy.</p> <p>Per una maggiore seduzione, abbinatele a capi che rivelino sottilmente la loro presenza. <strong>Il nero</strong> porta con s&eacute; una sensualit&agrave; senza tempo, il <strong>rosso</strong> rivela una passione ardente, mentre il <strong>bianco</strong> gioca con l'innocenza provocante.</p> <p>Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/perizoma-di-grandi-dimensioni/">tanga sexy per</a>variare, oppure aggiungete un <a href="https://www.divasboudoir.com/it/kimono-taglie-forti/">kimono</a> per una seduzione graduale che culmina con la scoperta di queste mutandine terribilmente eccitanti.</p>
summary
string<p>Scoprite le <strong>comode e sexy</strong> mutandine Criss Cross, che non vi faranno sentire in imbarazzo grazie alla loro <strong>splendida fascia in vita</strong>.</p> <p>L'<strong>allacciatura sui fianchi</strong> e il <strong>taglio brasiliano</strong> creano una silhouette perfettamente scolpita.</p>
title
stringMutandine Criss Cross: allacciatura sexy e comfort assoluto
usageinstructions
string<p>Le mutandine Criss Cross sono perfette per tutte le occasioni in cui si desidera unire il <strong>comfort assoluto alla seduzione</strong>. Il design non sgambato assicura un'usura che dura tutto il giorno senza alcun disagio.</p> <p>L'<strong>allacciatura sui fianchi</strong> consente una vestibilit&agrave; personalizzata e crea un effetto visivo incredibilmente sexy. Indossatelo con fiducia, sapendo che la sua perfetta vestibilit&agrave; esalter&agrave; le vostre curve senza mai comprimerle.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>De Criss Cross panty heeft het allemaal, met een ontwerp dat nooit volumineus is. De <strong>prachtige tailleband</strong> past zich perfect aan je royale rondingen aan en cre&euml;ert een gebeeldhouwd silhouet zonder beperkingen.</p> <p>De <strong>heupveter</strong> maakt van elke beweging een uitnodiging tot verleiding, terwijl <strong>de Braziliaanse snit</strong> je billen onthult en prachtig laat uitkomen. Deze <strong>nauwsluitende</strong> slips bieden optimale ondersteuning terwijl ze die vreselijk sexy look behouden.</p> <p>Het <strong>hoogwaardige kant</strong> omhelst je huid zachtjes voor absoluut comfort dat de hele dag blijft zitten. Verkrijgbaar in drie essenti&euml;le kleuren - mysterieus zwart, hartstochtelijk rood en uitdagend wit - onthult elke versie een ander facet van je sensualiteit. Deze creatie combineert perfect <strong>comfort en provocatie</strong>, waardoor elke dag een kans wordt om je onweerstaanbaar sexy en zelfverzekerd te voelen.</p>
guid
stringhttps://dev.divasboudoir.com/nl/groote-maat-slip-criss-cross-zwart-zwart/sbga8281.htm
highlights
string<ul> <li><strong>Absoluut geen afzakken</strong> dankzij de mooie tailleband</li> <li><strong>Sexy vetersluiting</strong> op de heupen, ultra uitdagend</li> <li><strong>Braziliaans model</strong> om je billen te showen</li> <li><strong>Komt omhoog over de buik</strong> voor perfecte ondersteuning</li> <li><strong>Kwaliteitsveter</strong> voor de hele dag comfort</li> <li><strong>Drie kleuren</strong>: zwart, rood en wit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringKriskras grote maat kanten slip met vetersluiting op de heupen. Niet volumineus, Braziliaans model. 3 sexy kleuren. Diva's Boudoir Lingerie.
keywords
string
title
stringCriss Cross panty grote maat | Diva's Boudoir
seotitle
stringGrote maat slip Criss Cross kant heupveter
seouri
stringgroote-maat-slip-criss-cross-zwart-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> Stretchkant (92% polyamide, 8% elastaan)</li> <li><strong>Kleuren:</strong> Zwart, Rood, Wit</li> <li><strong>Stijl :</strong> Slipje met heupveter en Braziliaans model</li> <li><strong>Snit :</strong> Braziliaans op de billen, oplopend op de buik</li> <li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li> </ul>
stylingtips
string<p>Criss Cross slips, met hun <strong>provocerende vetersluiting</strong>, zijn alles wat je nodig hebt om een ongelooflijk sexy look te cre&euml;ren.</p> <p>Voor nog meer verleiding combineer je ze met stukken die subtiel hun aanwezigheid onthullen. <strong>Zwart</strong> brengt tijdloze sensualiteit, <strong>rood</strong> onthult vurige passie en <strong>wit</strong> speelt met provocerende onschuld.</p> <p>Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/string-groote-maat/">sexy strings voor</a>de afwisseling, of voeg een <a href="https://www.divasboudoir.com/nl/plus-size-kimonos/">kimono</a> toe voor een geleidelijke verleiding die culmineert in de ontdekking van deze vreselijk opwindende slipjes.</p>
summary
string<p>Ontdek de <strong>comfortabele, sexy</strong> Criss Cross slip, die dankzij de <strong>mooie tailleband</strong> absoluut niet gaat knellen.</p> <p>De <strong>vetersluiting op de heupen</strong> en <strong>de Braziliaanse snit</strong> zorgen voor een perfect gebeeldhouwd silhouet.</p>
title
stringCriss Cross slip: Sexy vetersluiting en absoluut comfort
usageinstructions
string<p>Criss Cross slips zijn perfect voor alle gelegenheden waarbij je <strong>absoluut comfort</strong> wilt combineren <strong>met verleiding</strong>. Het niet opbollende ontwerp zorgt ervoor dat je het de hele dag zonder ongemak kunt dragen.</p> <p>De <strong>vetersluiting op de heupen</strong> zorgt voor een persoonlijke pasvorm en een ongelooflijk sexy visueel effect. Draag het met vertrouwen, wetende dat de perfecte pasvorm je rondingen zal verbeteren zonder ze ooit samen te drukken.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string
description
string<p>A cueca Criss Cross tem tudo, com um design que nunca é volumoso. A sua <strong>bela cintura</strong> adapta-se perfeitamente às suas curvas generosas, criando uma silhueta esculpida sem constrangimentos.</p> <p>O seu laço <strong>na anca</strong> transforma cada movimento num convite à sedução, enquanto o seu <strong>corte brasileiro</strong> revela e realça lindamente as suas nádegas. Estas cuecas <strong>que abraçam a barriga</strong> oferecem um suporte ótimo, mantendo aquele aspeto terrivelmente sexy.</p> <p>A <strong>renda de alta qualidade</strong> envolve suavemente a sua pele para um conforto absoluto que dura todo o dia. Disponível em três cores essenciais - preto misterioso, vermelho apaixonante e branco provocante - cada versão revela uma faceta diferente da sua sensualidade. Esta criação combina na perfeição <strong>conforto e provocação</strong>, transformando cada dia numa oportunidade para se sentir irresistivelmente sexy e confiante.</p>
guid
stringhttps://dev.divasboudoir.com/pt/cuecas-tamanho-grande-criss-cross-preto-preto/sbga8281.htm
highlights
string<ul> <li><strong>Sem qualquer flacidez</strong> graças à sua bela cintura</li> <li><strong>Laço sexy</strong> nas ancas, ultra provocante</li> <li><strong>Corte brasileiro</strong> para mostrar o seu traseiro</li> <li><strong>Sobe sobre a barriga</strong> para um apoio perfeito</li> <li><strong>Renda de qualidade</strong> para conforto durante todo o dia</li> <li><strong>Três cores</strong>: preto, vermelho e branco</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas de renda grandes Criss Cross com laço na anca. Não volumosas, corte brasileiro. 3 cores sensuais. Lingerie Diva's Boudoir.
keywords
string
title
stringCalcinha Criss Cross tamanho grande com laço | Diva's Boudoir
seotitle
stringCuecas de tamanho grande Criss Cross com renda na anca
seouri
stringcuecas-tamanho-grande-criss-cross-preto-preto
specifications
string<ul> <li><strong>Material:</strong> Renda elástica (92% poliamida, 8% elastano)</li> <li><strong>Cores:</strong> Preto, Vermelho, Branco</li> <li><strong>Estilo :</strong> Cuecas com laço na anca e corte brasileiro</li> <li><strong>Corte:</strong> Brasileiro nas nádegas, sobe na barriga</li> <li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada à mão</li> </ul>
stylingtips
string<p>As cuecas Criss Cross, com o seu <strong>laço provocante</strong>, são tudo o que precisa para criar um visual incrivelmente sexy.</p> <p>Para uma maior sedução, combine-as com peças que revelem subtilmente a sua presença. <strong>O preto</strong> traz uma sensualidade intemporal, <strong>o vermelho</strong> revela uma paixão ardente, enquanto <strong>o branco</strong> joga com uma inocência provocante.</p> <p>Complete o seu look com as nossas tangas <a href="https://www.divasboudoir.com/pt/fio-dental-tamanho-grande/">sensuais para</a>variar, ou adicione um <a href="https://www.divasboudoir.com/pt/quimonos-de-tamanho-grande/">quimono</a> para uma sedução gradual que culmina com a descoberta destas cuecas terrivelmente excitantes.</p>
summary
string<p>Descubra as cuequinhas Criss Cross, <strong>confortáveis e sensuais</strong>, que não fazem qualquer barulho graças à sua <strong>bela cintura</strong>.</p> <p>O seu laço <strong>nas ancas</strong> e o <strong>corte brasileiro</strong> criam uma silhueta perfeitamente esculpida.</p>
title
stringCuecas Criss Cross: laço sexy e conforto absoluto
usageinstructions
string<p>As cuecas Criss Cross são perfeitas para todas as ocasiões em que se quer combinar <strong>conforto absoluto com sedução</strong>. O design sem abaulamento garante uma utilização durante todo o dia sem desconforto.</p> <p>O <strong>laço nas ancas</strong> permite um ajuste personalizado, criando um efeito visual incrivelmente sexy. Use-o com confiança, sabendo que o seu ajuste perfeito irá realçar as suas curvas sem nunca as comprimir.</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
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
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
stringBlack Plus Size Sexy High Waist Floral Lace Strappy Panty P5124-1P
netweight
string
nextshipment
stringtoday
ordered
number74
orderidx
number0
origin
string
originalsize
string
packaging
string
productshipment
stringauto
productuid
string952F4D3D-C960-4C3A-B0293EDD79B2B08A
promountil
string
rating
stringnone
recorduid
string952F4D3D-C960-4C3A-B0293EDD79B2B08A
reference
stringSBGA8281
related
string
reserved
string
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.59 ms
Record Count: 15
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,1148,1136,1115') > 0
and product_variations.productuid = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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-40intlsizered3840-19999991wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
2109338-40intlsizeblack3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
3109338-40intlsizewhite3840-19999990wpluslingerieM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-4092-10074-8298-106
4113744-46intlsizered4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
5113744-46intlsizeblack4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
6113744-46intlsizewhite4446-19999990wpluslingerieXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46102-10886-92108-114
7114846-48intlsizered4648-19999990wpluslingerieXL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48100-11082-96106-116
8114846-48intlsizeblack4648-19999990wpluslingerieXL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48100-11082-96106-116
9114846-48intlsizewhite4648-19999990wpluslingerieXL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48100-11082-96106-116
10113648-50intlsizewhite4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
11113648-50intlsizered4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
12113648-50intlsizeblack4850-19999990wpluslingerie3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50110-11696-102116-122
13111550-52intlsizewhite5052-19999990wpluslingerie3XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52116-126102-110122-132
14111550-52intlsizered5052-19999990wpluslingerie3XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52116-126102-110122-132
15111550-52intlsizeblack5052-19999990wpluslingerie3XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52116-126102-110122-132
sizeranges
stringplus
sizes
string1093,1137,1148,1136,1115
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: 12.2 ms
Record Count: 9
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
and product_variations.isactive = 1
and product_sizes.id_size = 1148
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
and product_variations.isactive = 1
and product_sizes.id_size = 1115
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
1952F4D3D-C960-4C3A-B0293EDD79B2B08A3CFA6390-EA32-44B5-835AD30581BBDAAD1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01000-11500P5124-1PP5124-1P1115-10all
2952F4D3D-C960-4C3A-B0293EDD79B2B08AA4CB2EB3-DE60-4E1F-9B8EFC335308A4221093red#F50000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01100-10000P5124-311all
3952F4D3D-C960-4C3A-B0293EDD79B2B08A9C9EFFD2-2E08-401A-9194E7154B1CC91F1093white#FFFFFFM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01000-11000P5124-2-10all
4952F4D3D-C960-4C3A-B0293EDD79B2B08ABAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D1137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01100-122700P5124-1PP5124-1P1117-10all
5952F4D3D-C960-4C3A-B0293EDD79B2B08AB9CDA488-7C84-4456-BC8EC4FC1524DD881137red#F50000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01000-10000P5124-3-10all
6952F4D3D-C960-4C3A-B0293EDD79B2B08ACB13274B-82AC-4BA3-A182BFC5BAACE0921137white#FFFFFFXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01000-10100P5124-2P5124-21117-10all
7952F4D3D-C960-4C3A-B0293EDD79B2B08ADE4AE40E-912E-4422-ABAD6D2247F4A3FC1136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-114100P5124-1PP5124-1P1119-10all
8952F4D3D-C960-4C3A-B0293EDD79B2B08ABB3DBC58-6269-4085-87C19A61E38057C11136red#F500003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-11100P5124-3P5124-3P1119-10all
9952F4D3D-C960-4C3A-B0293EDD79B2B08A4F24B3E6-9038-4C5F-8AFB7405236AF15B1136white#FFFFFF3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-11000P5124-2-10all
subcategory
stringsexypanty
supplier
number-1
supplierreference
stringP5124-1P
tags
string
themes
stringsexystrings
totalvariations
string
type
stringdefault
unitprice
number11.625
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.82 ms
Record Count: 15
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
and product_variations.isactive = 1
and product_sizes.id_size = 1148
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A'
and product_variations.isactive = 1
and product_sizes.id_size = 1115
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
13CFA6390-EA32-44B5-835AD30581BBDAAD1093black#000000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01000-11500P5124-1PP5124-1P1115-10-10-10111.625all
2A4CB2EB3-DE60-4E1F-9B8EFC335308A4221093red#F50000M-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01100-10000P5124-311-10-10111.625all
39C9EFFD2-2E08-401A-9194E7154B1CC91F1093white#FFFFFFM-L38-4038-408-1012-1440-4240-4238-4044-4640-4238-40wlingerie38-40intlsize16.62511.625STOCK01000-11000P5124-2-10-10-10111.625all
4BAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D1137black#000000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01100-122700P5124-1PP5124-1P1117-10-10-10111.625all
5B9CDA488-7C84-4456-BC8EC4FC1524DD881137red#F50000XL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01000-10000P5124-3-10-10-10111.625all
6CB13274B-82AC-4BA3-A182BFC5BAACE0921137white#FFFFFFXL-2XL44-4644-4614-1618-2246-4846-4844-4650-5246-4844-46wlingerie44-46intlsize16.62511.625STOCK01000-10100P5124-2P5124-21117-10-10-10111.625all
7BAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D1148black#000000XL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.62511.625STOCK01100-122700P5124-1PP5124-1P1117-10-10-10111.625all
8B9CDA488-7C84-4456-BC8EC4FC1524DD881148red#F50000XL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.62511.625STOCK01000-10000P5124-3-10-10-10111.625all
9CB13274B-82AC-4BA3-A182BFC5BAACE0921148white#FFFFFFXL-2XL46-4846-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie46-48intlsize16.62511.625STOCK01000-10100P5124-2P5124-21117-10-10-10111.625all
10DE4AE40E-912E-4422-ABAD6D2247F4A3FC1136black#0000003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-114100P5124-1PP5124-1P1119-10-10-10111.625all
11BB3DBC58-6269-4085-87C19A61E38057C11136red#F500003XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-11100P5124-3P5124-3P1119-10-10-10111.625all
124F24B3E6-9038-4C5F-8AFB7405236AF15B1136white#FFFFFF3XL-4XL48-5048-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie48-50intlsize16.62511.625STOCK01000-11000P5124-2-10-10-10111.625all
13DE4AE40E-912E-4422-ABAD6D2247F4A3FC1115black#0000003XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.62511.625STOCK01000-114100P5124-1PP5124-1P1119-10-10-10111.625all
14BB3DBC58-6269-4085-87C19A61E38057C11115red#F500003XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.62511.625STOCK01000-11100P5124-3P5124-3P1119-10-10-10111.625all
154F24B3E6-9038-4C5F-8AFB7405236AF15B1115white#FFFFFF3XL-4XL50-5250-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie50-52intlsize16.62511.625STOCK01000-11000P5124-2-10-10-10111.625all
vatrate
number20
warehouse
string