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.688 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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-05-21 15:38:33'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-05-31 19:33:26'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.605 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','fr') 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('32529e83-f60f-44c6-af1fae0590320c7b',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.25 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','fr') and product_categories.language in ('all','fr') 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 <> 'CDBU6307' 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/cdbu6307/robe-chemisier-grande-taille-noire2.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/dvqc/cdbu6307/robe-chemisier-grande-taille-noire3.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/dvqc/cdbu6307/robe-chemisier-grande-taille-noire3.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>Maschinenwäsche bei 30°C empfohlen.</li>
<li>Schonprogramm mit reduziertem Schleudergang</li>
<li>An der Luft trocknen, um die Qualität des Stoffes zu erhalten</li>
<li>Bügeln ist dank des knitterfreien Stoffes nicht nötig</li>
<li>Bei Bedarf bei niedriger Temperatur bügeln</li>
</ul> |
| | description | | string | <p>Dieses ärmellose Hemdblusenkleid verkörpert die perfekte Balance zwischen zeitloser Eleganz und moderner Praktikabilität. Der taillierte Schnitt wurde speziell dafür entworfen, die natürlichen Kurven Ihrer Figur zu betonen und eine harmonische, schmeichelhafte Linie zu schaffen, ohne dabei einen figurbetonten Effekt zu erzielen.<br>Die durchgehende Knopfleiste bietet Ihnen eine einzigartige Flexibilität: Tragen Sie es ganz geschlossen für einen raffinierten Look oder teilweise aufgeknöpft für einen lässigen Stil. Diese Eigenschaft ermöglicht es Ihnen auch, das Kleidungsstück perfekt an Ihre Körperform anzupassen.<br>Das ärmellose Design umspielt sanft Ihre Schultern und bietet gleichzeitig viel Bewegungsfreiheit - ideal für einen aktiven Tag oder einen eleganten Abend. Die Silhouette ist perfekt ausbalanciert, wobei besonders auf die Proportionen geachtet wurde, um einen harmonischen visuellen Effekt zu erzielen.<br>Das Kleid ist aus einem hochwertigen Stoff aus 100% Polyester gefertigt und vereint Haltbarkeit und Pflegeleichtigkeit. Seine knitterfreie Eigenschaft ist besonders wertvoll, um den ganzen Tag über ein makelloses Aussehen zu bewahren, auch wenn Sie unterwegs sind.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/sexy-kleider-schwarz/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Taillierter Schnitt, der die Silhouette elegant betont</li>
<li>Durchgehende Knopfleiste für einen Stil, der sich nach Lust und Laune anpassen lässt</li>
<li>Knitterfreies Gewebe aus 100% Polyester für ganztägigen Tragekomfort</li>
<li>Ärmelloses Design, das Ihre Schultern sanft umspielt</li>
<li>Außergewöhnliche Vielseitigkeit: kann allein oder über einer Hose getragen werden</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Entdecken Sie unser ärmelloses Blusenkleid in großen Größen mit tailliertem Schnitt und knitterfreiem Stoff. Eleganz und Komfort für alle Figurtypen. Kostenlose Lieferung! |
| | keywords | | | title | | string | Blusenkleid Große Größe Ärmellos Tailliert Knitterfrei | Diva's Boudoir |
|
| | seotitle | | string | Blusenkleid in großer Größe ohne Ärmel tailliert geknöpft |
| | seouri | | string | sexy-kleider-schwarz |
| | specifications | | string | <ul>
<li>Zusammensetzung: 100% knitterfreies Polyester</li>
<li>Stil: Ärmelloses, tailliertes Blusenkleid</li>
<li>Verschluss: Durchgehende Knopfleiste über die gesamte Länge</li>
<li>Schnitt: An der Taille tailliert, um die Silhouette natürlich zu betonen, ohne einen formenden Effekt</li>
<li>Länge: Midi</li>
<li>Farbe: Elegantes Schwarz</li>
</ul> |
| | stylingtips | | string | <p>Für ein elegantes Büro-Outfit tragen Sie dieses Blusenkleid mit Pumps mit mittelhohem Absatz und dezenten Accessoires. Für einen legeren Look kombinieren Sie es mit flachen Sandalen und einer Umhängetasche. Am Abend tragen Sie es über einer schwarzen schmalen Hose und fügen Statement-Schmuck für einen modernen Stil hinzu. An kühleren Tagen ergänzen Sie es mit einem strukturierten Blazer oder einer langen Strickjacke. Dieses vielseitige Stück passt zu jedem Anlass, vom Arbeitstag bis zum Abendessen mit Freunden.</p> |
| | summary | | string | <p>Entdecken Sie unser ärmelloses Blusenkleid, ein vielseitiges Kleidungsstück, das Eleganz und Komfort vereint. Dieses taillierte Kleid betont Ihre Schultern und verleiht Ihrer Silhouette dank des perfekt sitzenden Schnitts eine schöne Silhouette. Sein knitterfreier Stoff garantiert Ihnen einen makellosen Look von morgens bis abends.</p> |
| | title | | string | Blusenkleid Urbane Eleganz - Schmeichelnde Passform und absoluter Komfort |
| | usageinstructions | | string | <p>Für eine optimale Passform wählen Sie Ihre übliche Größe - der taillierte Schnitt betont Ihre Figur auf natürliche Weise, ohne zu drücken. Dank der durchgehenden Knopfleiste können Sie die Öffnung des Dekolletés nach Belieben anpassen. Für eine definierte Silhouette fügen Sie einen schmalen Gürtel an der Taille hinzu. Dieses Kleid wurde so entworfen, dass es den ganzen Tag über bequem ist, vom Büro bis zum Ausgehen am Abend, und auch nach langem Sitzen nicht knittert.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Συνιστάται πλύσιμο στο πλυντήριο στους 30°C</li>
<li>Λεπτό πρόγραμμα με χαμηλό στύψιμο</li>
<li>Στεγνώστε στον αέρα για να διατηρήσετε την ποιότητα του υφάσματος</li>
<li>Δεν χρειάζεται σιδέρωμα χάρη στο ύφασμα που δεν τσαλακώνεται</li>
<li>Εάν είναι απαραίτητο, σιδερώστε σε χαμηλή θερμοκρασία</li>
</ul> |
| | description | | string | <p>Αυτό το αμάνικο φόρεμα με μπλούζα επιτυγχάνει την τέλεια ισορροπία ανάμεσα στη διαχρονική κομψότητα και τη σύγχρονη πρακτικότητα. Η στενή του γραμμή έχει σχεδιαστεί ειδικά για να ενισχύει τις φυσικές καμπύλες της σιλουέτας σας, δημιουργώντας μια αρμονική, κολακευτική γραμμή χωρίς φαινόμενο θήκης.<br>Το ολόσωμο κούμπωμα σας δίνει μοναδική ευελιξία: φορέστε το εντελώς κλειστό για μια εκλεπτυσμένη εμφάνιση ή μερικώς ξεκούμπωτο για ένα πιο χαλαρό στυλ. Αυτό το χαρακτηριστικό σας επιτρέπει επίσης να προσαρμόσετε το ρούχο τέλεια στο σχήμα του σώματός σας.<br>Ο αμάνικος σχεδιασμός λικνίζει απαλά τους ώμους σας, προσφέροντας παράλληλα μεγάλη ελευθερία κινήσεων, ιδανικό τόσο για δραστήριες ημέρες όσο και για κομψές βραδινές εξόδους. Η σιλουέτα είναι απόλυτα ισορροπημένη, με ιδιαίτερη προσοχή στις αναλογίες για τη δημιουργία ενός αρμονικού οπτικού αποτελέσματος.<br>Κατασκευασμένο από υψηλής ποιότητας ύφασμα από 100% πολυεστέρα, αυτό το φόρεμα συνδυάζει την ανθεκτικότητα με την ευκολία στη φροντίδα. Οι ανθεκτικές στις τσακίσεις ιδιότητές του είναι ιδιαίτερα χρήσιμες για τη διατήρηση μιας άψογης εμφάνισης όλη την ημέρα, ακόμη και όταν βρίσκεστε σε κίνηση.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/sexi-foremata-mayro/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Στενή γραμμή για κομψή σιλουέτα</li>
<li>Κλείσιμο με κουμπιά για ένα στυλ που μπορεί να προσαρμοστεί ανάλογα με τις ανάγκες σας</li>
<li>100% πολυεστερικό ύφασμα ανθεκτικό στις τσακίσεις για άνεση όλη την ημέρα</li>
<li>Ο αμάνικος σχεδιασμός τονίζει απαλά τους ώμους σας</li>
<li>Εξαιρετική ευελιξία: μπορεί να φορεθεί μόνη της ή πάνω από παντελόνι</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ανακαλύψτε το μεγάλο αμάνικο φόρεμα-μπλούζα με λεπτή γραμμή και ύφασμα ανθεκτικό στις τσακίσεις. Κομψότητα και άνεση για κάθε σιλουέτα. Δωρεάν παράδοση! |
| | keywords | | | title | | string | Μεγάλο αμάνικο φόρεμα με πλισέ μπλούζα | Diva's Boudoir |
|
| | seotitle | | string | Μεγάλο αμάνικο φόρεμα μπλούζα με κουμπιά μπροστά |
| | seouri | | string | sexi-foremata-mayro |
| | specifications | | string | <ul>
<li>Σύνθεση: 100% πολυεστέρας ανθεκτικός στις τσακίσεις</li>
<li>Στυλ : Φόρεμα με εφαρμοστή αμάνικη μπλούζα</li>
<li>Κλείσιμο: Κλείσιμο με κουμπιά σε όλο το μήκος</li>
<li>Κοπή: Μέση που σφίγγεται για να ενισχύει φυσικά τη σιλουέτα, χωρίς να έχει το φαινόμενο της θήκης</li>
<li>Μήκος: Midi</li>
<li>Χρώμα: Κομψό μαύρο</li>
</ul> |
| | stylingtips | | string | <p>Για μια κομψή εμφάνιση στο γραφείο, φορέστε αυτό το φόρεμα-μπλούζα με γόβες με μεσαίο τακούνι και διακριτικά αξεσουάρ. Για μια πιο casual εμφάνιση, συνδυάστε το με φλατ σανδάλια και μια τσάντα ώμου. Για το βράδυ, τοποθετήστε το πάνω από ένα λεπτό μαύρο παντελόνι και προσθέστε statement κοσμήματα για ένα σύγχρονο στυλ. Για τις πιο δροσερές ημέρες, συμπληρώστε με ένα δομημένο σακάκι ή μια μακριά ζακέτα. Αυτό το ευέλικτο κομμάτι είναι ιδανικό για κάθε περίσταση, από μια μέρα στο γραφείο μέχρι ένα δείπνο με φίλους.</p> |
| | summary | | string | <p>Ανακαλύψτε το αμάνικο φόρεμα με μπλούζα, ένα ευέλικτο κομμάτι που συνδυάζει κομψότητα και άνεση. Αυτό το φόρεμα σε στενή γραμμή αναδεικνύει τους ώμους σας και ενισχύει τη σιλουέτα σας με την τέλεια εφαρμογή του. Το ύφασμα που είναι ανθεκτικό στις τσακίσεις σημαίνει ότι θα δείχνετε υπέροχη από το πρωί μέχρι το βράδυ.</p> |
| | title | | string | Φόρεμα με μπλούζα Élégance Urbaine - Κολακευτική εφαρμογή και απόλυτη άνεση |
| | usageinstructions | | string | <p>Για καλύτερη εφαρμογή, επιλέξτε το συνηθισμένο σας μέγεθος - η λεπτή εφαρμογή θα ενισχύσει φυσικά τη σιλουέτα σας χωρίς συμπίεση. Το πλήρες κούμπωμα με κουμπιά σας επιτρέπει να προσαρμόσετε τη λαιμόκοψη στις προτιμήσεις σας. Για μια πιο καθορισμένη σιλουέτα, προσθέστε μια λεπτή ζώνη στη μέση. Αυτό το φόρεμα έχει σχεδιαστεί για να είναι άνετο όλη μέρα, από το γραφείο μέχρι τις βραδινές εξόδους, χωρίς να τσαλακώνεται ακόμα και μετά από πολύωρη καθιστή εργασία.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Machine wash at 30°C recommended</li>
<li>Delicate program with low spin</li>
<li>Air-dry to preserve fabric quality</li>
<li>Wrinkle-free fabric means no ironing required</li>
<li>If necessary, iron at low temperature</li>
</ul> |
| | description | | string | <p>This sleeveless blouse dress embodies the perfect balance between timeless elegance and modern practicality. Its slim fit has been specially designed to enhance the natural curves of your figure, creating a harmonious, flattering line without a sheathing effect.<br>Full-length buttoning gives you unique flexibility: wear it fully closed for a sophisticated look, or partially unbuttoned for a more relaxed style. This feature also allows you to adjust the garment perfectly to your body shape.<br>The sleeveless design delicately sublimates your shoulders while offering appreciable freedom of movement, ideal for both active days and elegant evenings. The silhouette is perfectly balanced, with particular attention paid to proportions to create a harmonious visual effect.<br>Made from high-quality 100% polyester fabric, this dress combines durability with ease of care. Its crease-resistant property is particularly appreciated for maintaining an impeccable appearance all day long, even when you're on the move.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/sexy-dresses-black/cdbu6307.htm |
| | highlights | | string | <ul>
<li>A slim fit that elegantly accentuates the silhouette</li>
<li>Full buttoning for adjustable styling to suit your needs</li>
<li>100% polyester crease-resistant fabric for all-day comfort</li>
<li>Sleeveless design delicately sublimates your shoulders</li>
<li>Exceptional versatility: wear alone or over pants</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Discover our plus size sleeveless blouse dress with slim fit and crease-resistant fabric. Elegance and comfort for every figure. Free delivery! |
| | keywords | | | title | | string | Plus Size Sleeveless Fitted Pleated Blouse Dress | Diva's Boudoir |
|
| | seotitle | | string | Plus size sleeveless buttoned blouse dress |
| | seouri | | | specifications | | string | <ul>
<li>Composition: 100% wrinkle-resistant polyester</li>
<li>Style: Sleeveless fitted blouse dress</li>
<li>Closure: Full-length button fastening</li>
<li>Cut: Curved at the waist to naturally enhance the silhouette, with no sheathing effect</li>
<li>Length: Midi</li>
<li>Color: Elegant black</li>
</ul> |
| | stylingtips | | string | <p>For an elegant office look, wear this blouse dress with mid-heeled pumps and discreet accessories. For a more casual look, pair it with flat sandals and a shoulder bag. For evening, layer over slim black pants and add statement jewelry for a contemporary look. For cooler days, complete with a structured blazer or long cardigan. This versatile piece is perfect for any occasion, from a day at work to dinner with friends.</p> |
| | summary | | string | <p>Discover our sleeveless blouse dress, a versatile piece that combines elegance and comfort. This slim-fitting dress emphasizes your shoulders and enhances your silhouette with its perfect fit. Its crease-resistant fabric guarantees a flawless look from morning to night.</p> |
| | title | | string | Élégance Urbaine blouse-dress - Flattering cut and absolute comfort |
| | usageinstructions | | string | <p>For optimum fit, choose your usual size - the slim fit will naturally enhance your silhouette without compression. Full buttoning lets you adjust the neckline opening to your preference. For a more defined silhouette, add a slim belt at the waist. This dress is designed for all-day comfort, from the office to evening outings, without wrinkling even after long hours of sitting.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Se recomienda lavar a máquina a 30°C</li>
<li>Programa delicado con centrifugado bajo</li>
<li>Secado al aire para preservar la calidad del tejido</li>
<li>No necesita plancha gracias a su tejido resistente a las arrugas</li>
<li>Si es necesario, planchar a baja temperatura</li>
</ul> |
| | description | | string | <p>Este vestido blusón sin mangas logra el equilibrio perfecto entre elegancia atemporal y practicidad moderna. Su corte entallado se ha diseñado especialmente para realzar las curvas naturales de tu figura, creando una línea armoniosa y favorecedora sin efecto enfundado.<br>La abotonadura completa le ofrece una flexibilidad única: llévelo completamente cerrado para un look sofisticado, o parcialmente desabrochado para un estilo más relajado. Esta característica también le permite ajustar la prenda perfectamente a la forma de su cuerpo.<br>El diseño sin mangas acuna suavemente los hombros, al tiempo que ofrece una gran libertad de movimientos, ideal tanto para los días activos como para las noches elegantes. La silueta está perfectamente equilibrada, con especial atención a las proporciones para crear un efecto visual armonioso.<br>Confeccionado en un tejido 100% poliéster de gran calidad, este vestido combina durabilidad y facilidad de cuidado. Su resistencia a las arrugas es especialmente útil para mantener un aspecto impecable durante todo el día, incluso en movimiento.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/vestido-sexy-negro/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Corte entallado para una silueta elegante</li>
<li>Cierre con botones para un estilo que se puede ajustar a tu gusto</li>
<li>Tejido 100% poliéster resistente a las arrugas para una mayor comodidad durante todo el día</li>
<li>Diseño sin mangas que acentúa delicadamente los hombros</li>
<li>Versatilidad excepcional: puede llevarse sola o sobre pantalones</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra nuestro vestido blusa sin mangas de talla grande con corte entallado y tejido resistente a las arrugas. Elegancia y comodidad para todas las figuras. Entrega gratuita |
| | keywords | | | title | | string | Vestido plisado sin mangas talla grande | Diva's Boudoir |
|
| | seotitle | | string | Vestido blusa grande sin mangas con botones delanteros |
| | seouri | | | specifications | | string | <ul>
<li>Composición: 100% poliéster resistente a las arrugas</li>
<li>Estilo : Vestido blusón entallado sin mangas</li>
<li>Cierre: Cierre integral con botones</li>
<li>Corte: Cintura ceñida para realzar la silueta de forma natural, sin efecto enfundado</li>
<li>Largo: Midi</li>
<li>Color: Negro elegante</li>
</ul> |
| | stylingtips | | string | <p>Para un look de oficina elegante, lleva este vestido blusón con zapatos de tacón medio y accesorios discretos. Para un look más informal, combínalo con sandalias planas y un bolso bandolera. Para la noche, póntelo sobre unos pantalones negros ajustados y añade joyas llamativas para un estilo contemporáneo. Para los días más fríos, combínalo con un blazer estructurado o un cárdigan largo. Esta prenda versátil es perfecta para cualquier ocasión, desde un día en la oficina hasta una cena con amigos.</p> |
| | summary | | string | <p>Descubra nuestro vestido blusón sin mangas, una pieza versátil que combina elegancia y comodidad. Este vestido entallado muestra tus hombros y realza tu figura con su ajuste perfecto. Gracias a su tejido resistente a las arrugas, te verás estupenda de la mañana a la noche.</p> |
| | title | | string | Vestido blusón Élégance Urbaine - Corte favorecedor y comodidad absoluta |
| | usageinstructions | | string | <p>Para un ajuste óptimo, elija su talla habitual: el corte entallado realzará naturalmente su figura sin comprimirla. El cierre con botones permite ajustar el escote a su gusto. Para una silueta más definida, añada un cinturón fino en la cintura. Este vestido está diseñado para que resulte cómodo todo el día, desde la oficina hasta las salidas nocturnas, sin arrugarse incluso después de pasar largas horas sentada.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage en machine à 30°C recommandé</li>
<li>Programme délicat avec essorage réduit</li>
<li>Séchage à l'air libre pour préserver la qualité du tissu</li>
<li>Repassage inutile grâce au tissu infroissable</li>
<li>En cas de besoin, repasser à basse température</li>
</ul> |
| | description | | string | <p>Cette robe-chemisier sans manche incarne l'équilibre parfait entre élégance intemporelle et praticité moderne. Sa coupe cintrée a été spécialement conçue pour mettre en valeur les courbes naturelles de votre silhouette, créant une ligne harmonieuse et flatteuse sans effet gainant.<br>Le boutonnage intégral sur toute la longueur vous offre une flexibilité unique : portez-la entièrement fermée pour une allure sophistiquée, ou partiellement déboutonnée pour un style plus décontracté. Cette caractéristique vous permet également d'ajuster le vêtement parfaitement à votre morphologie.<br>Le design sans manche sublime délicatement vos épaules tout en offrant une liberté de mouvement appréciable, idéale pour les journées actives comme pour les soirées élégantes. La silhouette est parfaitement équilibrée, avec une attention particulière portée aux proportions pour créer un effet visuel harmonieux.<br>Confectionnée dans un tissu 100% polyester de haute qualité, cette robe allie durabilité et facilité d'entretien. Sa propriété infroissable est particulièrement appréciable pour maintenir une apparence impeccable tout au long de la journée, même lors de vos déplacements.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/grande-taille-robe-chemisier-sans-manche-cintree/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Coupe cintrée qui met élégamment la silhouette en valeur</li>
<li>Boutonnage intégral pour un style ajustable selon vos envies</li>
<li>Tissu infroissable 100% polyester pour un confort optimal toute la journée</li>
<li>Design sans manche qui sublime délicatement vos épaules</li>
<li>Polyvalence exceptionnelle : se porte seule ou sur un pantalon</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Découvrez notre robe-chemisier grande taille sans manche avec coupe cintrée et tissu infroissable. Élégance et confort pour toutes les silhouettes. Livraison gratuite ! |
| | keywords | | | title | | string | Robe-Chemisier Grande Taille Sans Manche Cintrée Infroissable | Diva's Boudoir |
|
| | seotitle | | string | Robe-chemisier grande taille sans manche cintrée boutonnée |
| | seouri | | string | grande-taille-robe-chemisier-sans-manche-cintree |
| | specifications | | string | <ul>
<li>Composition : 100% polyester infroissable</li>
<li>Style : Robe-chemisier sans manche cintrée</li>
<li>Fermeture : Boutonnage intégral sur toute la longueur</li>
<li>Coupe : Cintrée à la taille pour mettre en valeur la silhouette naturellement, sans effet gainant</li>
<li>Longueur : Midi </li>
<li>Couleur : noir élégant</li>
</ul> |
| | stylingtips | | string | <p>Pour une tenue de bureau élégante, portez cette robe-chemisier avec des escarpins à talon moyen et des accessoires discrets. Pour un look plus décontracté, associez-la à des sandales plates et un sac en bandoulière. En soirée, superposez-la sur un pantalon slim noir et ajoutez des bijoux statement pour un style contemporain. Pour les journées plus fraîches, complétez avec un blazer structuré ou un cardigan long. Cette pièce polyvalente s'adapte à toutes les occasions, de la journée de travail au dîner entre amis.</p> |
| | summary | | string | <p>Découvrez notre robe-chemisier sans manche, une pièce polyvalente alliant élégance et confort. Cette robe cintrée met en valeur vos épaules et sublime votre silhouette grâce à sa coupe parfaitement ajustée. Son tissu infroissable vous garantit une allure impeccable du matin au soir.</p> |
| | title | | string | Robe-Chemisier Élégance Urbaine - Coupe flatteuse et confort absolu |
| | usageinstructions | | string | <p>Pour un ajustement optimal, choisissez votre taille habituelle - la coupe cintrée mettra naturellement votre silhouette en valeur sans compression. Le boutonnage intégral vous permet d'ajuster l'ouverture du décolleté selon vos préférences. Pour une silhouette plus définie, ajoutez une ceinture fine à la taille. Cette robe est conçue pour être confortable toute la journée, du bureau aux sorties en soirée, sans se froisser même après de longues heures assise.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Si consiglia il lavaggio in lavatrice a 30°C</li>
<li>Programma delicato con bassa centrifuga</li>
<li>Asciugare all'aria per preservare la qualità del tessuto</li>
<li>Non è necessario stirare grazie al tessuto antipiega</li>
<li>Se necessario, stirare a bassa temperatura</li>
</ul> |
| | description | | string | <p>Questo abito camicetta senza maniche rappresenta il perfetto equilibrio tra eleganza senza tempo e praticità moderna. La sua vestibilità slim è stata appositamente studiata per esaltare le curve naturali della vostra figura, creando una linea armoniosa e lusinghiera senza effetto guaina.<br>L'abbottonatura su tutta la lunghezza vi offre una flessibilità unica: indossatela completamente chiusa per un look sofisticato, o parzialmente sbottonata per uno stile più rilassato. Questa caratteristica consente inoltre di adattare il capo perfettamente alla forma del corpo.<br>Il design senza maniche culla delicatamente le spalle, offrendo al contempo una grande libertà di movimento, ideale sia per le giornate attive che per le serate eleganti. La silhouette è perfettamente bilanciata, con particolare attenzione alle proporzioni per creare un effetto visivo armonioso.<br>Realizzato in un tessuto di alta qualità in 100% poliestere, questo abito combina la durata con la facilità di manutenzione. Le sue proprietà antipiega sono particolarmente utili per mantenere un look impeccabile per tutto il giorno, anche quando si è in movimento.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/abiti-sexy-nero/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Vestibilità slim per una silhouette elegante</li>
<li>Chiusura con bottoni per uno stile che può essere regolato in base alle proprie esigenze</li>
<li>Tessuto 100% poliestere antipiega per un comfort che dura tutto il giorno</li>
<li>Il design senza maniche mette delicatamente in risalto le spalle</li>
<li>Eccezionale versatilità: può essere indossato da solo o sopra i pantaloni</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Scoprite il nostro abito camicetta senza maniche di taglia grande, con vestibilità slim e tessuto antipiega. Eleganza e comfort per ogni figura. Consegna gratuita! |
| | keywords | | | title | | string | Abito a camicetta plissettato senza maniche di taglia grande | Diva's Boudoir |
|
| | seotitle | | string | Abito a camicetta di grande taglia senza maniche e con chiusura a bottoni |
| | seouri | | | specifications | | string | <ul>
<li>Composizione: 100% poliestere antipiega</li>
<li>Stile: abito camicetta aderente senza maniche</li>
<li>Chiusura: Chiusura con bottoni su tutta la lunghezza</li>
<li>Taglio: Vita stretta per esaltare naturalmente la silhouette, senza effetto guaina</li>
<li>Lunghezza: midi</li>
<li>Colore: Nero elegante</li>
</ul> |
| | stylingtips | | string | <p>Per un look elegante da ufficio, indossate questo abito blusa con décolleté con tacco medio e accessori discreti. Per un look più casual, abbinatelo a sandali piatti e a una borsa a tracolla. Per la sera, indossatelo su pantaloni neri slim e aggiungete gioielli di rilievo per uno stile contemporaneo. Per le giornate più fresche, completate con un blazer strutturato o un cardigan lungo. Questo capo versatile è perfetto per ogni occasione, dalla giornata in ufficio alla cena con gli amici.</p> |
| | summary | | string | <p>Scoprite il nostro abito blusa senza maniche, un capo versatile che unisce eleganza e comfort. Questo abito aderente mette in mostra le spalle e valorizza la figura grazie alla sua perfetta vestibilità. Grazie al suo tessuto antipiega, sarà perfetto da mattina a sera.</p> |
| | title | | string | Abito blusa Élégance Urbaine - Vestibilità perfetta e comfort assoluto |
| | usageinstructions | | string | <p>Per una vestibilità ottimale, scegliete la vostra taglia abituale: la vestibilità slim valorizzerà naturalmente la vostra figura senza comprimere. L'allacciatura a bottoni permette di regolare la scollatura a piacimento. Per una silhouette più definita, aggiungete una cintura sottile in vita. Questo abito è progettato per essere comodo tutto il giorno, dall'ufficio alle uscite serali, senza sgualcirsi anche dopo lunghe ore di seduta.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Machinewas op 30°C aanbevolen</li>
<li>Fijnwasprogramma met laag centrifugeren</li>
<li>Aan de lucht drogen om de kwaliteit van de stof te behouden</li>
<li>Strijken is niet nodig dankzij kreukherstellende stof</li>
<li>Indien nodig, strijken op lage temperatuur</li>
</ul> |
| | description | | string | <p>Deze mouwloze blousejurk vormt de perfecte balans tussen tijdloze elegantie en moderne functionaliteit. De slanke pasvorm is speciaal ontworpen om de natuurlijke rondingen van je figuur te benadrukken, waardoor er een harmonieuze, flatterende lijn ontstaat zonder een scherend effect.<br>De doorlopende knoopsluiting geeft je unieke flexibiliteit: draag hem volledig gesloten voor een verfijnde look, of gedeeltelijk opengeknoopt voor een meer ontspannen stijl. Hierdoor kun je het kledingstuk perfect aanpassen aan je lichaamsvorm.<br>Het mouwloze ontwerp omsluit je schouders zachtjes en biedt veel bewegingsvrijheid, ideaal voor zowel actieve dagen als elegante avondjes uit. Het silhouet is perfect in balans, met speciale aandacht voor proporties om een harmonieus visueel effect te creëren.<br>Deze jurk is gemaakt van een hoogwaardige 100% polyester stof en combineert duurzaamheid met onderhoudsgemak. De kreukherstellende eigenschappen zijn bijzonder handig om er de hele dag onberispelijk uit te blijven zien, zelfs als je onderweg bent.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/sexy-outfit-zwart/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Slanke pasvorm voor een elegant silhouet</li>
<li>Volledige knoopsluiting voor een stijl die naar wens kan worden aangepast</li>
<li>100% polyester kreukherstellende stof voor de hele dag comfort</li>
<li>Mouwloos ontwerp accentueert subtiel je schouders</li>
<li>Uitzonderlijke veelzijdigheid: kan alleen of over een broek worden gedragen</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ontdek onze grote maat mouwloze blousejurk met slanke pasvorm en kreukvrije stof. Elegantie en comfort voor elk figuur. Gratis levering! |
| | keywords | | | title | | string | Grote Mouwloze Geplooide Blouse Jurk | Diva's Boudoir |
|
| | seotitle | | string | Grote maat mouwloze blousejurk met knoopsluiting |
| | seouri | | | specifications | | string | <ul>
<li>Samenstelling: 100% kreukvrij polyester</li>
<li>Stijl: Aansluitende mouwloze blousejurk</li>
<li>Sluiting: knoopsluiting over de hele lengte</li>
<li>Snit: In de taille geknoopt om het silhouet op natuurlijke wijze te accentueren, zonder scheringeffect</li>
<li>Lengte: Midi</li>
<li>Kleur: Elegant zwart</li>
</ul> |
| | stylingtips | | string | <p>Voor een elegante kantoorlook draag je deze blousejurk met pumps met middelhoge hakken en discrete accessoires. Voor een meer casual look combineer je hem met platte sandalen en een schoudertas. Voor de avond draag je hem over een slanke zwarte broek en voeg je opvallende sieraden toe voor een eigentijdse stijl. Voor koelere dagen maak je het af met een gestructureerde blazer of lang vest. Dit veelzijdige stuk is perfect voor elke gelegenheid, van een dag op kantoor tot een etentje met vrienden.</p> |
| | summary | | string | <p>Ontdek onze mouwloze blousejurk, een veelzijdig stuk dat elegantie en comfort combineert. Deze nauwsluitende jurk pronkt met je schouders en laat je figuur beter uitkomen dankzij de perfecte pasvorm. Dankzij de kreukvrije stof zie je er van 's ochtends vroeg tot 's avonds laat geweldig uit.</p> |
| | title | | string | Élégance Urbaine blousejurk - Flatterende pasvorm en absoluut comfort |
| | usageinstructions | | string | <p>Voor de beste pasvorm kies je je gebruikelijke maat - de slanke pasvorm verbetert je figuur op natuurlijke wijze zonder compressie. Met de volledige knoopsluiting kun je de halslijn naar wens aanpassen. Voor een meer gedefinieerd silhouet voeg je een smalle riem toe in de taille. Deze jurk is ontworpen om de hele dag comfortabel te zitten, van kantoor tot een avondje uit, zonder te kreuken, zelfs na lang zitten.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Recomenda-se a lavagem na máquina a 30°C</li>
<li>Programa delicado com centrifugação baixa</li>
<li>Secagem ao ar para preservar a qualidade do tecido</li>
<li>Não é necessário passar a ferro graças ao tecido resistente aos vincos</li>
<li>Se necessário, passar a ferro a baixa temperatura</li>
</ul> |
| | description | | string | <p>Este vestido blusa sem mangas atinge o equilíbrio perfeito entre elegância intemporal e praticidade moderna. O seu corte justo foi especialmente concebido para realçar as curvas naturais da sua figura, criando uma linha harmoniosa e lisonjeira sem um efeito de bainha.<br>O abotoamento a todo o comprimento dá-lhe uma flexibilidade única: use-o totalmente fechado para um look sofisticado ou parcialmente desabotoado para um estilo mais descontraído. Esta caraterística permite-lhe também ajustar a peça de vestuário perfeitamente à forma do seu corpo.<br>O design sem mangas aconchega suavemente os seus ombros, oferecendo ao mesmo tempo uma grande liberdade de movimentos, ideal tanto para dias activos como para noites elegantes. A silhueta é perfeitamente equilibrada, com especial atenção às proporções para criar um efeito visual harmonioso.<br>Fabricado num tecido 100% poliéster de alta qualidade, este vestido combina durabilidade e facilidade de manutenção. As suas propriedades de resistência aos vincos são particularmente úteis para manter um look impecável durante todo o dia, mesmo quando está em movimento.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/vestido-sexy-preto/cdbu6307.htm |
| | highlights | | string | <ul>
<li>Ajuste fino para uma silhueta elegante</li>
<li>Totalmente abotoado para um estilo que pode ser ajustado à sua medida</li>
<li>Tecido 100% poliéster resistente a vincos para conforto durante todo o dia</li>
<li>O design sem mangas acentua delicadamente os seus ombros</li>
<li>Versatilidade excecional: pode ser usado sozinho ou por cima de calças</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra o nosso vestido blusa grande sem mangas com um corte justo e tecido resistente aos vincos. Elegância e conforto para todas as silhuetas. Entrega gratuita! |
| | keywords | | | title | | string | Vestido grande com blusa plissada e sem mangas | Diva's Boudoir |
|
| | seotitle | | string | Vestido blusa grande sem mangas e com botões à frente |
| | seouri | | | specifications | | string | <ul>
<li>Composição: 100% poliéster resistente aos vincos</li>
<li>Estilo: Vestido com blusa sem mangas e justo</li>
<li>Aperto: Aperto de botão a todo o comprimento</li>
<li>Corte: Cintura cingida para realçar naturalmente a silhueta, sem efeito de bainha</li>
<li>Comprimento: Midi</li>
<li>Cor: Preto elegante</li>
</ul> |
| | stylingtips | | string | <p>Para um look de escritório elegante, use este vestido blusa com sapatos de salto médio e acessórios discretos. Para um look mais casual, combine-o com sandálias rasas e uma mala a tiracolo. Para a noite, vista-o por cima de calças pretas justas e adicione jóias de destaque para um estilo contemporâneo. Para os dias mais frios, complete com um blazer estruturado ou um casaco de malha comprido. Esta peça versátil é perfeita para qualquer ocasião, desde um dia no escritório a um jantar com amigos.</p> |
| | summary | | string | <p>Descubra o nosso vestido blusa sem mangas, uma peça versátil que alia elegância e conforto. Este vestido de corte justo deixa os seus ombros à mostra e realça a sua figura graças ao seu ajuste perfeito. O seu tecido resistente aos vincos permite-lhe ter um ótimo aspeto de manhã à noite.</p> |
| | title | | string | Vestido com blusa Élégance Urbaine - Ajuste lisonjeiro e conforto absoluto |
| | usageinstructions | | string | <p>Para um melhor ajuste, escolha o seu tamanho habitual - o ajuste fino realçará naturalmente a sua figura sem compressão. O fecho completo com botões permite-lhe ajustar o decote de acordo com a sua preferência. Para uma silhueta mais definida, adicione um cinto fino na cintura. Este vestido foi concebido para ser confortável durante todo o dia, desde o escritório até às saídas à noite, sem vincos mesmo após longas horas sentada.</p> |
|
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 32529E83-F60F-44C6-AF1FAE0590320C7B |
|
| promountil | |
| rating | |
| recorduid | | string | 32529E83-F60F-44C6-AF1FAE0590320C7B |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.34 ms Record Count: 4 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,'2334,2335,2336,2337') > 0 and product_variations.productuid = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 | 2334 | XL | intlsize | black | XL | XL | -1 | 999999 | 0 | w | plus | dress | 0XL | XL | | 42 | 12 | 16 | 44 | 44 | 42 | 48 | 44 | 42 | 100-107 | 79-86 | 105-112 | | | | | | | | 2 | 2335 | 1X | intlsize | black | 1X | 1X | -1 | 999999 | 0 | w | plus | dress | 1XL | 1X | | 44 | 14 | 18 | 46 | 46 | 44 | 50 | 46 | 44 | 107-114 | 86-93 | 112-119 | | | | | | | | 3 | 2336 | 2XL | intlsize | black | 2XL | 2XL | -1 | 999999 | 0 | w | plus | dress | 2XL | 2XL | | 46 | 16 | 20 | 48 | 48 | 46 | 52 | 48 | 46 | 114-121 | 93-100 | 119-126 | | | | | | | | 4 | 2337 | 3X | intlsize | black | 3X | 3X | -1 | 999999 | 0 | w | plus | dress | 3XL | 3X | | 48 | 18 | 22 | 50 | 50 | 48 | 54 | 50 | 48 | 121-128 | 100-107 | 126-133 | | | | | | |
|
| sizeranges | |
| sizes | | string | 2334,2335,2336,2337 |
|
| 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: 5.38 ms Record Count: 4 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2334 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2335 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2336 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2337 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 | 32529E83-F60F-44C6-AF1FAE0590320C7B | 404F398E-E2D4-4E85-A01F8CADEA95FE34 | 2334 | black | #000000 | 0XL | XL | | 42 | 12 | 16 | 44 | 44 | 42 | 48 | 44 | 42 | w | dress | | XL | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | YML58853 | 2FRM33J0917972117 | -1 | 0 | all | | | 2 | 32529E83-F60F-44C6-AF1FAE0590320C7B | 2951D02B-F664-436B-9CDB2E415EEF9C78 | 2335 | black | #000000 | 1XL | 1X | | 44 | 14 | 18 | 46 | 46 | 44 | 50 | 46 | 44 | w | dress | | 1X | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | YML58853 | 2G2Z69Z0917972087 | -1 | 0 | all | | | 3 | 32529E83-F60F-44C6-AF1FAE0590320C7B | D76C86FF-6E44-4122-9C7FA27A3F0D9184 | 2336 | black | #000000 | 2XL | 2XL | | 46 | 16 | 20 | 48 | 48 | 46 | 52 | 48 | 46 | w | dress | | 2XL | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 5 | 0 | 0 | YML58853 | 2FRM33J0917972077 | -1 | 0 | all | | | 4 | 32529E83-F60F-44C6-AF1FAE0590320C7B | 1229EE73-996D-4559-80FDA013D8F1BD90 | 2337 | black | #000000 | 3XL | 3X | | 48 | 18 | 22 | 50 | 50 | 48 | 54 | 50 | 48 | w | dress | | 3X | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | YML58853 | 2GHGFOE0917972097 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 7.42 ms Record Count: 4 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2334 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2335 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2336 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' 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 = '32529E83-F60F-44C6-AF1FAE0590320C7B' and product_variations.isactive = 1 and product_sizes.id_size = 2337 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 | 404F398E-E2D4-4E85-A01F8CADEA95FE34 | 2334 | black | #000000 | 0XL | XL | | 42 | 12 | 16 | 44 | 44 | 42 | 48 | 44 | 42 | w | dress | | XL | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | YML58853 | 2FRM33J0917972117 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 29.125 | all | | | 2 | 2951D02B-F664-436B-9CDB2E415EEF9C78 | 2335 | black | #000000 | 1XL | 1X | | 44 | 14 | 18 | 46 | 46 | 44 | 50 | 46 | 44 | w | dress | | 1X | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | YML58853 | 2G2Z69Z0917972087 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 29.125 | all | | | 3 | D76C86FF-6E44-4122-9C7FA27A3F0D9184 | 2336 | black | #000000 | 2XL | 2XL | | 46 | 16 | 20 | 48 | 48 | 46 | 52 | 48 | 46 | w | dress | | 2XL | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 5 | 0 | 0 | YML58853 | 2FRM33J0917972077 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 29.125 | all | | | 4 | 1229EE73-996D-4559-80FDA013D8F1BD90 | 2337 | black | #000000 | 3XL | 3X | | 48 | 18 | 22 | 50 | 50 | 48 | 54 | 50 | 48 | w | dress | | 3X | intlsize | 29.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | YML58853 | 2GHGFOE0917972097 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 29.125 | all | |
|
| vatrate | |
| warehouse | |