Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | |
| 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 | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | el | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | en | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | es | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | fr | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | it | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | nl | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | pt | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
|
|
| brandname | |
| breasts | |
| careinstructions | |
| categories | | string | divasboudoir.lingerie.sexylingerie.bustier |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg |
| | type | | | width | |
| | divasboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | fetishboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | latexboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | legsboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | lustboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | private | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/private/default.jpg |
| | type | | | width | |
| | smboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
|
|
| categorysizerange | |
| colorinfos | Query Template: /system/api/product/colors.cfc:13 Execution Time: 1.07 ms Record Count: 2 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black,deeprose') > 0 and product_variations.productuid = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 | | 2 | deeprose | color | dros | deeprose | pink | #880E4F | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2025-07-20 18:12:17'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | | string | ensemble-de-chemise-porte-jarretelles--yasmine |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-08-07 11:59:27'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.865 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','de') 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('b0ed1cdb-9d86-4302-b0ab33f3a45cafd1',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null )
| | id_action | branding | language | name | code | type | minimumOrder | maximumOrder | minimumItems | maximumItems | maximumUse | allowedItems | quotas | usedCount | linkedproducts | linkedthemes | linkedbrands | linkeditem | params | activeFrom | activeTo | isActive |
|
| linkedproducts | Query Template: /system/api/products.cfc:1305 Execution Time: 2.02 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','de') and product_categories.language in ('all','de') 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 <> 'SBBU5925' group by products.reference order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
| | productuid | reference | type | key | language | name | linkuid | colors | vatrate | metadatas | dimensions | mediadatas | tags | themes | isdivasize | totalvariations | variationlist | inpromo | haspromo | itempromo | itemprice | unitprice | prices | promountil | isfixedprice | ishot | isnew | orderidx | available | stock | instockvariations | brand | brandname | showbrand | display | sizetype | intlsize | sizes | sizerange | categorymediadatas | categorysizerange | section | category | subcategory |
|
| linkuid | |
| materials | |
| mediadatas | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_noire.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve_dos.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_noire.jpg |
| | type | | | width | |
| | deeprose | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu5925/guepiere_grande_taille_yasmine_mauve.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwäsche mit kaltem Wasser, um die Pailletten zu erhalten</li>
<li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li>
<li>Liegend trocknen, um die Form der Bügel zu erhalten</li>
<li>Niemals direkt über die glitzernde Maschenware bügeln</li>
<li>Die Strassringe vorsichtig handhaben</li>
<li>Hängend aufbewahren, um ein Hängenbleiben auf der Masche zu vermeiden</li>
</ul> |
| | description | | string | <p>Das Jasmin-Set revolutioniert die Kunst der Provokation mit seinem <strong>glitzernden Maschengewebe</strong>, das Ihre Silhouette in ein lebendes Kunstwerk verwandelt. Dieses einzigartige Material fängt bei jeder Bewegung das Licht ein und schafft ein hypnotisches visuelles Spiel, das alle Blicke auf sich zieht.</p>
<p>Die <strong>hauchdünnen Bügel-Cups</strong> formen ein perfektes Dekolleté und bieten gleichzeitig außergewöhnlichen BH-Stütz, der <strong>sich ganz natürlich an jede Körperform anpasst</strong>. Das technische Design enthüllt Ihre Vorzüge mit einer beunruhigenden Präzision und sorgt für den begehrten Push-up-Effekt.</p>
<p>strategisch platzierte <strong>O-Ringe aus Strass</strong> auf der Brust verleihen dem Ganzen eine kostbare Dimension, die den Unterschied ausmacht. Diese Details erzeugen einen raffinierten, frechen Effekt, der Ihre Kühnheit mit beunruhigender Eleganz offenbart. Die <strong>gewagten Ausschnitte auf der Vorder- und Rückseite</strong> enthüllen strategisch Ihre Haut und schaffen dieses verwirrende Spiel zwischen dem, was man sieht, und dem, was man verbirgt. Dieses Design formt Ihre Silhouette mit chirurgischer Präzision und enthüllt Ihre Sinnlichkeit aus jedem Blickwinkel.</p>
<p>Die <strong>verstellbaren Strumpfhalter an den Oberschenkeln</strong> revolutionieren die traditionellen Codes, indem sie diese einzigartige, provokative Silhouette schaffen. Diese Innovation verwandelt Ihre Beine in einen absoluten Verführungsvorteil und fügt eine spielerische Dimension hinzu, die alle Fantasien weckt.</p>
<p>Der <strong>transparente String mit Baumwollfutter</strong> rundet dieses außergewöhnliche Ensemble harmonisch ab. Diese Aufmerksamkeit für den Komfort zeigt das technische Know-how dieser Kreation, die ästhetische Kühnheit mit optimalem Wohlbefinden verbindet. Wenn Sie dieses Jasmin-Set tragen, bleiben Sie nicht länger unbemerkt - Sie werden zu diesem faszinierenden Wesen, das mit seiner glitzernden Anmut und seiner unwiderstehlichen magnetischen Aura hypnotisiert.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/set-in-Übergröße-Jasmin-Glitzerndes-Netzhemd/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Glitzernde Maschenware</strong>, die bei jeder Bewegung das Licht fängt</li>
<li><strong>Armaturierte Cups</strong>, die optimalen Halt und einen Push-up-Effekt bieten</li>
<li><strong>O-Ring-Strassringe</strong> für einen frechen und raffinierten Effekt</li>
<li><strong>Gewagte Ausschnitte</strong> auf der Vorder- und Rückseite, die Ihre Haut enthüllen</li>
<li><strong>Verstellbare Oberschenkel-Strumpfbänder</strong> für einen einzigartigen provokativen Look</li>
<li><strong>Passender transparenter String</strong> mit Baumwollfutter für Komfort</li>
<li><strong>Eng anliegender Schnitt</strong>, der Ihre Silhouette natürlich formt</li>
<li>Perfekt aufeinander abgestimmtes<strong>zweiteiliges Design</strong> aus Shirt und String</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Set Jasmin in großen Größen aus glitzernder Maschenware: gepanzerte Cups, Strassringe, Strumpfbänder an den Oberschenkeln, transparenter String. Provokative Verführung | Diva's Boudoir |
| | keywords | | | title | | string | Set Jasmin in großer Größe aus glitzernder Maschenware | Diva's Boudoir |
|
| | seotitle | | string | Set große Größe Jasmin Glitzerndes Netzhemd mit Strumpfhaltern Oberschenkel |
| | seouri | | string | set-in-Übergröße-Jasmin-Glitzerndes-Netzhemd |
| | specifications | | string | <ul>
<li><strong>Set:</strong> Zweiteilig (passendes Shirt und String)</li>
<li><strong>Material:</strong> Glitzernde Maschenware mit Shimmer-Effekt</li>
<li><strong>Cups:</strong> Ultradünn armaturiert mit Stoffunterlage</li>
<li><strong>Details:</strong> Strass-O-Ringe auf der Brust</li>
<li><strong>Ausschnitte:</strong> Gewagt vorne und hinten</li>
<li><strong>Strumpfbänder:</strong> Verstellbare Oberschenkel für einen provokativen Effekt</li>
<li><strong>String:</strong> Transparent mit Baumwollunterlage</li>
<li><strong>Schnitt:</strong> Eng anliegend und formend</li>
</ul> |
| | stylingtips | | string | <p>Veredeln Sie Ihr Jasmin-Ensemble mit unseren Netzstrümpfen <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">in großen Größen</a>, um den provokativen Look zu vervollständigen, oder fügen Sie einen <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">Kimono in großen Größen</a> aus Seide für kontrastierende Eleganz hinzu. Erkunden Sie unsere <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy Outfits</a> in <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">großen Größen</a>, um gewagte Lagenlooks zu kreieren, oder entdecken Sie unsere <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Negligés in großen Größen,</a> um mit Transparenzen zu spielen. Diese einzigartige Kreation enthüllt Ihre provokative Seite mit glitzernder Raffinesse.</p> |
| | summary | | string | <p>Lassen Sie Ihrer provokativen Seite freien Lauf mit dem Ensemble Jasmin aus glitzernder Maschenware!</p>
<p>Dieses eng anliegende Shirt formt Ihre Silhouette, während die Bügel-Cups Ihr Dekolleté betonen.</p>
<p>Mit seinen Strassringen und den Strumpfhaltern an den Oberschenkeln verwandelt dieses Ensemble jede Frau in eine Göttin der Verführung.</p> |
| | title | | string | Jasmin Set - Schimmernde Verführung und absolute Kühnheit |
| | usageinstructions | | string | <p>Um <strong>Ihren üppigen Brüsten optimalen Halt</strong> zu geben, positionieren Sie vorsichtig die armaturierten Körbchen, bevor Sie die Strumpfbänder an den Oberschenkeln anpassen. Die glitzernde Maschenware schmiegt sich natürlich an Ihre Formen an, ohne einzuengen, und ermöglicht so absolute Bewegungsfreiheit. Die Strumpfhalter lassen sich leicht verstellen, um den gewünschten provokativen Effekt zu erzielen. Dieses Set <strong>passt sich</strong> dank seines figurbetonten Schnitts und der dehnbaren Materialien <strong>jeder Körperform an</strong>. Das Baumwollfutter des Strings garantiert optimalen Tragekomfort den ganzen Abend lang.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε τις πούλιες</li>
<li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li>
<li>Στεγνώστε σε επίπεδη επιφάνεια για να διατηρήσετε το σχήμα των κορδονιών</li>
<li>Ποτέ μην σιδερώνετε απευθείας πάνω στο αφρώδες πλέγμα</li>
<li>Χειριστείτε τα δαχτυλίδια με στρας με προσοχή</li>
<li>Κρεμάστε τα για να αποφύγετε τα τσιμπήματα στο ύφασμα</li>
</ul> |
| | description | | string | <p>Το σετ Jasmin φέρνει επανάσταση στην τέχνη της πρόκλησης με το <strong>λαμπερό πλέγμα</strong> του που μεταμορφώνει τη σιλουέτα σας σε ένα ζωντανό έργο τέχνης. Αυτό το μοναδικό υλικό πιάνει το φως με κάθε κίνηση, δημιουργώντας ένα υπνωτικό οπτικό αποτέλεσμα που αιχμαλωτίζει το μάτι.</p>
<p>Τα <strong>εξαιρετικά λεπτά underwired cups</strong> σμιλεύουν ένα τέλειο ντεκολτέ, ενώ προσφέρουν εξαιρετική στήριξη που <strong>προσαρμόζεται φυσικά σε όλα τα σχήματα σώματος</strong>. Ο τεχνικός σχεδιασμός τους αποκαλύπτει τα προσόντα σας με απίστευτη ακρίβεια, δημιουργώντας το περιζήτητο push-up αποτέλεσμα.</p>
<p>τα στρατηγικά τοποθετημένα <strong>στρας O-ring</strong> στο μπούστο προσθέτουν αυτή την πολύτιμη διάσταση που κάνει τη διαφορά. Αυτές οι λεπτομέρειες δημιουργούν ένα εκλεπτυσμένο, άτακτο αποτέλεσμα που αποκαλύπτει την τόλμη σας με ανησυχητική κομψότητα. <strong>Τα τολμηρά κοψίματα μπροστά και πίσω</strong> αποκαλύπτουν στρατηγικά το δέρμα σας, δημιουργώντας αυτή την ανησυχητική αλληλεπίδραση μεταξύ του τι φαίνεται και του τι κρύβεται. Αυτό το σχέδιο σμιλεύει τη σιλουέτα σας με χειρουργική ακρίβεια, αποκαλύπτοντας τον αισθησιασμό σας από κάθε γωνία.</p>
<p>Οι <strong>ρυθμιζόμενες καλτσοδέτες μέχρι τον μηρό</strong> φέρνουν επανάσταση στους παραδοσιακούς κώδικες δημιουργώντας αυτή τη μοναδικά προκλητική σιλουέτα. Αυτή η καινοτομία μετατρέπει τα πόδια σας στο απόλυτο πλεονέκτημα αποπλάνησης, προσθέτοντας αυτή την παιχνιδιάρικη διάσταση που ξυπνά κάθε φαντασίωση.</p>
<p>Το <strong>διαφανές στρινγκ με βαμβακερή επένδυση</strong> ολοκληρώνει αυτό το εξαιρετικό σετ. Αυτή η προσοχή στην άνεση αποκαλύπτει την τεχνική εξειδίκευση αυτής της δημιουργίας, συνδυάζοντας την τολμηρή αισθητική με τη βέλτιστη ευεξία. Όταν φοράτε αυτό το σετ Jasmin, δεν περνάτε πλέον απαρατήρητη - γίνεστε αυτό το συναρπαστικό πλάσμα που υπνωτίζει με τη λαμπερή χάρη και την ακαταμάχητη μαγνητική αύρα του.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/megalo-megethos-set-gIasemI-poykamIso-shimmering-mesh/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Το λαμπερό πλέγμα</strong> πιάνει το φως με κάθε κίνηση</li>
<li><strong>Κορδόνια με μπανέλα</strong> για βέλτιστη στήριξη και push-up αποτέλεσμα</li>
<li><strong>Στρας σε σχήμα δακτυλίου</strong> για ένα εκλεπτυσμένο, φλερτ αποτέλεσμα</li>
<li><strong>Τολμηρά κοψίματα</strong> μπροστά και πίσω που αποκαλύπτουν το δέρμα σας</li>
<li><strong>Ρυθμιζόμενες καλτσοδέτες</strong> για μια μοναδικά προκλητική εμφάνιση</li>
<li><strong>Ασορτί διαφανές στρινγκ</strong> με βαμβακερή επένδυση για άνεση</li>
<li><strong>Κούρεμα που αγκαλιάζει το σώμα</strong> σας και σμιλεύει φυσικά τη σιλουέτα σας</li>
<li>Τέλεια συντονισμένο<strong>σχέδιο</strong> πουκάμισο και στρινγκ<strong>δύο τεμαχίων</strong> </li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Σετ Jasmin μεγάλο μέγεθος με λαμπερό πλέγμα: ενισχυμένα κύπελλα, δαχτυλίδια με στρας, καλτσοδέτες μέχρι τον μηρό, διαφανές στρινγκ. Προκλητική αποπλάνηση | Diva's Boudoir |
| | keywords | | | title | | string | Jasmine μεγάλο μέγεθος αφρώδες σετ πλέγματος | Diva's Boudoir |
|
| | seotitle | | string | Jasmin μεγάλο μέγεθος shimmering mesh πουκάμισο με σετ καλτσοδέτες μέχρι τον μηρό |
| | seouri | | string | μεγάλο-μέγεθος-σετ-γιασεμί-πουκάμισο-shimmering-mesh |
| | specifications | | string | <ul>
<li><strong>Σετ:</strong> Δύο τεμάχια (ασορτί πουκάμισο και στρινγκ)</li>
<li><strong>Υλικό:</strong> Αστραφτερό πλέγμα με λάμψη</li>
<li><strong>Κύπελλα:</strong> Εξαιρετικά λεπτά ενσύρματα με υφασμάτινο υπόστρωμα</li>
<li><strong>Λεπτομέρειες :</strong> Ο-δακτύλιος με στρας στο μπούστο</li>
<li><strong>Cut-outs :</strong> Τολμηρά μπροστά και πίσω</li>
<li><strong>Κορσέδες :</strong> Ρυθμιζόμενες στους μηρούς για προκλητικό αποτέλεσμα</li>
<li><strong>Στρινγκ</strong>: Διαφανές με βαμβακερή επένδυση</li>
<li><strong>Κοπή :</strong> Φόρμα που εφαρμόζει και σμιλεύει</li>
</ul> |
| | stylingtips | | string | <p>Ενισχύστε το σύνολο Jasmine με τις δικτυωτές <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για να ολοκληρώσετε την προκλητική εμφάνιση, ή προσθέστε ένα μεταξωτό <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">κιμονό plus size</a> για κομψότητα σε αντίθεση. Εξερευνήστε τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι plus size σύνολά</a> μας για να δημιουργήσετε τολμηρές επικαλύψεις ή ανακαλύψτε <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">τα plus size νεγκλιζέ</a> μας για να παίξετε με τις διαφάνειες. Αυτή η μοναδική δημιουργία αποκαλύπτει την προκλητική σας πλευρά με αστραφτερή εκλέπτυνση.</p> |
| | summary | | string | <p>Απελευθερώστε την προκλητική σας πλευρά με το σετ Jasmin σε λαμπερό πλέγμα!</p>
<p>Αυτό το εφαρμοστό σεμινάριο σμιλεύει τη σιλουέτα σας, ενώ τα ενισχυμένα κυπελάκια του αναδεικνύουν το ντεκολτέ σας.</p>
<p>Με τα δαχτυλίδια με στρας και τις ψηλές καλτσοδέτες, αυτό το σετ μεταμορφώνει κάθε γυναίκα σε μια σαγηνευτική θεά.</p> |
| | title | | string | Jasmine Set - Αστραφτερή αποπλάνηση και απόλυτη τόλμη |
| | usageinstructions | | string | <p>Για <strong>τη βέλτιστη στήριξη του πλούσιου στήθους σας</strong>, τοποθετήστε απαλά τα ενισχυμένα κύπελλα πριν ρυθμίσετε τις καλτσοδέτες των μηρών. Το λαμπερό πλέγμα αγκαλιάζει φυσικά το σχήμα σας χωρίς περιορισμούς, επιτρέποντας απόλυτη ελευθερία κινήσεων. Οι καλτσοδέτες ρυθμίζονται εύκολα για να δημιουργήσετε το προκλητικό αποτέλεσμα που θέλετε. Αυτό το σετ <strong>προσαρμόζεται σε όλα τα σχήματα σώματος</strong> χάρη στο εφαρμοστό κόψιμο και τα ελαστικά υφάσματα. Η βαμβακερή επένδυση του στρινγκ εγγυάται βέλτιστη άνεση όλο το βράδυ.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Hand wash in cold water to preserve glitter</li>
<li>Use a mild detergent without bleaching agents</li>
<li>Dry flat to maintain the shape of the underwiring</li>
<li>Never iron directly on the glittering mesh</li>
<li>Handle rhinestone rings with care</li>
<li>Store hanging to avoid snags on the mesh</li>
</ul> |
| | description | | string | <p>The Jasmin set revolutionizes the art of provocation with its <strong>glittering mesh</strong> that transforms your silhouette into a living work of art. This unique material catches the light with every movement, creating a hypnotic visual game that captivates every eye.</p>
<p><strong>Ultra-fine underwired cups</strong> sculpt a perfect décolleté while offering exceptional bra support that <strong>adapts naturally to all body types</strong>. Their technical design reveals your assets with uncanny precision, creating that sought-after push-up effect.</p>
<p>strategically positioned <strong>O-ring rhinestones</strong> on the bust add that precious dimension that makes all the difference. These details create a sophisticated naughty effect that reveals your boldness with unsettling elegance. <strong>Bold front and back cut-outs</strong> strategically reveal your skin, creating that unsettling interplay between what shows and what hides. This design sculpts your silhouette with surgical precision, revealing your sensuality from every angle.</p>
<p><strong>Adjustable thigh garters</strong> revolutionize traditional codes, creating a unique, provocative silhouette. This innovation transforms your legs into assets of absolute seduction, adding that playful dimension that awakens every fantasy.</p>
<p>The <strong>transparent cotton-lined thong</strong> completes this exceptional set. This attention to comfort reveals the technical know-how of this creation, combining bold aesthetics with optimal well-being. When you wear this Jasmin set, you no longer go unnoticed - you become that fascinating creature who hypnotizes with her sparkling grace and irresistible magnetic aura.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/plus-size-set-jasmin-chemise-maille-scintillante/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Shimmering mesh</strong> catches the light with every movement</li>
<li><strong>Underwired cups</strong> for optimum support and a push-up effect</li>
<li><strong>O-ring rhinestones</strong> for a sophisticated, flirtatious effect</li>
<li><strong>Bold</strong> front and back<strong>cut-outs</strong> that reveal your skin</li>
<li><strong>Adjustable thigh garters</strong> for a uniquely provocative look</li>
<li><strong>Matching transparent thong</strong> with cotton lining for comfort</li>
<li><strong>Form-fitting cut</strong> naturally sculpts your figure</li>
<li>Perfectly coordinated<strong>two-piece</strong> shirt and thong<strong>design</strong> </li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Jasmin plus size sparkling mesh set: underwired cups, rhinestone rings, thigh-high garters, transparent thong. Provocative seduction | Diva's Boudoir |
| | keywords | | | title | | string | Jasmine plus size sparkling mesh set | Diva's Boudoir |
|
| | seotitle | | string | Plus size set Jasmin shimmering mesh shirt with thigh-high garters |
| | seouri | | string | plus-size-set-jasmin-chemise-maille-scintillante |
| | specifications | | string | <ul>
<li><strong>Set:</strong> Two-piece (matching shirt and thong)</li>
<li><strong>Material:</strong> Shimmering shimmer mesh</li>
<li><strong>Cups:</strong> Ultra-fine wired with fabric underlay</li>
<li><strong>Details:</strong> O-ring rhinestones on bust</li>
<li><strong>Cut-outs :</strong> Bold front and back</li>
<li><strong>Garters:</strong> Adjustable thighs for provocative effect</li>
<li><strong>G-string</strong>: Transparent with cotton lining</li>
<li><strong>Cut:</strong> Form-fitting and sculpting</li>
</ul> |
| | stylingtips | | string | <p>Enhance your Jasmine ensemble with our <a href="https://www.divasboudoir.com/en/socks-large-size/">plus size</a> fishnet <a href="https://www.divasboudoir.com/en/socks-large-size/">stockings</a> to complete the provocative look, or add a <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size</a> silk <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> for contrasting elegance. Explore our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy plus size outfits</a> to create daring overlays, or discover our <a href="https://www.divasboudoir.com/en/plus-size-robes/">plus size negligees</a> to play with transparencies. This unique creation reveals your provocative side with scintillating sophistication.</p> |
| | summary | | string | <p>Unleash your provocative side with the Jasmin set in shimmering mesh!</p>
<p>This form-fitting chemise sculpts your figure, while its underwired cups sublimate your décolleté.</p>
<p>With its rhinestone rings and thigh-high garters, this set transforms every woman into a seductive goddess.</p> |
| | title | | string | Jasmine Set - Sparkling seduction and absolute audacity |
| | usageinstructions | | string | <p>For <strong>optimum support of your generous breasts</strong>, gently position the underwired cups before adjusting the thigh garters. The shimmering mesh naturally hugs your shape without constraint, allowing total freedom of movement. The garters are easily adjusted to create the provocative effect you desire. This set <strong>adapts to all body shapes</strong> thanks to its form-fitting cut and stretch fabrics. The cotton lining of the thong guarantees optimum comfort all evening long.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar a mano en agua fría para conservar las lentejuelas</li>
<li>Utilizar un detergente suave sin blanqueantes</li>
<li>Secar en plano para mantener la forma de los aros</li>
<li>No planchar nunca directamente sobre la malla brillante</li>
<li>Manipule los anillos de strass con cuidado</li>
<li>Colgar para evitar enganches en el tejido</li>
</ul> |
| | description | | string | <p>El conjunto Jasmin revoluciona el arte de la provocación con su <strong>malla brillante</strong> que transforma tu silueta en una obra de arte viviente. Este material único atrapa la luz con cada movimiento, creando un efecto visual hipnótico que cautiva la mirada.</p>
<p><strong>Las copas ultrafinas con aros</strong> esculpen un escote perfecto al tiempo que ofrecen un sujetador excepcional que <strong>se adapta con naturalidad a todas las formas del cuerpo</strong>. Su diseño técnico revela sus activos con una precisión asombrosa, creando ese codiciado efecto push-up.</p>
<p><strong>los brillantes</strong> estratégicamente situados en el busto añaden esa preciosa dimensión que marca la diferencia. Estos detalles crean un efecto sofisticado y travieso que revela tu atrevimiento con una elegancia inquietante. <strong>Las atrevidas aberturas en la parte delantera y trasera</strong> revelan estratégicamente tu piel, creando esa inquietante interacción entre lo que se muestra y lo que se oculta. Este diseño esculpe tu silueta con precisión quirúrgica, revelando tu sensualidad desde todos los ángulos.</p>
<p><strong>Los ligueros ajustables hasta el muslo</strong> revolucionan los códigos tradicionales creando esta silueta única y provocativa. Esta innovación convierte tus piernas en la mejor baza de seducción, añadiendo esa dimensión lúdica que despierta todas las fantasías.</p>
<p>El <strong>tanga transparente con forro de</strong> algodón completa este conjunto excepcional. Esta atención al confort revela la pericia técnica de esta creación, que combina una estética audaz con un bienestar óptimo. Cuando llevas este conjunto Jasmin, ya no pasas desapercibida: te conviertes en esta criatura fascinante que hipnotiza con su gracia chispeante y su aura magnética irresistible.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/talla-grande-conjunto-jazmín-camisa-malla-brillante/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Malla</strong> brillante que capta la luz con cada movimiento</li>
<li><strong>Copas con aros</strong> para una sujeción óptima y un efecto push-up</li>
<li><strong>Pedrería en forma de O</strong> para un efecto sofisticado y coqueto</li>
<li><strong>Atrevidas aberturas</strong> delanteras y traseras que dejan al descubierto tu piel</li>
<li><strong>Ligas ajustables en los muslos</strong> para un look provocador único</li>
<li><strong>Tanga transparente a juego</strong> con forro de algodón para mayor comodidad</li>
<li><strong>Corte ceñido</strong> al cuerpo que esculpe la silueta de forma natural</li>
<li><strong>Diseño</strong> perfectamente coordinado<strong>de</strong> camiseta y tanga de<strong>dos piezas</strong> </li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Conjunto de malla brillante Jasmin talla grande: copas con aros, aros de strass, ligueros hasta el muslo, tanga transparente. Seducción provocativa | Diva's Boudoir |
| | keywords | | | title | | string | Conjunto de malla brillante talla grande Jasmine | Diva's Boudoir |
|
| | seotitle | | string | Jasmin talla grande camisa de malla brillante con ligueros hasta el muslo conjunto |
| | seouri | | string | talla-grande-conjunto-jazmín-camisa-malla-brillante |
| | specifications | | string | <ul>
<li><strong>Conjunto:</strong> Dos piezas (camiseta y tanga a juego)</li>
<li><strong>Material:</strong> Malla brillante</li>
<li><strong>Copas :</strong> Alambre ultrafino con base de tela</li>
<li><strong>Detalles :</strong> Anilla de strass en el pecho</li>
<li><strong>Recortes :</strong> Atrevidos por delante y por detrás</li>
<li><strong>Ligueros :</strong> Ajustables en los muslos para un efecto provocativo</li>
<li><strong>Tanga</strong>: Transparente con forro de algodón</li>
<li><strong>Corte :</strong> Moldeado y esculpido</li>
</ul> |
| | stylingtips | | string | <p>Mejora tu conjunto Jasmine con nuestras <a href="https://www.divasboudoir.com/es/medias-grandes/">medias de</a> rejilla <a href="https://www.divasboudoir.com/es/medias-grandes/">talla grande</a> para completar el look provocativo, o añade un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">talla grande</a> para contrastar la elegancia. Explora nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexys conjuntos de talla grande</a> para crear atrevidas superposiciones, o descubre nuestros <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> de <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">talla</a> grande para jugar con las transparencias. Esta creación única revela tu lado provocativo con una sofisticación chispeante.</p> |
| | summary | | string | <p>Desata tu lado más provocativo con el conjunto Jasmin de malla brillante</p>
<p>Este ajustado picardías esculpe tu figura, mientras que sus copas con aros realzan tu escote.</p>
<p>Con sus aros de strass y sus ligueros hasta el muslo, este conjunto transforma a toda mujer en una seductora diosa.</p> |
| | title | | string | Jasmine Set - Seducción chispeante y atrevimiento absoluto |
| | usageinstructions | | string | <p>Para <strong>una sujeción óptima de su generoso busto</strong>, coloque suavemente las copas con aros antes de ajustar los ligueros de los muslos. La malla brillante abraza naturalmente tu figura sin constreñirte, permitiendo una total libertad de movimientos. Los ligueros son fáciles de ajustar para crear el efecto provocativo que desee. Este conjunto <strong>se adapta a todas las formas</strong> gracias a su corte ceñido y sus tejidos elásticos. El forro de algodón del tanga garantiza un confort óptimo durante toda la velada.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage à la main à l'eau froide pour préserver les paillettes</li>
<li>Utiliser une lessive douce sans agents blanchissants</li>
<li>Séchage à plat pour maintenir la forme des armatures</li>
<li>Ne jamais repasser directement sur la maille scintillante</li>
<li>Manipuler délicatement les anneaux strass</li>
<li>Ranger suspendu pour éviter les accrocs sur la maille</li>
</ul> |
| | description | | string | <p>L'ensemble Jasmin révolutionne l'art de la provocation avec sa <strong>maille scintillante</strong> qui transforme votre silhouette en œuvre d'art vivante. Cette matière unique accroche la lumière à chaque mouvement, créant un jeu visuel hypnotique qui captive tous les regards.</p>
<p>Les <strong>bonnets armaturés ultra-fins</strong> sculptent un décolleté parfait tout en offrant un soutien exceptionnel qui <strong>s'adapte naturellement à toutes les morphologies</strong>. Leur conception technique révèle vos atouts avec une précision troublante, créant cet effet push-up si recherché.</p>
<p> Les <strong>anneaux strass O-ring</strong> positionnés stratégiquement sur la poitrine ajoutent cette dimension précieuse qui fait toute la différence. Ces détails créent un effet coquin sophistiqué qui révèle votre audace avec une élégance troublante. Les <strong>découpes audacieuses devant et dos</strong> révèlent stratégiquement votre peau, créant ce jeu troublant entre ce qui se montre et ce qui se cache. Cette conception sculpte votre silhouette avec une précision chirurgicale, révélant votre sensualité sous tous les angles.</p>
<p>Les <strong>jarretières cuisses ajustables</strong> révolutionnent les codes traditionnels en créant cette silhouette provocatrice unique. Cette innovation transforme vos jambes en atouts de séduction absolue, ajoutant cette dimension ludique qui éveille tous les fantasmes.</p>
<p>Le <strong>string transparent avec doublure coton</strong> complète harmonieusement cet ensemble d'exception. Cette attention au confort révèle le savoir-faire technique de cette création, alliant audace esthétique et bien-être optimal. Quand vous portez cet ensemble Jasmin, vous ne passez plus inaperçue - vous devenez cette créature fascinante qui hypnotise avec sa grâce scintillante et son aura magnétique irrésistible.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/ensemble-grande-taille-jasmin-chemise-maille-scintillante/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Maille scintillante</strong> qui accroche la lumière à chaque mouvement</li>
<li><strong>Bonnets armaturés</strong> qui offrent un maintien optimal et un effet push-up</li>
<li><strong>Anneaux strass O-ring</strong> pour un effet coquin et sophistiqué</li>
<li><strong>Découpes audacieuses</strong> devant et dos qui révèlent votre peau</li>
<li><strong>Jarretières cuisses ajustables</strong> pour un look provocateur unique</li>
<li><strong>String transparent assorti</strong> avec doublure coton pour le confort</li>
<li><strong>Coupe moulante</strong> qui sculpte naturellement votre silhouette</li>
<li><strong>Design deux pièces</strong> chemise et string parfaitement coordonnés</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ensemble Jasmin grande taille maille scintillante : bonnets armaturés, anneaux strass, jarretières cuisses, string transparent. Séduction provocatrice | Diva's Boudoir |
| | keywords | | | title | | string | Ensemble Jasmin grande taille maille scintillante | Diva's Boudoir |
|
| | seotitle | | string | Ensemble grande taille Jasmin chemise maille scintillante avec jarretières cuisses |
| | seouri | | string | ensemble-grande-taille-jasmin-chemise-maille-scintillante |
| | specifications | | string | <ul>
<li><strong>Ensemble :</strong> Deux pièces (chemise et string assortis)</li>
<li><strong>Matière :</strong> Maille scintillante effet shimmer</li>
<li><strong>Bonnets :</strong> Armaturés ultra-fins avec sous-couche tissu</li>
<li><strong>Détails :</strong> Anneaux strass O-ring sur la poitrine</li>
<li><strong>Découpes :</strong> Audacieuses devant et dos</li>
<li><strong>Jarretières :</strong> Cuisses ajustables pour effet provocateur</li>
<li><strong>String :</strong> Transparent avec doublure coton</li>
<li><strong>Coupe :</strong> Moulante et sculptante</li>
</ul> |
| | stylingtips | | string | <p>Sublimez votre ensemble Jasmin avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> résille pour compléter le look provocateur, ou ajoutez un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono grande taille</a> en soie pour une élégance contrastée. Explorez nos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour créer des superpositions audacieuses, ou découvrez nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">déshabillés grande taille</a> pour jouer avec les transparences. Cette création unique révèle votre côté provocateur avec une sophistication scintillante.</p> |
| | summary | | string | <p>Libérez votre côté provocateur avec l'ensemble Jasmin en maille scintillante !</p>
<p>Cette chemise moulante sculpte votre silhouette tandis que ses bonnets à armatures subliment votre décolleté.</p>
<p>Avec ses anneaux strass et ses jarretières cuisses, cet ensemble transforme chaque femme en déesse de la séduction.</p> |
| | title | | string | Ensemble Jasmin - Séduction Scintillante et Audace Absolue |
| | usageinstructions | | string | <p>Pour un <strong>maintien optimal de votre poitrine généreuse</strong>, positionnez délicatement les bonnets armaturés avant d'ajuster les jarretières cuisses. La maille scintillante épouse naturellement vos formes sans contrainte, permettant une liberté de mouvement totale. Les jarretières se règlent facilement pour créer l'effet provocateur désiré. Cet ensemble <strong>s'adapte à toutes les morphologies</strong> grâce à sa coupe moulante et ses matières extensibles. La doublure coton du string garantit un confort optimal toute la soirée.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavare a mano in acqua fredda per preservare le paillettes</li>
<li>Utilizzare un detergente delicato senza agenti sbiancanti</li>
<li>Asciugare in piano per mantenere la forma del sottofilo</li>
<li>Non stirare mai direttamente sulle maglie scintillanti</li>
<li>Maneggiare con cura gli anelli di strass</li>
<li>Appendere per evitare strappi al tessuto</li>
</ul> |
| | description | | string | <p>Il set Jasmin rivoluziona l'arte della provocazione con la sua <strong>rete scintillante</strong> che trasforma la silhouette in un'opera d'arte vivente. Questo materiale unico cattura la luce a ogni movimento, creando un effetto visivo ipnotico che cattura lo sguardo.</p>
<p>Le <strong>coppe ultrasottili con ferretto</strong> scolpiscono un décolleté perfetto e offrono un reggiseno eccezionale che <strong>si adatta naturalmente a tutte le forme del corpo</strong>. Il loro design tecnico rivela le vostre forme con una precisione sorprendente, creando il ricercato effetto push-up.</p>
<p><strong>gli strass O-ring</strong> strategicamente posizionati sul seno aggiungono quella dimensione preziosa che fa la differenza. Questi dettagli creano un effetto sofisticato e malizioso che rivela la vostra audacia con un'eleganza sconvolgente. <strong>Audaci cut-out sul davanti e sul retro</strong> rivelano strategicamente la vostra pelle, creando un'inquietante interazione tra ciò che è mostrato e ciò che è nascosto. Questo design scolpisce la silhouette con precisione chirurgica, rivelando la vostra sensualità da ogni angolazione.</p>
<p>Il <strong>reggicalze regolabile</strong> rivoluziona i codici tradizionali creando una silhouette unica e provocante. Questa innovazione trasforma le vostre gambe nella risorsa di seduzione per eccellenza, aggiungendo quella dimensione giocosa che risveglia ogni fantasia.</p>
<p>Il <strong>perizoma trasparente con fodera in cotone</strong> completa questo set eccezionale. L'attenzione al comfort rivela la competenza tecnica di questa creazione, che unisce un'estetica audace a un benessere ottimale. Quando indossate questo set Jasmin, non passate più inosservate: diventate questa affascinante creatura che ipnotizza con la sua grazia scintillante e la sua irresistibile aura magnetica.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/set-taglia-grande-camicia-jasmine-maglia-scintillante/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>La rete scintillante</strong> cattura la luce ad ogni movimento</li>
<li><strong>Coppe con ferretto</strong> per un sostegno ottimale e un effetto push-up</li>
<li><strong>Strass a forma di anello per</strong> un effetto sofisticato e civettuolo</li>
<li><strong>Audaci cut-out</strong> anteriori e posteriori che lasciano intravedere la pelle</li>
<li><strong>Giarrettiere regolabili sulle cosce</strong> per un look unico e provocante</li>
<li><strong>Perizoma trasparente abbinato</strong> con fodera in cotone per il massimo comfort</li>
<li><strong>Il taglio aderente al corpo</strong> scolpisce la figura in modo naturale</li>
<li>Camicia e perizoma in<strong>due pezzi</strong> perfettamente coordinati</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Set Jasmin taglia grande in rete scintillante: coppe con ferretto, anelli di strass, reggicalze, perizoma trasparente. Seduzione provocante | Diva's Boudoir |
| | keywords | | | title | | string | Set di rete scintillante taglia grande Jasmine | Diva's Boudoir |
|
| | seotitle | | string | Jasmin taglia grande camicia in rete scintillante con reggicalze |
| | seouri | | string | set-taglia-grande-camicia-jasmine-maglia-scintillante |
| | specifications | | string | <ul>
<li><strong>Set:</strong> Due pezzi (camicia e perizoma coordinati)</li>
<li><strong>Materiale:</strong> Rete scintillante</li>
<li><strong>Coppe :</strong> Ultra finemente cablate con sottotazza in tessuto</li>
<li><strong>Dettagli :</strong> O-ring con strass sul busto</li>
<li><strong>Tagli:</strong> Audaci davanti e dietro</li>
<li><strong>Giarrettiere :</strong> Regolabili sulle cosce per un effetto provocante</li>
<li><strong>Perizoma</strong>: Trasparente con fodera in cotone</li>
<li><strong>Taglio :</strong> aderente e modellante</li>
</ul> |
| | stylingtips | | string | <p>Arricchite il vostro ensemble Jasmine con le nostre <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze</a> a rete <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">taglia grande</a> per completare il look provocante, o aggiungete un <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> di seta <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">taglia grande</a> per un'eleganza a contrasto. Esplorate i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">completi sexy taglia grande</a> per creare audaci sovrapposizioni o scoprite i nostri <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">negligé taglia grande</a> per giocare con le trasparenze. Questa creazione unica rivela il vostro lato provocante con una raffinatezza scintillante.</p> |
| | summary | | string | <p>Liberate il vostro lato provocante con il set Jasmin in rete scintillante!</p>
<p>Questa chemise aderente scolpisce la vostra figura, mentre le coppe con ferretto esaltano il vostro décolleté.</p>
<p>Con i suoi anelli di strass e le giarrettiere alte fino alle cosce, questo set trasforma ogni donna in una dea seducente.</p> |
| | title | | string | Set Gelsomino - Seduzione scintillante e audacia assoluta |
| | usageinstructions | | string | <p>Per un <strong>sostegno ottimale del vostro seno generoso</strong>, posizionate delicatamente le coppe con ferretto prima di regolare i reggicosce. La rete scintillante abbraccia naturalmente le vostre forme senza costringervi, permettendovi una totale libertà di movimento. Le giarrettiere sono facili da regolare per creare l'effetto provocante desiderato. Questo set <strong>si adatta a tutte le forme del corpo</strong> grazie al taglio aderente e ai tessuti elasticizzati. La fodera in cotone del perizoma garantisce un comfort ottimale per tutta la serata.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwas in koud water om de lovertjes te behouden</li>
<li>Gebruik een mild wasmiddel zonder bleekmiddelen</li>
<li>Plat drogen om de vorm van de bedrading te behouden</li>
<li>Strijk nooit rechtstreeks op het fonkelende gaas</li>
<li>Ga voorzichtig om met strassringen</li>
<li>Ophangen om te voorkomen dat de stof blijft haken</li>
</ul> |
| | description | | string | <p>De Jasmin-set brengt een revolutie teweeg in de kunst van het provoceren met het <strong>glinsterende gaas</strong> dat je silhouet verandert in een levend kunstwerk. Dit unieke materiaal vangt het licht bij elke beweging en creëert zo een hypnotiserend visueel effect dat de aandacht trekt.</p>
<p>De <strong>ultradunne beugelcups</strong> vormen een perfect decolleté en bieden uitzonderlijke bh die <strong>zich op natuurlijke wijze aan alle lichaamsvormen aanpast</strong>. Het technische ontwerp onthult je pluspunten met griezelige precisie en creëert dat gewilde push-up effect.</p>
<p>strategisch geplaatste <strong>O-ring strassteentjes</strong> op de buste voegen die kostbare dimensie toe die het verschil maakt. Deze details creëren een geraffineerd, ondeugend effect dat je brutaliteit onthult met een verontrustende elegantie. <strong>De gedurfde uitsnijdingen aan de voor- en achterkant</strong> onthullen je huid op een strategische manier, waardoor een verontrustend samenspel ontstaat tussen wat getoond wordt en wat verborgen blijft. Dit ontwerp vormt je silhouet met chirurgische precisie en onthult je sensualiteit vanuit elke hoek.</p>
<p>De <strong>verstelbare dij-hoge kousenbanden</strong> revolutioneren traditionele codes door dit unieke provocerende silhouet te creëren. Deze innovatie verandert je benen in de ultieme verleiding en voegt die speelse dimensie toe die elke fantasie doet ontwaken.</p>
<p>De <strong>transparante string met katoenen voering</strong> maakt deze uitzonderlijke set compleet. Deze aandacht voor comfort onthult de technische expertise van deze creatie, die gedurfde esthetiek combineert met optimaal welzijn. Als je dit Jasmin-setje draagt, blijf je niet langer onopgemerkt - je wordt dit fascinerende wezen dat hypnotiseert met haar sprankelende gratie en onweerstaanbare magnetische uitstraling.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/grote-maat-set-jasmijn-shirt-glinsterend-mesh/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>Glinsterende mesh</strong> vangt het licht bij elke beweging</li>
<li><strong>Beugelcups</strong> voor optimale ondersteuning en een push-up effect</li>
<li><strong>O-ring strassteentjes</strong> voor een geraffineerd, flirterig effect</li>
<li><strong>Gewaagde uitsnijdingen</strong> voor en achter die je huid onthullen</li>
<li><strong>Verstelbare dijbeenkousenband</strong> voor een unieke, uitdagende look</li>
<li><strong>Bijpassende transparante string</strong> met katoenen voering voor comfort</li>
<li><strong>De nauwsluitende snit</strong> geeft je silhouet een natuurlijke vorm</li>
<li>Perfect gecoördineerd<strong>tweedelig</strong> shirt en string<strong>ontwerp</strong></li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Jasmin grote maat glinsterende mesh set: beugel cups, strass ringen, dij-hoge kousenbanden, transparante string. Provocerende verleiding | Diva's Boudoir |
| | keywords | | | title | | string | Jasmine grote maat sparkling mesh set | Diva's Boudoir |
|
| | seotitle | | string | Jasmin grote maat glinsterende mesh shirt met dijhoge kousenband set |
| | seouri | | string | grote-maat-set-jasmijn-shirt-glinsterend-mesh |
| | specifications | | string | <ul>
<li><strong>Set:</strong> Tweedelig (bijpassend shirt en string)</li>
<li><strong>Materiaal:</strong> Glinsterende mesh</li>
<li><strong>Cups :</strong> Ultrafijn bedraad met stoffen onderlaag</li>
<li><strong>Details :</strong> O-ring strassteentjes op de buste</li>
<li><strong>Uitsparingen :</strong> Gewaagde voor- en achterkant</li>
<li><strong>Kousenband :</strong> Verstelbare dijen voor een uitdagend effect</li>
<li><strong>G-string</strong>: Transparant met katoenen voering</li>
<li><strong>Snit :</strong> Aansluitend en modellerend</li>
</ul> |
| | stylingtips | | string | <p>Verfraai je Jasmine ensemble met onze <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">grote maten</a> visnet <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">kousen</a> om de provocerende look compleet te maken, of voeg een <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">grote maat</a> zijden <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> toe voor contrasterende elegantie. Ontdek onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy outfits van grote maten</a> om gewaagde overlays te creëren of ontdek onze <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés van grote maten</a> om te spelen met transparanties. Deze unieke creatie onthult je uitdagende kant met sprankelende verfijning.</p> |
| | summary | | string | <p>Laat je van je uitdagende kant zien met de Jasmin set van glinsterend mesh!</p>
<p>Deze nauwsluitende chemise vormt je figuur, terwijl de beugelcups je decolleté verbeteren.</p>
<p>Met zijn strasringen en dijhoge kousenbanden verandert deze set elke vrouw in een verleidelijke godin.</p> |
| | title | | string | Jasmijn Set - Sprankelende verleiding en absolute durf |
| | usageinstructions | | string | <p>Voor <strong>optimale ondersteuning van je royale buste</strong> plaats je de beugelcups voorzichtig voordat je de dijbeugels aanpast. Het glinsterende gaas omhelst op natuurlijke wijze je vorm zonder beperkingen, waardoor je volledige bewegingsvrijheid hebt. De kousenbanden zijn eenvoudig te verstellen om het provocerende effect te creëren dat jij wilt. Dit setje <strong>past zich aan alle lichaamsvormen</strong> aan dankzij de vormvaste snit en de stretchstoffen. De katoenen voering van de string garandeert optimaal comfort, de hele avond lang.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar à mão em água fria para preservar as lantejoulas</li>
<li>Utilizar um detergente suave sem agentes branqueadores</li>
<li>Secar na horizontal para manter a forma dos fios inferiores</li>
<li>Nunca passar a ferro diretamente sobre a malha brilhante</li>
<li>Manusear as argolas de strass com cuidado</li>
<li>Pendurar para evitar que o tecido fique preso</li>
</ul> |
| | description | | string | <p>O conjunto Jasmin revoluciona a arte da provocação com a sua <strong>malha brilhante</strong> que transforma a sua silhueta numa obra de arte viva. Este material único capta a luz a cada movimento, criando um efeito visual hipnótico que cativa o olhar.</p>
<p><strong>As copas ultra-finas com arame</strong> esculpem um decote perfeito, oferecendo um apoio excecional que <strong>se adapta naturalmente a todas as formas do corpo</strong>. O seu design técnico revela os seus atributos com uma precisão incrível, criando o tão procurado efeito push-up.</p>
<p><strong>os strass em O-ring</strong> estrategicamente colocados no busto acrescentam aquela dimensão preciosa que faz toda a diferença. Estes detalhes criam um efeito sofisticado e atrevido que revela a sua ousadia com uma elegância inquietante. <strong>Recortes ousados na frente e nas costas</strong> revelam estrategicamente a sua pele, criando aquela interação inquietante entre o que é mostrado e o que é escondido. Este design esculpe a sua silhueta com precisão cirúrgica, revelando a sua sensualidade de todos os ângulos.</p>
<p>As <strong>ligas ajustáveis na altura das coxas</strong> revolucionam os códigos tradicionais, criando esta silhueta única e provocante. Esta inovação transforma as suas pernas no derradeiro trunfo de sedução, acrescentando aquela dimensão lúdica que desperta todas as fantasias.</p>
<p>A <strong>tanga transparente com forro de algodão</strong> completa este conjunto excecional. Esta atenção ao conforto revela a perícia técnica desta criação, combinando uma estética arrojada com um bem-estar ótimo. Ao usar este conjunto Jasmin, já não passa despercebida, transforma-se nesta criatura fascinante que hipnotiza com a sua graça cintilante e a sua aura magnética irresistível.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/conjunto-tamanho-grande-jasmim-camisa-malha-cintilante/sbbu5925.htm |
| | highlights | | string | <ul>
<li><strong>A malha cintilante</strong> capta a luz em cada movimento</li>
<li><strong>Copas com aros</strong> para um apoio ótimo e um efeito push-up</li>
<li><strong>Brilhantes em forma de anel</strong> para um efeito sofisticado e sedutor</li>
<li><strong>Recortes ousados</strong> à frente e atrás que revelam a sua pele</li>
<li><strong>Ligas ajustáveis nas coxas</strong> para um look único e provocante</li>
<li><strong>Tanga transparente a condizer</strong> com forro de algodão para maior conforto</li>
<li><strong>O corte justo ao corpo</strong> esculpe naturalmente a sua figura</li>
<li>Camisa e tanga<strong>de duas peças</strong> perfeitamente coordenadas</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Conjunto de malha cintilante Jasmin tamanho grande: copas com aros, anéis de strass, ligas até à coxa, tanga transparente. Sedução provocante | Diva's Boudoir |
| | keywords | | | title | | string | Conjunto de malha cintilante Jasmine tamanho grande | Diva's Boudoir |
|
| | seotitle | | string | Conjunto de camisa de malha cintilante e ligas até à coxa Jasmin tamanho grande |
| | seouri | | string | conjunto-tamanho-grande-jasmim-camisa-malha-cintilante |
| | specifications | | string | <ul>
<li><strong>Conjunto:</strong> Duas peças (camisa e tanga a condizer)</li>
<li><strong>Material:</strong> Malha cintilante</li>
<li><strong>Copas :</strong> Com arame ultra-fino e base em tecido</li>
<li><strong>Pormenores:</strong> Anel em O com brilhantes no busto</li>
<li><strong>Recortes :</strong> Frente e costas ousadas</li>
<li><strong>Ligas :</strong> Ajustáveis nas coxas para um efeito provocante</li>
<li><strong>Fio-dental</strong>: Transparente com forro de algodão</li>
<li><strong>Corte :</strong> Adaptável e esculpido</li>
</ul> |
| | stylingtips | | string | <p>Melhore o seu conjunto Jasmine com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> de rede <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">plus size</a> para completar o visual provocante, ou adicione um <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">quimono</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size</a> para uma elegância contrastante. Explore os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexy plus size</a> para criar sobreposições ousadas, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees plus size</a> para brincar com as transparências. Esta criação única revela o seu lado provocante com uma sofisticação cintilante.</p> |
| | summary | | string | <p>Liberte o seu lado provocante com o conjunto Jasmin em malha cintilante!</p>
<p>Esta camisa de noite esculpe a sua figura, enquanto as copas com aros realçam o seu decote.</p>
<p>Com os seus anéis de strass e ligas até às coxas, este conjunto transforma qualquer mulher numa deusa sedutora.</p> |
| | title | | string | Conjunto Jasmine - Sedução cintilante e ousadia absoluta |
| | usageinstructions | | string | <p>Para um <strong>apoio ótimo do seu busto generoso</strong>, posicione suavemente as copas com arame antes de ajustar as ligas das coxas. A malha cintilante abraça naturalmente a sua forma sem constrangimentos, permitindo uma total liberdade de movimentos. As ligas são fáceis de ajustar para criar o efeito provocante que deseja. Este conjunto <strong>adapta-se a todas as formas do corpo</strong> graças ao seu corte justo e aos tecidos elásticos. O forro em algodão da tanga garante um conforto ótimo durante toda a noite.</p> |
|
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | | string | ENSEMBLE DE CHEMISE PORTE-JARRETELLES yasmine |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 |
|
| promountil | |
| rating | |
| recorduid | | string | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 2.14 ms Record Count: 10 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,2067,2073,2075') > 0 and product_variations.productuid = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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
| | recorduid | size | sizetype | color | param1 | param2 | available | groupavailable | stock | gender | sizerange | sizegroup | suppliersize | intlsize | inches | eusize | ussize | uksize | frsize | essize | desize | itsize | ptsize | elsize | bust | waist | hip | underbust | cup | thigh | legheight | bodyheight | bodyweight | | 1 | 2074 | 1X/2X- | intlsize | deeprose | 1X/2X | | -1 | 999999 | 0 | w | plus | lingerie | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | 104-110 | 86-91 | 112-120 | | | | | | | | 2 | 2074 | 1X/2X- | intlsize | black | 1X/2X | | -1 | 999999 | 0 | w | plus | lingerie | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | 104-110 | 86-91 | 112-120 | | | | | | | | 3 | 2075 | 3X/4X+ | intlsize | deeprose | 3X/4X+ | 3X/4X+ | -1 | 999999 | 0 | w | plus | lingerie | 3X/4X | 3X/4X+ | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 128-132 | 102-108 | 132-138 | | | | | | | | 4 | 2075 | 3X/4X+ | intlsize | black | 3X/4X+ | 3X/4X+ | -1 | 999999 | 0 | w | plus | lingerie | 3X/4X | 3X/4X+ | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 128-132 | 102-108 | 132-138 | | | | | | | | 5 | 2069 | XL | intlsize | deeprose | XL | XL | -1 | 999999 | 0 | w | plus | lingerie | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | 99-104 | 81-86 | 107-112 | | | | | | | | 6 | 2069 | XL | intlsize | black | XL | XL | -1 | 999999 | 0 | w | plus | lingerie | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | 99-104 | 81-86 | 107-112 | | | | | | | | 7 | 2067 | 1X/2X | intlsize | deeprose | 1X/2X | 1X/2X | -1 | 999999 | 0 | w | plus | lingerie | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 112-118 | 92-96 | 122-128 | | | | | | | | 8 | 2067 | 1X/2X | intlsize | black | 1X/2X | 1X/2X | -1 | 999999 | 0 | w | plus | lingerie | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 112-118 | 92-96 | 122-128 | | | | | | | | 9 | 2073 | 3X/4X | intlsize | black | 3X/4X | 3X/4X | -1 | 999999 | 0 | w | plus | lingerie | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 120-128 | 98-102 | 128-132 | | | | | | | | 10 | 2073 | 3X/4X | intlsize | deeprose | 3X/4X | 3X/4X | -1 | 999999 | 0 | w | plus | lingerie | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 120-128 | 98-102 | 128-132 | | | | | | |
|
| sizeranges | |
| sizes | | string | 2069,2074,2067,2073,2075 |
|
| sizetype | |
| specifications | Struct Entries: 23 | | belly | | | bones | | | bra | | | breasts | | | bust | | | closing | | | crochtless | | | cups | | | cut | | | garter | | | halter | | | lacing | | | lining | | | modestypanel | | | panty | | | sheathing | | | sleeves | | | stocking | | | straps | | | stretch | | | suspenders | | | transparency | | | underwires | |
|
| stock | |
| stocks | Query Template: /system/api/product/stocks.cfc:25 Execution Time: 9.48 ms Record Count: 6 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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
| | productuid | variationuid | recorduid | color | hexvalue | suppliersize | intlsize | inches | eusize | ussize | uksize | frsize | essize | desize | itsize | ptsize | elsize | gender | sizegroup | cup | size | sizetype | itemprice | itempromo | promoUntil | stockuid | warehouse | ontour | packaging | supplier | reserved | ordered | returned | defect | manufacturerreference | ean | available | stock | display | comments | | 1 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | 88BC89A4-BF56-4DFD-894B6C7A1788EC33 | 2074 | black | #000000 | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | all | | | 2 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | 8A28DF21-A6F6-49A3-88BA0B094322AA1B | 2074 | deeprose | #880E4F | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD06606A-PLUM | 198680005283 | -1 | 0 | all | | | 3 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | 3E52F1AD-AAE7-4DBF-B6CD7D0B694B5EA8 | 2069 | black | #000000 | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | XL | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | all | | | 4 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | 1A9DB1A7-3403-45E1-B648E2D45F70DC74 | 2069 | deeprose | #880E4F | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | XL | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-PLUM | | -1 | 0 | all | | | 5 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | 5BF95579-3AC2-4A07-B904E5A12F7CF451 | 2073 | black | #000000 | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | all | | | 6 | B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1 | EBF9D481-0471-4AAE-A66578CE1D443637 | 2073 | deeprose | #880E4F | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | HD06606A-PLUM | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 26.1 ms Record Count: 10 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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 = 'B0ED1CDB-9D86-4302-B0AB33F3A45CAFD1' 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
| | variationuid | recorduid | color | hexvalue | suppliersize | intlsize | inches | eusize | ussize | uksize | frsize | essize | desize | itsize | ptsize | elsize | gender | sizegroup | cup | size | sizetype | itemprice | itempromo | promoUntil | stockuid | warehouse | ontour | packaging | supplier | reserved | ordered | returned | defect | manufacturerreference | ean | available | stock | availablepersize | stockpersize | availablepercolor | stockpercolor | haspromo | unitprice | display | comments | | 1 | 88BC89A4-BF56-4DFD-894B6C7A1788EC33 | 2074 | black | #000000 | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 2 | 8A28DF21-A6F6-49A3-88BA0B094322AA1B | 2074 | deeprose | #880E4F | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD06606A-PLUM | 198680005283 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 3 | 5BF95579-3AC2-4A07-B904E5A12F7CF451 | 2075 | black | #000000 | 3X/4X | 3X/4X+ | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | 3X/4X+ | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 4 | EBF9D481-0471-4AAE-A66578CE1D443637 | 2075 | deeprose | #880E4F | 3X/4X | 3X/4X+ | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | 3X/4X+ | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | HD06606A-PLUM | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 5 | 3E52F1AD-AAE7-4DBF-B6CD7D0B694B5EA8 | 2069 | black | #000000 | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | XL | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 6 | 1A9DB1A7-3403-45E1-B648E2D45F70DC74 | 2069 | deeprose | #880E4F | XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | XL | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-PLUM | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 7 | 88BC89A4-BF56-4DFD-894B6C7A1788EC33 | 2067 | black | #000000 | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 1X/2X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 8 | 8A28DF21-A6F6-49A3-88BA0B094322AA1B | 2067 | deeprose | #880E4F | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 1X/2X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD06606A-PLUM | 198680005283 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 9 | 5BF95579-3AC2-4A07-B904E5A12F7CF451 | 2073 | black | #000000 | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD06606A-BLAK | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | | | 10 | EBF9D481-0471-4AAE-A66578CE1D443637 | 2073 | deeprose | #880E4F | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 48.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | HD06606A-PLUM | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 48.2917 | all | |
|
| vatrate | |
| warehouse | |