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.cabaret.dresses.all |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/cabaret/dresses1.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.707 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 |
|
| 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-23 18:59:52'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | | string | sz2412104818876472-longue |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-08-07 12:00:32'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.651 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select cart_actions.* from cart_actions where cart_actions.branding IN ('all','divasboudoir') and cart_actions.language IN ('all','nl') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('6be1b1ec-c4b1-4e0d-83e7b3321b764129',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.32 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','nl') and product_categories.language in ('all','nl') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'CDBU4359' 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/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_detail.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_dos.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/dvqc/cdbu4359/longue_robe_grande_taille_col_montant_detail.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 das tiefe Schwarz zu erhalten</li>
<li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li>
<li>Flach trocknen, um die Form der Drapierung zu erhalten.</li>
<li>Niemals direkt über die formgebenden Falten bügeln</li>
<li>Vorsichtig aufhängen, um Abdrücke zu vermeiden</li>
<li>In einer Hülle aufbewahren, um die maximale Länge zu schützen</li>
</ul> |
| | description | | string | <p>Dieses lange Kleid revolutioniert die Kunst der modernen Eleganz mit seinem <strong>skulpturalen Stehkragen</strong>, der einen auffallenden architektonischen Effekt erzeugt. Diese klare Linie verlängert sanft Ihren Hals und verleiht ihm gleichzeitig diese zeitgenössische Dimension, die für Aufsehen sorgt.</p>
<p>Die <strong>meisterhafte Drapierung im Taillenbereich</strong> verwandelt dieses Kleid in ein tragbares Kunstwerk. Diese Falten und Kräuselungen erzeugen einen formenden Effekt, der die Silhouette auf natürliche Weise schlanker erscheinen lässt und gleichzeitig kleine Bereiche, die Sie harmonisieren möchten, dezent ausgleicht. Die <strong>bodenlange Maxilänge</strong> schafft den Look einer modernen Göttin, die nie unbemerkt bleibt. Der Balayage-Effekt sorgt für diese raffinierte Theatralik, die jeden Schritt in einen Moment purer Anmut verwandelt. Das <strong>zeitlose Tiefschwarz</strong> unterstreicht jeden Hautton und passt zu den prestigeträchtigsten Anlässen. Diese Farbe verrät Ihre Vorliebe für Exzellenz und Ihren ausgeprägten Sinn für Stil.</p>
<p>Der <strong>ärmellose Schnitt</strong> enthüllt Ihre Arme mit natürlicher Eleganz und schafft eine klare Linie, die <strong>sich perfekt an jede Körperform anpasst</strong>. Der fließende Stoff schmiegt sich sanft und ohne Zwang an Ihre Kurven. Der <strong>anmutig fließende</strong> Stoff erzeugt bei jeder Bewegung diese hypnotische Bewegung und enthüllt Ihre natürliche Schönheit mit einer Raffinesse, die Konventionen überwindet. Wenn Sie dieses Kleid tragen, werden Sie zu dieser modernen Ikone, die mit ihrer architektonischen Erhabenheit und ihrer unwiderstehlichen magnetischen Aura hypnotisiert.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/kleid-große-Größe-lang-schwarz-Stehkragen-drapiert/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Skulpturaler Stehkragen</strong>, der den Hals sanft und modern verlängert.</li>
<li><strong>Meisterhafte Drapierung</strong> auf Taillenhöhe, die die Silhouette auf natürliche Weise schlanker wirken lässt</li>
<li><strong>Bodenlange Maxilänge</strong> für einen theatralischen Sweep-Effekt</li>
<li><strong>zeitloses Schwarz</strong>, das alle Hauttöne hervorhebt</li>
<li><strong>Ärmelloser Schnitt</strong>, der die Arme elegant enthüllt</li>
<li><strong>Figurformender Effekt</strong>, der alle Körperformen perfekt harmonisiert</li>
<li><strong>Anmutige fließende Linien</strong>, die eine hypnotische Bewegung erzeugen</li>
<li>Perfekter<strong>architektonischer Stil</strong> für prestigeträchtige Veranstaltungen</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Langes Kleid in großen Größen schwarz mit Stehkragen: formende Drapierung, Maxilänge, Architektureffekt, fließender Schnitt. Moderne Majestät und Eleganz | Diva's Boudoir |
| | keywords | | | title | | string | Langes Kleid in großer Größe schwarz Stehkragen drapiert | Diva's Boudoir |
|
| | seotitle | | string | Kleid große Größe lang schwarz Stehkragen drapiert skulptural |
| | seouri | | string | kleid-große-Größe-lang-schwarz-Stehkragen-drapiert |
| | specifications | | string | <ul>
<li><strong>Typ:</strong> Langes Maxikleid</li>
<li><strong>Farbe:</strong> zeitloses Tiefschwarz</li>
<li><strong>Kragen:</strong> Skulptural ansteigend<strong>,</strong> ärmellos</li>
<li><strong>Drapierung:</strong> Magistral auf Taillenhöhe</li>
<li><strong>Länge:</strong> Maxi bodenlang mit Sweeping-Effekt</li>
<li><strong>Schnitt:</strong> Fließend mit skulpturaler Wirkung</li>
<li><strong>Stil:</strong> Modernes architektonisches Design</li>
<li><strong>Anlässe:</strong> Prestigeträchtige Veranstaltungen und außergewöhnliche Abende</li>
</ul> |
| | stylingtips | | string | <p>Veredeln Sie Ihr Kleid mit unseren <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">Feinstrümpfen in</a> Übergröße für einen raffinierten Total-Black-Look, oder fügen Sie unsere <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">Seidenkimonos in Übergröße</a> für einen eleganten Lagenlook hinzu.</p>
<p>Ergänzen Sie sie mit unseren schwarzen <a href="https://www.divasboudoir.com/de/slips-in-grossen-grossen/">Slips</a> in Übergröße für eine perfekte Harmonie, oder erkunden Sie unsere <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">sexy Kleider in Übergröße</a> aus der gleichen Kollektion, um die architektonischen Looks zu vervielfachen. Diese einzigartige Kreation offenbart Ihren Sinn für Stil mit einer beunruhigenden modernen Majestät.</p> |
| | summary | | string | <p>Verkörpern Sie die moderne Majestät mit diesem schwarzen Maxikleid mit skulpturalem Stehkragen! Seine meisterhafte Drapierung auf Taillenhöhe und seine Bodenlänge schaffen eine statueske Silhouette von absoluter Eleganz.</p>
<p>Mit ihrem architektonischen Effekt und dem anmutig fließenden Muster verwandelt diese Kreation jeden Auftritt in einen Moment purer Faszination.</p> |
| | title | | string | Langes schwarzes Kleid mit Stehkragen - Moderne Majestät und Statuenhafte Ausstrahlung |
| | usageinstructions | | string | <p>Ziehen Sie dieses Kleid sanft an und achten Sie dabei auf den skulpturalen Stehkragen, der sich natürlich positioniert. Die <strong>meisterhafte Drapierung</strong> platziert sich automatisch, um diesen figurformenden Effekt zu erzeugen, der Ihre Silhouette harmonisiert. Die Maxilänge erfordert besondere Aufmerksamkeit beim Tragen, um den eleganten Sweep-Effekt zu erhalten. Dieses Kleid ist dank der technischen Drapierung und des fließenden Schnitts für <strong>jeden Körperbau</strong> geeignet. Tragen Sie es selbstbewusst, um Ihre majestätische Seite bei Ihren prestigeträchtigsten Veranstaltungen zu zeigen.</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>Αυτό το μάξι φόρεμα φέρνει επανάσταση στην τέχνη της μοντέρνας κομψότητας με το <strong>γλυπτικό γιακά</strong> που δημιουργεί ένα εντυπωσιακό αρχιτεκτονικό αποτέλεσμα. Ο κομψός σχεδιασμός επιμηκύνει απαλά το λαιμό σας, ενώ προσθέτει μια σύγχρονη διάσταση που κάνει αίσθηση.</p>
<p>Το <strong>αριστοτεχνικό ντραπέ στη μέση</strong> μετατρέπει αυτό το φόρεμα σε ένα φορέσιμο έργο τέχνης. Αυτές οι πτυχώσεις και οι ραφές δημιουργούν ένα αποτέλεσμα γλυπτικής που βελτιώνει φυσικά τη σιλουέτα, ενώ διαγράφει διακριτικά τυχόν μικρές περιοχές που θέλετε να εναρμονίσετε. Το <strong>μάξι φόρεμα που φτάνει μέχρι το πάτωμα</strong> δημιουργεί αυτό το μοντέρνο βλέμμα θεάς που δεν περνάει ποτέ απαρατήρητο. Το σαρωτικό αποτέλεσμα προσθέτει μια εκλεπτυσμένη θεατρικότητα που μετατρέπει κάθε βήμα σε μια στιγμή καθαρής χάρης. <strong>Το διαχρονικό βαθύ μαύρο</strong> υποβόσκει σε όλους τους τόνους του δέρματος και είναι ιδανικό για τις πιο επίσημες περιστάσεις. Αυτό το χρώμα αποκαλύπτει το γούστο σας για την τελειότητα και τη διεκδικητική αίσθηση του στυλ σας.</p>
<p>Το <strong>αμάνικο κόψιμο</strong> αποκαλύπτει τα μπράτσα σας με φυσική κομψότητα, δημιουργώντας μια κομψή γραμμή που <strong>είναι ιδανική για κάθε σωματότυπο</strong>. Το ρευστό ύφασμα αγκαλιάζει απαλά τις καμπύλες σας χωρίς περιορισμούς. Η <strong>χαριτωμένη ρευστότητα</strong> του υφάσματος δημιουργεί αυτή την υπνωτική κίνηση σε κάθε σας κίνηση, αποκαλύπτοντας τη φυσική σας ομορφιά με μια φινέτσα που ξεπερνά τις συμβάσεις. Όταν φοράτε αυτό το φόρεμα, γίνεστε αυτό το σύγχρονο είδωλο που υπνωτίζει με το αρχιτεκτονικό του μεγαλείο και την ακαταμάχητη μαγνητική του αύρα.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/makry-mayro-forema-me-pshlo-gIaka/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Το γλυπτό κολάρο επι</strong> μηκύνει απαλά το λαιμό με ένα μοντέρνο twist.</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 | Μαύρο μάξι φόρεμα με ψηλό λαιμό: σμιλευτικό ντραπέ, μάξι μήκος, αρχιτεκτονικό αποτέλεσμα, ρευστό κόψιμο. Σύγχρονη μεγαλοπρέπεια και κομψότητα | Diva's Boudoir |
| | keywords | | | title | | string | Μαύρο μάξι φόρεμα με ψηλή λαιμόκοψη | Diva's Boudoir |
|
| | seotitle | | string | Μακρύ μαύρο φόρεμα με ψηλό λαιμό και σμιλευτικό ντραπέ |
| | seouri | | string | μακρύ-μαύρο-φόρεμα-με-ψηλό-γιακά |
| | specifications | | string | <ul>
<li><strong>Τύπος :</strong> Maxi φόρεμα</li>
<li><strong>Χρώμα :</strong> διαχρονικό βαθύ μαύρο</li>
<li><strong>Κολάρο :</strong> Γλυπτικός αμάνικος γιακάς</li>
<li><strong>Drapé :</strong> Μαγκιστράλ στη μέση</li>
<li><strong>Μήκος :</strong> Maxi μήκος δαπέδου με σαρωτικό αποτέλεσμα</li>
<li><strong>Κοπή :</strong> Ρευστό με γλυπτικό αποτέλεσμα</li>
<li><strong>Στυλ:</strong> Μοντέρνο αρχιτεκτονικό</li>
<li><strong>Περιστάσεις:</strong> Υψηλού κύρους εκδηλώσεις και ξεχωριστές βραδιές</li>
</ul> |
| | stylingtips | | string | <p>Ενισχύστε το φόρεμά σας με τις λεπτές μας <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">κάλτσες plus size</a> για ένα εκλεπτυσμένο total black look ή προσθέστε τα μεταξωτά μας <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">κιμονό plus size</a> για κομψότητα σε στρώσεις.</p>
<p>Ολοκληρώστε την εμφάνιση με τα μαύρα <a href="https://www.divasboudoir.com/el/eswroychwn-syn-megethos/">plus size εσώρουχά</a> μας για τέλεια αρμονία, ή εξερευνήστε τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι plus size φορέματά</a> μας από την ίδια συλλογή για πιο αρχιτεκτονικές εμφανίσεις. Αυτή η μοναδική δημιουργία αποκαλύπτει την αίσθηση του στυλ σας με ανησυχητική σύγχρονη μεγαλοπρέπεια.</p> |
| | summary | | string | <p>Ενσαρκώστε τη σύγχρονη μεγαλοπρέπεια σε αυτό το μαύρο μάξι φόρεμα με τον γλυπτικό όρθιο γιακά! Το αριστοτεχνικό ντραπέ του στη μέση και το μήκος του στο πάτωμα δημιουργούν μια αγαλματένια σιλουέτα απόλυτης κομψότητας.</p>
<p>Με το αρχιτεκτονικό του αποτέλεσμα και τη χαριτωμένη ρευστότητά του, αυτή η δημιουργία μετατρέπει κάθε εμφάνιση σε μια στιγμή καθαρής γοητείας.</p> |
| | title | | string | Μαύρο Maxi φόρεμα με ψηλό λαιμό - Σύγχρονη μεγαλοπρέπεια και αγαλματένια γοητεία |
| | usageinstructions | | string | <p>Φορέστε απαλά αυτό το φόρεμα, φροντίζοντας να τοποθετήσετε φυσικά το γλυπτικό όρθιο κολάρο. Το <strong>αριστοτεχνικό τύλιγμα</strong> τοποθετείται αυτόματα για να δημιουργήσει αυτό το γλυπτικό αποτέλεσμα που εναρμονίζει τη σιλουέτα σας. Το μάξι μήκος απαιτεί ιδιαίτερη προσοχή όταν κινείστε για να διατηρήσετε το κομψό σαρωτικό αποτέλεσμα. Αυτό το φόρεμα <strong>είναι ιδανικό για όλους τους σωματότυπους</strong> χάρη στο τεχνικό ντραπέ του και το ρευστό του κόψιμο. Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε τη μεγαλοπρεπή πλευρά σας στις πιο σημαντικές εκδηλώσεις σας.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Hand wash in cold water to preserve the deep black color</li>
<li>Use a mild detergent without bleaching agents</li>
<li>Dry flat to maintain drape shape</li>
<li>Never iron directly over sculpting folds</li>
<li>Hang delicately to avoid marks</li>
<li>Store in a bag to protect maxi length</li>
</ul> |
| | description | | string | <p>This maxi dress revolutionizes the art of modern elegance with its <strong>sculptural stand-up collar</strong> that creates a striking architectural effect. The sleek lines delicately elongate your neck, while adding a contemporary dimension that's sure to make a statement.</p>
<p>The <strong>masterful draping at the waist</strong> transforms this dress into a wearable work of art. These pleats and gathers create a sculpting effect that naturally refines the silhouette while discreetly erasing any small areas you wish to harmonize. The <strong>floor-length maxi</strong> creates that modern goddess look that never goes unnoticed. The sweeping effect adds a sophisticated theatricality that transforms every step into a moment of pure grace. <strong>Timeless deep black</strong> sublimates all skin tones and adapts to the most prestigious occasions. This color reveals your taste for excellence and your assertive sense of style.</p>
<p>The <strong>sleeveless cut</strong> reveals your arms with natural elegance, creating a sleek line that <strong>adapts perfectly to all body types</strong>. The flowing fabric gently hugs your curves without constraint. The <strong>graceful fluidity</strong> of the fabric creates that hypnotic movement with every shift, revealing your natural beauty with a sophistication that transcends convention. When you wear this dress, you become that modern icon that hypnotizes with its architectural majesty and irresistible magnetic aura.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/plus-size-long-black-high-neck-drape-dress/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Sculptural stand-up collar</strong> delicately elongates the neck with modernity</li>
<li><strong>Masterful draping</strong> at the waist naturally refines the silhouette</li>
<li><strong>Floor-length maxi</strong> for a theatrical sweeping effect</li>
<li><strong>timeless black</strong> to sublimate all skin tones</li>
<li><strong>Sleeveless cut</strong> that elegantly reveals the arms</li>
<li><strong>Sculpting effect</strong> perfectly harmonizes all morphologies</li>
<li><strong>Graceful fluidity</strong> creates hypnotic movement</li>
<li><strong>Architectural style</strong> perfect for prestigious events</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Black high neck plus size maxi dress: sculpting drape, maxi length, architectural effect, fluid cut. Modern majesty and elegance | Diva's Boudoir |
| | keywords | | | title | | string | Long dress plus size black high collar draped | Diva's Boudoir |
|
| | seotitle | | string | Plus size long black dress with high collar and sculpting drape |
| | seouri | | string | plus-size-long-black-high-neck-drape-dress |
| | specifications | | string | <ul>
<li><strong>Type:</strong> maxi long dress</li>
<li><strong>Color:</strong> timeless deep black</li>
<li><strong>Collar</strong>: Sculptural, sleeveless stand-up collar</li>
<li><strong>Drapé:</strong> Magistral at the waist</li>
<li><strong>Length:</strong> floor-length maxi with sweeping effect</li>
<li><strong>Cut:</strong> Fluid with sculpting effect</li>
<li><strong>Style:</strong> Modern architectural</li>
<li><strong>Occasions:</strong> Prestigious events and special evenings</li>
</ul> |
| | stylingtips | | string | <p>Enhance your dress with our slim <a href="https://www.divasboudoir.com/en/socks-large-size/">plus-size stockings</a> for a sophisticated total black look, or add our silk <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus-size kimonos</a> for layered elegance.</p>
<p>Complete the look with our black <a href="https://www.divasboudoir.com/en/plus-size-panties/">plus size panties</a> for perfect harmony, or explore our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy plus size dresses</a> from the same collection to multiply architectural looks. This unique creation reveals your sense of style with unsettling modern majesty.</p> |
| | summary | | string | <p>Embody modern majesty in this black maxi dress with sculptural stand-up collar! Its masterful waist drape and floor-length create a statuesque silhouette of absolute elegance.</p>
<p>With its architectural effect and graceful fluidity, this creation transforms every appearance into a moment of pure fascination.</p> |
| | title | | string | Black High Neck Maxi Dress - Modern Majesty and Statuesque Allure |
| | usageinstructions | | string | <p>Gently slip this dress on, taking care to position the sculptural stand-up collar naturally. The <strong>magisterial drape</strong> moves into place automatically to create that sculpting effect that harmonizes your silhouette. The maxi length requires special attention when moving to preserve the elegant sweeping effect. Thanks to its technical drape and fluid cut, this dress <strong>is perfect for all body types</strong>. Wear it with confidence to reveal your majestic side at your most prestigious events.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar a mano en agua fría para conservar el color negro intenso</li>
<li>Utilizar un detergente suave sin blanqueantes</li>
<li>Séquela en plano para mantener la forma del drapeado</li>
<li>Nunca planchar directamente sobre los pliegues esculpidos</li>
<li>Colgar suavemente para evitar marcas</li>
<li>Guardar en una bolsa para proteger la longitud máxima</li>
</ul> |
| | description | | string | <p>Este maxi vestido revoluciona el arte de la elegancia moderna con su <strong>escultural cuello alzado</strong> que crea un sorprendente efecto arquitectónico. Su elegante diseño alarga el cuello con delicadeza y añade una dimensión contemporánea que no pasa desapercibida.</p>
<p>El <strong>magistral drapeado en la cintura</strong> transforma este vestido en una obra de arte ponible. Los pliegues y fruncidos crean un efecto escultural que afina la silueta de forma natural al tiempo que borra discretamente cualquier pequeña zona que desee armonizar. El <strong>maxi largo hasta el suelo</strong> crea ese look de diosa moderna que nunca pasa desapercibido. El efecto barrido añade una sofisticada teatralidad que transforma cada paso en un momento de pura gracia. <strong>El atemporal negro intenso</strong> sublima todos los tonos de piel y es perfecto para las ocasiones más prestigiosas. Este color revela su gusto por la excelencia y su asertivo sentido del estilo.</p>
<p>El <strong>corte sin mangas</strong> revela sus brazos con elegancia natural, creando una línea elegante <strong>perfecta para cada tipo de cuerpo</strong>. El tejido fluido abraza suavemente sus curvas sin constreñirlas. La <strong>grácil fluidez</strong> del tejido crea ese movimiento hipnótico con cada movimiento, revelando tu belleza natural con una sofisticación que trasciende las convenciones. Cuando llevas este vestido, te conviertes en ese icono moderno que hipnotiza con su majestuosidad arquitectónica y su irresistible aura magnética.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/maxi-vestido-negro-largo-con-cuello-alto-drapeado/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>El escultural cuello alzado</strong> alarga suavemente el cuello con un toque moderno</li>
<li><strong>Magistral drapeado</strong> en la cintura que afina la silueta de forma natural</li>
<li><strong>Largo maxi hasta el suelo</strong> para un efecto de barrido teatral</li>
<li><strong>negro atemporal</strong> que realza todos los tonos de piel</li>
<li><strong>Corte sin mangas</strong> que deja ver los brazos con elegancia</li>
<li><strong>Efecto esculpido</strong> que se adapta perfectamente a todas las formas del cuerpo</li>
<li><strong>Su fluidez</strong> crea un movimiento hipnótico</li>
<li><strong>Estilo arquitectónico</strong> perfecto para eventos de prestigio</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Maxi vestido negro de cuello alto: caída escultural, largo maxi, efecto arquitectónico, corte fluido. Majestuosidad y elegancia modernas | Diva's Boudoir |
| | keywords | | | title | | string | Maxi vestido negro con cuello alto drapeado | Diva's Boudoir |
|
| | seotitle | | string | Vestido largo negro de cuello grande y caída escultural |
| | seouri | | string | maxi-vestido-negro-largo-con-cuello-alto-drapeado |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> Maxi vestido</li>
<li><strong>Color :</strong> Negro profundo atemporal</li>
<li><strong>Cuello :</strong> Cuello escultural sin mangas</li>
<li><strong>Drapé :</strong> Magistral en la cintura</li>
<li><strong>Largo :</strong> Maxi largo hasta el suelo con efecto barrido</li>
<li><strong>Corte :</strong> Fluido con efecto esculpido</li>
<li><strong>Estilo:</strong> Moderno y arquitectónico</li>
<li><strong>Ocasiones :</strong> Eventos de prestigio y veladas especiales</li>
</ul> |
| | stylingtips | | string | <p>Realza tu vestido con nuestros <a href="https://www.divasboudoir.com/es/medias-grandes/">pantalones</a> slim <a href="https://www.divasboudoir.com/es/medias-grandes/">talla</a> grande para un sofisticado look total black, o añade nuestros <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimonos</a> de seda <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">talla grande</a> para una elegancia a capas.</p>
<p>Completa el look con nuestras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">braguitas</a> negras <a href="https://www.divasboudoir.com/es/braguitas-de-talla-grande/">talla grande</a> para una armonía perfecta, o explora nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">sexys vestidos talla grande</a> de la misma colección para looks más arquitectónicos. Esta creación única revela tu sentido del estilo con una inquietante majestuosidad moderna.</p> |
| | summary | | string | <p>Encarna la majestuosidad moderna con este maxivestido negro de escultural cuello alto Su magistral drapeado en la cintura y su largo hasta el suelo crean una silueta escultural de elegancia absoluta.</p>
<p>Con su efecto arquitectónico y su grácil fluidez, esta creación transforma cada aparición en un momento de pura fascinación.</p> |
| | title | | string | Maxivestido negro de cuello alto - Majestad moderna y encanto escultural |
| | usageinstructions | | string | <p>Deslice suavemente este vestido, teniendo cuidado de colocar el escultural cuello alto de forma natural. La <strong>magistral caída</strong> se coloca automáticamente para crear ese efecto escultural que armoniza tu silueta. El largo maxi requiere especial atención al moverse para preservar el elegante efecto de barrido. Gracias a su caída técnica y su corte vaporoso, este vestido <strong>se adapta a todo tipo de cuerpos</strong>. Llévelo con confianza para revelar su lado majestuoso en sus eventos más prestigiosos.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage à la main à l'eau froide pour préserver le noir profond</li>
<li>Utiliser une lessive douce sans agents blanchissants</li>
<li>Séchage à plat pour maintenir la forme du drapé</li>
<li>Ne jamais repasser directement sur les plis sculptants</li>
<li>Suspendre délicatement pour éviter les marques</li>
<li>Ranger dans une housse pour protéger la longueur maxi</li>
</ul> |
| | description | | string | <p>Cette robe longue révolutionne l'art de l'élégance moderne avec son <strong>col montant sculptural</strong> qui crée un effet architectural saisissant. Cette ligne épurée allonge délicatement votre cou tout en apportant cette dimension contemporaine qui fait sensation.</p>
<p>Le <strong>drapé magistral au niveau de la taille</strong> transforme cette robe en véritable œuvre d'art portable. Ces plis et fronces créent un effet sculptant qui affine naturellement la silhouette tout en gommant discrètement les petites zones que vous souhaitez harmoniser. La <strong>longueur maxi au sol</strong> crée cette allure de déesse moderne qui ne passe jamais inaperçue. L'effet balayage apporte cette théâtralité sophistiquée qui transforme chaque pas en moment de pure grâce. Le <strong>noir profond intemporel</strong> sublime toutes les carnations et s'adapte à toutes les occasions les plus prestigieuses. Cette couleur révèle votre goût pour l'excellence et votre sens du style affirmé.</p>
<p>La <strong>coupe sans manches</strong> révèle vos bras avec une élégance naturelle, créant cette ligne épurée qui <strong>s'adapte parfaitement à toutes les morphologies</strong>. Le tissu fluide épouse délicatement vos courbes sans contrainte. La <strong>fluidité gracieuse</strong> du tissu crée ce mouvement hypnotique à chaque déplacement, révélant votre beauté naturelle avec une sophistication qui transcende les conventions. Quand vous portez cette robe, vous devenez cette icône moderne qui hypnotise avec sa majesté architecturale et son aura magnétique irrésistible.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/robe-grande-taille-longue-noire-col-montant-drape/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Col montant sculptural</strong> qui allonge délicatement le cou avec modernité</li>
<li><strong>Drapé magistral</strong> au niveau de la taille qui affine naturellement la silhouette</li>
<li><strong>Longueur maxi au sol</strong> pour un effet balayage théâtral</li>
<li><strong>noir intemporel</strong> qui sublime toutes les carnations</li>
<li><strong>Coupe sans manches</strong> qui révèle les bras avec élégance</li>
<li><strong>Effet sculptant</strong> qui harmonise parfaitement toutes les morphologies</li>
<li><strong>Fluidité gracieuse</strong> qui crée un mouvement hypnotique</li>
<li><strong>Style architectural</strong> parfait pour événements prestigieux</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Robe longue grande taille noire col montant : drapé sculptant, longueur maxi, effet architectural, coupe fluide. Majesté moderne et élégance | Diva's Boudoir |
| | keywords | | | title | | string | Robe longue grande taille noire col montant drapé | Diva's Boudoir |
|
| | seotitle | | string | Robe grande taille longue noire col montant drapé sculptant |
| | seouri | | string | robe-grande-taille-longue-noire-col-montant-drape |
| | specifications | | string | <ul>
<li><strong>Type :</strong> Robe longue maxi</li>
<li><strong>Couleur :</strong> noir profond intemporel</li>
<li><strong>Col :</strong> Montant sculptural sans manches</li>
<li><strong>Drapé :</strong> Magistral au niveau de la taille</li>
<li><strong>Longueur :</strong> Maxi au sol avec effet balayage</li>
<li><strong>Coupe :</strong> Fluide avec effet sculptant</li>
<li><strong>Style :</strong> Architectural moderne</li>
<li><strong>Occasions :</strong> Événements prestigieux et soirées d'exception</li>
</ul> |
| | stylingtips | | string | <p>Sublimez votre robe avec nos <a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas grande taille</a> fins pour un look total black sophistiqué, ou ajoutez nos <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimonos grande taille</a> en soie pour une élégance superposée.</p>
<p>Complétez avec nos <a href="https://www.divasboudoir.com/fr/culottes-grande-taille/">culottes grande taille</a> noires pour une harmonie parfaite, ou explorez nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">robes sexys grande taille</a> de la même collection pour multiplier les looks architecturaux. Cette création unique révèle votre sens du style avec une majesté moderne troublante.</p> |
| | summary | | string | <p>Incarnez la majesté moderne avec cette robe longue noire au col montant sculptural ! Son drapé magistral au niveau de la taille et sa longueur au sol créent une silhouette statuesque d'une élégance absolue.</p>
<p>Avec son effet architectural et sa fluidité gracieuse, cette création transforme chaque apparition en moment de pure fascination.</p> |
| | title | | string | Robe Longue noire Col Montant - Majesté Moderne et Allure Statuesque |
| | usageinstructions | | string | <p>Enfilez délicatement cette robe en prenant soin du col montant sculptural qui se positionne naturellement. Le <strong>drapé magistral</strong> se place automatiquement pour créer cet effet sculptant qui harmonise votre silhouette. La longueur maxi demande une attention particulière lors des déplacements pour préserver l'effet balayage élégant. Cette robe <strong>sublime toutes les morphologies</strong> grâce à son drapé technique et sa coupe fluide. Portez-la avec assurance pour révéler votre côté majestueux lors de vos événements les plus prestigieux.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavare a mano in acqua fredda per preservare il colore nero intenso</li>
<li>Utilizzare un detergente delicato senza agenti sbiancanti</li>
<li>Asciugare in piano per mantenere la forma del drappeggio</li>
<li>Non stirare mai direttamente sulle pieghe di scolpitura</li>
<li>Appendere delicatamente per evitare segni</li>
<li>Conservare in un sacchetto per proteggere la lunghezza massima</li>
</ul> |
| | description | | string | <p>Questo maxi abito rivoluziona l'arte dell'eleganza moderna con il suo <strong>colletto scultoreo che</strong> crea un sorprendente effetto architettonico. Il design elegante allunga delicatamente il collo, aggiungendo una dimensione contemporanea che si fa notare.</p>
<p>Il <strong>magistrale drappeggio in vita</strong> trasforma questo abito in un'opera d'arte da indossare. Le pieghe e le arricciature creano un effetto scultura che affina naturalmente la silhouette e cancella con discrezione le piccole aree che si desidera armonizzare. La <strong>maxi lunghezza al pavimento</strong> crea un look da dea moderna che non passa mai inosservato. L'effetto "sweeping" aggiunge una sofisticata teatralità che trasforma ogni passo in un momento di pura grazia. <strong>L'intramontabile nero profondo</strong> sublima tutte le tonalità della pelle ed è perfetto per le occasioni più prestigiose. Questo colore rivela il vostro gusto per l'eccellenza e il vostro senso dello stile.</p>
<p>Il <strong>taglio senza maniche</strong> rivela le braccia con naturale eleganza, creando una linea elegante <strong>perfetta per ogni tipo di corpo</strong>. Il tessuto fluido abbraccia delicatamente le vostre curve senza costringerle. La <strong>leggiadra fluidità</strong> del tessuto crea un movimento ipnotico a ogni movimento, rivelando la vostra bellezza naturale con una raffinatezza che trascende le convenzioni. Quando indossate questo abito, diventate l'icona moderna che ipnotizza con la sua maestosità architettonica e la sua irresistibile aura magnetica.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/grande-abito-nero-lungo-con-collo-alto-drappeggiato/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Il colletto scultoreo</strong> allunga delicatamente il collo con un tocco moderno</li>
<li><strong>Magistrale drappeggio</strong> in vita che slancia naturalmente la silhouette</li>
<li><strong>Maxi lunghezza al pavimento</strong> per un effetto teatrale e avvolgente</li>
<li><strong>nero senza tempo</strong> per esaltare tutte le tonalità della pelle</li>
<li><strong>Taglio senza maniche</strong> che scopre elegantemente le braccia</li>
<li><strong>Effetto scultura</strong> che si adatta perfettamente a tutte le forme del corpo</li>
<li><strong>La leggiadra fluidità</strong> crea un movimento ipnotico</li>
<li><strong>Stile architettonico</strong> perfetto per eventi prestigiosi</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Maxi abito nero a collo alto: drappeggio scultoreo, lunghezza maxi, effetto architettonico, taglio fluido. Maestosità ed eleganza moderna | Diva's Boudoir |
| | keywords | | | title | | string | Grande abito nero con collo alto drappeggiato | Diva's Boudoir |
|
| | seotitle | | string | Abito lungo nero a collo alto con drappeggio scultoreo |
| | seouri | | string | grande-abito-nero-lungo-con-collo-alto-drappeggiato |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> maxi abito</li>
<li><strong>Colore :</strong> nero profondo senza tempo</li>
<li><strong>Colletto :</strong> Colletto scultoreo senza maniche</li>
<li><strong>Drappeggio :</strong> Magistrale in vita</li>
<li><strong>Lunghezza :</strong> Maxi lunghezza fino al pavimento con effetto ampio</li>
<li><strong>Taglio :</strong> Fluido con effetto scultura</li>
<li><strong>Stile:</strong> Moderno e architettonico</li>
<li><strong>Occasioni:</strong> Eventi prestigiosi e serate speciali</li>
</ul> |
| | stylingtips | | string | <p>Arricchite il vostro abito con i nostri slip slim <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">plus size</a> per un sofisticato look total black, oppure aggiungete i nostri <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">kimono</a> in seta <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">taglia grande</a> per un'eleganza a strati.</p>
<p>Completate il look con le nostre <a href="https://www.divasboudoir.com/it/mutande-curvy/">mutandine</a> nere <a href="https://www.divasboudoir.com/it/mutande-curvy/">plus size</a> per un'armonia perfetta, oppure esplorate i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti sexy taglia grande</a> della stessa collezione per look più architettonici. Questa creazione unica rivela il vostro senso dello stile con una maestosità moderna e sconvolgente.</p> |
| | summary | | string | <p>Incarnate la moderna maestosità con questo maxi abito nero dal colletto scultoreo! Il suo magistrale drappeggio in vita e la lunghezza al pavimento creano una silhouette statuaria di assoluta eleganza.</p>
<p>Con il suo effetto architettonico e la sua leggiadra fluidità, questa creazione trasforma ogni apparizione in un momento di puro fascino.</p> |
| | title | | string | Maxi abito nero a collo alto - Maestosità moderna e fascino statuario |
| | usageinstructions | | string | <p>Infilate delicatamente questo abito, avendo cura di posizionare naturalmente il colletto scultoreo. Il <strong>magistrale drappeggio</strong> si posiziona automaticamente per creare quell'effetto scultura che armonizza la silhouette. La lunghezza maxi richiede un'attenzione particolare quando ci si muove, per preservare l'elegante effetto ampio. Questo abito <strong>è perfetto per tutte le corporature</strong>, grazie al suo drappeggio tecnico e al taglio fluido. Indossatelo con disinvoltura per rivelare il vostro lato maestoso agli eventi più prestigiosi.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwas in koud water om de diepzwarte kleur te behouden</li>
<li>Gebruik een mild wasmiddel zonder bleekmiddelen</li>
<li>Plat drogen om de vorm van de stof te behouden</li>
<li>Nooit rechtstreeks op de plooien strijken</li>
<li>Voorzichtig ophangen om vlekken te voorkomen</li>
<li>Bewaar in een zak om de maximale lengte te beschermen</li>
</ul> |
| | description | | string | <p>Deze maxi-jurk revolutioneert de kunst van moderne elegantie met zijn <strong>sculpturale opstaande kraag</strong> die een opvallend architecturaal effect creëert. Het slanke ontwerp verlengt je nek op subtiele wijze en voegt een eigentijdse dimensie toe die een statement maakt.</p>
<p>De <strong>meesterlijke drapering in de taille</strong> maakt van deze jurk een draagbaar kunstwerk. Deze plooien en plooien creëren een sculpturaal effect dat het silhouet op natuurlijke wijze verfijnt en tegelijkertijd discreet alle kleine zones wegwerkt die je wilt harmoniseren. De <strong>vloerlange maxi</strong> creëert die moderne godinnenlook die nooit onopgemerkt blijft. Het zwierige effect voegt een geraffineerde theatraliteit toe die elke stap verandert in een moment van pure gratie. <strong>Tijdloos diepzwart</strong> sublimeert alle huidtinten en is perfect voor de meest prestigieuze gelegenheden. Deze kleur onthult je smaak voor uitmuntendheid en je assertieve gevoel voor stijl.</p>
<p>De <strong>mouwloze snit</strong> onthult je armen met natuurlijke elegantie en creëert een strakke lijn die <strong>perfect is voor elk lichaamstype</strong>. De vloeiende stof omhelst je rondingen zonder beperkingen. De <strong>sierlijke vloeiendheid</strong> van de stof creëert een hypnotiserende beweging bij elke beweging en onthult je natuurlijke schoonheid met een raffinement dat boven alle conventies uitstijgt. Als je deze jurk draagt, word je dat moderne icoon dat hypnotiseert met zijn architectonische majesteit en onweerstaanbare magnetische uitstraling.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/grote-maat-lange-zwarte-jurk-met-gedrapeerde-hoge-kraag/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>Sculpturale opstaande kraag</strong> verlengt de hals met een moderne twist</li>
<li><strong>Meesterlijke drapering</strong> in de taille die het silhouet op natuurlijke wijze verfijnt</li>
<li><strong>Vloerlange maxi</strong> voor een theatraal vegend effect</li>
<li><strong>tijdloos zwart</strong> voor alle huidtinten</li>
<li><strong>Mouwloze snit</strong> die de armen elegant onthult</li>
<li><strong>Sculpturerend effect</strong> dat perfect past bij alle lichaamsvormen</li>
<li><strong>Gracieuze vloeiendheid</strong> creëert hypnotiserende beweging</li>
<li><strong>Architecturale stijl</strong>, perfect voor prestigieuze evenementen</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Zwarte maxi-jurk met grote maat: sculpturale drapering, maxilengte, architecturaal effect, vloeiende snit. Moderne majesteit en elegantie | Diva's Boudoir |
| | keywords | | | title | | string | Zwarte grote maat jurk met gedrapeerde hoge hals | Diva's Boudoir |
|
| | seotitle | | string | Lange zwarte jurk met grote maat en sculpturale drapering |
| | seouri | | string | grote-maat-lange-zwarte-jurk-met-gedrapeerde-hoge-kraag |
| | specifications | | string | <ul>
<li><strong>Type :</strong> Maxi jurk</li>
<li><strong>Kleur :</strong> tijdloos diepzwart</li>
<li><strong>Kraag :</strong> Sculpturale mouwloze kraag</li>
<li><strong>Drapé :</strong> Magistraal in de taille</li>
<li><strong>Lengte :</strong> Maxi vloerlengte met vloeiend effect</li>
<li><strong>Snit :</strong> Vloeiend met sculpturaal effect</li>
<li><strong>Stijl:</strong> Modern architecturaal</li>
<li><strong>Gelegenheden:</strong> Prestigieuze evenementen en speciale avonden</li>
</ul> |
| | stylingtips | | string | <p>Maak je jurk af met onze slanke <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">plus size broekjes</a> voor een geraffineerde total black look, of voeg onze zijden <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">plus size kimono's</a> toe voor gelaagde elegantie.</p>
<p>Maak de look compleet met onze zwarte <a href="https://www.divasboudoir.com/nl/groote-maten-slipjes/">grote maten slips</a> voor een perfecte harmonie, of ontdek onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy grote maten jurken</a> uit dezelfde collectie voor meer architectonische looks. Deze unieke creatie onthult je gevoel voor stijl met verontrustende moderne majesteit.</p> |
| | summary | | string | <p>Belichaam moderne majesteit in deze zwarte maxi-jurk met zijn sculpturale opstaande kraag! De meesterlijke drapering in de taille en de lengte tot op de grond creëren een statuesk silhouet van absolute elegantie.</p>
<p>Met zijn architecturale effect en sierlijke vloeiendheid verandert deze creatie elke verschijning in een moment van pure fascinatie.</p> |
| | title | | string | Zwarte Maxi Dress met hoge hals - Moderne majesteit en statueske allure |
| | usageinstructions | | string | <p>Trek deze jurk zachtjes aan en zorg ervoor dat de sculpturale opstaande kraag op een natuurlijke manier zit. De <strong>meesterlijke drapering</strong> wordt automatisch gepositioneerd om dat sculpturale effect te creëren dat je silhouet harmoniseert. De maxilengte vraagt speciale aandacht bij het bewegen om het elegante vegende effect te behouden. Deze jurk <strong>is perfect voor alle lichaamstypes</strong>, dankzij de technische drapering en vloeiende snit. Draag hem vol vertrouwen om je van je majestueuze kant te laten zien op je meest prestigieuze evenementen.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar à mão em água fria para preservar a cor preta profunda</li>
<li>Utilizar um detergente suave sem agentes branqueadores</li>
<li>Secar na horizontal para manter a forma do drapeado</li>
<li>Nunca passar a ferro diretamente sobre as dobras esculpidas</li>
<li>Pendurar suavemente para evitar marcas</li>
<li>Guardar num saco para proteger o comprimento máximo</li>
</ul> |
| | description | | string | <p>Este vestido maxi revoluciona a arte da elegância moderna com o seu <strong>colarinho escultural</strong> que cria um efeito arquitetónico impressionante. O design elegante alonga delicadamente o pescoço, acrescentando uma dimensão contemporânea que faz uma afirmação.</p>
<p>O drapeado <strong>magistral na cintura</strong> transforma este vestido numa obra de arte que pode ser usada. Estas pregas e franzidos criam um efeito de escultura que afina naturalmente a silhueta, ao mesmo tempo que apaga discretamente quaisquer pequenas áreas que queira harmonizar. O <strong>maxi comprimento até ao chão</strong> cria aquele visual de deusa moderna que nunca passa despercebido. O efeito de varrimento acrescenta uma teatralidade sofisticada que transforma cada passo num momento de pura graça. <strong>O preto profundo e intemporal</strong> sublima todos os tons de pele e é perfeito para as ocasiões mais prestigiadas. Esta cor revela o seu gosto pela excelência e o seu sentido de estilo assertivo.</p>
<p>O <strong>corte sem mangas</strong> revela os seus braços com uma elegância natural, criando uma linha elegante que <strong>é perfeita para todos os tipos de corpo</strong>. O tecido fluido abraça suavemente as suas curvas sem constrangimentos. A <strong>fluidez graciosa</strong> do tecido cria um movimento hipnótico em cada movimento, revelando a sua beleza natural com uma sofisticação que transcende as convenções. Quando usa este vestido, torna-se naquele ícone moderno que hipnotiza com a sua majestade arquitetónica e a sua aura magnética irresistível.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/vestido-preto-comprido-maxi-com-gola-alta-drapeada/cdbu4359.htm |
| | highlights | | string | <ul>
<li><strong>A gola escultural de pé</strong> alonga suavemente o pescoço com um toque moderno</li>
<li>Um drapeado<strong>magistral</strong> na cintura que adelgaça naturalmente a silhueta</li>
<li><strong>Maxi até ao chão</strong> para um efeito teatral</li>
<li><strong>preto intemporal</strong> para realçar todos os tons de pele</li>
<li><strong>Corte sem mangas</strong> que revela elegantemente os braços</li>
<li><strong>Efeito esculpido</strong> que combina na perfeição com todos os tipos de corpo</li>
<li><strong>A fluidez graciosa</strong> cria um movimento hipnótico</li>
<li><strong>Estilo arquitetónico</strong> perfeito para eventos de prestígio</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Vestido maxi preto com gola alta: drapeado esculpido, comprimento maxi, efeito arquitetónico, corte fluido. Majestade e elegância modernas | Diva's Boudoir |
| | keywords | | | title | | string | Vestido maxi preto com gola alta drapeada | Diva's Boudoir |
|
| | seotitle | | string | Vestido preto comprido de gola alta com drapeado esculpido |
| | seouri | | string | vestido-preto-comprido-maxi-com-gola-alta-drapeada |
| | specifications | | string | <ul>
<li><strong>Tipo :</strong> Vestido maxi</li>
<li><strong>Cor :</strong> Preto profundo intemporal</li>
<li><strong>Gola :</strong> Gola escultural sem mangas</li>
<li><strong>Drapé:</strong> Magistral na cintura</li>
<li><strong>Comprimento :</strong> Maxi ao nível do chão com efeito de varrimento</li>
<li><strong>Corte :</strong> Fluido com efeito esculpido</li>
<li><strong>Estilo:</strong> Arquitetónico moderno</li>
<li><strong>Ocasiões:</strong> Eventos de prestígio e noites especiais</li>
</ul> |
| | stylingtips | | string | <p>Realce o seu vestido com as nossas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a> finas <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">plus size</a> para um look total black sofisticado, ou adicione <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">os</a> nossos <a href="https://www.divasboudoir.com/fr/kimono-grande-taille/">quimonos plus size</a> de seda para uma elegância em camadas.</p>
<p>Complete o look com as nossas <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">cuecas</a> pretas <a href="https://www.divasboudoir.com/pt/calcinhas-curvy/">plus size</a> para uma harmonia perfeita, ou explore os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sexy plus size</a> da mesma coleção para looks mais arquitectónicos. Esta criação única revela o seu sentido de estilo com uma majestade moderna inquietante.</p> |
| | summary | | string | <p>Encarne a majestade moderna neste vestido maxi preto com a sua gola escultural! O seu drapeado magistral na cintura e o comprimento no chão criam uma silhueta escultural de absoluta elegância.</p>
<p>Com o seu efeito arquitetónico e fluidez graciosa, esta criação transforma cada aparição num momento de puro fascínio.</p> |
| | title | | string | Vestido maxi preto de gola alta - Majestade moderna e fascínio escultural |
| | usageinstructions | | string | <p>Vista suavemente este vestido, tendo o cuidado de posicionar naturalmente a gola escultural de pé. O <strong>drapeado magistral</strong> é posicionado automaticamente para criar o efeito escultural que harmoniza a sua silhueta. O comprimento maxi requer uma atenção especial ao movimentar-se para preservar o elegante efeito de varrimento. Este vestido <strong>é perfeito para todos os tipos de corpo</strong>, graças ao seu drapeado técnico e corte fluido. Use-o com confiança para revelar o seu lado majestoso nos seus eventos mais prestigiados.</p> |
|
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | | string | sz2412104818876472 longue |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 |
|
| promountil | |
| rating | |
| recorduid | | string | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.37 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,'2351,2352,2353,2354,2355') > 0 and product_variations.productuid = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 | 2355 | 4X | intlsize | black | 4X | 4X | -1 | 999999 | 0 | w | plus | dress | 4XL | 4X | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 128-134 | 107-112 | 133-140 | | | | | | | | 2 | 2351 | XL | intlsize | black | XL | XL | -1 | 999999 | 0 | w | plus | dress | 0XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | 100-107 | 79-86 | 105-112 | | | | | | | | 3 | 2352 | 1X | intlsize | black | 1X | 1X | -1 | 999999 | 0 | w | plus | dress | 1XL | 1X | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 107-114 | 86-93 | 112-119 | | | | | | | | 4 | 2353 | 2XL | intlsize | black | 2XL | 2XL | -1 | 999999 | 0 | w | plus | dress | 2XL | 2XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 114-121 | 93-100 | 119-126 | | | | | | | | 5 | 2354 | 3X | intlsize | black | 3X | 3X | -1 | 999999 | 0 | w | plus | dress | 3XL | 3X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 121-128 | 100-107 | 126-133 | | | | | | |
|
| sizeranges | |
| sizes | | string | 2351,2352,2353,2354,2355 |
|
| 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: 197 ms Record Count: 5 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2351 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2352 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2353 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2354 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2355 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 | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 | 5A570D2E-01F1-4ADB-98DBBFBED4C5198D | 2355 | black | #000000 | 4XL | 4X | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | dress | | 4X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 2 | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 | FAF2F574-C665-4676-9DDB06B852B95615 | 2351 | black | #000000 | 0XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | dress | | XL | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 3 | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 | 7E00044A-0C24-4549-B94D5FC233586E9D | 2352 | black | #000000 | 1XL | 1X | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | dress | | 1X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 4 | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 | 84932E1A-4641-45BA-90E4B91BED2338DD | 2353 | black | #000000 | 2XL | 2XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | dress | | 2XL | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 5 | 6BE1B1EC-C4B1-4E0D-83E7B3321B764129 | D81E880A-229F-4E78-A835D9C65B9DCD2F | 2354 | black | #000000 | 3XL | 3X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | dress | | 3X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 10.2 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2351 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2352 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2353 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2354 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' 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 = '6BE1B1EC-C4B1-4E0D-83E7B3321B764129' and product_variations.isactive = 1 and product_sizes.id_size = 2355 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 | 5A570D2E-01F1-4ADB-98DBBFBED4C5198D | 2355 | black | #000000 | 4XL | 4X | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | dress | | 4X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 62.4583 | all | | | 2 | FAF2F574-C665-4676-9DDB06B852B95615 | 2351 | black | #000000 | 0XL | XL | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | dress | | XL | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 62.4583 | all | | | 3 | 7E00044A-0C24-4549-B94D5FC233586E9D | 2352 | black | #000000 | 1XL | 1X | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | dress | | 1X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 62.4583 | all | | | 4 | 84932E1A-4641-45BA-90E4B91BED2338DD | 2353 | black | #000000 | 2XL | 2XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | dress | | 2XL | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 62.4583 | all | | | 5 | D81E880A-229F-4E78-A835D9C65B9DCD2F | 2354 | black | #000000 | 3XL | 3X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | dress | | 3X | intlsize | 62.4583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 62.4583 | all | |
|
| vatrate | |
| warehouse | |