Mijn mand

❌
Totaal aantal items
Winkelmand bekijken
Menu
Maten bekijken
Culotte French Cancan - De glamoureuze geest van franje
Dubbelklikken om te vergroten
SKU: SBGA7101
Culotte French Cancan - De glamoureuze geest van franje
Promo
Voorraad:

De Franse Cancan-panty brengt de glamoureuze geest van de Parijse cabarets terug met zijn vele franjes en ondeugende strikje.

Een speels stuk dat je rondingen benadrukt met onweerstaanbare charme en uitzonderlijke kwaliteit.

Sterke punten

  • Meerdere ruches voor een spectaculair volume-effect
  • Authentieke en glamoureuzeFranse Cancan stijl
  • Kleine decoratieve strik in de holte van de lendenen
  • Topkwaliteit met zorgvuldige afwerking
  • Flatterende snit om royale rondingen te benadrukken
  • Optimaal comfort ondanks het volumineuze ontwerp
Maat:

Weet je niet zeker welke maat je moet kiezen? Raadpleeg onze maattabel

Kleur:
Hoeveelheid:
34.95 € 24.95 €
Snelle verzending
voor de ongeduldigen...
Goed advies
via chat, facebook of e-mail
Gratis retourneren
binnen 15 dagen *

Franse Cancan grote maat frilly slip zwart

Productomschrijving

Deze Franse Cancan slips hebben alle magie van de Parijse cabarets met hun trapsgewijze ruches die een spectaculair volume-effect creëren.

Elke ruche is ontworpen om je royale rondingen te accentueren en tegelijkertijd dat vleugje speelsheid toe te voegen dat zo kenmerkend is voor de cancan stijl.

Het strikje dat strategisch in de holte van de lendenen is geplaatst, voegt een vleugje geraffineerde koketterie toe dat niet onopgemerkt zal blijven. De uitzonderlijke kwaliteit is zichtbaar in elk detail: de franjes zijn perfect gestructureerd om hun vorm te behouden, de naden zijn onzichtbaar en de stof past zich perfect aan alle lichaamsvormen aan.

Deze slips maken van elk intimiteitsmoment een glamoureus spektakel en bieden optimaal comfort dankzij een bestudeerde snit die zich op natuurlijke wijze naar de vorm vormt zonder afbreuk te doen aan het opvallende visuele effect.

Technische details

  • Stijl : Frans Cancan frilly slipje
  • Kleur : Zwart
  • Details : Meerdere ruches, decoratieve strik
  • Snit : Hoge taille met volume effect
  • Afwerking : Onzichtbare naden, premium kwaliteit

Beschikbaar maten

Beschikbaar van 2XL+ tot 4XL

Beschikbare kleuren

Zwart en Rood

Maattabel

Controleer de juiste maat voor jou

Internationale
  • Borst
  • Maat
  • Heupen
2XL+
  • 114-118
  • 98-104
  • 120-126
3XL-
  • 118-124
  • 104-108
  • 126-136
L
  • 92-100
  • 74-82
  • 98-106
XL
  • 102-108
  • 86-92
  • 108-114
2XL
  • 108-114
  • 92-98
  • 114-120
3XL
  • 114-118
  • 98-104
  • 120-126
4XL
  • 124-130
  • 108-114
  • 136-146

Onderhoudstips

  • Handwas in koud water om de structuur van de franjes te behouden
  • Gebruik een mild wasmiddel zonder agressieve middelen
  • Voorzichtig persen zonder te draaien om te voorkomen dat de ruches vervormen
  • Droog plat en breng de ruches weer in vorm
  • vermijd rechtstreeks op de ruches te strijken
  • Bewaar ze voorzichtig om het volume van de ruches te behouden

Gebruikstips

Om je French Cancan slip aan te trekken, ga je voorzichtig te werk en respecteer je de structuur van de ruches. Eenmaal op zijn plaats, pas je de ruches een beetje aan om het gewenste volume-effect te krijgen.

Deze slips zijn ideaal om te dragen bij outfits die hun spectaculaire kant laten zien - denk aan korte rokjes of getailleerde jurken waarin de ruches goed uitkomen.

Het strikje achteraan zorgt voor een ondeugende verrassing die perfect is voor intieme momenten.

Stijltips

De French Cancan onderbroek werkt perfect in combinatie met een push-up bh om een glamoureus ensemble te creëren. Voor de ultieme cabaretlook combineer je ze met netkousen en pumps met hak. Je kunt ze ook onder een strakke jurk dragen voor een verrassingseffect bij het uitkleden.

Deze slips transformeren je figuur in een glamoureuze pin-up die de mooiste Parijse cabarets waardig is.

