Mi cesta

❌
Total de artículos
Ver cesta
Menú
Ver tallas
V-String Lana Dentelle - Sutil seducción y transparencia
Doble clic para ampliar
SKU: SBGA7831
V-String Lana Dentelle - Sutil seducción y transparencia
Promo
Stock:

El tanga en V Lana de encaje extra transparente es pura seducción sutil Su favorecedor corte en V realza las curvas generosas y su encaje ultrafino deja al descubierto la cantidad justa.

El secreto para volver loca de deseo a tu pareja.

Puntos destacados

  • Encaje extra transparente - Revela sutilmente la piel
  • Favorecedor corte en V - Realza la figura de forma natural
  • Prácticamente sin costuras - Se adapta perfectamente a las curvas
  • Forro de algodón suave - Comodidad óptima durante todo el día
  • Tejido transpirable - Ligereza y frescor garantizados
  • Efecto seductor - Realiza la mitad del trabajo de seducción
Talla:

¿No sabe qué talla elegir? Consulte nuestra guía de tallas

Color:
Cantidad:
17.95 € 12.95 €
Envío rápido
para los impacientes...
Ayuda y consejos
por chat, facebook o correo electrónico
Devoluciones gratuitas
en un plazo de 15 días *

Tanga talla grande encaje transparente Tanga en V Lana

Descripción del producto

El string en V Lana es el arma secreta de la seducción El encaje extra azul-petróleoe juega con la mirada, revelando lo justo para encender la imaginación. Su exclusivo corte en V se adapta a todas las formas del cuerpo y crea una silueta impresionante.
Lo mejor es que apenas se siente en la piel. El tejido ultraligero y transpirable hace que te olvides de que lo llevas puesto, mientras que el corte casi sin costuras abraza tu silueta como una segunda piel. El suave forro de algodón añade ese toque extra de comodidad que marca la diferencia.
Esta pieza hace literalmente la mitad del trabajo de seducción. Con este tanga, todo lo que tienes que hacer es ser tú misma: el resto depende de la magia del encaje transparente. Te garantizamos que dejarás a tu pareja con ganas de más
Su diseño se adapta a todas las figuras, por lo que resulta favorecedor al instante, convirtiendo cada momento íntimo en un instante de pura sensualidad.

Detalles técnicos

  • Material: 88% nailon, 12% elastán
  • Forro: Algodón suave
  • Estilo: Tanga en V de encaje blanco y negro
  • Ajuste: Prácticamente sin costuras
  • Efecto: Sutil seducción y provocación
  • Comodidad : Ligero y transpirable

Tallas disponibles

Disponible de XL+ a 3X/4X

Color disponible

Negro

Guía de tallas

Comprueba cuál es tu talla

Internacional
  • Pecho
  • Talla
  • Caderas
XL+
  • 104-110
  • 86-91
  • 112-120
1X/2X-
  • 104-110
  • 86-91
  • 112-120
3X/4X+
  • 128-132
  • 102-108
  • 132-138
XL
  • 99-104
  • 81-86
  • 107-112
1X/2X
  • 112-118
  • 92-96
  • 122-128
3X/4X
  • 120-128
  • 98-102
  • 128-132

Consejos de cuidado

  • Lavar a mano sólo con agua fría
  • Utilizar lejía sin cloro si es necesario
  • Colgar para secar, no centrifugar
  • No planchar nunca el encaje
  • Manipular con cuidado para preservar la transparencia
  • Mantener alejado de objetos ásperos

Consejos de uso

Ponte este string en V cuando quieras jugar la carta de la seducción sutil. Su transparencia extrafina crea el efecto de provocación perfecto: lo suficiente para excitar, pero no demasiado para revelarlo todo. El corte en V realza naturalmente las caderas y crea una silueta irresistible.

perfecto para veladas románticas o para sentirse sexy a diario. El forro de algodón garantiza un confort óptimo, incluso cuando se lleva durante mucho tiempo.

Consejos de estilo

Este Lana V-String combina perfectamente con un elegante picardías para una seducción progresiva, o con nuestras sofisticadas medias para realzar tus piernas. Descubre también nuestros secretos de tocador para una experiencia sensual completa que revela la personalidad única de cada mujer.

