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: 0.857 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 | 2 |
|
| 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 17:18:30'} |
|
| 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 | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-11-03 16:55:23'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.807 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select cart_actions.* from cart_actions where cart_actions.branding IN ('all','divasboudoir') and cart_actions.language IN ('all','es') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('c57fc38e-ea9f-45ef-8ee9bdf39d464fa8',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: 1.55 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','es') and product_categories.language in ('all','es') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'SBBU9374' 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/sbbu9374/bustier_grande_taille_snake_detail.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu9374/bustier_grande_taille_snake_dos.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu9374/bustier_grande_taille_snake.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbbu9374/bustier_grande_taille_snake.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 den Flor zu erhalten</li>
<li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li>
<li>Liegend trocknen, um die Form des Rahmens zu erhalten</li>
<li>Niemals direkt über das Samtmuster bügeln</li>
<li>Satinbindungen vorsichtig handhaben</li>
<li>Hängend aufbewahren, um Falten in der Maschenware zu vermeiden</li>
</ul> |
| | description | | string | <p>Dieses Snake-Bustier revolutioniert die Kunst der Verführung mit seinem <strong>Schlangenmuster aus Samt auf Maschenware</strong>, das bei jeder Bewegung ein hypnotisches visuelles Spiel erzeugt. Diese einzigartige Textur verwandelt Ihre Silhouette in ein lebendiges Kunstwerk, das alle Blicke auf sich zieht.</p>
<p>Der<strong>innovative Monofil-Bügel</strong> formt ein perfektes Dekolleté und bietet gleichzeitig außergewöhnlichen BH-Stütz, der <strong>sich ganz natürlich an jede Körperform anpasst</strong>. Dieses technische Design enthüllt Ihre Vorzüge mit chirurgischer Präzision und schafft diese perfekte Kurve, die sofort die Aufmerksamkeit auf sich zieht. Der <strong>gewagte Frontausschnitt</strong> enthüllt strategisch Ihre Haut und schafft dieses verwirrende Spiel zwischen dem, was man sieht, und dem, was man verbirgt. Die vertikalen Satinbindungen formen Ihre Taille mit beunruhigender Eleganz und lassen Ihre Silhouette auf natürliche Weise schlanker wirken, sodass Sie garantiert einen atemberaubenden Effekt erzielen.</p>
<p>Der <strong>tief ausgeschnittene Rücken mit seiner geformten Kontur</strong> enthüllt die sinnliche Kurve Ihrer Wirbelsäule und enthüllt Ihre Schönheit aus jedem Blickwinkel.</p>
<p>Dieses Design enthüllt Ihre Sinnlichkeit mit einer Raffinesse, die über alle Konventionen hinausgeht. Der <strong>passende High-Waist-String</strong> ergänzt dieses außergewöhnliche Set harmonisch mit seinen verstellbaren doppelten Seitenbändern, die die begehrte moderne Silhouette kreieren. Diese perfekte Abstimmung offenbart Ihre Liebe zum Detail und Ihren Geschmack für hervorragende Qualität. Die <strong>verstellbaren Träger</strong> sorgen den ganzen Tag über für optimalen Tragekomfort und ermöglichen eine individuelle Passform, die Ihre Formen auf natürliche Weise hervorhebt.</p>
<p>Wenn Sie dieses Snake-Bustier tragen, bleiben Sie nicht länger unbemerkt - Sie hypnotisieren mit dieser unwiderstehlichen katzenhaften Anmut.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/bustier-mit-großer-Taille-Snake-Schlangennetz-Bügel/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Einfädiger Bü</strong> gel, der optimalen BH für große Brüste bietet</li>
<li><strong>Gewagter frontaler Ausschnitt</strong>, der Ihre Haut auf raffinierte Weise enthüllt</li>
<li><strong>Vertikale, formende Bindebänder</strong>, die die Taille natürlich schlanker wirken lassen</li>
<li><strong>Tief ausgeschnittener Rücken</strong> für eine schmeichelhafte Silhouette aus jedem Blickwinkel</li>
<li><strong>Verstellbare Träger</strong>, die sich perfekt an Ihre Körperform anpassen</li>
<li><strong>Passender High Waist String</strong> mit verstellbaren Seitenbändern</li>
<li><strong>Samtweiches Schlangenmuster</strong>, das bei jeder Bewegung das Licht fängt</li>
<li><strong>Hakenverschluss am Rücken</strong> für eine optimale individuelle Passform</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Snake-Bustier in Übergröße aus Schlangennetz: Einfädiger Bügel, frontaler Ausschnitt, formende Bänder, passender High-Waist-String. Hypnotische Verführung | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake große Größe Schlangenmasche Armatur | Diva's Boudoir |
|
| | seotitle | | string | Bustier in Übergröße Snake aus Schlangennetz mit Bügel und passendem String |
| | seouri | | string | bustier-mit-großer-Taille-Snake-Schlangennetz-Bügel |
| | specifications | | string | <ul>
<li><strong>Art :</strong> Bustier mit passendem High-Waist-String</li>
<li><strong>Muster:</strong> Samtschlange auf Maschenware</li>
<li>Bügel<strong>:</strong> Monofil für optimalen BH</li>
<li><strong>Ausschnitte:</strong> Gewagte Front und tief ausgeschnittener Rücken.</li>
<li><strong>Träger:</strong> Verstellbar für individuellen Komfort.</li>
<li><strong>String:</strong> Hohe Taille mit doppelten seitlichen Riemen</li>
<li><strong>Verschluss:</strong> Haken und Ösen im Rücken</li>
<li><strong>Bindungen:</strong> Vertikal aus Satin für einen formenden Effekt</li>
</ul> |
| | stylingtips | | string | <p>Veredeln Sie Ihr Snake-Bustier mit unseren Netzstrümpfen <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">in Übergröße</a> für einen raffinierten Rock-Look, oder ergänzen Sie es mit unseren <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">sexy Outfits</a> in Übergröße, um gewagte Lagenlooks zu kreieren.</p>
<p>Erkunden Sie unsere <a href="https://www.divasboudoir.com/de/body-in-ubergrosse/">Bodys in großen Größen</a> aus der gleichen Kollektion, um Abwechslung zu schaffen, 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 Kontrasten zu spielen. Dieses Einzelstück lässt sich perfekt mit unserer gesamten anspruchsvollen Kollektion kombinieren.</p> |
| | summary | | string | <p>Stehlen Sie sich die Show mit diesem Snake-Bustier aus Mesh mit Schlangenmuster!</p>
<p>Der einfädige Bügel bietet perfekten BH, während der gewagte Frontausschnitt und die vertikalen Bänder Ihre Taille formen. Zusammen mit dem passenden hochgeschnittenen String verwandelt dieses Set jeden Auftritt in einen Moment der puren Faszination.</p> |
| | title | | string | Snake Bustier - Hypnotische Verführung und geformte Taille |
| | usageinstructions | | string | <p>Um <strong>Ihre große Brust optimal zu unterstützen</strong>, stellen Sie die Träger vorsichtig ein, bevor Sie die Rückenhaken schließen. Der einfädige Bügel sollte sich natürlich an die Kurve Ihrer Büste anpassen, um einen perfekten Halt zu gewährleisten.</p>
<p>Die vertikalen Bänder werden so positioniert, dass sie Ihre Taille formen und den gewünschten schlankmachenden Effekt erzeugen. Der High Waist String lässt sich dank seiner doppelten Riemen leicht verstellen und <strong>passt sich so jeder Körperform</strong> an.</p>
<p>Dieses Stück enthüllt Ihre wilde Seite mit einer raffinierten natürlichen Eleganz.</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>Αυτό το μπούστο Snake φέρνει επανάσταση στην τέχνη της αποπλάνησης με το <strong>βελούδινο μοτίβο φιδιού</strong> που δημιουργεί ένα υπνωτικό οπτικό αποτέλεσμα με κάθε κίνηση. Αυτή η μοναδική υφή μεταμορφώνει τη σιλουέτα σας σε ένα ζωντανό έργο τέχνης που αιχμαλωτίζει το μάτι.</p>
<p>Το<strong>πρωτοποριακό μονόσυρματο underwire</strong> σμιλεύει ένα τέλειο ντεκολτέ, ενώ προσφέρει εξαιρετική στήριξη που <strong>προσαρμόζεται φυσικά σε όλα τα σχήματα σώματος</strong>. Αυτός ο τεχνικός σχεδιασμός αποκαλύπτει τα προτερήματά σας με χειρουργική ακρίβεια, δημιουργώντας αυτή την τέλεια καμπύλη που τραβάει αμέσως τα βλέμματα. Το <strong>τολμηρό μπροστινό κόψιμο</strong> αποκαλύπτει στρατηγικά το δέρμα σας, δημιουργώντας αυτή την ανησυχητική αλληλεπίδραση μεταξύ του τι φαίνεται και του τι κρύβεται. Τα κάθετα σατέν κορδόνια σμιλεύουν τη μέση σας με ανησυχητική κομψότητα, βελτιώνοντας φυσικά τη σιλουέτα σας για ένα εγγυημένα εντυπωσιακό αποτέλεσμα.</p>
<p>Το <strong>χαμηλό κόψιμο στην πλάτη με το σμιλευμένο περίγραμμα</strong> αποκαλύπτει την αισθησιακή καμπύλη της σπονδυλικής σας στήλης, αποκαλύπτοντας την ομορφιά σας από κάθε γωνία.</p>
<p>Αυτό το σχέδιο αποκαλύπτει τον αισθησιασμό σας με μια φινέτσα που ξεπερνά τις συμβάσεις. Το <strong>ασορτί στρινγκ με υψηλή μέση</strong> ολοκληρώνει αυτό το εξαιρετικό σετ με διπλά ρυθμιζόμενα πλαϊνά λουράκια που δημιουργούν την περιζήτητη μοντέρνα σιλουέτα. Αυτός ο τέλειος συντονισμός αποκαλύπτει την προσοχή σας στη λεπτομέρεια και το γούστο σας για την τελειότητα. Οι <strong>ρυθμιζόμενοι ιμάντες</strong> εξασφαλίζουν βέλτιστη άνεση όλη την ημέρα, επιτρέποντας μια εξατομικευμένη εφαρμογή που ενισχύει φυσικά το σχήμα σας.</p>
<p>Όταν φοράτε αυτό το μπούστο Snake, δεν θα περνάτε ποτέ απαρατήρητη - θα μαγνητίζετε με την ακαταμάχητη αιλουροειδή χάρη.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/megalo-megethos-bustier-fIdIsIo-plegma-underwire/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Το μονό συρματόσχοινο</strong> παρέχει βέλτιστη στήριξη για μεγαλύτερα στήθη</li>
<li><strong>Το τολμηρό μπροστινό κόψιμο</strong> αποκαλύπτει το δέρμα σας με φινέτσα</li>
<li><strong>Σχηματιστικά κάθετα κορδόνια</strong> που βελτιώνουν φυσικά τη γραμμή της μέσης</li>
<li><strong>Χαμηλό κόψιμο στην πλάτη</strong> για κολακευτική σιλουέτα από κάθε γωνία</li>
<li><strong>Οι ρυθμιζόμενες τιράντες</strong> προσαρμόζονται τέλεια στο σχήμα του σώματός σας</li>
<li><strong>Ασορτί στρινγκ με ψηλή μέση</strong> και ρυθμιζόμενες πλαϊνές τιράντες</li>
<li><strong>Το βελούδινο σχέδιο φιδιού</strong> πιάνει το φως σε κάθε κίνηση</li>
<li><strong>Κλείσιμο με άγκιστρο και μάτια στο πίσω μέρος</strong> για βέλτιστη προσαρμογή</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Μπουστάκι από φιδίσιο πλέγμα plus-size: μονό συρματόσχοινο, μπροστινό cut-out, κορδόνια γλυπτικής, ασορτί στρινγκ με ψηλή μέση. Υπνωτική αποπλάνηση | Diva's Boudoir |
| | keywords | | | title | | string | Μπουστάκι Snake μεγάλο μέγεθος διχτυωτό με μπανέλα | Diva's Boudoir |
|
| | seotitle | | string | Μεγάλο μπουστάκι με πλέγμα φιδιού με μπανέλα και ασορτί στρινγκ |
| | seouri | | string | μεγάλο-μέγεθος-bustier-φιδίσιο-πλέγμα-underwire |
| | specifications | | string | <ul>
<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>
<li><strong>Γραβάτες:</strong> Για σμιλευτικό αποτέλεσμα</li>
</ul> |
| | stylingtips | | string | <p>Ενισχύστε το μπούστο Snake με τις δικτυωτές <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για μια εκλεπτυσμένη ροκ εμφάνιση ή ολοκληρώστε την εμφάνιση με τα <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">σέξι ρούχα plus size</a> για να δημιουργήσετε τολμηρές επικαλύψεις.</p>
<p>Εξερευνήστε τα <a href="https://www.divasboudoir.com/el/kormaki-syn-megethos/">plus size κορμάκια</a> μας από την ίδια συλλογή για ποικιλία, ή ανακαλύψτε τα <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">plus size νεγκλιζέ</a> μας για να παίξετε με τις αντιθέσεις. Αυτό το μοναδικό κομμάτι ταιριάζει απόλυτα με την εκλεπτυσμένη συλλογή μας.</p> |
| | summary | | string | <p>Κλέψτε την παράσταση με αυτό το μπούστο από πλέγμα Snake!</p>
<p>Το μονό συρματόσχοινο προσφέρει τέλεια στήριξη, ενώ το τολμηρό μπροστινό κόψιμο και τα κάθετα κορδόνια σμιλεύουν τη μέση σας. Σε συνδυασμό με το ασορτί στρίνγκ υψηλής μέσης, αυτό το σετ μετατρέπει κάθε σας εμφάνιση σε μια στιγμή απόλυτης γοητείας.</p> |
| | title | | string | Bustier Snake - Υπνωτική αποπλάνηση και σμιλεμένη μέση |
| | usageinstructions | | string | <p>Για <strong>βέλτιστη στήριξη του πλούσιου στήθους σας</strong>, ρυθμίστε απαλά τους ιμάντες πριν κλείσετε τα άγκιστρα στην πλάτη. Το μονό συρματόσχοινο θα πρέπει να ακολουθεί φυσικά την καμπύλη του στήθους σας για τέλεια στήριξη.</p>
<p>Τα κάθετα δεσίματα τοποθετούνται έτσι ώστε να σμιλεύουν τη μέση σας και να δημιουργούν το επιθυμητό αποτέλεσμα αδυνατίσματος. Το ψηλόμεσο στρινγκ ρυθμίζεται εύκολα χάρη στους διπλούς ιμάντες του για μια <strong>εφαρμογή που προσαρμόζεται σε όλα τα σχήματα σώματος</strong>.</p>
<p>Αυτό το κομμάτι αποκαλύπτει την άγρια πλευρά σας με εκλεπτυσμένη φυσική κομψότητα.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Hand wash in cold water to preserve the velvet</li>
<li>Use a mild detergent without bleaching agents</li>
<li>Dry flat to maintain the shape of the frame</li>
<li>Never iron directly on the velvet pattern</li>
<li>Handle satin ties with care</li>
<li>Store hanging to avoid wrinkling the knitwear</li>
</ul> |
| | description | | string | <p>This Snake bustier revolutionizes the art of seduction with its <strong>velvet-on-mesh snake pattern</strong> that creates a hypnotic visual play with every movement. This unique texture transforms your silhouette into a living work of art that captivates every eye.</p>
<p>The<strong>innovative single-wire underwire</strong> sculpts a perfect décolleté while offering exceptional bra that <strong>adapts naturally to all body types</strong>. This technical design reveals your assets with surgical precision, creating that perfect curve that immediately catches the eye. The <strong>bold front cut</strong> strategically reveals your skin, creating that unsettling interplay between what shows and what hides. Vertical satin ties sculpt your waist with unsettling elegance, naturally refining your silhouette for a guaranteed striking effect.</p>
<p>The <strong>low-cut back with its sculpted contour</strong> reveals the sensual curve of your spine, revealing your beauty from every angle.</p>
<p>This design reveals your sensuality with a sophistication that transcends convention. The <strong>matching high-waisted thong</strong> harmoniously completes this exceptional set, with its double adjustable side straps creating that sought-after modern silhouette. This perfect coordination reveals your attention to detail and taste for excellence. <strong>Adjustable straps</strong> guarantee all-day comfort, allowing a personalized fit that naturally enhances your shape.</p>
<p>When you wear this Snake bustier, you no longer go unnoticed - you hypnotize with that irresistible feline grace.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/bustier-plus-size-snake-mesh-underwire/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Single-wire underwire</strong> provides optimal bra support for fuller breasts</li>
<li><strong>Bold front cut</strong> reveals your skin with sophistication</li>
<li><strong>Sculpting vertical ties</strong> that naturally refine the waistline</li>
<li><strong>Low-cut back</strong> for a flattering silhouette from every angle</li>
<li><strong>Adjustable straps</strong> for a perfect fit</li>
<li><strong>Matching high-waisted thong</strong> with adjustable side straps</li>
<li><strong>Velvet snake pattern</strong> that catches the light with every movement</li>
<li><strong>Hook-and-eye back closure</strong> for optimum custom fit</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Snake-mesh plus size bustier: single-wire underwire, front cutout, sculpting ties, matching high-waisted thong. Hypnotic seduction | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake plus size mesh underwire | Diva's Boudoir |
|
| | seotitle | | string | Plus size Snake mesh bustier with underwire and matching thong |
| | seouri | | string | bustier-plus-size-snake-mesh-underwire |
| | specifications | | string | <ul>
<li><strong>Type :</strong> Bustier with matching high-waisted thong</li>
<li><strong>Pattern:</strong> Velvet snake on mesh</li>
<li><strong>Underwire:</strong> Monofilament for optimal bra</li>
<li><strong>Cut-outs :</strong> Bold front and low-cut back</li>
<li><strong>Straps:</strong> Adjustable for personalized comfort</li>
<li><strong>Thong:</strong> High waist with double side straps</li>
<li><strong>Closure:</strong> Hooks and eyelets in back</li>
<li><strong>Ties:</strong> Vertical satin ties for sculpting effect</li>
</ul> |
| | stylingtips | | string | <p>Sublimate your Snake bustier 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> for a sophisticated rock look, or complete with our <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">plus size sexy outfits</a> to create daring overlays.</p>
<p>Explore our <a href="https://www.divasboudoir.com/en/plus-size-body/">plus size bodysuits</a> from the same collection for variety, or discover our <a href="https://www.divasboudoir.com/en/plus-size-robes/">plus size negligees</a> to play with contrasts. This unique piece is a perfect match for our entire sophisticated collection.</p> |
| | summary | | string | <p>Steal the show with this Snake mesh bustier!</p>
<p>Its single-wire underwire offers perfect bra support, while its bold front cutout and vertical ties sculpt your waist. Accompanied by its matching high-waisted thong, this ensemble transforms every appearance into a moment of pure fascination.</p> |
| | title | | string | Bustier Snake - Hypnotic seduction and sculpted waistline |
| | usageinstructions | | string | <p>For <strong>optimum bra support</strong>, gently adjust the straps before closing the back hooks. The single-wire underwire should naturally follow the curve of your bust for perfect support.</p>
<p>The vertical ties position themselves to sculpt your waist and create that sought-after slimming effect. The high-waisted thong is easy to adjust thanks to its double straps for a <strong>fit that adapts to all body types</strong>.</p>
<p>This piece reveals your wild side with sophisticated natural elegance.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar a mano en agua fría para preservar el terciopelo</li>
<li>Utiliza un detergente suave sin blanqueantes</li>
<li>Séquelo en plano para mantener la forma del marco</li>
<li>No planchar nunca directamente sobre el dibujo de terciopelo</li>
<li>Manipule los lazos de satén con cuidado</li>
<li>Cuélguelos para evitar que se arrugue el tejido</li>
</ul> |
| | description | | string | <p>Este corpiño Snake revoluciona el arte de la seducción con su <strong>motivo de serpiente de terciopelo sobre malla</strong> que crea un efecto visual hipnótico con cada movimiento. Esta textura única transforma tu silueta en una obra de arte viviente que cautiva la mirada.</p>
<p>El<strong>innovador aro de un solo alambre</strong> esculpe un escote perfecto a la vez que ofrece un sujetador excepcional que <strong>se adapta con naturalidad a todas las formas del cuerpo</strong>. Este diseño técnico revela sus activos con precisión quirúrgica, creando esa curva perfecta que atrae inmediatamente las miradas. El <strong>atrevido corte frontal</strong> revela estratégicamente su piel, creando esa inquietante interacción entre lo que se muestra y lo que se oculta. Los lazos verticales de satén esculpen tu cintura con una elegancia inquietante, afinando naturalmente tu silueta para un efecto impactante garantizado.</p>
<p>La <strong>espalda escotada con su contorno esculpido</strong> revela la sensual curva de tu columna vertebral, revelando tu belleza desde todos los ángulos.</p>
<p>Este diseño revela tu sensualidad con una sofisticación que trasciende los convencionalismos. El <strong>tanga de cintura alta a juego</strong> completa este excepcional conjunto con tirantes laterales dobles ajustables que crean esa buscada silueta moderna. Esta perfecta coordinación revela su atención al detalle y su gusto por la excelencia. Los <strong>tirantes ajustables</strong> garantizan un confort óptimo durante todo el día, permitiendo un ajuste personalizado que realza naturalmente su silueta.</p>
<p>Cuando lleves este corpiño Snake, nunca pasarás desapercibida: hipnotizarás con esa irresistible gracia felina.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/talla-grande-bustier-malla-serpiente-aros/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Los aros de un solo hilo</strong> proporcionan un sujetador óptimo para los pechos más grandes</li>
<li><strong>Corte frontal atrevido</strong> que revela tu piel con sofisticación</li>
<li><strong>Lazos verticales moldeadores</strong> que afinan la cintura de forma natural</li>
<li><strong>Espalda escotada</strong> para una silueta favorecedora desde todos los ángulos</li>
<li><strong>Tirantes ajustables</strong> que se adaptan perfectamente a la forma de tu cuerpo</li>
<li><strong>Tanga de talle alto a juego</strong> con tirantes laterales ajustables</li>
<li><strong>Estampado de serpiente aterciopelada</strong> que capta la luz con cada movimiento</li>
<li><strong>Cierre de corchetes en la espalda</strong> para una personalización óptima</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bustier talla grande de malla de serpiente: aros de un solo hilo, recorte frontal, lazos esculturales, tanga de cintura alta a juego. Seducción hipnótica | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake talla grande malla con aros | Diva's Boudoir |
|
| | seotitle | | string | Corpiño talla grande de malla de serpiente con aros y tanga a juego |
| | seouri | | string | talla-grande-bustier-malla-serpiente-aros |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> Bustier con tanga de cintura alta a juego</li>
<li><strong>Diseño :</strong> Serpiente de terciopelo sobre malla</li>
<li><strong>Aros :</strong> Mono-alambre para un sujetador óptimo</li>
<li><strong>Cortes :</strong> Delantero atrevido y espalda escotada</li>
<li><strong>Tirantes:</strong> Ajustable para mayor comodidad</li>
<li><strong>Tanga:</strong> Cintura alta con tiras laterales dobles</li>
<li><strong>Cierre:</strong> Ganchos y ojales en la espalda</li>
<li><strong>Lazos:</strong> Lazos verticales de satén para un efecto esculpido</li>
</ul> |
| | stylingtips | | string | <p>Realza tu corpiño Snake 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</a> grande para un look rockero y sofisticado, o completa el look con nuestros <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexys talla</a> grande para crear atrevidas superposiciones.</p>
<p>Explora nuestros <a href="https://www.divasboudoir.com/es/body-tallas-grandes/">bodys talla</a> grande de la misma colección para variar, o descubre nuestros <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías talla</a> grande para jugar con los contrastes. Esta pieza única combina a la perfección con nuestra sofisticada colección.</p> |
| | summary | | string | <p>Acapara todas las miradas con este corpiño de malla Snake</p>
<p>Su aros de un solo hilo ofrecen un sujetador perfecto, mientras que su atrevido corte frontal y sus lazos verticales esculpen tu cintura. Combinado con su tanga de cintura alta a juego, este conjunto convierte cada aparición en un momento de pura fascinación.</p> |
| | title | | string | Bustier Snake - Seducción hipnótica y cintura esculpida |
| | usageinstructions | | string | <p>Para <strong>un sujetador óptimo para su busto generoso</strong>, ajuste suavemente los tirantes antes de cerrar los corchetes traseros. Los aros de un solo hilo se adaptan naturalmente a las curvas del busto para ofrecer una sujeción perfecta.</p>
<p>Los lazos verticales se colocan para esculpir la cintura y crear el deseado efecto adelgazante. El tanga de talle alto es fácil de ajustar gracias a sus tirantes dobles para un <strong>ajuste que se adapta a todas las formas del cuerpo</strong>.</p>
<p>Esta prenda revela tu lado salvaje con una sofisticada elegancia natural.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage à la main à l'eau froide pour préserver le velours</li>
<li>Utiliser une lessive douce sans agents blanchissants</li>
<li>Séchage à plat pour maintenir la forme de l'armature</li>
<li>Ne jamais repasser directement sur le motif velours</li>
<li>Manipuler délicatement les liens en satin</li>
<li>Ranger suspendu pour éviter les plis sur la maille</li>
</ul> |
| | description | | string | <p>Ce bustier Snake révolutionne l'art de la séduction avec son <strong>motif serpent en velours sur maille</strong> qui crée un jeu visuel hypnotique à chaque mouvement. Cette texture unique transforme votre silhouette en œuvre d'art vivante qui captive tous les regards.</p>
<p>L'<strong>armature mono-fil innovante</strong> sculpte un décolleté parfait tout en offrant un soutien exceptionnel qui <strong>s'adapte naturellement à toutes les morphologies</strong>. Cette conception technique révèle vos atouts avec une précision chirurgicale, créant cette courbe parfaite qui attire immédiatement l'attention. La <strong>découpe frontale audacieuse</strong> révèle stratégiquement votre peau, créant ce jeu troublant entre ce qui se montre et ce qui se cache. Les liens verticaux en satin sculptent votre taille avec une élégance troublante, affinant naturellement votre silhouette pour un effet saisissant garanti.</p>
<p>Le <strong>dos décolleté au décolleté très bas avec son contour sculpté</strong> dévoile la courbe sensuelle de votre colonne vertébrale, révélant votre beauté sous tous les angles.</p>
<p>Cette conception révèle votre sensualité avec une sophistication qui transcende les conventions. Le <strong>string taille haute assorti</strong> complète harmonieusement cet ensemble d'exception avec ses sangles latérales doubles réglables qui créent cette silhouette moderne si recherchée. Cette coordination parfaite révèle votre attention aux détails et votre goût pour l'excellence. Les <strong>bretelles ajustables</strong> garantissent un confort optimal toute la journée, permettant un ajustement personnalisé qui valorise naturellement vos formes.</p>
<p>Quand vous portez ce bustier Snake, vous ne passez plus inaperçue - vous hypnotisez avec cette grâce féline irrésistible.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/bustier-grande-taille-snake-maille-serpent-armature/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Armature mono-fil</strong> qui offre un soutien optimal pour les poitrines généreuses</li>
<li><strong>Découpe frontale audacieuse</strong> qui révèle votre peau avec sophistication</li>
<li><strong>Liens verticaux sculptants</strong> qui affinent naturellement la taille</li>
<li><strong>Dos décolleté bas</strong> pour une silhouette flatteuse sous tous les angles</li>
<li><strong>Bretelles ajustables</strong> qui s'adaptent parfaitement à votre morphologie</li>
<li><strong>String taille haute assorti</strong> avec sangles latérales réglables</li>
<li><strong>Motif serpent velours</strong> qui accroche la lumière à chaque mouvement</li>
<li><strong>Fermeture crochets dos</strong> pour un ajustement personnalisé optimal</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bustier Snake grande taille maille serpent : armature mono-fil, découpe frontale, liens sculptants, string taille haute assorti. Séduction hypnotique | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake grande taille maille serpent armature | Diva's Boudoir |
|
| | seotitle | | string | Bustier grande taille Snake maille serpent avec armature et string assorti |
| | seouri | | string | bustier-grande-taille-snake-maille-serpent-armature |
| | specifications | | string | <ul>
<li><strong>Type :</strong> Bustier avec string taille haute assorti</li>
<li><strong>Motif :</strong> Serpent en velours sur maille</li>
<li><strong>Armature :</strong> Mono-fil pour soutien optimal</li>
<li><strong>Découpes :</strong> Frontale audacieuse et dos décolleté</li>
<li><strong>Bretelles :</strong> Ajustables pour confort personnalisé</li>
<li><strong>String :</strong> Taille haute avec sangles latérales doubles</li>
<li><strong>Fermeture :</strong> Crochets et œillets dans le dos</li>
<li><strong>Liens :</strong> Verticaux en satin pour effet sculptant</li>
</ul> |
| | stylingtips | | string | <p>Sublimez votre bustier Snake avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> résille pour un look rock sophistiqué, ou complétez avec nos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">tenues sexys grande taille</a> pour créer des superpositions audacieuses.</p>
<p>Explorez nos <a href="https://www.divasboudoir.com/fr/body-grande-taille/">bodys grande taille</a> de la même collection pour varier les plaisirs, ou découvrez nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">déshabillés grande taille</a> pour jouer avec les contrastes. Cette pièce unique se marie parfaitement avec l'ensemble de notre collection sophistiquée.</p> |
| | summary | | string | <p>Volez la vedette avec ce bustier Snake en maille motif serpent !</p>
<p>Son armature mono-fil offre un soutien parfait tandis que sa découpe frontale audacieuse et ses liens verticaux sculptent votre taille. Accompagné de son string taille haute assorti, cet ensemble transforme chaque apparition en moment de pure fascination.</p> |
| | title | | string | Bustier Snake - Séduction Hypnotique et Taille Sculptée |
| | usageinstructions | | string | <p>Pour un <strong>soutien optimal de votre poitrine généreuse</strong>, ajustez délicatement les bretelles avant de fermer les crochets dorsaux. L'armature mono-fil doit épouser naturellement la courbe de votre buste pour un maintien parfait.</p>
<p>Les liens verticaux se positionnent pour sculpter votre taille et créer cet effet affinant recherché. Le string taille haute se règle facilement grâce à ses sangles doubles pour un <strong>ajustement qui s'adapte à toutes les morphologies</strong>.</p>
<p>Cette pièce révèle votre côté sauvage avec une élégance naturelle sophistiquée.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavare a mano in acqua fredda per preservare il velluto</li>
<li>Utilizzare un detergente delicato senza agenti sbiancanti</li>
<li>Asciugare in piano per mantenere la forma del telaio</li>
<li>Non stirare mai direttamente sul motivo del velluto</li>
<li>Maneggiare con cura le cravatte di raso</li>
<li>Appendere per evitare di sgualcire il tessuto</li>
</ul> |
| | description | | string | <p>Questo bustier Snake rivoluziona l'arte della seduzione con il suo <strong>motivo a serpente in velluto su rete</strong> che crea un effetto visivo ipnotico a ogni movimento. Questa texture unica trasforma la silhouette in un'opera d'arte vivente che cattura lo sguardo.</p>
<p>L'<strong>innovativo ferretto monofilo</strong> scolpisce un décolleté perfetto, offrendo un reggiseno eccezionale che <strong>si adatta naturalmente a tutte le forme del corpo</strong>. Questo design tecnico rivela le vostre caratteristiche con precisione chirurgica, creando quella curva perfetta che cattura immediatamente lo sguardo. L'<strong>audace cut-out frontale</strong> rivela strategicamente la pelle, creando un'inquietante interazione tra ciò che è mostrato e ciò che è nascosto. I lacci verticali in raso scolpiscono la vita con eleganza sconvolgente, affinando naturalmente la silhouette per un effetto di sicuro impatto.</p>
<p>La <strong>schiena scollata, con il suo contorno scolpito</strong>, rivela la curva sensuale della colonna vertebrale, rivelando la vostra bellezza da ogni angolazione.</p>
<p>Questo design rivela la vostra sensualità con una raffinatezza che trascende le convenzioni. Il <strong>perizoma a vita alta abbinato</strong> completa questo set eccezionale con le sue doppie bretelle laterali regolabili che creano una silhouette moderna e ricercata. Questo coordinato perfetto rivela la vostra attenzione ai dettagli e il vostro gusto per l'eccellenza. Le <strong>spalline regolabili</strong> assicurano un comfort ottimale per tutto il giorno, consentendo una vestibilità personalizzata che esalta naturalmente le vostre forme.</p>
<p>Quando indosserete questo bustier Snake, non passerete mai inosservate: vi incanterete con un'irresistibile grazia felina.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/bustier-di-taglia-grande-con-ferretto-in-maglia-di-serpente/sbbu9374.htm |
| | highlights | | string | <ul>
<li>Il<strong>ferretto a filo singolo</strong> offre un reggiseno ottimale per i seni più grandi</li>
<li><strong>Il taglio frontale audace</strong> rivela la pelle con raffinatezza</li>
<li><strong>Lacci verticali modellanti</strong> che affinano naturalmente il punto vita</li>
<li><strong>Schiena scollata</strong> per una silhouette perfetta da ogni angolazione</li>
<li>Le<strong>spalline regolabili</strong> si adattano perfettamente alla forma del corpo</li>
<li><strong>Perizoma a vita alta abbinato</strong> con spalline laterali regolabili</li>
<li><strong>Il motivo a serpente in velluto</strong> cattura la luce ad ogni movimento</li>
<li><strong>Chiusura con gancio e occhiello sul retro</strong> per una personalizzazione ottimale</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bustier taglia grande a rete di serpente: ferretto a filo singolo, cut-out frontale, lacci modellanti, perizoma a vita alta abbinato. Seduzione ipnotica | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake taglia grande a rete con ferretto | Diva's Boudoir |
|
| | seotitle | | string | Bustier di taglia grande in maglia serpente con ferretto e perizoma coordinato |
| | seouri | | string | bustier-di-taglia-grande-con-ferretto-in-maglia-di-serpente |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> Bustier con perizoma a vita alta coordinato</li>
<li><strong>Motivo:</strong> Serpente di velluto su rete</li>
<li><strong>Ferretto:</strong> monofilo per un reggiseno ottimale</li>
<li><strong>Tagli:</strong> Frontali e posteriori scollati</li>
<li><strong>Spalline:</strong> regolabili per un comfort personalizzato</li>
<li><strong>Perizoma:</strong> vita alta con doppi cinturini laterali</li>
<li><strong>Chiusura:</strong> Ganci e occhielli sulla schiena</li>
<li><strong>Lacci:</strong> Lacci verticali in raso per un effetto scultura</li>
</ul> |
| | stylingtips | | string | <p>Arricchite il vostro bustier Snake 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/">taglie forti</a> per un look rock sofisticato, oppure completate il look con i nostri <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">completi sexy taglie forti</a> per creare audaci sovrapposizioni.</p>
<p>Esplorate i nostri <a href="https://www.divasboudoir.com/it/body-taglia-grande/">body taglia grande</a> della stessa collezione per variare, oppure scoprite i nostri <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">negligé taglia grande</a> per giocare con i contrasti. Questo pezzo unico si abbina perfettamente alla nostra collezione sofisticata.</p> |
| | summary | | string | <p>Rubate la scena con questo bustier a rete Snake!</p>
<p>Il suo ferretto a filo singolo offre un reggiseno perfetto, mentre l'audace cut-out frontale e i lacci verticali scolpiscono la vita. Abbinato al perizoma a vita alta coordinato, questo set trasforma ogni apparizione in un momento di puro fascino.</p> |
| | title | | string | Bustier Snake - Seduzione ipnotica e punto vita scolpito |
| | usageinstructions | | string | <p>Per un <strong>reggiseno ottimale del vostro seno generoso</strong>, regolate delicatamente le spalline prima di chiudere i ganci posteriori. Il ferretto a filo singolo deve seguire naturalmente la curva del seno per un sostegno perfetto.</p>
<p>I lacci verticali sono posizionati in modo da scolpire la vita e creare il ricercato effetto snellente. Il perizoma a vita alta è facile da regolare grazie alle doppie spalline, per una <strong>vestibilità che si adatta a tutte le forme del corpo</strong>.</p>
<p>Questo capo rivela il vostro lato selvaggio con una sofisticata eleganza naturale.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwas in koud water om het velours te behouden</li>
<li>Gebruik een mild wasmiddel zonder bleekmiddelen</li>
<li>Plat drogen om de vorm van het frame te behouden</li>
<li>Strijk nooit rechtstreeks op het fluwelen patroon</li>
<li>Ga voorzichtig om met satijnen stropdassen</li>
<li>Ophangen om kreuken van de stof te voorkomen</li>
</ul> |
| | description | | string | <p>Deze Snake bustier revolutioneert de kunst van het verleiden met zijn <strong>fluweel-op-gaas slangenmotief</strong> dat bij elke beweging een hypnotiserend visueel effect creëert. Deze unieke textuur transformeert je silhouet in een levend kunstwerk dat de aandacht trekt.</p>
<p>De<strong>innovatieve enkeldraads beugel</strong> geeft vorm aan een perfect decolleté en biedt uitzonderlijke bh die <strong>zich op natuurlijke wijze aanpast aan alle lichaamsvormen</strong>. Dit technische ontwerp onthult je pluspunten met chirurgische precisie en creëert die perfecte ronding die meteen in het oog springt. De <strong>gedurfde uitsnijding aan de voorkant</strong> onthult je huid op strategische wijze en creëert een verontrustend samenspel tussen wat getoond wordt en wat verborgen blijft. De verticale satijnen bandjes vormen je taille met verontrustende elegantie en verfijnen je silhouet op natuurlijke wijze voor een gegarandeerd opvallend effect.</p>
<p>De <strong>laag uitgesneden rug met zijn gebeeldhouwde contouren</strong> onthult de sensuele ronding van je ruggengraat en onthult je schoonheid vanuit elke hoek.</p>
<p>Dit ontwerp onthult je sensualiteit met een verfijning die de conventies overstijgt. De <strong>bijpassende string met hoge taille</strong> maakt deze uitzonderlijke set compleet met dubbele verstelbare bandjes aan de zijkant die dat gewilde moderne silhouet creëren. Deze perfecte coördinatie onthult je aandacht voor detail en je smaak voor uitmuntendheid. De <strong>verstelbare bandjes</strong> zorgen de hele dag door voor optimaal comfort en een persoonlijke pasvorm die je vorm op natuurlijke wijze versterkt.</p>
<p>Als je deze bustier van Snake draagt, zul je nooit onopgemerkt blijven - je zult betoveren met die onweerstaanbare katachtige gratie.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/grote-maat-bustier-slang-mesh-beugel/sbbu9374.htm |
| | highlights | | string | <ul>
<li><strong>Eendraads beugel</strong> biedt optimale bh voor grotere borsten</li>
<li><strong>De gedurfde snit aan de voorkant</strong> onthult je huid met raffinement</li>
<li><strong>Sculpting verticale bandjes</strong> die de taille op natuurlijke wijze verfijnen</li>
<li><strong>Laag uitgesneden rug</strong> voor een flatterend silhouet vanuit elke hoek</li>
<li><strong>Verstelbare bandjes</strong> passen zich perfect aan je lichaamsvorm aan</li>
<li><strong>Bijpassende string met hoge taille</strong> en verstelbare bandjes aan de zijkant</li>
<li><strong>Fluwelen slangenpatroon</strong> vangt het licht bij elke beweging</li>
<li><strong>Haak-en-oogsluiting op de rug</strong> voor optimale aanpassing aan je lichaamsvorm</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Snake-mesh bustier van grote maat: enkeldraads beugel, uitsnijding aan de voorkant, sculpting bandjes, bijpassende string met hoge taille. Hypnotiserende verleiding | Diva's Boudoir |
| | keywords | | | title | | string | Bustier Snake grote maat mesh beugel | Diva's Boudoir |
|
| | seotitle | | string | Slangengaas grote maat bustier met beugel en bijpassende string |
| | seouri | | string | grote-maat-bustier-slang-mesh-beugel |
| | specifications | | string | <ul>
<li><strong>Type :</strong> Bustier met bijpassende string met hoge taille</li>
<li><strong>Patroon :</strong> Fluwelen slang op mesh</li>
<li><strong>Beugel :</strong> Monodraad voor optimale bh</li>
<li><strong>Uitsnijdingen :</strong> Gewaagde voorkant en laag uitgesneden achterkant</li>
<li><strong>Bandjes:</strong> Verstelbaar voor individueel comfort</li>
<li><strong>String:</strong> Hoge taille met dubbele zijbandjes</li>
<li><strong>Sluiting:</strong> Haken en oogjes op de rug</li>
<li><strong>Bandjes:</strong> Verticale satijnen bandjes voor sculpting effect</li>
</ul> |
| | stylingtips | | string | <p>Verfraai je Snake bustier 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> voor een geraffineerde rock look, of maak de look compleet met onze <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">grote maten sexy outfits</a> voor gewaagde overlays.</p>
<p>Verken onze <a href="https://www.divasboudoir.com/nl/bodysuits-grote-maten/">plus size bodysuits</a> uit dezelfde collectie voor afwisseling, of ontdek onze <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">plus size negligés</a> om te spelen met contrasten. Dit unieke stuk past perfect bij onze geraffineerde collectie.</p> |
| | summary | | string | <p>Steel de show met deze Snake mesh bustier!</p>
<p>De eendraads beugel biedt perfecte bh, terwijl de gewaagde uitsnede aan de voorkant en de verticale bandjes je taille vormgeven. In combinatie met de bijpassende string met hoge taille maakt deze set van elke verschijning een moment van pure fascinatie.</p> |
| | title | | string | Bustier Snake - Hypnotische verleiding en gebeeldhouwde taille |
| | usageinstructions | | string | <p>Voor <strong>een optimale bh-ondersteuning van je buste</strong> pas je de bandjes voorzichtig aan voordat je de haakjes op de rug sluit. De enkeldraads beugel volgt op natuurlijke wijze de ronding van je buste voor perfecte ondersteuning.</p>
<p>De verticale bandjes vormen je taille en zorgen voor het gewenste afslankende effect. De string met hoge taille is eenvoudig te verstellen dankzij de dubbele bandjes voor een <strong>pasvorm die zich aanpast aan alle lichaamsvormen</strong>.</p>
<p>Dit stuk onthult je wilde kant met geraffineerde natuurlijke elegantie.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar à mão em água fria para preservar o veludo</li>
<li>Utilizar um detergente suave sem agentes branqueadores</li>
<li>Secar na horizontal para manter a forma da moldura</li>
<li>Nunca passar a ferro diretamente sobre o padrão de veludo</li>
<li>Manusear as gravatas de cetim com cuidado</li>
<li>Pendurar para evitar vincar o tecido</li>
</ul> |
| | description | | string | <p>Este corpete Snake revoluciona a arte da sedução com o seu <strong>motivo de cobra em veludo sobre malha</strong> que cria um efeito visual hipnótico a cada movimento. Esta textura única transforma a sua silhueta numa obra de arte viva que cativa o olhar.</p>
<p>A<strong>inovadora armação de arame único</strong> esculpe um decote perfeito, oferecendo um apoio excecional que <strong>se adapta naturalmente a todas as formas do corpo</strong>. Este design técnico revela os seus activos com precisão cirúrgica, criando aquela curva perfeita que chama imediatamente a atenção. O <strong>ousado recorte frontal</strong> revela estrategicamente a sua pele, criando uma interação inquietante entre o que é mostrado e o que é escondido. Os atilhos de cetim verticais esculpem a sua cintura com uma elegância inquietante, afinando naturalmente a sua silhueta para um efeito marcante garantido.</p>
<p>As <strong>costas decotadas com o seu contorno esculpido</strong> revelam a curva sensual da sua coluna vertebral, revelando a sua beleza de todos os ângulos.</p>
<p>Este design revela a sua sensualidade com uma sofisticação que transcende as convenções. A <strong>tanga de cintura subida a condizer</strong> completa este conjunto excecional com tiras laterais duplas ajustáveis que criam a tão procurada silhueta moderna. Esta coordenação perfeita revela a sua atenção aos pormenores e o seu gosto pela excelência. As <strong>alças ajustáveis</strong> garantem um conforto ótimo durante todo o dia, permitindo um ajuste personalizado que realça naturalmente a sua forma.</p>
<p>Quando usar este corpete Snake, nunca passará despercebida - ficará fascinada com aquela irresistível graça felina.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/corpete-de-tamanho-grande-em-malha-de-cobra-com-armação/sbbu9374.htm |
| | highlights | | string | <ul>
<li>O arame<strong>de fio único</strong> proporciona um suporte ótimo para seios maiores</li>
<li><strong>O corte frontal arrojado</strong> revela a sua pele com sofisticação</li>
<li><strong>Laços verticais es</strong> culpidos que afinam naturalmente a cintura</li>
<li><strong>Costas decotadas</strong> para uma silhueta lisonjeira de todos os ângulos</li>
<li><strong>Alças ajustáveis</strong> adaptam-se perfeitamente à forma do seu corpo</li>
<li>Tanga<strong>de cintura alta a condizer</strong> com alças laterais ajustáveis</li>
<li><strong>O padrão de cobra de veludo</strong> capta a luz em cada movimento</li>
<li><strong>Fecho de gancho e olho na parte de trás</strong> para uma personalização óptima</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Corpete plus size em malha de cobra: arame simples, recorte frontal, laços esculturais, tanga de cintura alta a condizer. Sedução hipnótica | Diva's Boudoir |
| | keywords | | | title | | string | Corpete Snake tamanho grande em rede com arame | Diva's Boudoir |
|
| | seotitle | | string | Corpete grande em malha de cobra com aros e tanga a condizer |
| | seouri | | string | corpete-de-tamanho-grande-em-malha-de-cobra-com-armação |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> Corpete com tanga de cintura alta a condizer</li>
<li><strong>Padrão:</strong> Serpente de veludo sobre malha</li>
<li><strong>Arame:</strong> Mono-arame para um apoio ótimo</li>
<li><strong>Recortes :</strong> Frente ousada e costas decotadas</li>
<li><strong>Alças:</strong> Ajustáveis para um conforto personalizado</li>
<li><strong>Tanga:</strong> Cintura alta com tiras laterais duplas</li>
<li><strong>Fecho:</strong> Ganchos e ilhós nas costas</li>
<li><strong>Atilhos:</strong> Atilhos de cetim verticais para um efeito esculpido</li>
</ul> |
| | stylingtips | | string | <p>Melhore o seu corpete Snake 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 um look rock sofisticado, ou complete o look com os nossos <a href="https://www.divasboudoir.com/fr/tenues-sexy-grande-taille/">conjuntos sexy plus size</a> para criar sobreposições ousadas.</p>
<p>Explore os nossos <a href="https://www.divasboudoir.com/pt/body-plus-size/">bodysuits plus size</a> da mesma coleção para variar, ou descubra os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees plus size</a> para jogar com contrastes. Esta peça única combina perfeitamente com a nossa coleção sofisticada.</p> |
| | summary | | string | <p>Roube a cena com este corpete em malha Snake!</p>
<p>A sua armação de arame simples oferece um suporte perfeito, enquanto o seu ousado recorte frontal e os atilhos verticais esculpem a sua cintura. Combinado com a tanga de cintura alta a condizer, este conjunto transforma cada aparição num momento de puro fascínio.</p> |
| | title | | string | Corpete Snake - Sedução hipnótica e cintura esculpida |
| | usageinstructions | | string | <p>Para um <strong>suporte ótimo do seu busto generoso</strong>, ajuste suavemente as alças antes de fechar os ganchos das costas. O arame de fio único acompanha naturalmente a curva do seu busto para uma sustentação perfeita.</p>
<p>Os atilhos verticais posicionam-se para esculpir a sua cintura e criar o tão procurado efeito adelgaçante. A tanga de cintura alta é fácil de ajustar graças às suas tiras duplas para um <strong>ajuste que se adapta a todas as formas do corpo</strong>.</p>
<p>Esta peça revela o seu lado selvagem com uma elegância natural sofisticada.</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 | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | C57FC38E-EA9F-45EF-8EE9BDF39D464FA8 |
|
| promountil | |
| rating | |
| recorduid | | string | C57FC38E-EA9F-45EF-8EE9BDF39D464FA8 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.75 ms Record Count: 5 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 | black | 1X/2X | | -1 | 999999 | 1 | 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 | 2075 | 3X/4X+ | intlsize | black | 3X/4X+ | 3X/4X+ | -1 | 999999 | 1 | 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 | | | | | | | | 3 | 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 | | | | | | | | 4 | 2067 | 1X/2X | intlsize | black | 1X/2X | 1X/2X | -1 | 999999 | 1 | 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 | | | | | | | | 5 | 2073 | 3X/4X | intlsize | black | 3X/4X | 3X/4X | -1 | 999999 | 1 | 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: 8.19 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 | C57FC38E-EA9F-45EF-8EE9BDF39D464FA8 | E3736463-33BF-4497-9987CF704F878873 | 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 | 1 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD04903A-BLAK | 840312886035 | 1 | 1 | all | | | 2 | C57FC38E-EA9F-45EF-8EE9BDF39D464FA8 | 9961893B-0050-4EB2-88F4EBF8A730318A | 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 | HD04903A-BLAK | | -1 | 0 | all | | | 3 | C57FC38E-EA9F-45EF-8EE9BDF39D464FA8 | 91FBAD8B-9B65-44B7-A4012D4BC5505B92 | 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 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD04903A-BLAK | 840312886042 | 1 | 1 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 11.6 ms Record Count: 5 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 = 'C57FC38E-EA9F-45EF-8EE9BDF39D464FA8' 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 | E3736463-33BF-4497-9987CF704F878873 | 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 | 1 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD04903A-BLAK | 840312886035 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 48.2917 | all | | | 2 | 91FBAD8B-9B65-44B7-A4012D4BC5505B92 | 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 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD04903A-BLAK | 840312886042 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 48.2917 | all | | | 3 | 9961893B-0050-4EB2-88F4EBF8A730318A | 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 | HD04903A-BLAK | | -1 | 0 | -1 | 0 | -1 | 2 | 0 | 48.2917 | all | | | 4 | E3736463-33BF-4497-9987CF704F878873 | 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 | 1 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | HD04903A-BLAK | 840312886035 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 48.2917 | all | | | 5 | 91FBAD8B-9B65-44B7-A4012D4BC5505B92 | 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 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | HD04903A-BLAK | 840312886042 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 48.2917 | all | |
|
| vatrate | |
| warehouse | |