To Top
Winkelmand bekijken
Artikelen
Totaal aantal items
Struct
Entries: 108
actions
Array
available
number1
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
string
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.82 ms
Record Count: 2
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') > 0
and product_variations.productuid = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-11
2redcolorredredred#F50000-10
colorrange
stringblack
colors
stringblack,red
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 '2018-02-08 12:50:05'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number10
instockvariations
number1
isactive
number1
iscustommade
number0
isdivasize
number1
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number29.125
itempromo
number20.7917
key
stringculotte-volants-noirs-p5308-1
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-10-22 18:44:20'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.617 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','nl')
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('dbc2c4f2-fc73-4411-b00f499ef117ff0b',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','nl')
and product_categories.language in ('all','nl')
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 <> 'SBGA7101'
group by products.reference
order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
productuidreferencetypekeylanguagenamelinkuidcolorsvatratemetadatasdimensionsmediadatastagsthemesisdivasizetotalvariationsvariationlistinpromohaspromoitempromoitempriceunitpricepricespromountilisfixedpriceishotisneworderidxavailablestockinstockvariationsbrandbrandnameshowbranddisplaysizetypeintlsizesizessizerangecategorymediadatascategorysizerangesectioncategorysubcategory
linkuid
string
materials
string
mediadatas
Struct
alt
Struct
height
string1118
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sbga7101/culotte_grande_taille_cancan_noire.jpg
type
stringimg
width
string773
back
Struct
height
string937
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga7101/co_114x_red_ps12122017.jpg
type
stringimg
width
string648
default
Struct
height
string1118
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sbga7101/culotte_grande_taille_cancan_noire.jpg
type
stringimg
width
string773
variations
Struct
colors
Struct
black
Struct
height
string1118
isprivate
string0
rating
stringall
src
string/photobank/products/cdug/sbga7101/culotte_grande_taille_cancan_noire.jpg
type
stringimg
width
string773
red
Struct
height
string937
isprivate
string0
rating
stringall
src
string/photobank/products/puun/sbga7101/co_114x_red_ps12122017.jpg
type
stringimg
width
string648
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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwäsche mit kaltem Wasser, um die Struktur der Rüschen zu erhalten</li> <li>Verwenden Sie ein mildes Waschmittel ohne aggressive Wirkstoffe</li> <li>Sanft ausdrücken, ohne zu wringen, damit die Rüschen nicht verformt werden</li> <li>Flach trocknen und dabei die Rüschen wieder in Form bringen</li> <li>vermeiden Sie direktes Bügeln auf den Volants</li> <li>Vorsichtig verstauen, um das Volumen der Rüschen zu erhalten</li> </ul>
description
string<p>Dieser French Cancan Slip fängt den Zauber der Pariser Cabarets mit seinen <strong>kaskadierenden Rüschen</strong> ein, die einen spektakulären Volumeneffekt erzeugen.</p> <p>Jeder einzelne Volant wurde so konzipiert, dass <strong>er Ihre üppigen Kurven</strong> betont und gleichzeitig den für den Cancan-Stil so typischen Hauch von Verspieltheit verleiht.</p> <p>Die kleine Schleife, die strategisch in der Lendengegend platziert ist, verleiht dem Ganzen eine raffinierte Note von Koketterie, die nicht unbemerkt bleibt. Die außergewöhnliche Qualität ist in jedem Detail spürbar: Die Rüschen sind perfekt strukturiert, um ihre Form zu behalten, die Nähte sind unsichtbar und der <strong>Stoff passt sich perfekt an jede Körperform</strong> an.</p> <p>Dieser Slip verwandelt jeden intimen Moment in ein glamouröses Spektakel und bietet <strong>optimalen Tragekomfort</strong> dank seines durchdachten Schnitts, der <strong> sich natürlich an die Formen anpasst</strong>, ohne den atemberaubenden visuellen Effekt zu beeinträchtigen.</p>
guid
stringhttps://dev.divasboudoir.com/de/string-coquette-schwarz/sbga7101.htm
highlights
string<ul> <li><strong>Mehrere Froufrous</strong> für einen spektakulären Volumeneffekt</li> <li>Authentischer und glamouröser<strong>French Cancan-Stil</strong> </li> <li><strong>Kleine Zierschleife</strong> in der Lendengegend</li> <li><strong>Premium-Qualität</strong> mit sorgfältiger Verarbeitung</li> <li><strong>Schmeichelnde Passform</strong>, die großzügige Kurven betont</li> <li><strong>Optimaler Tragekomfort</strong> trotz des voluminösen Designs</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringFrench Cancan Höschen in großen Größen mit Rüschen in Schwarz mit Zierschleife. Glamouröser Pariser Kabarett-Stil in Premium-Qualität. Kostenlose Lieferung ab 59€ bei Diva's Boudoir.
keywords
string
title
stringCulotte Froufrous French Cancan Grande Taille | Diva's Boudoir
seotitle
stringSlip in Übergröße mit Rüschen French Cancan schwarz
seouri
stringstring-coquette-schwarz
specifications
string<ul> <li><strong>Stil:</strong> Höschen mit Rüschen French Cancan</li> <li><strong>Farbe:</strong> Schwarz</li> <li><strong>Details:</strong> Mehrere Rüschen, dekorative Schleife</li> <li><strong>Schnitt:</strong> Hohe Taille mit Volumeneffekt</li> <li><strong>Verarbeitung:</strong> Unsichtbare Nähte, Premium-Qualität</li> </ul>
stylingtips
string<p>Der French Cancan Slip lässt sich perfekt mit einem <a href="https://www.divasboudoir.com/de/bruststraffer-in-ubergrosse/"><strong>Push-up-BH</strong></a> kombinieren, um ein komplettes Glamour-Ensemble zu schaffen. Für einen selbstbewussten Cabaret-Look kombinieren Sie sie mit <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/"><strong>Netzstrümpfen</strong></a> und Pumps mit Absätzen. Sie kann auch unter einem engen Kleid getragen werden, um beim Ausziehen für einen Überraschungseffekt zu sorgen.</p> <p>Dieser Slip verwandelt Ihre Silhouette sofort in ein <strong>glamouröses Pin-up-Girl</strong>, das den schönsten Pariser Kabaretts würdig ist.</p>
summary
string<p>Der Slip French Cancan lässt mit seinen zahlreichen Rüschen und der kleinen frechen Schleife den glamourösen Geist der Pariser Cabarets wieder aufleben.</p> <p>Ein verspieltes Stück, das Ihre Kurven mit unwiderstehlichem Charme und außergewöhnlicher Qualität hervorhebt.</p>
title
stringFrench Cancan Höschen - Der glamouröse Geist der Rüschen
usageinstructions
string<p>Um Ihren French-Cancan-Slip anzuziehen, gehen Sie vorsichtig vor und achten Sie dabei auf die Struktur der Rüschen. Sobald Sie an Ort und Stelle sind, stellen Sie die Rüschen leicht ein, um den gewünschten Volumeneffekt zu erzielen.</p> <p>Dieses Höschen lässt sich am besten mit <strong>Outfits kombinieren, die</strong> seine spektakuläre Seite betonen - denken Sie an kurze Röcke oder eng anliegende Kleider, die die Rüschen durchblicken lassen.</p> <p>Die <strong>kleine Schleife auf dem Rücken</strong> sorgt für eine freche Überraschung, die perfekt für intime Momente geeignet ist.</p>
el
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τη δομή των φρουτιέρας</li> <li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς επιθετικούς παράγοντες</li> <li>Στύψτε απαλά χωρίς να στρίβετε για να αποφύγετε την παραμόρφωση των βολάν</li> <li>Στεγνώστε σε επίπεδη επιφάνεια, επαναφέροντας τα βολάν στο σχήμα τους</li> <li>αποφύγετε το σιδέρωμα απευθείας πάνω στα βολάν</li> <li>Αποθηκεύστε με προσοχή για να διατηρήσετε τον όγκο των βολάν</li> </ul>
description
string<p>Αυτά τα γαλλικά εσώρουχα Cancan αιχμαλωτίζουν όλη τη μαγεία των παριζιάνικων καμπαρέ με τα <strong>καταιγιστικά βολάν</strong> τους που δημιουργούν ένα εντυπωσιακό εφέ όγκου.</p> <p>Κάθε βολάν έχει σχεδιαστεί για να <strong>τονίζει τις γενναιόδωρες καμπύλες σας</strong>, ενώ παράλληλα προσθέτει αυτή την πινελιά παιχνιδίσματος που είναι τόσο χαρακτηριστική για το στυλ του Κανκάν.</p> <p>Ο μικρός φιόγκος στρατηγικά τοποθετημένος στην κοιλότητα των οσφύων προσθέτει μια πινελιά εκλεπτυσμένης κοκεταρίας που δεν θα περάσει απαρατήρητη. Η εξαιρετική ποιότητα είναι εμφανής σε κάθε λεπτομέρεια: τα βολάν είναι τέλεια δομημένα για να διατηρούν το σχήμα τους, οι ραφές είναι αόρατες και το <strong>ύφασμα προσαρμόζεται τέλεια σε όλα τα σχήματα του σώματος</strong>.</p> <p>Αυτά τα εσώρουχα μετατρέπουν κάθε στιγμή οικειότητας σε ένα λαμπερό θέαμα, προσφέροντας <strong>βέλτιστη άνεση</strong> χάρη σε ένα μελετημένο κόψιμο που προσαρμόζεται <strong> φυσικά στο σχήμα</strong> χωρίς να υπονομεύει το εντυπωσιακό οπτικό αποτέλεσμα.</p>
guid
stringhttps://dev.divasboudoir.com/el/string-coquette-mayro/sbga7101.htm
highlights
string<ul> <li><strong>Πολλαπλά κρόσσια</strong> για εντυπωσιακό εφέ όγκου</li> <li>Αυθεντικό και λαμπερό<strong>γαλλικό στυλ Cancan</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Μεγάλο μαύρο εσώρουχο γαλλικού Cancan με διακοσμητικό φιόγκο. Παριζιάνικη γοητεία καμπαρέ υψηλής ποιότητας. Δωρεάν παράδοση από €59 στο Diva's Boudoir.
keywords
string
title
stringΓαλλικό Cancan Froufrou Culotte Grande Taille | Diva's Boudoir
seotitle
stringΓαλλικό Cancan μεγάλο μέγεθος frilly εσώρουχα μαύρο
seouri
stringstring-coquette-mayro
specifications
string<ul> <li><strong>Στυλ :</strong> Γαλλικό Cancan frilly εσώρουχα</li> <li><strong>Χρώμα :</strong> Μαύρο</li> <li><strong>Λεπτομέρειες</strong>: Πολλαπλά βολάν, διακοσμητικός φιόγκος</li> <li><strong>Κόψιμο :</strong> Ψηλή μέση με εφέ όγκου</li> <li><strong>Τελειώματα :</strong> Αόρατες ραφές, κορυφαία ποιότητα</li> </ul>
stylingtips
string<p>Το γαλλικό εσώρουχο Cancan λειτουργεί τέλεια με ένα <a href="https://www.divasboudoir.com/el/megalo-megethos-enischyth-sththoys/"><strong>push-up σουτιέν</strong></a> για να δημιουργήσει ένα λαμπερό σύνολο. Για την απόλυτη εμφάνιση καμπαρέ, συνδυάστε το με <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/"><strong>διχτυωτές κάλτσες</strong></a> και γόβες με τακούνι. Μπορούν επίσης να φορεθούν κάτω από ένα στενό φόρεμα για να δημιουργήσουν ένα εφέ έκπληξης κατά το γδύσιμο.</p> <p>Αυτά τα εσώρουχα θα μεταμορφώσουν αμέσως τη σιλουέτα σας σε μια <strong>λαμπερή pin-up</strong> αντάξια των καλύτερων παριζιάνικων καμπαρέ.</p>
summary
string<p>Το γαλλικό εσώρουχο Cancan αναβιώνει το γοητευτικό πνεύμα των παριζιάνικων καμπαρέ με τα πολλαπλά κρόσσια και τον μικρό άτακτο φιόγκο.</p> <p>Ένα παιχνιδιάρικο κομμάτι που αναδεικνύει τις καμπύλες σας με ακαταμάχητη γοητεία και εξαιρετική ποιότητα.</p>
title
stringCulotte French Cancan - Το γοητευτικό πνεύμα των διακοσμητικών στοιχείων
usageinstructions
string<p>Για να φορέσετε το εσώρουχό σας Γαλλικού Κανάν, προχωρήστε με λεπτότητα, σεβόμενοι τη δομή των φραμπαλάδων. Αφού τοποθετήσετε τα βολάν στη θέση τους, ρυθμίστε ελαφρώς τα βολάν για να πετύχετε το επιθυμητό αποτέλεσμα όγκου.</p> <p>Αυτά τα εσώρουχα είναι ιδανικά για να τα φοράτε με <strong>ρούχα που</strong> αναδεικνύουν τη θεαματική τους πλευρά - σκεφτείτε κοντές φούστες ή εφαρμοστά φορέματα που αναδεικνύουν τα βολάν.</p> <p>Ο <strong>μικρός φιόγκος στο πίσω μέρος</strong> προσθέτει μια άτακτη έκπληξη που είναι ιδανική για προσωπικές στιγμές.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water to preserve the structure of the frills</li> <li>Use a mild detergent without aggressive agents</li> <li>Press gently without twisting to avoid distorting the ruffles</li> <li>Dry flat, bringing frills back into shape</li> <li>avoid ironing directly on ruffles</li> <li>Store with care to maintain ruffle volume</li> </ul>
description
string<p>These French Cancan panties capture all the magic of Parisian cabarets with <strong>cascading frills</strong> that create a spectacular volume effect.</p> <p>Each ruffle has been designed to <strong>enhance your generous curves</strong>, while adding that touch of playfulness so characteristic of the cancan style.</p> <p>The little bow strategically placed in the hollow of the loins adds a note of refined coquetry that won't go unnoticed. Exceptional quality is evident in every detail: the frills are perfectly structured to keep their shape, the seams are invisible and the <strong>fabric adapts perfectly to all morphologies</strong>.</p> <p>These panties transform every moment of intimacy into a glamorous spectacle, offering <strong>optimum comfort</strong> thanks to a studied cut that <strong> naturally hugs the shape</strong> without compromising the striking visual effect.</p>
guid
stringhttps://dev.divasboudoir.com/en/string-coquette-black/sbga7101.htm
highlights
string<ul> <li><strong>Multiple frills</strong> for spectacular volume effect</li> <li>Authentic and glamorous<strong>French Cancan style</strong></li> <li><strong>Decorative bow</strong> in the hollow of the loins</li> <li><strong>Premium quality</strong> with meticulous finishing</li> <li><strong>Flattering cut</strong> enhances generous curves</li> <li><strong>Optimum comfort</strong> despite voluminous design</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBlack frilly French Cancan plus size panty with decorative bow. Premium-quality Parisian cabaret glamour. Free delivery from 59€ at Diva's Boudoir.
keywords
string
title
stringCulotte Froufrous French Cancan Plus Size | Diva's Boudoir
seotitle
stringPlus size frilly panties French Cancan black
seouri
stringstring-coquette-black
specifications
string<ul> <li><strong>Style:</strong> French Cancan frilly panties</li> <li><strong>Color:</strong> Black</li> <li><strong>Details:</strong> Multiple ruffles, decorative bow</li> <li><strong>Cut:</strong> High waist with volume effect</li> <li><strong>Finishes:</strong> Invisible seams, premium quality</li> </ul>
stylingtips
string<p>French Cancan panties pair perfectly with a <a href="https://www.divasboudoir.com/en/large-size-breast-stand/"><strong>push-up bra</strong></a> to create a complete glamorous ensemble. For the ultimate cabaret look, pair with <a href="https://www.divasboudoir.com/en/socks-large-size/"><strong>fishnet stockings</strong></a> and heeled pumps. They can also be worn under a tight dress to create a surprise effect when undressing.</p> <p>These panties instantly transform your figure into a <strong>glamorous pin-up</strong> worthy of the finest Parisian cabarets.</p>
summary
string<p>The French Cancan panty revisits the glamorous spirit of Parisian cabarets with its multiple frills and saucy little bow.</p> <p>A playful piece that enhances your curves with irresistible charm and exceptional quality.</p>
title
stringCulotte French Cancan - The glamorous spirit of frills
usageinstructions
string<p>To slip on your French Cancan panties, proceed gently, respecting the structure of the frills. Once in place, adjust the ruffles slightly to achieve the desired volume effect.</p> <p>These panties are ideal for <strong>outfits that</strong> show off their spectacular side - think short skirts or fitted dresses that show off the frills.</p> <p>The <strong>little bow in the back</strong> adds a naughty surprise perfect for intimate moments.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano en agua fr&iacute;a para preservar la estructura de los volantes</li> <li>Utilizar un detergente suave sin agentes agresivos</li> <li>Planchar suavemente sin retorcer para no deformar los volantes</li> <li>Secar en plano, dando forma a los volantes</li> <li>evitar planchar directamente sobre los volantes</li> <li>Guardar con cuidado para mantener el volumen de los volantes</li> </ul>
description
string<p>Estas braguitas de canc&aacute;n franc&eacute;s capturan toda la magia de los cabarets parisinos con sus <strong>volantes en cascada</strong> que crean un espectacular efecto de volumen.</p> <p>Cada volante ha sido dise&ntilde;ado para <strong>realzar tus generosas curvas</strong>, al tiempo que a&ntilde;ade ese toque juguet&oacute;n tan caracter&iacute;stico del estilo canc&aacute;n.</p> <p>El lacito estrat&eacute;gicamente colocado en el hueco del lomo a&ntilde;ade un toque de refinada coqueter&iacute;a que no pasar&aacute; desapercibido. La calidad excepcional se manifiesta en cada detalle: los volantes est&aacute;n perfectamente estructurados para conservar su forma, las costuras son invisibles y el <strong>tejido se adapta perfectamente a todas las formas del cuerpo</strong>.</p> <p>Estas braguitas convierten cada momento de intimidad en un espect&aacute;culo de glamour, ofreciendo <strong>un confort &oacute;ptimo</strong> gracias a un corte estudiado que <strong> se amolda naturalmente a la forma</strong> sin comprometer el impactante efecto visual.</p>
guid
stringhttps://dev.divasboudoir.com/es/tanga-coquette-negro/sbga7101.htm
highlights
string<ul> <li><strong>M&uacute;ltiples volantes</strong> para un efecto volumen espectacular</li> <li>Aut&eacute;ntico y glamuroso<strong>estilo canc&aacute;n franc&eacute;s</strong></li> <li><strong>Peque&ntilde;o lazo decorativo</strong> en el hueco del lomo</li> <li><strong>Calidad superior</strong> con meticulosos acabados</li> <li><strong>Corte favorecedor</strong> para realzar las curvas generosas</li> <li><strong>Comodidad &oacute;ptima</strong> a pesar de su voluminoso dise&ntilde;o</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringBraga francesa Cancan negra con volantes y lazo decorativo. Glamour de cabaret parisino de primera calidad. Envío gratuito a partir de 59 € en Diva's Boudoir.
keywords
string
title
stringFrench Cancan Froufrou Culotte talla grande | Diva's Boudoir
seotitle
stringCancan francés talla grande bragas con volantes negro
seouri
stringtanga-coquette-negro
specifications
string<ul> <li><strong>Estilo :</strong> Braga con volantes French Cancan</li> <li><strong>Color :</strong> Negro</li> <li><strong>Detalles :</strong> M&uacute;ltiples volantes, lazo decorativo</li> <li><strong>Corte :</strong> Cintura alta con efecto volumen</li> <li><strong>Acabados :</strong> Costuras invisibles, calidad superior</li> </ul>
stylingtips
string<p>Las bragas French Cancan combinan a la perfecci&oacute;n con un <a href="https://www.divasboudoir.com/es/sujetadores-abiertos-curvys/"><strong>sujetador push-up</strong></a> para crear un conjunto glamuroso. Para un look de cabaret a la &uacute;ltima, comb&iacute;nalas con <a href="https://www.divasboudoir.com/es/medias-grandes/"><strong>medias de rejilla</strong></a> y zapatos de tac&oacute;n. Tambi&eacute;n se pueden llevar debajo de un vestido ajustado para crear un efecto sorpresa al desvestirse.</p> <p>Estas bragas transformar&aacute;n instant&aacute;neamente su figura en una <strong>glamurosa pin-up</strong> digna de los mejores cabarets parisinos.</p>
summary
string<p>La braguita French Cancan revisita el esp&iacute;ritu glamuroso de los cabarets parisinos con sus m&uacute;ltiples volantes y su lacito travieso.</p> <p>Una pieza l&uacute;dica que realza tus curvas con un encanto irresistible y una calidad excepcional.</p>
title
stringCulotte French Cancan - El glamuroso espíritu de los volantes
usageinstructions
string<p>Para colocar la braguita French Cancan, proceda con delicadeza, respetando la estructura de los volantes. Una vez colocadas, ajuste ligeramente los volantes para conseguir el efecto de volumen deseado.</p> <p>Estas braguitas son ideales para llevar con <strong>conjuntos que</strong> muestren su lado espectacular: piense en faldas cortas o vestidos entallados que dejen ver los volantes.</p> <p>El <strong>lacito de la parte trasera</strong> a&ntilde;ade una traviesa sorpresa perfecta para los momentos &iacute;ntimos.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide pour pr&eacute;server la structure des froufrous</li> <li>Utiliser une lessive douce sans agents agressifs</li> <li>Presser d&eacute;licatement sans tordre pour &eacute;viter de d&eacute;former les volants</li> <li>S&eacute;chage &agrave; plat en remettant les froufrous en forme</li> <li>&Eacute;viter le repassage direct sur les volants</li> <li>Ranger avec pr&eacute;caution pour maintenir le volume des froufrous</li> </ul>
description
string<p>Cette culotte French Cancan capture toute la magie des cabarets parisiens avec ses <strong>froufrous cascadants</strong> qui cr&eacute;ent un effet de volume spectaculaire.</p> <p>Chaque volant a &eacute;t&eacute; pens&eacute; pour&nbsp;<strong>sublimer vos courbes g&eacute;n&eacute;reuses</strong> tout en apportant cette touche d'espi&egrave;glerie si caract&eacute;ristique du style cancan.</p> <p>Le petit n&oelig;ud plac&eacute; strat&eacute;giquement dans le creux des reins ajoute une note de coquetterie raffin&eacute;e qui ne passe pas inaper&ccedil;ue. La qualit&eacute; exceptionnelle se ressent dans chaque d&eacute;tail : les froufrous sont parfaitement structur&eacute;s pour garder leur forme, les coutures sont invisibles et le&nbsp;<strong>tissu s'adapte parfaitement &agrave; toutes les morphologies</strong>.</p> <p>Cette culotte transforme chaque moment d'intimit&eacute; en spectacle glamour, offrant un&nbsp;<strong>confort optimal</strong> gr&acirc;ce &agrave; sa coupe &eacute;tudi&eacute;e qui <strong>&eacute;pouse naturellement les formes</strong> sans compromettre l'effet visuel saisissant.</p>
guid
stringhttps://dev.divasboudoir.com/fr/culotte-grande-taille-frech-cancan/sbga7101.htm
highlights
string<ul> <li><strong>Froufrous multiples</strong> pour un effet volume spectaculaire</li> <li><strong>Style French Cancan</strong> authentique et glamour</li> <li><strong>Petit n&oelig;ud d&eacute;coratif</strong> dans le creux des reins</li> <li><strong>Qualit&eacute; premium</strong> avec finitions soign&eacute;es</li> <li><strong>Coupe flatteuse</strong> qui sublime les courbes g&eacute;n&eacute;reuses</li> <li><strong>Confort optimal</strong> malgr&eacute; le design volumineux</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCulotte French Cancan grande taille à froufrous noire avec nœud décoratif. Style glamour cabaret parisien de qualité premium. Livraison gratuite dès 59€ chez Diva's Boudoir.
keywords
string
title
stringCulotte Froufrous French Cancan Grande Taille | Diva's Boudoir
seotitle
stringCulotte grande taille à froufrous French Cancan noire
seouri
stringculotte-grande-taille-frech-cancan
specifications
string<ul> <li><strong>Style :</strong> Culotte &agrave; froufrous French Cancan</li> <li><strong>Couleur :</strong> Noir</li> <li><strong>D&eacute;tails :</strong> Multiples volants, n&oelig;ud d&eacute;coratif</li> <li><strong>Coupe :</strong> Taille haute avec effet volume</li> <li><strong>Finitions :</strong> Coutures invisibles, qualit&eacute; premium</li> </ul>
stylingtips
string<p>La culotte French Cancan se marie parfaitement avec un <a href="https://www.divasboudoir.com/fr/redresse-seins-grande-taille/"><strong>soutien-gorge push-up</strong></a> pour cr&eacute;er un ensemble glamour complet. Pour un look cabaret assum&eacute;, associez-la &agrave; des <a href="https://www.divasboudoir.com/fr/bas-grande-taille/"><strong>bas r&eacute;sille</strong></a> et des escarpins &agrave; talons. Elle peut aussi se porter sous une robe moulante pour cr&eacute;er un effet de surprise lors du d&eacute;shabillage.&nbsp;</p> <p>Cette culotte transforme instantan&eacute;ment votre silhouette en&nbsp;<strong>pin-up glamour</strong> digne des plus beaux cabarets parisiens.</p>
summary
string<p>La culotte French Cancan revisite l'esprit glamour des cabarets parisiens avec ses multiples froufrous et son petit n&oelig;ud coquin.</p> <p>Une pi&egrave;ce espi&egrave;gle qui sublime vos courbes avec un charme irr&eacute;sistible et une qualit&eacute; exceptionnelle.</p>
title
stringCulotte French Cancan - L'esprit glamour des froufrous
usageinstructions
string<p>Pour enfiler votre culotte French Cancan, proc&eacute;dez d&eacute;licatement en respectant la structure des froufrous. Une fois en place, ajustez l&eacute;g&egrave;rement les volants pour obtenir l'effet de volume d&eacute;sir&eacute;.</p> <p>Cette culotte se porte id&eacute;alement avec des&nbsp;<strong>tenues qui mettent en valeur</strong> son c&ocirc;t&eacute; spectaculaire - pensez aux jupes courtes ou aux robes ajust&eacute;es qui laissent entrevoir les froufrous.</p> <p>Le&nbsp;<strong>petit n&oelig;ud dans le dos</strong> ajoute une surprise coquine parfaite pour les moments intimes.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano in acqua fredda per preservare la struttura dei fronzoli</li> <li>Utilizzare un detergente delicato senza agenti aggressivi</li> <li>Stirare delicatamente senza torcere per evitare di deformare le balze</li> <li>Asciugare in piano, riportando le balze in forma</li> <li>evitare di stirare direttamente sulle balze</li> <li>Conservare con cura per mantenere il volume dei volant</li> </ul>
description
string<p>Queste mutandine francesi Cancan catturano tutta la magia dei cabaret parigini con le loro <strong>balze a cascata</strong> che creano uno spettacolare effetto volume.</p> <p>Ogni volant è stato progettato per <strong>esaltare le vostre curve generose</strong>, aggiungendo quel tocco di giocosità così caratteristico dello stile cancan.</p> <p>Il piccolo fiocco strategicamente posizionato nell'incavo dei lombi aggiunge un tocco di raffinata civetteria che non passerà inosservato. L'eccezionale qualità è evidente in ogni dettaglio: le balze sono perfettamente strutturate per mantenere la forma, le cuciture sono invisibili e il <strong>tessuto si adatta perfettamente a tutte le forme del corpo</strong>.</p> <p>Queste mutandine trasformano ogni momento di intimità in uno spettacolo glamour, offrendo un <strong>comfort ottimale</strong> grazie a un taglio studiato che <strong> si modella naturalmente alle forme</strong> senza compromettere il suggestivo effetto visivo.</p>
guid
stringhttps://dev.divasboudoir.com/it/perizoma-coquette-nero/sbga7101.htm
highlights
string<ul> <li><strong>Balze multiple</strong> per un effetto volume spettacolare</li> <li>Autentico e affascinante<strong>stile francese Cancan</strong> </li> <li><strong>Piccolo fiocco decorativo</strong> nell'incavo dei lombi</li> <li><strong>Qualità premium</strong> con finiture meticolose</li> <li><strong>Taglio lusinghiero</strong> per esaltare le curve generose</li> <li><strong>Comfort ottimale</strong> nonostante il design voluminoso</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrande mutandina francese a balze in nero con fiocco decorativo. Glamour parigino da cabaret di qualità superiore. Consegna gratuita a partire da 59 € su Diva's Boudoir.
keywords
string
title
stringCulotte French Cancan Froufrou Taglia Grande | Diva's Boudoir
seotitle
stringFrench Cancan mutandine a balze taglia grande nero
seouri
stringperizoma-coquette-nero
specifications
string<ul> <li><strong>Stile :</strong> Mutandine a balze French Cancan</li> <li><strong>Colore :</strong> nero</li> <li><strong>Dettagli :</strong> Volant multipli, fiocco decorativo</li> <li><strong>Taglio :</strong> Vita alta con effetto volume</li> <li><strong>Finiture :</strong> Cuciture invisibili, qualità superiore</li> </ul>
stylingtips
string<p>Le mutandine French Cancan si abbinano perfettamente a un <a href="https://www.divasboudoir.com/it/reggiseni-di-grandi-dimensioni/"><strong>reggiseno push-up</strong></a> per creare un insieme glamour. Per un look da cabaret, abbinatele a <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/"><strong>calze a rete</strong></a> e a décolleté con tacco. Possono anche essere indossate sotto un abito attillato per creare un effetto sorpresa quando ci si spoglia.</p> <p>Queste mutandine trasformeranno immediatamente la vostra figura in una <strong>pin-up glamour</strong> degna dei migliori cabaret parigini.</p>
summary
string<p>La mutandina French Cancan rivisita lo spirito glamour dei cabaret parigini con le sue molteplici balze e il suo fiocchetto birichino.</p> <p>Un capo giocoso che esalta le vostre curve con un fascino irresistibile e una qualità eccezionale.</p>
title
stringCulotte French Cancan - Lo spirito glamour dei fronzoli
usageinstructions
string<p>Per infilare la mutandina French Cancan, procedere con delicatezza, rispettando la struttura dei volant. Una volta posizionate, regolate leggermente le balze per ottenere l'effetto volume desiderato.</p> <p>Queste mutandine sono ideali per essere indossate con <strong>outfit che</strong> ne mettano in risalto il lato spettacolare, come gonne corte o abiti aderenti che mettano in evidenza le balze.</p> <p>Il <strong>piccolo fiocco sul retro</strong> aggiunge una sorpresa maliziosa, perfetta per i momenti di intimità.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Handwas in koud water om de structuur van de franjes te behouden</li> <li>Gebruik een mild wasmiddel zonder agressieve middelen</li> <li>Voorzichtig persen zonder te draaien om te voorkomen dat de ruches vervormen</li> <li>Droog plat en breng de ruches weer in vorm</li> <li>vermijd rechtstreeks op de ruches te strijken</li> <li>Bewaar ze voorzichtig om het volume van de ruches te behouden</li> </ul>
description
string<p>Deze Franse Cancan slips hebben alle magie van de Parijse cabarets met hun <strong>trapsgewijze ruches</strong> die een spectaculair volume-effect cre&euml;ren.</p> <p>Elke ruche is ontworpen om <strong>je royale rondingen te accentueren</strong> en tegelijkertijd dat vleugje speelsheid toe te voegen dat zo kenmerkend is voor de cancan stijl.</p> <p>Het strikje dat strategisch in de holte van de lendenen is geplaatst, voegt een vleugje geraffineerde koketterie toe dat niet onopgemerkt zal blijven. De uitzonderlijke kwaliteit is zichtbaar in elk detail: de franjes zijn perfect gestructureerd om hun vorm te behouden, de naden zijn onzichtbaar en de <strong>stof past zich perfect aan alle lichaamsvormen</strong> aan.</p> <p>Deze slips maken van elk intimiteitsmoment een glamoureus spektakel en bieden <strong>optimaal comfort</strong> dankzij een bestudeerde snit die <strong> zich op natuurlijke wijze naar de vorm vormt</strong> zonder afbreuk te doen aan het opvallende visuele effect.</p>
guid
stringhttps://dev.divasboudoir.com/nl/string-coquette-zwart/sbga7101.htm
highlights
string<ul> <li><strong>Meerdere ruches</strong> voor een spectaculair volume-effect</li> <li>Authentieke en glamoureuze<strong>Franse Cancan stijl</strong></li> <li><strong>Kleine decoratieve strik</strong> in de holte van de lendenen</li> <li><strong>Topkwaliteit</strong> met zorgvuldige afwerking</li> <li><strong>Flatterende snit</strong> om royale rondingen te benadrukken</li> <li><strong>Optimaal comfort</strong> ondanks het volumineuze ontwerp</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringGrote zwarte Cancan panty met franje en decoratieve strik. Parijse cabaretglamour van topkwaliteit. Gratis bezorging vanaf €59 bij Diva's Boudoir.
keywords
string
title
stringFranse Cancan Froufrou Culotte Grote Maat | Diva's Boudoir
seotitle
stringFranse Cancan grote maat frilly slip zwart
seouri
stringstring-coquette-zwart
specifications
string<ul> <li><strong>Stijl :</strong> Frans Cancan frilly slipje</li> <li><strong>Kleur :</strong> Zwart</li> <li><strong>Details :</strong> Meerdere ruches, decoratieve strik</li> <li><strong>Snit :</strong> Hoge taille met volume effect</li> <li><strong>Afwerking :</strong> Onzichtbare naden, premium kwaliteit</li> </ul>
stylingtips
string<p>De French Cancan onderbroek werkt perfect in combinatie met een <a href="https://www.divasboudoir.com/nl/grote-maat-borstvergroter/"><strong>push-up bh</strong></a> om een glamoureus ensemble te cre&euml;ren. Voor de ultieme cabaretlook combineer je ze met <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/"><strong>netkousen</strong></a> en pumps met hak. Je kunt ze ook onder een strakke jurk dragen voor een verrassingseffect bij het uitkleden.</p> <p>Deze slips transformeren je figuur in een <strong>glamoureuze pin-up</strong> die de mooiste Parijse cabarets waardig is.</p>
summary
string<p>De Franse Cancan-panty brengt de glamoureuze geest van de Parijse cabarets terug met zijn vele franjes en ondeugende strikje.</p> <p>Een speels stuk dat je rondingen benadrukt met onweerstaanbare charme en uitzonderlijke kwaliteit.</p>
title
stringCulotte French Cancan - De glamoureuze geest van franje
usageinstructions
string<p>Om je French Cancan slip aan te trekken, ga je voorzichtig te werk en respecteer je de structuur van de ruches. Eenmaal op zijn plaats, pas je de ruches een beetje aan om het gewenste volume-effect te krijgen.</p> <p>Deze slips zijn ideaal om te dragen bij <strong>outfits die</strong> hun spectaculaire kant laten zien - denk aan korte rokjes of getailleerde jurken waarin de ruches goed uitkomen.</p> <p>Het <strong>strikje achteraan</strong> zorgt voor een ondeugende verrassing die perfect is voor intieme momenten.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão em água fria para preservar a estrutura dos folhos</li> <li>Utilizar um detergente suave sem agentes agressivos</li> <li>Pressionar suavemente sem torcer para não deformar os folhos</li> <li>Secar na horizontal, dando forma aos folhos</li> <li>evitar passar a ferro diretamente sobre os folhos</li> <li>Guardar com cuidado para manter o volume dos folhos</li> </ul>
description
string<p>Estas cuecas French Cancan captam toda a magia dos cabarés parisienses com os seus <strong>folhos em cascata</strong> que criam um efeito de volume espetacular.</p> <p>Cada folho foi concebido para <strong>realçar as suas curvas generosas</strong>, acrescentando aquele toque de brincadeira tão caraterístico do estilo cancan.</p> <p>O pequeno laço estrategicamente colocado no côncavo dos lombos acrescenta um toque de coqueteria refinada que não passará despercebido. A qualidade excecional é evidente em cada detalhe: os folhos são perfeitamente estruturados para manter a sua forma, as costuras são invisíveis e o <strong>tecido adapta-se perfeitamente a todas as formas do corpo</strong>.</p> <p>Estas cuecas transformam cada momento de intimidade num espetáculo glamoroso, oferecendo <strong>um conforto ótimo</strong> graças a um corte estudado que <strong> se molda naturalmente à forma</strong> sem comprometer o efeito visual marcante.</p>
guid
stringhttps://dev.divasboudoir.com/pt/fio-dental-coquette-preto/sbga7101.htm
highlights
string<ul> <li><strong>Vários folhos</strong> para um efeito de volume espetacular</li> <li>Autêntico e glamoroso<strong>estilo francês Cancan</strong> </li> <li><strong>Pequeno laço decorativo</strong> no côncavo dos lombos</li> <li><strong>Qualidade superior</strong> com acabamentos meticulosos</li> <li><strong>Corte lisonjeiro</strong> para realçar as curvas generosas</li> <li><strong>Ótimo conforto</strong> apesar do design volumoso</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringCuecas francesas grandes, pretas, com folhos e laço decorativo. Glamour de cabaré parisiense de qualidade superior. Entrega gratuita a partir de 59 € na Diva's Boudoir.
keywords
string
title
stringFrench Cancan Froufrou Culotte Grande Taille | Diva's Boudoir
seotitle
stringFrench Cancan cuecas com folhos tamanho grande preto
seouri
stringfio-dental-coquette-preto
specifications
string<ul> <li><strong>Estilo :</strong> Calcinhas com folhos French Cancan</li> <li><strong>Cor :</strong> Preto</li> <li><strong>Detalhes :</strong> Vários folhos, laço decorativo</li> <li><strong>Corte :</strong> Cintura alta com efeito de volume</li> <li><strong>Acabamentos :</strong> Costuras invisíveis, qualidade superior</li> </ul>
stylingtips
string<p>As cuecas French Cancan funcionam perfeitamente com um <a href="https://www.divasboudoir.com/pt/sutias-abertos-curvys/"><strong>sutiã push-up</strong></a> para criar um conjunto glamoroso. Para o derradeiro look de cabaré, combine-as com <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/"><strong>meias de rede</strong></a> e sapatos de salto alto. Também podem ser usadas por baixo de um vestido justo para criar um efeito surpresa ao despir-se.</p> <p>Estas cuecas transformarão instantaneamente a sua figura numa <strong>pin-up glamorosa</strong> digna dos melhores cabarés parisienses.</p>
summary
string<p>A cueca French Cancan revisita o espírito glamoroso dos cabarés parisienses com os seus múltiplos folhos e o seu pequeno laço maroto.</p> <p>Uma peça divertida que realça as suas curvas com um charme irresistível e uma qualidade excecional.</p>
title
stringCulotte French Cancan - O espírito glamoroso dos folhos
usageinstructions
string<p>Para vestir as suas cuecas French Cancan, proceda com delicadeza, respeitando a estrutura dos folhos. Uma vez no sítio, ajuste ligeiramente os folhos para obter o efeito de volume desejado.</p> <p>Estas cuecas são ideais para usar com <strong>roupas que</strong> mostrem o seu lado espetacular - pense em saias curtas ou vestidos justos que mostrem os folhos.</p> <p>O <strong>pequeno laço na parte de trás</strong> acrescenta uma surpresa marota que é perfeita para momentos íntimos.</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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-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-coquette-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringculotte volants noirs P5308-1
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
stringDBC2C4F2-FC73-4411-B00F499EF117FF0B
promountil
string
rating
stringnone
recorduid
stringDBC2C4F2-FC73-4411-B00F499EF117FF0B
reference
stringSBGA7101
related
string
reserved
number0
returned
number0
returnsallowed
number1
section
stringlingerie
shipment
string5to7days
showbrand
number0
sizeinfos
Query
Template: /system/api/product/sizes.cfc:20
Execution Time: 1.88 ms
Record Count: 14
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,'2308,2309,2310,2367,2311,2374,2379') > 0
and product_variations.productuid = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
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
123672XL+intlsizeblack2XL+2XL+-19999990wpluslingerie2XL2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50114-11898-104120-126
223672XL+intlsizered2XL+2XL+-19999990wpluslingerie2XL2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50114-11898-104120-126
323743XL-intlsizeblack3XL-19999991wpluslingerie3XL3XL-52-5422-2426-2854-5654-5652-5458-6054-5652-54118-124104-108126-136
423743XL-intlsizered3XL-19999990wpluslingerie3XL3XL-52-5422-2426-2854-5654-5652-5458-6054-5652-54118-124104-108126-136
52308LintlsizeblackLL-19999990wpluslingerieLL40-4210-1214-1642-4442-4440-4244-4642-4440-4292-10074-8298-106
62308LintlsizeredLL-19999990wpluslingerieLL40-4210-1214-1642-4442-4440-4244-4642-4440-4292-10074-8298-106
72309XLintlsizeblackXLXL-19999990wpluslingerieXLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46102-10886-92108-114
82309XLintlsizeredXLXL-19999990wpluslingerieXLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46102-10886-92108-114
923102XLintlsizered2XL2XL-19999990wpluslingerie2XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48108-11492-98114-120
1023102XLintlsizeblack2XL2XL-19999990wpluslingerie2XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48108-11492-98114-120
1123113XLintlsizeblack3XL3XL-19999991wpluslingerie3XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52114-11898-104120-126
1223113XLintlsizered3XL3XL-19999990wpluslingerie3XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52114-11898-104120-126
1323794XLintlsizered4XL4XL-19999990wpluslingerie4XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56124-130108-114136-146
1423794XLintlsizeblack4XL4XL-19999990wpluslingerie4XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56124-130108-114136-146
sizeranges
stringplus
sizes
string2308,2309,2310,2367,2311,2374,2379
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
number1
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 53.8 ms
Record Count: 10
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2308
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2309
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2310
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2367
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2311
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2374
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2379
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
1DBC2C4F2-FC73-4411-B00F499EF117FF0BB4A2E176-9CF4-4B87-9592A312014B6B2A2308black#000000LL40-4210-1214-1642-4442-4440-4244-4642-4440-42wlingerieLintlsize29.12520.7917STOCK01000-10000P5308-1-10all
2DBC2C4F2-FC73-4411-B00F499EF117FF0BBA6D86D8-7675-46BA-86FA95A89606C4112308red#F50000LL40-4210-1214-1642-4442-4440-4244-4642-4440-42wlingerieLintlsize29.12520.7917STOCK01000-10000-10all
3DBC2C4F2-FC73-4411-B00F499EF117FF0B1927364A-F968-45F1-AF3C2C8657AD0CED2309black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize29.12520.7917STOCK01000-10100P5308-1-10all
4DBC2C4F2-FC73-4411-B00F499EF117FF0B267174BB-24DE-4F3F-A066C12E25D5BAFE2309red#F50000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize29.12520.7917STOCK01000-10000-10all
5DBC2C4F2-FC73-4411-B00F499EF117FF0B96FA47A4-B05A-4277-B636B2A04BA21B722310black#0000002XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12520.7917STOCK01000-10000P5308-1-10all
6DBC2C4F2-FC73-4411-B00F499EF117FF0B7F21BD43-7671-4130-82928E9A3C0B6BBC2310red#F500002XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12520.7917STOCK01000-10000-10all
7DBC2C4F2-FC73-4411-B00F499EF117FF0B833F0F45-1CCF-44E5-8F7BFEFB4238719D2311black#0000003XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie3XLintlsize29.12520.7917STOCK01100-10100P5308-111all
8DBC2C4F2-FC73-4411-B00F499EF117FF0B42CE5A3C-6848-4280-B427DD037F04E2202311red#F500003XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie3XLintlsize29.12520.7917STOCK01000-10000-10all
9DBC2C4F2-FC73-4411-B00F499EF117FF0B1ADD0FD7-6645-4044-972B41E3A2CD8EE52379black#0000004XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie4XLintlsize29.12520.7917STOCK01000-10000-10all
10DBC2C4F2-FC73-4411-B00F499EF117FF0B507314A2-CB38-4FDC-9CC3D8231E8294BE2379red#F500004XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie4XLintlsize29.12520.7917STOCK01000-10000-10all
subcategory
stringsexypanty
supplier
number-1
supplierreference
stringP5308
tags
string
themes
stringsexystrings
totalvariations
number12
type
stringdefault
unitprice
number20.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 20.4 ms
Record Count: 14
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2308
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2309
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2310
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2367
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2311
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2374
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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B' 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 = 'DBC2C4F2-FC73-4411-B00F499EF117FF0B'
and product_variations.isactive = 1
and product_sizes.id_size = 2379
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
196FA47A4-B05A-4277-B636B2A04BA21B722367black#0000002XL2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie2XL+intlsize29.12520.7917STOCK01000-10000P5308-1-10-10-11120.7917all
27F21BD43-7671-4130-82928E9A3C0B6BBC2367red#F500002XL2XL+48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie2XL+intlsize29.12520.7917STOCK01000-10000-10-10-10120.7917all
3833F0F45-1CCF-44E5-8F7BFEFB4238719D2374black#0000003XL3XL-52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie3XL-intlsize29.12520.7917STOCK01100-10100P5308-111-11-11120.7917all
442CE5A3C-6848-4280-B427DD037F04E2202374red#F500003XL3XL-52-5422-2426-2854-5654-5652-5458-6054-5652-54wlingerie3XL-intlsize29.12520.7917STOCK01000-10000-10-11-10120.7917all
5B4A2E176-9CF4-4B87-9592A312014B6B2A2308black#000000LL40-4210-1214-1642-4442-4440-4244-4642-4440-42wlingerieLintlsize29.12520.7917STOCK01000-10000P5308-1-10-10-11120.7917all
6BA6D86D8-7675-46BA-86FA95A89606C4112308red#F50000LL40-4210-1214-1642-4442-4440-4244-4642-4440-42wlingerieLintlsize29.12520.7917STOCK01000-10000-10-10-10120.7917all
71927364A-F968-45F1-AF3C2C8657AD0CED2309black#000000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize29.12520.7917STOCK01000-10100P5308-1-10-10-11120.7917all
8267174BB-24DE-4F3F-A066C12E25D5BAFE2309red#F50000XLXL44-4614-1618-2046-4846-4844-4650-5246-4844-46wlingerieXLintlsize29.12520.7917STOCK01000-10000-10-10-10120.7917all
996FA47A4-B05A-4277-B636B2A04BA21B722310black#0000002XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12520.7917STOCK01000-10000P5308-1-10-10-11120.7917all
107F21BD43-7671-4130-82928E9A3C0B6BBC2310red#F500002XL2XL46-4816-1820-2448-5048-5046-4852-5448-5046-48wlingerie2XLintlsize29.12520.7917STOCK01000-10000-10-10-10120.7917all
11833F0F45-1CCF-44E5-8F7BFEFB4238719D2311black#0000003XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie3XLintlsize29.12520.7917STOCK01100-10100P5308-111-11-11120.7917all
1242CE5A3C-6848-4280-B427DD037F04E2202311red#F500003XL3XL50-5220-2224-2652-5452-5450-5256-5852-5450-52wlingerie3XLintlsize29.12520.7917STOCK01000-10000-10-11-10120.7917all
131ADD0FD7-6645-4044-972B41E3A2CD8EE52379black#0000004XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie4XLintlsize29.12520.7917STOCK01000-10000-10-10-11120.7917all
14507314A2-CB38-4FDC-9CC3D8231E8294BE2379red#F500004XL4XL54-5624-2628-3056-5856-5854-5660-6256-5854-56wlingerie4XLintlsize29.12520.7917STOCK01000-10000-10-10-10120.7917all
vatrate
number20
warehouse
number1