To Top
Ver cesta
Artículos
Total de artículos
Struct
Entries: 108
actions
Array
available
number2
brand
stringhouseofdesire
brandcode
stringhecs
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
stringHouse of Desire
breasts
stringna
careinstructions
string
categories
stringdivasboudoir.lingerie.briefs.thong
category
stringbriefs
categorygender
stringf
categorymediadatas
Struct
adult
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
default
Struct
height
string318
isprivate
string0
rating
stringall
src
string/photobank/categories/divasboudoir/lingerie/sexylingerie/thong.jpg
type
stringimg
width
string691
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.661 ms
Record Count: 1
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue,
(if(
(select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
)
)) as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock
from product_colors
left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1
left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01'
where FIND_IN_SET(product_colors.color,'black') > 0
and product_variations.productuid = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
group by product_colors.range,product_colors.color
order by product_colors.range,product_colors.color
recorduidtypecodecolorrangehexvalueavailablestock
1blackcolorblakblackblack#000000-12
colorrange
stringblack
colors
stringblack
colortype
stringcolor
comments
string
compositions
Struct
Entries: 13
coton
string
elastane
string
free
string
leather
string
lycra
string
metal
string
nylon
string
polyamide
string
polyester
string
polyurethane
string
silk
string
spandex
string
viscose
string
datecreated
Date Time (Europe/Paris)
{ts '2025-07-01 12:54:27'}
defect
number0
dimensions
Struct
Entries: 14
acrylicbones
string
backsideheight
string
diameter
string
flatsteelbones
string
frontsideheight
string
fullheight
string
length
string
modestysize
string
panels
string
sides
string
spiralsteelbones
string
totallength
string
unit
stringcm
wiresize
string
display
stringall
displayfrom
string
displayto
string
grossweight
string
hasbrandinfos
booleanfalse
hascareinstructions
booleantrue
hascolorinfos
booleantrue
hascompositions
booleanfalse
hasdescription
booleantrue
hasdimensions
booleanfalse
hasmaterials
booleanfalse
hasotherspecifications
booleanfalse
haspromo
number1
hasshortdescription
booleantrue
hassizeinfos
booleantrue
hasspecifications
booleantrue
hasstockinfos
booleanfalse
hasstylingtips
booleantrue
hasusageinstructions
booleantrue
hasvariations
booleantrue
import
string
inpromo
number3
instockvariations
number2
isactive
number1
iscustommade
number0
isdivasize
number0
isfirstprice
number0
isfixedprice
number0
ishot
number0
isnew
number0
isonline
number0
isoutletprice
number0
itemprice
number14.9583
itempromo
number10.7917
key
stringstring-tanga-en-dentelle-lana
language
stringall
lastupdated
Date Time (Europe/Paris)
{ts '2025-07-25 16:04:45'}
linkedactions
Query
Template: /system/api/cart/actions.cfc:12
Execution Time: 0.65 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','es')
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('62f3bd96-dd3a-4147-b16dbfc3d7e1971e',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.34 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','es')
and product_categories.language in ('all','es')
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 <> 'SBGA7831'
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
string837
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7831/lana_2.jpg
type
stringimg
width
string579
back
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7831/lana_3.jpg
type
stringimg
width
string592
default
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7831/string-grande-taille-lana.jpg
type
stringimg
width
string592
variations
Struct
colors
Struct
black
Struct
height
string856
isprivate
string0
rating
stringall
src
string/photobank/products/hecs/sbga7831/string-grande-taille-lana.jpg
type
stringimg
width
string592
video
Struct
embedsrc
string
height
string
id
string
isprivate
string
rating
string
src
string
thumb
Struct
default
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
high
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
maxres
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
medium
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
standard
Struct
height
string
isprivate
string
rating
string
src
string
type
string
width
string
type
string
width
string
mediagallery
string
metadatas
Struct
darkboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
divasboudoir
Struct
de
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Nur mit kaltem Wasser von Hand waschen</li> <li>Verwende bei Bedarf chlorfreies Bleichmittel</li> <li>Auf dem Bügel trocknen, nicht schleudern</li> <li>Spitze niemals bügeln</li> <li>Behutsam handhaben, um die Transparenz zu erhalten</li> <li>Vor rauen Gegenständen geschützt aufbewahren</li> </ul>
description
string<p>Dieser V-String von Lana ist die Geheimwaffe für eine Verführung, die ins Schwarze trifft! Die extra blaue Petróleoe-Spitze spielt mit den Blicken und enthüllt gerade genug, um die Fantasie zu beflügeln. Der einzigartige V-förmige Schnitt passt sich jeder Körperform an und schafft eine atemberaubende Silhouette.<br>Das Tolle daran ist, dass es sich auf der Haut kaum spürbar anfühlt. Das ultraleichte, atmungsaktive Material lässt Sie vergessen, dass Sie es tragen, während sich der fast nahtlose Schnitt wie eine zweite Haut an die Formen schmiegt. Das weiche Baumwollfutter sorgt für das gewisse Extra an Komfort, das den Unterschied ausmacht.<br>Dieses Stück macht buchstäblich die halbe Verführungsarbeit. Mit diesem String müssen Sie einfach nur Sie selbst sein - den Rest erledigt die Magie der transparenten Spitze. Der Partner wird garantiert nach mehr verlangen!<br>Das Design, das für alle Figuren gedacht ist, garantiert einen sofortigen Schmeichel-Effekt und verwandelt jeden intimen Moment in einen Augenblick purer Sinnlichkeit.</p>
guid
stringhttps://dev.divasboudoir.com/de/string-schwarz/sbga7831.htm
highlights
string<ul> <li><strong>Extra taupefarbene Spitze</strong> - Hebt die Haut subtil hervor.</li> <li><strong>Schmeichelnder V-Schnitt</strong> - Betont die Silhouette auf natürliche Weise</li> <li><strong>Nahezu nahtlos</strong> - Passt sich den Kurven perfekt an</li> <li><strong>Weiches Baumwollfutter</strong> - Optimaler Tragekomfort den ganzen Tag lang</li> <li><strong>Atmungsaktives Material</strong> - Garantiert leicht und frisch</li> <li><strong>Neck-Effekt</strong> - Macht die halbe Verführungsarbeit</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringV-String aus Lana in großen Größen mit extra transparenter Spitze. Schmeichelnder V-Schnitt, doppelter Baumwollanteil, garantiert subtile Verführung. Bequemlichkeit und Sinnlichkeit. Diskrete Lieferung.
keywords
string
title
stringSpitzenstring ροζ και μαύροe Grande Taille V-String Lana | Diva's Boudoir
seotitle
stringString große Größe Spitze zwart en ouro V-String Lana
seouri
stringstring-schwarz
specifications
string<ul> <li><strong>Material:</strong> 88% Nylon, 12% Spandex</li> <li><strong>Futter:</strong> Weiche Baumwolle</li> <li><strong>Stil:</strong> V-String Spitze weiß &amp; schwarz</li> <li><strong>Schnitt:</strong> Fast nahtlos</li> <li><strong>Wirkung:</strong> Subtile Verführung und Neckerei</li> <li><strong>Tragekomfort:</strong> Leicht und atmungsaktiv</li> </ul>
stylingtips
string<p>Dieser Lana V-String passt perfekt zu einem eleganten <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Neglig&eacute;</a> für eine schrittweise Verführung oder zu unseren raffinierten <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Strümpfen</a>, um Ihre Beine zu betonen. Entdecken Sie auch unsere <a href="https://www.divasboudoir.com/de/freche-spielzeuge/">Boudoir-Geheimnisse</a> für ein umfassendes sinnliches Erlebnis, das die einzigartige Persönlichkeit jeder Frau enthüllt.</p>
summary
string<p>Der Lana V-String aus extra transparenter Spitze ist subtile Verführung in ihrer reinsten Form! Der schmeichelhafte V-Schnitt betont die üppigen Kurven und die hauchdünne Spitze enthüllt genau das Richtige.</p> <p>Das Geheimnis, um Ihren Partner völlig verrückt vor Verlangen zu machen.</p>
title
stringV-String Lana Spitze - Subtile Verführung und Transparenz
usageinstructions
string<p>Tragen Sie diesen V-String, wenn Sie Lust haben, die subtile Verführungskarte auszuspielen. Seine extrafeine Transparenz sorgt für den perfekten neckischen Effekt - genug, um anzuregen, nicht zu viel, um alles zu enthüllen. Der V-förmige Schnitt betont natürlich die Hüften und schafft eine unwiderstehliche Silhouette.</p> <p>perfekt für romantische Abende oder wenn der Wunsch aufkommt, sich auch im Alltag sexy zu fühlen. Das Baumwollfutter sorgt für optimalen Tragekomfort auch bei längerem Tragen.</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>Αυτό το Lana V-String είναι το μυστικό όπλο της αποπλάνησης! Η επιπλέον μπλε-πετρολεόη δαντέλα παίζει με το μάτι, αποκαλύπτοντας όσο χρειάζεται για να εξάψει τη φαντασία. Το μοναδικό του κόψιμο σε σχήμα V προσαρμόζεται σε όλα τα σχήματα του σώματος και δημιουργεί μια σιλουέτα που κόβει την ανάσα.<br>Το σπουδαίο είναι ότι μόλις και μετά βίας την αισθάνεστε στο δέρμα σας. Το εξαιρετικά ελαφρύ, αναπνεύσιμο ύφασμα σας κάνει να ξεχνάτε ότι το φοράτε, ενώ το σχεδόν χωρίς ραφές κόψιμο αγκαλιάζει το σχήμα σας σαν δεύτερο δέρμα. Το μαλακό βαμβακερό dounegro y rosare προσφέρει αυτή την έξτρα πινελιά άνεσης που κάνει όλη τη διαφορά.<br>Αυτό το κομμάτι κάνει κυριολεκτικά τη μισή δουλειά της αποπλάνησης. Με αυτό το στρινγκ, το μόνο που έχετε να κάνετε είναι να είστε ο εαυτός σας - τα υπόλοιπα εξαρτώνται από τη μαγεία της τρασπαρμένης δαντέλας. Είναι εγγυημένο ότι θα αφήσει τον σύντροφό σας να θέλει περισσότερα!<br>Το σχέδιο έχει σχεδιαστεί για να ταιριάζει σε κάθε σώμα και κολακεύει άμεσα, μετατρέποντας κάθε προσωπική στιγμή σε μια στιγμή αγνού αισθησιασμού.</p>
guid
stringhttps://dev.divasboudoir.com/el/string-mayro/sbga7831.htm
highlights
string<ul> <li><strong>Extra taupe δαντέλα</strong> - Αποκαλύπτει διακριτικά το δέρμα</li> <li><strong>Κολακευτικό κόψιμο V</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
stringLana μεγάλο μέγεθος V-String με extra διαφανή δαντέλα. Κολακευτική λαιμόκοψη V, βαμβακερή επένδυση, εγγυημένη διακριτική αποπλάνηση. Άνεση και αισθησιασμός. Διακριτική παράδοση.
keywords
string
title
stringΣτρινγκ δαντέλα ροζ και μαύροe Μεγάλο μέγεθος V-string Lana | Diva's Boudoir
seotitle
stringΣτρινγκ μεγάλο μέγεθος δαντέλα zwart en γάτα V-String Lana
seouri
stringstring-mayro
specifications
string<ul> <li><strong>Υλικό:</strong> 88% Νάιλον, 12% Spandex</li> <li><strong>Φόδρα:</strong> Μαλακό βαμβάκι</li> <li><strong>Στυλ :</strong> Λευκή &amp; μαύρη δαντέλα V-string</li> <li><strong>Εφαρμογή:</strong> Σχεδόν χωρίς ραφές</li> <li><strong>Επίδραση: Εύκολη εφαρμογή:</strong> Εύκολη αποπλάνηση και πείραγμα</li> <li><strong>Άνεση :</strong> Ελαφρύ και αναπνέει</li> </ul>
stylingtips
string<p>Αυτό το Lana V-String ταιριάζει τέλεια με ένα κομψό <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">νεγκλιζέ</a> για προοδευτική αποπλάνηση ή με τις εκλεπτυσμένες <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες</a> μας για να αναδείξετε τα πόδια σας. Ανακαλύψτε επίσης τα <a href="https://www.divasboudoir.com/el/sexoyalika-paichnidia/">μυστικά του μπουντουάρ</a> μας για μια ολοκληρωμένη αισθησιακή εμπειρία που αποκαλύπτει τη μοναδική προσωπικότητα κάθε γυναίκας.</p>
summary
string<p>Το Lana V-String σε extra türkis δαντέλα είναι καθαρή αποπλάνηση! Το κολακευτικό σχήμα V ενισχύει τις γενναιόδωρες καμπύλες και η εξαιρετικά λεπτή δαντέλα του αποκαλύπτει ακριβώς τη σωστή ποσότητα.</p> <p>Το μυστικό για να τρελάνετε τον σύντροφό σας από τον πόθο.</p>
title
stringV-String Lana Dentelle - Λεπτή αποπλάνηση και διαφάνεια
usageinstructions
string<p>Φορέστε αυτό το V-String όταν θέλετε να παίξετε το χαρτί της διακριτικής αποπλάνησης. Η εξαιρετικά λεπτή του διαφάνεια δημιουργεί το τέλειο εφέ πειραγμάτων - αρκετό για να διεγείρει, όχι τόσο πολύ ώστε να αποκαλύπτει τα πάντα. Το κόψιμο σε σχήμα V τονίζει φυσικά τους γοφούς και δημιουργεί μια ακαταμάχητη σιλουέτα.</p> <p>ιδανικό για ρομαντικές βραδιές έξω ή όταν θέλετε να νιώθετε σέξι κάθε μέρα. Η βαμβακερή επένδυση εξασφαλίζει βέλτιστη άνεση, ακόμη και όταν φοριέται για μεγάλο χρονικό διάστημα.</p>
en
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Hand wash in cold water only</li> <li>Use chlorine-free bleach if necessary</li> <li>Dry on hanger, no spin-drying</li> <li>Never iron lace</li> <li>Handle with care to preserve transparency</li> <li>Keep away from rough objects</li> </ul>
description
string<p>This Lana V-String is the secret weapon of seduction! Extra-sheer lace plays with the eye, revealing just enough to fire the imagination. Its unique V-cut adapts to all body shapes and creates a breathtaking silhouette.<br>The great thing is the barely perceptible sensation on the skin. The ultra-light, breathable fabric makes you forget you're wearing it, while the almost seamless cut hugs your shape like a second skin. The soft cotton lining adds that extra touch of comfort that makes all the difference.<br>This piece literally does half the job of seduction. With this thong, you just have to be yourself - the rest is up to the magic of transparent lace. Your partner will want more, guaranteed!<br>A design for every figure guarantees an immediate flattering effect, transforming every intimate moment into a moment of pure sensuality.</p>
guid
stringhttps://dev.divasboudoir.com/en/string-black/sbga7831.htm
highlights
string<ul> <li><strong>Extra sheer lace</strong> - Subtly reveals the skin</li> <li><strong>Flattering V-cut</strong> - Naturally enhances the figure</li> <li><strong>Virtually seamless</strong> - Fits curves perfectly</li> <li><strong>Soft cotton lining</strong> - Optimal all-day comfort</li> <li><strong>Breathable fabric</strong> - Guaranteed lightness and freshness</li> <li><strong>Teasing effect</strong> - Does half the work of seduction</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringV-String Lana plus size extra sheer lace. Flattering V-cut, cotton lining, subtle seduction guaranteed. Comfort and sensuality. Discreet delivery.
keywords
string
title
stringThong Transparent Lace Plus Size V-String Lana | Diva's Boudoir
seotitle
stringPlus size transparent lace V-String Lana
seouri
stringstring-black
specifications
string<ul> <li><strong>Material:</strong> 88% Nylon, 12% Spandex</li> <li><strong>Lining:</strong> Soft cotton</li> <li><strong>Style:</strong> Sheer lace V-string</li> <li><strong>Cut:</strong> Almost seamless</li> <li><strong>Effect:</strong> Subtle seduction and teasing</li> <li><strong>Comfort :</strong> Light and breathable</li> </ul>
stylingtips
string<p>This Lana V-String pairs perfectly with an elegant <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligee</a> for progressive seduction, or with our sophisticated <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> to sublimate the legs. Discover also our <a href="https://www.divasboudoir.com/en/naughty-toys/">boudoir secrets</a> for a complete sensual experience that reveals each woman's unique personality.</p>
summary
string<p>The Lana V-String in extra sheer lace is pure subtle seduction! Its flattering V-cut enhances generous curves, while its ultra-fine lace reveals just the right amount.</p> <p>The secret to driving your partner wild with desire.</p>
title
stringV-String Lana Dentelle - Subtle seduction and transparency
usageinstructions
string<p>Wear this V-String when the urge to play the subtle seduction card arises. Its extra-thin transparency creates the perfect teasing effect - enough to excite, not too much to reveal everything. The V-shaped cut naturally highlights the hips and creates an irresistible silhouette.</p> <p>perfect for romantic evenings or when the urge to feel sexy every day arises. The cotton lining ensures optimum comfort even for extended wear.</p>
es
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar a mano sólo con agua fría</li> <li>Utilizar lejía sin cloro si es necesario</li> <li>Colgar para secar, no centrifugar</li> <li>No planchar nunca el encaje</li> <li>Manipular con cuidado para preservar la transparencia</li> <li>Mantener alejado de objetos ásperos</li> </ul>
description
string<p>El string en V Lana es el arma secreta de la seducción El encaje extra azul-petróleoe juega con la mirada, revelando lo justo para encender la imaginación. Su exclusivo corte en V se adapta a todas las formas del cuerpo y crea una silueta impresionante.<br>Lo mejor es que apenas se siente en la piel. El tejido ultraligero y transpirable hace que te olvides de que lo llevas puesto, mientras que el corte casi sin costuras abraza tu silueta como una segunda piel. El suave forro de algodón añade ese toque extra de comodidad que marca la diferencia.<br>Esta pieza hace literalmente la mitad del trabajo de seducción. Con este tanga, todo lo que tienes que hacer es ser tú misma: el resto depende de la magia del encaje transparente. Te garantizamos que dejarás a tu pareja con ganas de más<br>Su diseño se adapta a todas las figuras, por lo que resulta favorecedor al instante, convirtiendo cada momento íntimo en un instante de pura sensualidad.</p>
guid
stringhttps://dev.divasboudoir.com/es/cadena-negro/sbga7831.htm
highlights
string<ul> <li><strong>Encaje extra transparente</strong> - Revela sutilmente la piel</li> <li><strong>Favorecedor corte en V</strong> - Realza la figura de forma natural</li> <li><strong>Prácticamente sin costuras</strong> - Se adapta perfectamente a las curvas</li> <li><strong>Forro de algodón suave</strong> - Comodidad óptima durante todo el día</li> <li><strong>Tejido transpirable</strong> - Ligereza y frescor garantizados</li> <li><strong>Efecto seductor</strong> - Realiza la mitad del trabajo de seducción</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLana talla grande tanga en V de encaje extra transparente. Favorecedor escote en V, forro de algodón, seducción sutil garantizada. Comodidad y sensualidad. Entrega discreta.
keywords
string
title
stringTanga Encaje transparente Talla grande Tanga en V Lana | Diva's Boudoir
seotitle
stringTanga talla grande encaje transparente Tanga en V Lana
seouri
stringcadena-negro
specifications
string<ul> <li><strong>Material:</strong> 88% nailon, 12% elastán</li> <li><strong>Forro:</strong> Algodón suave</li> <li><strong>Estilo:</strong> Tanga en V de encaje blanco y negro</li> <li><strong>Ajuste:</strong> Prácticamente sin costuras</li> <li><strong>Efecto:</strong> Sutil seducción y provocación</li> <li><strong>Comodidad :</strong> Ligero y transpirable</li> </ul>
stylingtips
string<p>Este Lana V-String combina perfectamente con un elegante <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para una seducción progresiva, o con nuestras sofisticadas <a href="https://www.divasboudoir.com/es/medias-grandes/">medias</a> para realzar tus piernas. Descubre también nuestros <a href="https://www.divasboudoir.com/es/juguetes-traviesos/">secretos de tocador</a> para una experiencia sensual completa que revela la personalidad única de cada mujer.</p>
summary
string<p>El tanga en V Lana de encaje extra transparente es pura seducción sutil Su favorecedor corte en V realza las curvas generosas y su encaje ultrafino deja al descubierto la cantidad justa.</p> <p>El secreto para volver loca de deseo a tu pareja.</p>
title
stringV-String Lana Dentelle - Sutil seducción y transparencia
usageinstructions
string<p>Ponte este string en V cuando quieras jugar la carta de la seducción sutil. Su transparencia extrafina crea el efecto de provocación perfecto: lo suficiente para excitar, pero no demasiado para revelarlo todo. El corte en V realza naturalmente las caderas y crea una silueta irresistible.</p> <p>perfecto para veladas románticas o para sentirse sexy a diario. El forro de algodón garantiza un confort óptimo, incluso cuando se lleva durante mucho tiempo.</p>
fr
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavage &agrave; la main &agrave; l'eau froide uniquement</li> <li>Utiliser de l'eau de javel sans chlore si n&eacute;cessaire</li> <li>S&eacute;chage sur cintre, pas d'essorage</li> <li>Ne jamais repasser la dentelle</li> <li>Manipuler d&eacute;licatement pour pr&eacute;server la transparence</li> <li>Conserver &agrave; l'abri des objets rugueux</li> </ul>
description
string<p>Ce V-String Lana, c'est l'arme secr&egrave;te pour une s&eacute;duction qui fait mouche ! La dentelle extra bleu-petr&oacute;leoe joue avec les regards, r&eacute;v&eacute;lant juste assez pour enflammer l'imagination. Sa coupe en V unique s'adapte toutes morphologies et cr&eacute;e une silhouette &agrave; couper le souffle.<br>Le truc g&eacute;nial, c'est cette sensation &agrave; peine perceptible sur la peau. La mati&egrave;re ultra l&eacute;g&egrave;re et respirante fait oublier qu'on le porte, tandis que la coupe presque sans coutures &eacute;pouse les formes comme une seconde peau. La dounegro y rosare en coton douce apporte ce petit plus de confort qui fait toute la diff&eacute;rence.<br>Cette pi&egrave;ce fait litt&eacute;ralement la moiti&eacute; du boulot de s&eacute;duction. Avec ce string, il suffit d'&ecirc;tre soi-m&ecirc;me - le reste, c'est la magie de la dentelle trasparentee qui s'en charge. Le partenaire va en redemander, c'est garanti !<br>Le design pens&eacute; pour toutes les silhouettes garantit un effet flatteur imm&eacute;diat, transformant chaque moment intime en instant de pure sensualit&eacute;.</p>
guid
stringhttps://dev.divasboudoir.com/fr/string-dentelle-rosae-grande-taille/sbga7831.htm
highlights
string<ul> <li><strong>Dentelle extra taupe</strong> - R&eacute;v&egrave;le la peau avec subtilit&eacute;</li> <li><strong>Coupe en V flatteuse</strong> - Met en valeur la silhouette naturellement</li> <li><strong>Presque sans coutures</strong> - &Eacute;pouse les courbes parfaitement</li> <li><strong>Doublure coton douce</strong> - Confort optimal toute la journ&eacute;e</li> <li><strong>Mati&egrave;re respirante</strong> - L&eacute;g&egrave;ret&eacute; et fra&icirc;cheur garanties</li> <li><strong>Effet taquinerie</strong> - Fait la moiti&eacute; du travail de s&eacute;duction</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringV-String Lana grande taille dentelle extra transparentee. Coupe en V flatteuse, doublauwre coton, séduction subtile garantie. Confort et sensualité. Livraison discrète.
keywords
string
title
stringString Dentelle pink και μαύροe Grande Taille V-String Lana | Diva's Boudoir
seotitle
stringString grande taille dentelle zwart en γάτα V-String Lana
seouri
stringstring-dentelle-rosae-grande-taille
specifications
string<ul> <li><strong>Mati&egrave;re :</strong> 88% Nylon, 12% Spandex</li> <li><strong>Doublure :</strong> Coton doux</li> <li><strong>Style :</strong> V-String dentelle blanc &amp; noir</li> <li><strong>Coupe :</strong> Presque sans coutures</li> <li><strong>Effet :</strong> S&eacute;duction subtile et taquinerie</li> <li><strong>Confort :</strong> L&eacute;ger et respirant</li> </ul>
stylingtips
string<p>Ce V-String Lana se marie parfaitement avec un <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">d&eacute;shabill&eacute;</a> &eacute;l&eacute;gant pour une s&eacute;duction progressive, ou avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas</a> sophistiqu&eacute;s pour subvermelhor les jambes. D&eacute;couvrez &eacute;galement nos <a href="https://www.divasboudoir.com/fr/jouets-coquins/">secrets de boudoir</a> pour une exp&eacute;rience sensuelle compl&egrave;te qui r&eacute;v&egrave;le la personnalit&eacute; unique de chacune.</p>
summary
string<p>Le V-String Lana en dentelle extra t&uuml;rkis, c'est la s&eacute;duction subtile &agrave; l'&eacute;tat pur ! Sa coupe en V flatteuse sublime courbes g&eacute;n&eacute;reuses et sa dentelle ultra fine r&eacute;v&egrave;le juste ce qu'il faut.</p> <p>Le secret pour rendre votre partenaire compl&egrave;tement fou de d&eacute;sir.</p>
title
stringV-String Lana Dentelle - Séduction Subtile et Transparence
usageinstructions
string<p>Porter ce V-String quand l'envie de jouer la carte de la s&eacute;duction subtile se fait sentir. Sa transparence extra fine cr&eacute;e un effet taquinerie parfait - assez pour exciter, pas trop pour tout r&eacute;v&eacute;ler. La coupe en V met naturellement en valeur les hanches et cr&eacute;e une silhouette irr&eacute;sistible.</p> <p>&nbsp;Parfait pour les soir&eacute;es romantiques ou quand l'envie de se sentir sexy au quotidien se manifeste. La doublure coton assure un confort optimal m&ecirc;me pour un port prolong&eacute;.</p>
it
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavare a mano solo in acqua fredda</li> <li>Se necessario, utilizzare candeggina senza cloro</li> <li>Appendere ad asciugare, non centrifugare</li> <li>Non stirare mai i pizzi</li> <li>Maneggiare delicatamente per preservare la trasparenza</li> <li>Tenere lontano da oggetti ruvidi</li> </ul>
description
string<p>Questo Lana V-String è l'arma segreta della seduzione! Il pizzo extra azul-petróleoe gioca con gli occhi, rivelando quanto basta per accendere l'immaginazione. Il suo taglio unico a V si adatta a tutte le forme del corpo e crea una silhouette mozzafiato.<br>Il bello è che si sente appena sulla pelle. Il tessuto ultraleggero e traspirante fa dimenticare di indossarlo, mentre il taglio quasi senza cuciture abbraccia le forme come una seconda pelle. La morbida fodera in cotone aggiunge quel tocco di comfort in più che fa la differenza.<br>Questo pezzo fa letteralmente metà del lavoro di seduzione. Con questo perizoma, tutto ciò che dovete fare è essere voi stesse: il resto lo fa la magia del pizzo trasparente. Il vostro partner ne vorrà ancora!<br>Il design è stato progettato per adattarsi a ogni figura ed è immediatamente lusinghiero, trasformando ogni momento intimo in un momento di pura sensualità.</p>
guid
stringhttps://dev.divasboudoir.com/it/stringa-nero/sbga7831.htm
highlights
string<ul> <li><strong>Pizzo extra taupe</strong> - Rivela sottilmente la pelle</li> <li><strong>Taglio a V lusinghiero</strong> - Esalta la figura in modo naturale</li> <li><strong>Praticamente senza cuciture</strong> - Si adatta perfettamente alle curve</li> <li><strong>Fodera in morbido cotone</strong> - Comfort ottimale per tutto il giorno</li> <li><strong>Tessuto traspirante</strong> - Garantisce leggerezza e freschezza</li> <li><strong>Effetto stuzzicante</strong> - Fa metà del lavoro di seduzione</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLana, taglia grande, stringa a V in pizzo extra velato. Lusinghiero scollo a V, fodera in cotone, sottile seduzione garantita. Comfort e sensualità. Consegna discreta.
keywords
string
title
stringPerizoma in pizzo trasparente Taglia grande V-String Lana | Diva's Boudoir
seotitle
stringPerizoma taglia grande in pizzo zwart en goud V-String Lana
seouri
stringstringa-nero
specifications
string<ul> <li><strong>Materiale:</strong> 88% Nylon, 12% Spandex</li> <li><strong>Fodera:</strong> morbido cotone</li> <li><strong>Stile:</strong> perizoma a V in pizzo bianco e nero</li> <li><strong>Vestibilità:</strong> Praticamente senza cuciture</li> <li><strong>Effetto:</strong> Sottile seduzione e stuzzicante</li> <li><strong>Comfort:</strong> Leggero e traspirante</li> </ul>
stylingtips
string<p>Questo Lana V-String si abbina perfettamente a un elegante <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">negligé</a> per una seduzione progressiva, o alle nostre sofisticate <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> per valorizzare le gambe. Scoprite anche i nostri <a href="https://www.divasboudoir.com/it/giocattoli-cattivi/">segreti del boudoir</a> per un'esperienza sensuale completa che rivela la personalità unica di ogni donna.</p>
summary
string<p>Il Lana V-String in pizzo extra velato è pura seduzione sottile! Il suo lusinghiero taglio a V esalta le curve generose e il pizzo finissimo rivela la giusta quantità.</p> <p>Il segreto per far impazzire di desiderio il vostro partner.</p>
title
stringCorde a V Lana Dentelle - Sottile seduzione e trasparenza
usageinstructions
string<p>Indossate questo V-String quando volete giocare la carta della seduzione sottile. La sua sottilissima trasparenza crea l'effetto perfetto: abbastanza da eccitare, ma non troppo da rivelare tutto. Il taglio a V mette naturalmente in risalto i fianchi e crea una silhouette irresistibile.</p> <p>perfetto per le serate romantiche o per sentirsi sexy ogni giorno. La fodera in cotone garantisce un comfort ottimale anche se indossata a lungo.</p>
nl
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Alleen met de hand wassen in koud water</li> <li>Gebruik chloorvrij bleekmiddel indien nodig</li> <li>Ophangen om te drogen, niet centrifugeren</li> <li>Kant nooit strijken</li> <li>Voorzichtig behandelen om transparantie te behouden</li> <li>Verwijderd houden van ruwe voorwerpen</li> </ul>
description
string<p>Deze Lana V-String is het geheime wapen van verleiding! Het extra transparante kant speelt met het oog en onthult net genoeg om de verbeelding te prikkelen. De unieke V-vormige snit past zich aan alle lichaamsvormen aan en creëert een adembenemend silhouet.<br>Het mooie is dat het nauwelijks aanvoelt op je huid. De ultralichte, ademende stof doet je vergeten dat je het draagt, terwijl de bijna naadloze snit je vorm als een tweede huid omarmt. De zachte katoenen voering voegt dat extra beetje comfort toe dat het verschil maakt.<br>Dit stuk doet letterlijk het halve werk van verleiding. Met deze string hoef je alleen maar jezelf te zijn - de rest is aan de magie van het transparante kant. Je partner wil gegarandeerd meer!<br>Het ontwerp past bij elk figuur, dus het is direct flatterend en maakt van elk intiem moment een moment van pure sensualiteit.</p>
guid
stringhttps://dev.divasboudoir.com/nl/string-zwart/sbga7831.htm
highlights
string<ul> <li><strong>Extra doorschijnend kant</strong> - onthult subtiel de huid</li> <li><strong>Flatterende V-uitsnijding</strong> - verfraait het figuur op natuurlijke wijze</li> <li><strong>Vrijwel naadloos</strong> - Past perfect bij rondingen</li> <li><strong>Zachte katoenen voering</strong> - Optimaal comfort, de hele dag lang</li> <li><strong>Ademende stof</strong> - Gegarandeerd licht en fris</li> <li><strong>Plagend effect</strong> - Doet het halve werk van verleiding</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLana grote maat extra transparante kanten V-string. Flatterende V-hals, katoenen voering, subtiele verleiding gegarandeerd. Comfort en sensualiteit. Discrete levering.
keywords
string
title
stringG-string Transparant kant Grote maat V-string Lana | Diva's Boudoir
seotitle
stringG-string grote maat transparant kant V-string Lana
seouri
stringstring-zwart
specifications
string<ul> <li><strong>Materiaal:</strong> 88% Nylon, 12% Spandex</li> <li><strong>Voering:</strong> Zacht katoen</li> <li><strong>Stijl:</strong> Sheer kant V-string</li> <li><strong>Pasvorm:</strong> Vrijwel naadloos</li> <li><strong>Effect :</strong> Subtiele verleiding en plagerij</li> <li><strong>Comfort :</strong> Lichtgewicht en ademend</li> </ul>
stylingtips
string<p>Deze Lana V-String past perfect bij een elegante <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligé</a> voor progressieve verleiding, of bij onze geraffineerde <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> om je benen te accentueren. Ontdek ook onze <a href="https://www.divasboudoir.com/nl/ondeugend-speelgoed/">boudoirgeheimen</a> voor een complete sensuele ervaring die de unieke persoonlijkheid van elke vrouw onthult.</p>
summary
string<p>De Lana V-String in extra doorschijnend kant is pure subtiele verleiding! De flatterende V-vormige snit benadrukt royale rondingen en het ultrafijne kant onthult precies de juiste hoeveelheid.</p> <p>Het geheim om je partner wild te maken van verlangen.</p>
title
stringV-snaar Lana Dentelle - Subtiele verleiding en transparantie
usageinstructions
string<p>Draag deze V-string als je subtiel wilt verleiden. De extra dunne transparantie creëert het perfecte plagende effect - genoeg om op te winden, niet te veel om alles te onthullen. De V-vormige snit benadrukt op natuurlijke wijze de heupen en creëert een onweerstaanbaar silhouet.</p> <p>perfect voor romantische avondjes uit of wanneer je je elke dag sexy wilt voelen. De katoenen voering zorgt voor optimaal draagcomfort, zelfs bij langdurig dragen.</p>
pt
Struct
Entries: 15
abstract
string
careinstructions
string<ul> <li>Lavar à mão apenas em água fria</li> <li>Utilizar lixívia sem cloro, se necessário</li> <li>Pendurar para secar, não secar à centrifugação</li> <li>Nunca passar a renda a ferro</li> <li>Manusear com cuidado para preservar a transparência</li> <li>Manter afastado de objectos ásperos</li> </ul>
description
string<p>Esta Lana V-String é a arma secreta da sedução! A renda extra azul-petróleoe brinca com o olhar, revelando apenas o suficiente para despertar a imaginação. O seu corte único em V adapta-se a todas as formas do corpo e cria uma silhueta de cortar a respiração.<br>O melhor de tudo é que quase não se sente na pele. O tecido ultra-leve e respirável faz com que se esqueça que o está a usar, enquanto o corte quase sem costuras abraça a sua forma como uma segunda pele. O forro de algodão macio acrescenta aquele toque extra de conforto que faz toda a diferença.<br>Esta peça faz literalmente metade do trabalho de sedução. Com esta tanga, tudo o que tem de fazer é ser você mesma - o resto é com a magia da renda transparente. É garantido que vai deixar o seu parceiro a querer mais!<br>O design foi concebido para se adaptar a todas as figuras e é instantaneamente lisonjeiro, transformando cada momento íntimo num momento de pura sensualidade.</p>
guid
stringhttps://dev.divasboudoir.com/pt/corda-preto/sbga7831.htm
highlights
string<ul> <li><strong>Renda extra taupe</strong> - Revela subtilmente a pele</li> <li><strong>Corte em V lisonjeiro</strong> - Realça naturalmente a figura</li> <li><strong>Praticamente sem costuras</strong> - Adapta-se perfeitamente às curvas</li> <li><strong>Forro de algodão macio</strong> - Conforto ótimo durante todo o dia</li> <li><strong>Tecido respirável</strong> - Garantia de leveza e frescura</li> <li><strong>Efeito provocador</strong> - Faz metade do trabalho de sedução</li> </ul>
keypoint
string
keywords
string
metas
Struct
description
stringLana tamanho grande em renda extra transparente V-String. Decote em V lisonjeiro, forro em algodão, sedução subtil garantida. Conforto e sensualidade. Entrega discreta.
keywords
string
title
stringFio-dental Renda transparente Tamanho grande Fio-dental em V Lana | Diva's Boudoir
seotitle
stringFio-dental tamanho grande em renda laranja Fio-dental Lana
seouri
stringcorda-preto
specifications
string<ul> <li><strong>Material:</strong> 88% Nylon, 12% Spandex</li> <li><strong>Forro:</strong> Algodão macio</li> <li><strong>Estilo:</strong> Tanga em V de renda branca e preta</li> <li><strong>Ajuste:</strong> Praticamente sem costuras</li> <li><strong>Efeito:</strong> Sedução subtil e provocação</li> <li><strong>Conforto :</strong> Leve e respirável</li> </ul>
stylingtips
string<p>Esta Lana V-String combina perfeitamente com um elegante <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligee</a> para uma sedução progressiva, ou com as nossas sofisticadas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> para realçar as suas pernas. Descubra também <a href="https://www.divasboudoir.com/pt/brinquedos-marotos/">os</a> nossos <a href="https://www.divasboudoir.com/pt/brinquedos-marotos/">segredos de boudoir</a> para uma experiência sensual completa que revela a personalidade única de cada mulher.</p>
summary
string<p>A Lana V-String em renda extra transparente é pura sedução subtil! O seu corte lisonjeiro em V realça as curvas generosas e a sua renda ultra-fina revela apenas a quantidade certa.</p> <p>O segredo para deixar o seu parceiro louco de desejo.</p>
title
stringV-String Lana Dentelle - Sedução subtil e transparência
usageinstructions
string<p>Use esta V-String quando quiser jogar a carta da sedução subtil. A sua transparência extra-fina cria o efeito de provocação perfeito - o suficiente para excitar, mas não demasiado para revelar tudo. O corte em V realça naturalmente as ancas e cria uma silhueta irresistível.</p> <p>perfeito para noites românticas ou quando se quer sentir sexy todos os dias. O forro em algodão garante um conforto ótimo, mesmo quando usado durante longos períodos.</p>
fetishboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
latexboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
legsboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
lustboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
smboudoir
Struct
de
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-schwarz
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
el
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-mayro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
en
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-black
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
es
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-negro
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
fr
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-noir
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
it
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-nero
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
nl
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-zwart
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
pt
Struct
Entries: 14
abstract
string
careinstructions
string
description
string
highlights
string
keypoint
string
keywords
string
metas
Struct
description
string
keywords
string
title
string
seotitle
string
seouri
string-preto
specifications
string
stylingtips
string
summary
string
title
string
usageinstructions
string
name
stringSTRING TANGA EN DENTELLE LANA
netweight
string
nextshipment
stringtoday
ordered
number1
orderidx
number0
origin
string
originalsize
string
packaging
number0
productshipment
stringauto
productuid
string62F3BD96-DD3A-4147-B16DBFC3D7E1971E
promountil
string
rating
stringnone
recorduid
string62F3BD96-DD3A-4147-B16DBFC3D7E1971E
reference
stringSBGA7831
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.38 ms
Record Count: 6
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,'2069,2074,2240,2067,2073,2075') > 0
and product_variations.productuid = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
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
12240XL+intlsizeblackXL+XL+-19999990wpluslingerieXLXL+42-4412-1416-1844-4644-4642-4448-5044-4642-44104-11086-91112-120
220741X/2X-intlsizeblack1X/2X-19999991wpluslingerie1X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44104-11086-91112-120
320753X/4X+intlsizeblack3X/4X+3X/4X+-19999991wpluslingerie3X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52128-132102-108132-138
42069XLintlsizeblackXLXL-19999990wpluslingerieXLXL40-4210-1214-1642-4442-4440-4246-4842-4440-4299-10481-86107-112
520671X/2Xintlsizeblack1X/2X1X/2X-19999991wpluslingerie1X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48112-11892-96122-128
620733X/4Xintlsizeblack3X/4X3X/4X-19999991wpluslingerie3X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50120-12898-102128-132
sizeranges
stringplus
sizes
string2069,2074,2240,2067,2073,2075
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
number2
stocks
Query
Template: /system/api/product/stocks.cfc:25
Execution Time: 6.87 ms
Record Count: 3
Cached: No
Datasource: divasboudoir_sitedatas
Lazy: No
SQL:
select * from (
select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid,
product_variations.color, product_colors.hexvalue, product_sizes.suppliersize,
product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup,
if(intlsize <> '',intlsize,product_sizes.intlsize) as size,
if(intlsize <> '','intlsize','intlsize') as sizetype,
product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil,
product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect,
product_variations.reference as manufacturerreference,
product_variations.ean,
(if(
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0,
(sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)),
if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0,
-1,
if(
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0,
sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),
0
))
))
as available,
IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock,
'all' as display,
product_variations.comments
from product_stocks
left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid
left outer join product_sizes on product_variations.size = product_sizes.suppliersize
left outer join product_colors on product_variations.color = product_colors.color
where product_stocks.productuid = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2240
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
162F3BD96-DD3A-4147-B16DBFC3D7E1971E74742026-5B81-4192-BE00FAEB9FEADEDF2074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize14.958310.7917STOCK01100-10100HD07209A19868000798011all
262F3BD96-DD3A-4147-B16DBFC3D7E1971E43FB9076-EA4F-495D-946F337BE51A94BF2069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize14.958310.7917STOCK01000-10100HD07209A198680007973-10all
362F3BD96-DD3A-4147-B16DBFC3D7E1971E3E2AD561-BEDD-4400-88FD7AACB67D250B2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize14.958310.7917STOCK01100-10100HD07209A19868000838311all
subcategory
stringthong
supplier
number-1
supplierreference
stringHD07209A-BLAK
tags
string
themes
string
totalvariations
number3
type
stringdefault
unitprice
number10.7917
usageinstructions
string
variations
Query
Template: /system/api/product/variations.cfc:171
Execution Time: 9.91 ms
Record Count: 6
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2069
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2074
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2240
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2067
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2073
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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E' 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 = '62F3BD96-DD3A-4147-B16DBFC3D7E1971E'
and product_variations.isactive = 1
and product_sizes.id_size = 2075
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
143FB9076-EA4F-495D-946F337BE51A94BF2240black#000000XLXL+42-4412-1416-1844-4644-4642-4448-5044-4642-44wlingerieXL+intlsize14.958310.7917STOCK01000-10100HD07209A198680007973-10-10-12110.7917all
274742026-5B81-4192-BE00FAEB9FEADEDF2074black#0000001X/2X1X/2X-42-4412-1416-1844-4644-4642-4446-4844-4642-44wlingerie1X/2X-intlsize14.958310.7917STOCK01100-10100HD07209A19868000798011-11-12110.7917all
33E2AD561-BEDD-4400-88FD7AACB67D250B2075black#0000003X/4X3X/4X+50-5220-2224-2852-5452-5450-5256-5852-5450-52wlingerie3X/4X+intlsize14.958310.7917STOCK01100-10100HD07209A19868000838311-11-12110.7917all
443FB9076-EA4F-495D-946F337BE51A94BF2069black#000000XLXL40-4210-1214-1642-4442-4440-4246-4842-4440-42wlingerieXLintlsize14.958310.7917STOCK01000-10100HD07209A198680007973-10-10-12110.7917all
574742026-5B81-4192-BE00FAEB9FEADEDF2067black#0000001X/2X1X/2X46-4816-1820-2248-5048-5046-4852-5448-5046-48wlingerie1X/2Xintlsize14.958310.7917STOCK01100-10100HD07209A19868000798011-11-12110.7917all
63E2AD561-BEDD-4400-88FD7AACB67D250B2073black#0000003X/4X3X/4X48-5018-2022-2450-5250-5248-5054-5650-5248-50wlingerie3X/4Xintlsize14.958310.7917STOCK01100-10100HD07209A19868000838311-11-12110.7917all
vatrate
number20
warehouse
number2