Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | | string | divasboudoir,smboudoir |
|
| 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,divasboudoir.lingerie.sexylingerie.babydoll |
|
| 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.773 ms Record Count: 2 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black,red') > 0 and product_variations.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 | 1 | | 2 | red | color | red | red | red | #F50000 | -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 '2024-10-11 18:53:26'} |
|
| 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-08-01 16:55:35'} |
|
| 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','nl') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('c74b0521-2498-4c95-adf7d85a1754da3e',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.29 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','nl') and product_categories.language in ('all','nl') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'SFBA4638' 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/puun/sfba4638/task-31512984-2-1.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sfba4638/30895705.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sfba4638/30895705.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sfba4638/30895584.jpg |
| | type | | | width | |
| | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sfba4638/task-31512984-2-1.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 | | | description | | string | Kleid Adeline<br /><br />Skaterschnitt, Reißverschluss vorne, um mit den Nerven Ihres Partners zu spielen.<br /><br />Anpassung hinter dem Nacken.<br /><br />Abnehmbare Strumpfbänder unter dem Rock platziert, die Sie leicht verstellen oder entfernen können. |
| | guid | | string | https://dev.divasboudoir.com/de/kleid-in-ubergrosse-adeline-schwarz-ou-rot/sfba4638.htm |
| | highlights | | string | <ul>
<li>Durchgehender Frontreißverschluss für ein progressives und fesselndes Spiel der Verführung</li>
<li>Schmeichelnder Patinaschnitt, der Ihre Silhouette mit Eleganz und Bewegung betont</li>
<li>Transparente Spitzeneinsätze an den Seiten, die einen sinnlichen Kontrast zum Kunstleder bilden</li>
<li>Abnehmbare und verstellbare Strumpfbänder, die unter dem Rock versteckt sind, für einen zusätzlichen verführerischen Touch</li>
<li>Hinter dem Nacken anpassbar für einen perfekten Sitz und ein makelloses Dekolleté</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Entdecken Sie das Kleid Adeline von Diva's Boudoir, dem Spezialisten für sexy Lingerie in großen Größen. Schneller und kostenloser Versand. Französische Boutique. |
| | keywords | | | title | | string | Kleid in Übergröße Adeline - Kostenloser Schnellversand |
|
| | seotitle | | string | Kleid in Übergröße Adeline |
| | seouri | | string | kleid-in-ubergrosse-adeline-schwarz-ou-rot |
| | specifications | | string | <ul>
<li>Zusammensetzung: Hochwertiges Kunstleder und transparente Spitze</li>
<li>Style: Skaterkleid mit durchgehendem Frontreißverschluss</li>
<li>Ausschnitt: Verstellbar mit Befestigung hinter dem Nacken</li>
<li>Unterscheidende Details: Einsätze aus transparenter Spitze, dekorativer Reißverschluss, abnehmbare Strumpfbänder</li>
<li>Länge: Mitte Oberschenkel mit ausgestelltem Rock</li>
<li>Farbe: Tiefschwarz mit Glanzeffekt</li>
<li>Inklusive Zubehör: Abnehmbare und verstellbare Strumpfbänder</li>
</ul> |
| | stylingtips | | string | <p>Für einen Abend zu zweit kombinieren Sie dieses Kleid mit Netzstrümpfen und hochhackigen Pumps, um einen ausgesprochen sinnlichen Look zu erzielen. Minimalistischer Silberschmuck ist eine perfekte Ergänzung zum glänzenden Kunstleder. Für einen zusätzlichen Hauch von Kühnheit entscheiden Sie sich für Strümpfe mit Rückennaht, die die Aufmerksamkeit auf Ihre Beine und die Strumpfbänder lenken. Was die Frisur angeht: Leicht gewelltes Haar, das über die Schultern fällt, oder ein unstrukturierter Dutt betonen den Ansatz hinter dem Nacken. Ein Lippenstift in tiefen Rottönen verleiht diesem aufregenden Look den letzten Schliff und bildet einen starken Kontrast zum intensiven Schwarz des Kleides.</p> |
| | summary | | string | Hübsche Mischung aus elastischem Kunstleder und Netzstoff mit Blumenmuster. |
| | title | | | usageinstructions | | string | <p>Für eine optimale Passform schließen Sie zunächst den Reißverschluss vollständig, bevor Sie das Kleid anziehen. Befestigen Sie dann den Riemen hinter dem Nacken und passen Sie ihn je nach Ihrer Vorliebe für ein mehr oder weniger ausgeprägtes Dekolleté an.</p>
<p>Die Strumpfbänder sind so konzipiert, dass sie sich leicht verstellen lassen - befestigen Sie sie an Ihren Strümpfen, bevor Sie sie unter dem Rock befestigen, um es einfacher zu machen. Um ein fesselndes Spiel der Verführung zu schaffen, lassen Sie Ihre Partnerin den Reißverschluss und seine Funktionsweise nach und nach entdecken.</p>
<p>Das Kleid ist so konzipiert, dass es je nach Vorliebe mit oder ohne Unterwäsche getragen werden kann, wobei das Innenfutter in jedem Fall für einen optimalen Tragekomfort sorgt.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Φόρεμα Adeline<br /><br />Κοπή skater, μπροστινό φερμουάρ για να παίζετε με τα νεύρα του συντρόφου σας.<br /><br />Ρυθμιζόμενο πίσω από το λαιμό.<br /><br />Αποσπώμενες καλτσοδέτες κάτω από τη φούστα για εύκολη ρύθμιση και αφαίρεση. |
| | guid | | string | https://dev.divasboudoir.com/el/adeline-plus-size-forema-mayro-ou-kokkino/sfba4638.htm |
| | highlights | | string | <ul>
<li>Πλήρες φερμουάρ μπροστά για ένα προοδευτικό και σαγηνευτικό παιχνίδι αποπλάνησης</li>
<li>Κολακευτικό skater κόψιμο που αναδεικνύει τη σιλουέτα σας με κομψότητα και κίνηση</li>
<li>Διαφανή δαντελένια ένθετα στα πλάγια δημιουργούν μια αισθησιακή αντίθεση με το faux leather</li>
<li>Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες κρυμμένες κάτω από τη φούστα για μια επιπλέον σαγηνευτική πινελιά</li>
<li>Ρύθμιση πίσω από το λαιμό για τέλεια στήριξη και ντεκολτέ</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ανακαλύψτε το φόρεμα Adeline από το Diva's Boudoir, τον ειδικό στα σέξι εσώρουχα για μεγάλα μεγέθη. Δωρεάν γρήγορη παράδοση. Γαλλικό κατάστημα. |
| | keywords | | | title | | string | Adeline plus size φόρεμα - Δωρεάν γρήγορη αποστολή |
|
| | seotitle | | string | Adeline plus size φόρεμα |
| | seouri | | string | adeline-plus-size-forema-mayro-ou-kokkino |
| | specifications | | string | <ul>
<li>Σύνθεση: Υψηλής ποιότητας ψεύτικο δέρμα και διάφανη δαντέλα</li>
<li>Στυλ: Φόρεμα skater με φερμουάρ μπροστά</li>
<li>Λαιμόκοψη: Ρυθμιζόμενο με δέσιμο στο πίσω μέρος του λαιμού</li>
<li>Διακριτικά χαρακτηριστικά: Διαφανή δαντελένια ένθετα, διακοσμητικό φερμουάρ, αποσπώμενες καλτσοδέτες</li>
<li>Μήκος: Μέσο του μηρού με φουσκωτή φούστα</li>
<li>Χρώμα: βαθύ μαύρο με γυαλιστερό εφέ</li>
<li>Περιλαμβάνονται αξεσουάρ: Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες</li>
</ul> |
| | stylingtips | | string | <p>Για μια βραδινή έξοδο, συνδυάστε αυτό το φόρεμα με διχτυωτές κάλτσες και ψηλοτάκουνες γόβες για μια άκρως αισθησιακή εμφάνιση. Τα μινιμαλιστικά ασημένια κοσμήματα θα συμπληρώσουν τέλεια τη γυαλιστερή όψη του faux leather. Για μια έξτρα πινελιά τόλμης, επιλέξτε κάλτσες με ραφές στο πίσω μέρος για να τραβήξετε την προσοχή στα πόδια και τις καλτσοδέτες σας. Όσον αφορά το χτένισμά σας, τα ελαφρώς κυματιστά μαλλιά που πέφτουν στους ώμους σας ή ένας αδόμητος κότσος θα αναδείξουν τη γραβάτα στο πίσω μέρος του λαιμού σας. Ένα βαθύ κόκκινο κραγιόν θα δώσει την τελευταία πινελιά σε αυτή τη σαγηνευτική εμφάνιση, δημιουργώντας μια εντυπωσιακή αντίθεση με το έντονο μαύρο του φορέματος.</p> |
| | summary | | string | Υπέροχο μείγμα από ελαστικό faux δέρμα και φλοράλ διχτυωτό ύφασμα. |
| | title | | | usageinstructions | | string | <p>Για καλύτερη εφαρμογή, κλείστε το φόρεμα με φερμουάρ μέχρι πάνω πριν το φορέσετε και, στη συνέχεια, κλείστε το λουρί πίσω από το λαιμό, ρυθμίζοντας το για περισσότερο ή λιγότερο ντεκολτέ.</p>
<p>Οι καλτσοδέτες έχουν σχεδιαστεί για να ρυθμίζονται εύκολα - συνδέστε τις στις κάλτσες σας πριν τις στερεώσετε κάτω από τη φούστα για ευκολία. Για να δημιουργήσετε ένα σαγηνευτικό παιχνίδι αποπλάνησης, αφήστε τη σύντροφό σας να ανακαλύψει σταδιακά το φερμουάρ και τον τρόπο λειτουργίας του.</p>
<p>Το φόρεμα έχει σχεδιαστεί για να φοριέται με ή χωρίς εσώρουχα, ανάλογα με τις προτιμήσεις σας, με την εσωτερική επένδυση να εξασφαλίζει βέλτιστη άνεση σε κάθε περίπτωση.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Adeline dress<br /><br />Skater cut, front zipper to play with your partner's nerves.<br /><br />Behind-the-neck adjustment.<br /><br />Detachable garters under the skirt for easy adjustment and removal. |
| | guid | | string | https://dev.divasboudoir.com/en/adeline-plus-size-dress-black-ou-red/sfba4638.htm |
| | highlights | | string | <ul>
<li>Full front zipper for a progressive and captivating game of seduction</li>
<li>Flattering skater cut that enhances your silhouette with elegance and movement</li>
<li>Sheer lace inserts on sides create a sensual contrast with faux leather</li>
<li>Detachable, adjustable garters concealed under the skirt for an extra touch of seduction</li>
<li>Behind-the-neck adjustment guarantees perfect support and impeccable décolleté</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Discover the Adeline dress from Diva's Boudoir, the specialist in sexy plus size lingerie. Fast, free shipping. French boutique. |
| | keywords | | | title | | string | Adeline plus size dress - Free fast shipping |
|
| | seotitle | | string | Adeline plus size dress |
| | seouri | | string | adeline-plus-size-dress-black-ou-red |
| | specifications | | string | <ul>
<li>Composition: High-quality faux leather and sheer lace</li>
<li>Style: Skater dress with full front zipper</li>
<li>Neckline: Adjustable with tie at back of neck</li>
<li>Distinctive details: Sheer lace inserts, decorative zipper, detachable garters</li>
<li>Length: Mid-thigh with flared skirt</li>
<li>Color: deep black with shiny effect</li>
<li>Accessories included: Detachable and adjustable garters</li>
</ul> |
| | stylingtips | | string | <p>For an evening tête-à-tête, pair this dress with fishnet stockings and high-heeled pumps for a resolutely sensual look. Minimalist silver jewelry perfectly complements the shiny look of faux leather. For an extra touch of daring, opt for back-seamed stockings that will draw attention to your legs and garters. As for your hairstyle, lightly waved shoulder-length hair or an unstructured chignon will highlight the tie at the nape of your neck. Deep red lipstick adds the finishing touch to this captivating look, creating a striking contrast with the intense black of the dress.</p> |
| | summary | | string | Lovely mix of elastic faux leather and floral-print fishnet. |
| | title | | | usageinstructions | | string | <p>For optimum fit, first zip up fully before putting on the dress, then fasten the strap behind the neck, adjusting according to your preference for more or less neckline.</p>
<p>The garters are designed to be easily adjustable - attach them to your stockings before fastening them under the skirt for ease. To create a captivating game of seduction, let your partner gradually discover the zipper and how it works.</p>
<p>The dress is designed to be worn with or without underwear, depending on your preference, with the inner lining ensuring optimum comfort either way.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Vestido Adeline<br /><br />Corte skater, cremallera delantera para jugar con los nervios de tu pareja.<br /><br />Ajustable detrás del cuello.<br /><br />Ligueros desmontables bajo la falda para ajustar y quitar fácilmente. |
| | guid | | string | https://dev.divasboudoir.com/es/vestido-talla-grande-adeline-negro-ou-rojo/sfba4638.htm |
| | highlights | | string | <ul>
<li>Cremallera frontal completa para un juego de seducción progresivo y cautivador</li>
<li>Favorecedor corte skater que realza tu figura con elegancia y movimiento</li>
<li>Inserciones de encaje transparente en los laterales que crean un sensual contraste con la piel sintética</li>
<li>Ligueros desmontables y ajustables ocultos bajo la falda para un toque extra de seducción</li>
<li>Ajuste detrás del cuello para una sujeción y un escote perfectos</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubre el vestido Adeline de Diva's Boudoir, la especialista en lencería sexy de talla grande. Entrega rápida y gratuita. Tienda francesa. |
| | keywords | | | title | | string | Vestido talla grande Adeline - Envío rápido gratuito |
|
| | seotitle | | string | Vestido talla grande Adeline |
| | seouri | | string | vestido-talla-grande-adeline-negro-ou-rojo |
| | specifications | | string | <ul>
<li>Composición: Piel sintética de alta calidad y encaje transparente</li>
<li>Estilo: Vestido skater con cremallera frontal completa</li>
<li>Escote: Ajustable con lazo en la nuca</li>
<li>Características distintivas: Inserciones de encaje transparente, cremallera decorativa, ligueros desmontables</li>
<li>Largo: Medio muslo con falda acampanada</li>
<li>Color: negro intenso con efecto brillante</li>
<li>Accesorios incluidos: Ligas desmontables y ajustables</li>
</ul> |
| | stylingtips | | string | <p>Para salir por la noche, combina este vestido con medias de rejilla y zapatos de tacón para conseguir un look decididamente sensual. Las joyas plateadas minimalistas complementarán a la perfección el aspecto brillante de la piel sintética. Para un toque extra de atrevimiento, opta por unas medias con costuras traseras para llamar la atención sobre tus piernas y tus ligueros. En cuanto al peinado, una melena ligeramente ondulada que caiga hasta los hombros o un moño desestructurado resaltarán el lazo en la nuca. Un pintalabios rojo intenso dará el toque final a este look cautivador, creando un llamativo contraste con el negro intenso del vestido.</p> |
| | summary | | string | Encantadora mezcla de piel sintética elástica y rejilla floral. |
| | title | | | usageinstructions | | string | <p>Para un ajuste óptimo, suba la cremallera del vestido antes de ponérselo y, a continuación, abroche el tirante por detrás del cuello, ajustándolo para tener más o menos escote.</p>
<p>Los ligueros se han diseñado para que puedan ajustarse fácilmente: sujételos a las medias antes de abrocharlos bajo la falda para mayor facilidad. Para crear un cautivador juego de seducción, deja que tu pareja descubra poco a poco la cremallera y su funcionamiento.</p>
<p>El vestido está diseñado para llevarlo con o sin ropa interior, según sus preferencias, y el forro interior garantiza una comodidad óptima en ambos casos.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>La robe <strong>Adeline</strong> incarne l'équilibre parfait entre audace et sophistication. Sa silhouette patineuse soigneusement étudiée met en valeur vos courbes avec élégance, tandis que la jupe évasée apporte mouvement et dynamisme à chacun de vos pas, créant une allure captivante qui ne manquera pas d'attirer tous les regards.</p>
<p><br>L'élément signature de cette création est sans conteste sa <strong>fermeture éclair intégrale à l'avant</strong>. Ce détail aussi fonctionnel que provocant vous permet de contrôler le rythme de la séduction, dévoilant progressivement votre silhouette selon vos envies. Un véritable jeu de patience qui saura faire monter la tension et l'anticipation chez votre partenaire.</p>
<p><br>Les empiècements en dentelle transparente positionnés stratégiquement sur les côtés créent un contraste saisissant avec le similicuir brillant. Cette dualité entre opacité et transparence ajoute une dimension visuelle fascinante à l'ensemble, tout en laissant entrevoir subtilement votre peau pour un effet résolument sensuel.</p>
<p><br>L'attache derrière la nuque assure un ajustement personnalisé et un maintien optimal du décolleté, vous permettant de vous sentir à la fois séduisante et parfaitement à l'aise. Ce système d'attache soigneusement conçu garantit que la robe épouse parfaitement votre silhouette tout au long de la soirée.</p>
<p><br>Pour compléter cette création déjà remarquable, des <strong>jarretières détachables</strong> sont discrètement intégrées sous la jupe. Entièrement réglables, elles vous permettent d'accessoiriser votre tenue avec des bas pour une touche de séduction supplémentaire, ou de les retirer facilement selon vos préférences et l'occasion.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/grande-taille-robe-patineuse-similicuir-zip-integral/sfba4638.htm |
| | highlights | | string | <ul>
<li>Fermeture éclair intégrale à l'avant pour un jeu de séduction progressif et captivant</li>
<li>Coupe patineuse flatteuse qui sublime votre silhouette avec élégance et mouvement</li>
<li>Empiècements en dentelle transparente sur les côtés créant un contraste sensuel avec le similicuir</li>
<li>Jarretières détachables et réglables dissimulées sous la jupe pour une touche de séduction supplémentaire</li>
<li>Ajustement derrière la nuque garantissant un maintien parfait et un décolleté impeccable</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Découvrez la robe Adeline de chez Diva's Boudoir, le spécialiste en lingerie sexy grande taille. Envoi rapide et offert. Boutique française. |
| | keywords | | | title | | string | Robe grande taille Adeline - Envoi rapide gratuit |
|
| | seotitle | | string | Robe grande taille patineuse en similicuir zip intégral |
| | seouri | | string | grande-taille-robe-patineuse-similicuir-zip-integral |
| | specifications | | string | <ul>
<li>Composition : Similicuir haute qualité et dentelle transparente</li>
<li>Style : Robe patineuse avec fermeture éclair frontale intégrale</li>
<li>Encolure : Ajustable avec attache derrière la nuque</li>
<li>Détails distinctifs : Empiècements en dentelle transparente, fermeture éclair décorative, jarretières détachables</li>
<li>Longueur : Mi-cuisse avec jupe évasée</li>
<li>Couleur : noir intense avec effet brillant</li>
<li>Accessoires inclus : Jarretières détachables et réglables</li>
</ul> |
| | stylingtips | | string | <p>Pour une soirée en tête-à-tête, associez cette robe avec des bas résille et des escarpins à talons hauts pour un look résolument sensuel. Des bijoux minimalistes en argent compléteront parfaitement l'aspect brillant du similicuir. Pour une touche d'audace supplémentaire, optez pour des bas avec couture arrière qui attireront l'attention sur vos jambes et les jarretières. Côté coiffure, des cheveux légèrement ondulés tombant sur les épaules ou un chignon déstructuré mettront en valeur l'attache derrière la nuque. Un rouge à lèvres dans les tons rouges profonds apportera la touche finale à ce look captivant, créant un contraste saisissant avec le noir intense de la robe.</p> |
| | summary | | string | <p>Succombez au charme irrésistible de notre robe Adeline, une création aussi audacieuse que séduisante. Sa coupe patineuse met en valeur votre silhouette, tandis que sa fermeture éclair intégrale à l'avant promet des moments de séduction intense. Avec ses empiècements en dentelle transparente et ses jarretières détachables, cette robe incarne l'alliance parfaite entre élégance et sensualité provocante.</p> |
| | title | | string | Robe Adeline Désir - Sensualité audacieuse et jeu de séduction |
| | usageinstructions | | string | <p>Pour un ajustement optimal, commencez par fermer complètement la fermeture éclair avant d'enfiler la robe, puis attachez la bride derrière la nuque en ajustant selon votre préférence pour un décolleté plus ou moins prononcé.</p>
<p>Les jarretières sont conçues pour être facilement réglables - fixez-les à vos bas avant de les attacher sous la jupe pour plus de facilité. Pour créer un jeu de séduction captivant, laissez votre partenaire découvrir progressivement la fermeture éclair et son fonctionnement.</p>
<p>La robe est conçue pour être portée avec ou sans sous-vêtements selon votre préférence, la doublure intérieure assurant un confort optimal dans tous les cas.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Abito Adeline<br /><br />Taglio skater, zip frontale per giocare con i nervi del partner.<br /><br />Regolabile dietro il collo.<br /><br />Giarrettiere staccabili sotto la gonna per una facile regolazione e rimozione. |
| | guid | | string | https://dev.divasboudoir.com/it/abito-adeline-taglia-grande-nero-ou-rosso/sfba4638.htm |
| | highlights | | string | <ul>
<li>Zip frontale completa per un gioco di seduzione progressivo e accattivante</li>
<li>Taglio skater lusinghiero che esalta la figura con eleganza e movimento</li>
<li>Gli inserti in pizzo trasparente sui lati creano un contrasto sensuale con l'ecopelle</li>
<li>Giarrettiere staccabili e regolabili nascoste sotto la gonna per un tocco di seduzione in più</li>
<li>Regolazione dietro il collo per un sostegno e una scollatura perfetti</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Scoprite l'abito Adeline da Diva's Boudoir, lo specialista della lingerie sexy per taglie grandi. Consegna rapida e gratuita. Negozio francese. |
| | keywords | | | title | | string | Abito Adeline taglia grande - Spedizione veloce e gratuita |
|
| | seotitle | | string | Abito Adeline taglia grande |
| | seouri | | string | abito-adeline-taglia-grande-nero-ou-rosso |
| | specifications | | string | <ul>
<li>Composizione: Ecopelle di alta qualità e pizzo trasparente</li>
<li>Stile: abito skater con zip frontale completa</li>
<li>Scollatura: regolabile con laccetto dietro il collo</li>
<li>Caratteristiche distintive: inserti in pizzo trasparente, cerniera decorativa, giarrettiere staccabili</li>
<li>Lunghezza: metà coscia con gonna svasata</li>
<li>Colore: nero intenso con effetto lucido</li>
<li>Accessori inclusi: giarrettiere staccabili e regolabili</li>
</ul> |
| | stylingtips | | string | <p>Per una serata fuori, abbinate questo abito a calze a rete e a décolleté con tacco alto per un look decisamente sensuale. Gioielli minimalisti in argento completeranno perfettamente l'aspetto lucido dell'ecopelle. Per un tocco di audacia in più, optate per calze con cuciture posteriori per attirare l'attenzione sulle gambe e sulle giarrettiere. Per quanto riguarda l'acconciatura, i capelli leggermente mossi che cadono sulle spalle o uno chignon non strutturato metteranno in risalto la cravatta sulla nuca. Un rossetto rosso intenso darà il tocco finale a questo look accattivante, creando un contrasto sorprendente con il nero intenso dell'abito.</p> |
| | summary | | string | Un bel mix di ecopelle elasticizzata e rete floreale. |
| | title | | | usageinstructions | | string | <p>Per una vestibilità ottimale, chiudere l'abito con la cerniera fino in fondo prima di indossarlo, quindi allacciare il cinturino dietro il collo, regolando per una maggiore o minore scollatura.</p>
<p>Le giarrettiere sono state progettate per essere facilmente regolabili: fissatele alle calze prima di allacciarle sotto la gonna. Per creare un accattivante gioco di seduzione, lasciate che il vostro partner scopra gradualmente la cerniera e il suo funzionamento.</p>
<p>L'abito è progettato per essere indossato con o senza biancheria intima, a seconda delle preferenze, e la fodera interna garantisce un comfort ottimale in entrambi i casi.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Adeline jurk<br /><br />Skater model, rits aan de voorkant om met de zenuwen van je partner te spelen.<br /><br />Verstelbaar achter de hals.<br /><br />Afneembare kousenbanden onder de rok voor eenvoudig verstellen en verwijderen. |
| | guid | | string | https://dev.divasboudoir.com/nl/adeline-jurk-grote-maat-zwart-ou-rood/sfba4638.htm |
| | highlights | | string | <ul>
<li>Volledige ritssluiting aan de voorkant voor een progressief en meeslepend verleidingsspel</li>
<li>Flatterende skater snit die je figuur met elegantie en beweging verbetert</li>
<li>Sheer kanten inzetstukken aan de zijkanten creëren een sensueel contrast met het kunstleer</li>
<li>Afneembare en verstelbare kousenbanden verborgen onder de rok voor een extra verleidelijke touch</li>
<li>Achter-de-hals aanpassing voor perfecte ondersteuning en decolleté</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ontdek de Adeline jurk van Diva's Boudoir, de specialist in sexy lingerie voor grote maten. Gratis snelle levering. Franse winkel. |
| | keywords | | | title | | string | Adeline jurk grote maat - Gratis snelle verzending |
|
| | seotitle | | string | Adeline jurk grote maat |
| | seouri | | string | adeline-jurk-grote-maat-zwart-ou-rood |
| | specifications | | string | <ul>
<li>Samenstelling: Hoogwaardig imitatieleer en transparante kant</li>
<li>Stijl: Skaterjurk met volledige ritssluiting aan de voorkant</li>
<li>Halslijn: Verstelbaar met striksluiting achter in de nek</li>
<li>Bijzondere kenmerken: inzetstukken van transparante kant, decoratieve ritssluiting, afneembare kousenbanden</li>
<li>Lengte: halverwege de dij met uitlopende rok</li>
<li>Kleur: diepzwart met glanzend effect</li>
<li>Inbegrepen accessoires: afneembare en verstelbare kousenbanden</li>
</ul> |
| | stylingtips | | string | <p>Voor een avondje uit combineer je deze jurk met netkousen en pumps met hoge hakken voor een uitgesproken sensuele look. Minimalistische zilveren sieraden vullen de glanzende look van het kunstleer perfect aan. Voor een extra vleugje durf kies je voor kousen met naden aan de achterkant om de aandacht te vestigen op je benen en kousenbanden. Wat je kapsel betreft, licht golvend haar dat op je schouders valt of een ongestructureerd knotje zal de das achter in je nek benadrukken. Een dieprode lippenstift maakt deze fascinerende look helemaal af en zorgt voor een opvallend contrast met het intense zwart van de jurk.</p> |
| | summary | | string | Mooie mix van stretch imitatieleer en gebloemd visnet. |
| | title | | | usageinstructions | | string | <p>Voor de beste pasvorm rits je de jurk helemaal dicht voordat je hem aantrekt en maak je het bandje achter de hals vast, waarbij je het verstelt voor meer of minder decolleté.</p>
<p>De kousenbanden zijn zo ontworpen dat ze gemakkelijk verstelbaar zijn - maak ze vast aan je kousen voordat je ze onder de rok vastmaakt voor meer gemak. Voor een boeiend verleidingsspel laat je je partner geleidelijk de ritssluiting ontdekken en hoe die werkt.</p>
<p>De jurk is ontworpen om met of zonder ondergoed gedragen te worden, afhankelijk van je voorkeur, waarbij de binnenvoering zorgt voor optimaal comfort.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Vestido Adeline<br /><br />Corte skater, fecho à frente para brincar com os nervos do seu parceiro.<br /><br />Ajustável atrás do pescoço.<br /><br />Ligas amovíveis por baixo da saia para ajustar e retirar facilmente. |
| | guid | | string | https://dev.divasboudoir.com/pt/vestido-adeline-plus-size-preto-ou-vermelho/sfba4638.htm |
| | highlights | | string | <ul>
<li>Fecho frontal completo para um jogo de sedução progressivo e cativante</li>
<li>Corte de skater lisonjeiro que realça a sua figura com elegância e movimento</li>
<li>As inserções de renda transparente nos lados criam um contraste sensual com a pele sintética</li>
<li>Ligas amovíveis e ajustáveis escondidas sob a saia para um toque extra sedutor</li>
<li>Ajuste atrás do pescoço para um apoio e decote perfeitos</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra o vestido Adeline da Diva's Boudoir, a especialista em lingerie sexy plus size. Entrega rápida e gratuita. Loja francesa. |
| | keywords | | | title | | string | Vestido Adeline plus size - Envio rápido e gratuito |
|
| | seotitle | | string | Vestido Adeline plus size |
| | seouri | | string | vestido-adeline-plus-size-preto-ou-vermelho |
| | specifications | | string | <ul>
<li>Composição: Pele sintética de alta qualidade e renda pura</li>
<li>Estilo: Vestido skater com fecho de correr à frente</li>
<li>Decote: Ajustável com laço na parte de trás do pescoço</li>
<li>Caraterísticas distintivas: Inserções de renda transparente, fecho de correr decorativo, ligas amovíveis</li>
<li>Comprimento: A meio da coxa com saia larga</li>
<li>Cor: preto profundo com efeito brilhante</li>
<li>Acessórios incluídos: Ligas amovíveis e ajustáveis</li>
</ul> |
| | stylingtips | | string | <p>Para uma saída à noite, combine este vestido com meias de rede e sapatos de salto alto para um visual resolutamente sensual. As jóias prateadas minimalistas complementarão na perfeição o aspeto brilhante da pele sintética. Para um toque extra de ousadia, opte por meias com costuras atrás para chamar a atenção para as suas pernas e ligas. Quanto ao seu penteado, um cabelo ligeiramente ondulado que caia até aos ombros ou um carrapito desestruturado irá realçar a gravata na parte de trás do seu pescoço. Um batom vermelho intenso dará o toque final a este look cativante, criando um contraste marcante com o preto intenso do vestido.</p> |
| | summary | | string | Uma mistura encantadora de pele sintética elástica e rede floral. |
| | title | | | usageinstructions | | string | <p>Para um melhor ajuste, feche o vestido até cima antes de o vestir e, em seguida, aperte a alça atrás do pescoço, ajustando para mais ou menos decote.</p>
<p>As ligas foram concebidas para serem facilmente ajustáveis - prenda-as às suas meias antes de as apertar por baixo da saia para maior facilidade. Para criar um jogo de sedução cativante, deixe o seu parceiro descobrir gradualmente o fecho e o seu funcionamento.</p>
<p>O vestido foi concebido para ser usado com ou sem roupa interior, dependendo da sua preferência, com o forro interior a garantir um conforto ótimo em qualquer dos casos.</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 | | string | Kleid Adeline aus Kunstleder und Netzgewebe.<br /><br />Skater-Schnitt, Reißverschluss an der Vorderseite, um mit den Nerven Ihres Partners zu spielen.<br /><br />Anpassung hinter dem Nacken.<br /><br />Abnehmbare Strumpfbänder unter dem Rock platziert, die Sie leicht verstellen oder entfernen können. |
| | highlights | | string | <ul>
<li>Durchgehender Frontreißverschluss für volle Kontrolle über das Tempo Ihrer Dominanzspiele</li>
<li>Schmeichelnder Skater-Schnitt, der Ihre Silhouette betont und gleichzeitig wesentliche Bewegungsfreiheit ermöglicht</li>
<li>Transparente Spitzeneinsätze an den Seiten schaffen einen visuellen Fetisch-Kontrast zum glänzenden Kunstleder</li>
<li>Abnehmbare und verstellbare Strumpfbänder, die unter dem Rock verborgen sind, um das Anbringen von Zwangszubehör zu erleichtern</li>
<li>Verstellbare Nackenpartie, die auch bei intensiven Sessions für perfekten Halt sorgt</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Entdecken Sie das Kleid Adeline von The BDSM Boudoir, dem Spezialisten für sexy Lingerie in großen Größen. Schneller und kostenloser Versand. Französische Boutique. |
| | keywords | | | title | | string | Kleid Adeline in großen Größen - The BDSM Boudoir |
|
| | seotitle | | string | Kleid in Übergröße aus Kunstleder Adeline |
| | seouri | | string | kleid-in-ubergrosse-aus-kunstleder-adeline-schwarz-ou-rot |
| | specifications | | string | <ul>
<li>Zusammensetzung: Hochwertiges Kunstleder und strapazierfähige, transparente Spitze</li>
<li>Stil: BDSM-Patinenkleid mit durchgehendem Frontreißverschluss</li>
<li>Ausschnitt: Verstellbarer Ausschnitt mit verstärkter Befestigung hinter dem Nacken</li>
<li>Unterscheidende Details: Einsätze aus transparenter Spitze, robuster Reißverschluss, abnehmbare Strumpfbänder</li>
<li>Länge: Mittlerer Oberschenkel mit ausgestelltem Rock, der Bewegungsfreiheit ermöglicht</li>
<li>Farbe: Tiefschwarz mit glänzendem Fetish-Effekt</li>
<li>Inklusive Zubehör: Abnehmbare und verstellbare Strumpfbänder, die mit verschiedenen Accessoires kompatibel sind</li>
</ul> |
| | stylingtips | | string | <p>Für eine Dominanz-Session kombinieren Sie dieses Kleid mit Vinyl-Stiefeln und passenden langen Handschuhen für einen unwiderstehlichen autoritären Look. Ergänzen Sie es mit einer Peitsche oder Gerte aus unserer Kollektion, um Ihre dominante Position zu unterstreichen. Für einen eleganten Unterwerfungslook wählen Sie eine Halskette mit Leine und Netzstrümpfe, die die Strumpfbänder hervorheben. Metallische Accessoires wie leichte Ketten oder dekorative Klammern fügen eine zusätzliche visuelle Dimension hinzu, die die Atmosphäre Ihrer Rollenspiele intensivieren wird. Denken Sie daran, dass die Haltung genauso wichtig ist wie das Outfit - tragen Sie dieses Kleid mit dem Selbstbewusstsein, das es ausstrahlt, ob Sie nun in einer dominanten oder unterwürfigen Rolle sind.</p> |
| | summary | | string | Hübsche Mischung aus elastischem Kunstleder und Netzgewebe, abnehmbare Strumpfbänder. |
| | title | | string | Kleid Adeline aus Kunstleder |
| | usageinstructions | | string | <p>Für eine optimale Passform schließen Sie zunächst den Reißverschluss vollständig, bevor Sie das Kleid anziehen, und befestigen Sie dann den Riemen fest hinter dem Nacken. Die Strumpfbänder sind so konzipiert, dass sie verschiedene Accessoires tragen können - befestigen Sie sie je nach Szenario an Ihren Strümpfen oder an leichten Zwangsfesseln.</p>
<p>Der Frontreißverschluss kann als zentrales Element eines Machtspiels eingesetzt werden, bei dem der Dominante das Tempo der Enthüllung bestimmt.</p>
<p>Um das Erlebnis zu intensivieren, kombinieren Sie es mit anderen BDSM-Accessoires aus unserer Kollektion wie Handschellen oder einem passenden Halsband.</p>
<p>Wie bei jeder BDSM-Praxis sollten Sie immer ein Sicherheitswort festlegen und sich vor jeder Sitzung der gegenseitigen Zustimmung versichern.</p> |
|
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Φόρεμα Adeline από ψεύτικο δέρμα και δίχτυ.<br /><br />Κούρεμα skater, μπροστινό φερμουάρ για να παίζετε με τα νεύρα του συντρόφου σας.<br /><br />Ρυθμιζόμενο πίσω από το λαιμό.<br /><br />Αποσπώμενες καλτσοδέτες κάτω από τη φούστα για εύκολη ρύθμιση και αφαίρεση. |
| | highlights | | string | <ul>
<li>Πλήρες φερμουάρ μπροστά για απόλυτο έλεγχο του ρυθμού των παιχνιδιών κυριαρχίας σας</li>
<li>Κολακευτικό κόψιμο skater που ενισχύει τη σιλουέτα σας, ενώ επιτρέπει την ουσιαστική ελευθερία κινήσεων</li>
<li>Διαφανή ένθετα από δαντέλα στα πλαϊνά δημιουργούν μια φετιχιστική οπτική αντίθεση με το γυαλιστερό faux leather</li>
<li>Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες κρυμμένες κάτω από τη φούστα για εύκολη τοποθέτηση αξεσουάρ περιορισμού</li>
<li>Ρύθμιση πίσω από το λαιμό για τέλεια στήριξη ακόμη και κατά τη διάρκεια έντονων συνεδριών</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ανακαλύψτε το φόρεμα Adeline από το The Bdsm Boudoir, τον ειδικό στα σέξι εσώρουχα plus size. Δωρεάν γρήγορη παράδοση. Γαλλικό κατάστημα. |
| | keywords | | | title | | string | Adeline plus size φόρεμα - The Bdsm Boudoir |
|
| | seotitle | | string | Adeline φόρεμα μεγάλου μεγέθους από faux δέρμα |
| | seouri | | string | adeline-forema-megaloy-megethoys-apo-faux-derma-mayro-ou-kokkino |
| | specifications | | string | <ul>
<li>Σύνθεση: Υψηλής ποιότητας ψεύτικο δέρμα και ανθεκτική διάφανη δαντέλα</li>
<li>Στυλ: BDSM φόρεμα skater με φερμουάρ μπροστά</li>
<li>Λαιμόκοψη: Ρυθμιζόμενη με ενισχυμένο δέσιμο στο πίσω μέρος του λαιμού</li>
<li>Διακριτικά χαρακτηριστικά: Διαφανή δαντελένια ένθετα, φερμουάρ βαρέως τύπου, αποσπώμενες καλτσοδέτες</li>
<li>Μήκος: Μέσο του μηρού με φουσκωτή φούστα για ελευθερία κινήσεων</li>
<li>Χρώμα: Έντονο μαύρο με φετίχ γυαλιστερό εφέ</li>
<li>Περιλαμβάνονται αξεσουάρ: Αποσπώμενες και ρυθμιζόμενες καλτσοδέτες συμβατές με διάφορα αξεσουάρ</li>
</ul> |
| | stylingtips | | string | <p>Για μια συνεδρία κυριαρχίας, συνδυάστε αυτό το φόρεμα με βινυλικές μπότες μέχρι το ύψος των μηρών και ασορτί μακριά γάντια για μια ακαταμάχητη εμφάνιση εξουσίας. Συμπληρώστε το με ένα μαστίγιο ή ένα μαστίγιο ιππασίας από τη συλλογή μας για να επιβεβαιώσετε την κυρίαρχη θέση σας. Για μια κομψή υποτακτική εμφάνιση, επιλέξτε ένα κολιέ με λουρί και διχτυωτές κάλτσες για να αναδείξετε τις καλτσοδέτες σας. Τα μεταλλικά αξεσουάρ, όπως οι ελαφριές αλυσίδες ή τα διακοσμητικά κλιπ, θα προσθέσουν μια επιπλέον οπτική διάσταση που θα εντείνει την ατμόσφαιρα του παιχνιδιού ρόλων σας. Να θυμάστε ότι η συμπεριφορά είναι εξίσου σημαντική με το ντύσιμο - φορέστε αυτό το φόρεμα με την αυτοπεποίθηση που σας εμπνέει, είτε είστε σε κυρίαρχο είτε σε υποτακτικό ρόλο.</p> |
| | summary | | string | Όμορφο μείγμα από ελαστικό faux δέρμα και δίχτυ, αποσπώμενες καλτσοδέτες. |
| | title | | string | Φόρεμα Adeline από faux δέρμα |
| | usageinstructions | | string | <p>Για καλύτερη εφαρμογή, κλείστε το φερμουάρ πλήρως πριν φορέσετε το φόρεμα και, στη συνέχεια, στερεώστε καλά τον ιμάντα πίσω από το λαιμό. Οι καλτσοδέτες έχουν σχεδιαστεί για να υποστηρίζουν διάφορα αξεσουάρ - συνδέστε τις με τις κάλτσες σας ή με ελαφριά δεσμά συγκράτησης ανάλογα με το σενάριό σας.</p>
<p>Το μπροστινό φερμουάρ μπορεί να χρησιμοποιηθεί ως το επίκεντρο ενός παιχνιδιού εξουσίας, όπου ο κυρίαρχος παίκτης ελέγχει το ρυθμό της αποκάλυψης.</p>
<p>Για να εντείνετε την εμπειρία, συνδυάστε το με άλλα αξεσουάρ BDSM από τη συλλογή μας, όπως χειροπέδες ή ένα ταιριαστό κολιέ.</p>
<p>Όπως συμβαίνει με όλες τις πρακτικές BDSM, καθιερώστε πάντα μια ασφαλή λέξη και εξασφαλίστε την αμοιβαία συναίνεση πριν από κάθε συνεδρία.</p> |
|
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Adeline dress in faux leather and fishnet.<br /><br />Skater cut, front zipper to play with your partner's nerves.<br /><br />Behind-the-neck adjustment.<br /><br />Detachable garters under the skirt for easy adjustment and removal. |
| | highlights | | string | <ul>
<li>Full front zipper for total control over the rhythm of your domination games</li>
<li>Flattering skater cut that enhances your silhouette while allowing essential freedom of movement</li>
<li>Sheer lace inserts on the sides create a fetish-like visual contrast with shiny faux leather</li>
<li>Detachable, adjustable garters concealed under the skirt for easy attachment of restraint accessories</li>
<li>Behind-the-neck adjustment for perfect support even during intense sessions</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Discover the Adeline dress from The BDSM Boudoir, the specialist in sexy plus size lingerie. Fast, free shipping. French boutique. |
| | keywords | | | title | | string | Plus size dress Adeline - The Bdsm Boudoir |
|
| | seotitle | | string | Adeline plus size dress in leatherette |
| | seouri | | string | adeline-plus-size-dress-in-leatherette-black-ou-red |
| | specifications | | string | <ul>
<li>Composition: High-quality imitation leather and resistant transparent lace</li>
<li>Style: BDSM skater dress with full front zipper</li>
<li>Neckline: Adjustable with reinforced tie at back of neck</li>
<li>Distinctive details: Sheer lace inserts, heavy-duty zipper, detachable garters</li>
<li>Length: Mid-thigh with flared skirt for freedom of movement</li>
<li>Color: Intense black with fetish gloss effect</li>
<li>Accessories included: Detachable, adjustable garters compatible with various accessories</li>
</ul> |
| | stylingtips | | string | <p>For a dominance session, pair this dress with vinyl thigh-high boots and matching long gloves for an irresistible authoritative look. Complete with a whip or riding crop from our collection to assert your dominant position. For an elegantly submissive look, opt for a leash necklace and fishnet stockings to highlight the garters. Metallic accessories such as light chains or decorative clips will add an extra visual dimension that will intensify the atmosphere of your role-playing. Remember that attitude is as important as outfit - wear this dress with the confidence it inspires, whether you're in a dominant or submissive role.</p> |
| | summary | | string | Lovely mix of elastic faux leather and fishnet, detachable garters. |
| | title | | string | Adeline dress in imitation leather |
| | usageinstructions | | string | <p>For optimum fit, first zip up completely before putting on the dress, then securely fasten the strap behind the neck. The garters are designed to support a variety of accessories - attach them to your stockings or to lightweight restraint ties depending on your scenario.</p>
<p>The front zipper can be used as the centerpiece of a power play, where the dominant controls the pace of the unveiling.</p>
<p>To intensify the experience, combine with other BDSM accessories from our collection, such as handcuffs or a matching necklace.</p>
<p>As with any BDSM practice, always establish a safe word and ensure mutual consent before each session.</p> |
|
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Vestido Adeline de piel sintética y rejilla.<br /><br />Corte skater, cremallera delantera para jugar con los nervios de tu pareja.<br /><br />Ajustable detrás del cuello.<br /><br />Ligueros desmontables bajo la falda para ajustar y quitar fácilmente. |
| | highlights | | string | <ul>
<li>Cremallera frontal completa para un control total sobre el ritmo de tus juegos de dominación</li>
<li>Favorecedor corte skater que realza tu figura a la vez que permite una libertad de movimientos esencial</li>
<li>Inserciones de encaje transparente en los laterales que crean un contraste visual fetichista con la piel sintética brillante</li>
<li>Ligueros desmontables y ajustables ocultos bajo la falda para facilitar la colocación de accesorios de sujeción</li>
<li>Ajuste detrás del cuello para una sujeción perfecta incluso durante sesiones intensas</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubre el vestido Adeline de The BDSM Boudoir, especialista en lencería sexy de talla grande. Entrega rápida y gratuita. Tienda francesa. |
| | keywords | | | title | | string | Adeline talla grande vestido - The BDSM Boudoir |
|
| | seotitle | | string | Vestido Adeline talla grande en polipiel |
| | seouri | | string | vestido-adeline-talla-grande-en-polipiel-negro-ou-rojo |
| | specifications | | string | <ul>
<li>Composición: Piel sintética de alta calidad y encaje transparente resistente</li>
<li>Estilo: Vestido skater BDSM con cremallera frontal completa</li>
<li>Escote: Ajustable con lazo reforzado en la nuca</li>
<li>Características distintivas: Inserciones de encaje transparente, cremallera resistente, ligueros desmontables</li>
<li>Largo: A medio muslo con falda acampanada para mayor libertad de movimiento</li>
<li>Color: Negro intenso con efecto fetiche brillante</li>
<li>Accesorios incluidos: Ligas desmontables y ajustables compatibles con varios accesorios</li>
</ul> |
| | stylingtips | | string | <p>Para una sesión de dominación, combina este vestido con botas de vinilo hasta el muslo y guantes largos a juego para una irresistible imagen de autoridad. Compleméntalo con un látigo o una fusta de nuestra colección para reafirmar tu posición dominante. Para un look elegantemente sumiso, opta por un collar de correa y unas medias de rejilla para lucir tus ligueros. Los accesorios metálicos, como las cadenas de luces o los clips decorativos, añadirán una dimensión visual adicional que intensificará la atmósfera de tu juego de rol. Recuerda que la actitud es tan importante como la vestimenta: lleva este vestido con la confianza que inspira, tanto si estás en un papel dominante como sumiso.</p> |
| | summary | | string | Preciosa mezcla de piel sintética elástica y rejilla, con ligueros desmontables. |
| | title | | string | Vestido Adeline de piel sintética |
| | usageinstructions | | string | <p>Para un ajuste óptimo, suba completamente la cremallera antes de ponerse el vestido y, a continuación, sujete firmemente el tirante por detrás del cuello. Los ligueros están diseñados para sujetar diversos accesorios: sujétalos a las medias o a ligeros lazos de sujeción, según el escenario.</p>
<p>La cremallera frontal puede utilizarse como pieza central de un juego de poder, en el que la jugadora dominante controla el ritmo del destape.</p>
<p>Para intensificar la experiencia, combínalo con otros accesorios BDSM de nuestra colección, como unas esposas o un collar a juego.</p>
<p>Como en todas las prácticas BDSM, establece siempre una palabra de seguridad y asegúrate del consentimiento mutuo antes de cada sesión.</p> |
|
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>La robe <strong>Adeline incarne l'équilibre parfait entre esthétique BDSM et fonctionnalité pratique</strong>. Sa silhouette patineuse soigneusement étudiée met en valeur vos courbes avec autorité, tandis que la jupe évasée offre une liberté de mouvement essentielle pour exercer votre domination ou apprécier votre soumission avec grâce et confort.<br>L'élément signature de cette création est sans conteste sa fermeture éclair intégrale à l'avant. Ce détail aussi fonctionnel que symbolique vous permet, ou à votre partenaire, de contrôler précisément le rythme du dévoilement. Un véritable instrument de pouvoir qui transforme <strong>l'habillage et le déshabillage en un rituel de domination ou de soumission à part entière</strong>.<br>Les empiècements en dentelle transparente positionnés stratégiquement sur les côtés créent un contraste saisissant avec le similicuir brillant. Cette <strong>dualité entre opacité et transparence</strong> ajoute une dimension visuelle fetish à l'ensemble, tout en laissant entrevoir subtilement votre peau pour un effet résolument provocant qui intensifiera chaque scène.<br>L'attache derrière la nuque assure un ajustement personnalisé et un maintien optimal du décolleté, vous permettant de vous sentir parfaitement sécurisée même lors de sessions intenses. Ce système d'attache soigneusement conçu garantit que la robe reste en place quelles que soient vos activités.<br>Pour compléter cette création déjà remarquable, des jarretières détachables sont discrètement intégrées sous la jupe. Entièrement réglables, elles vous permettent non seulement d'accessoiriser votre tenue avec des bas, mais aussi d'attacher facilement divers accessoires de contrainte pour enrichir vos scénarios BDSM selon vos envies et limites convenues.</p> |
| | highlights | | string | <ul>
<li>Fermeture éclair intégrale à l'avant pour un contrôle total sur le rythme de vos jeux de domination</li>
<li>Coupe patineuse flatteuse qui sublime votre silhouette tout en permettant une liberté de mouvement essentielle</li>
<li>Empiècements en dentelle transparente sur les côtés créant un contraste visuel fetish avec le similicuir brillant</li>
<li>Jarretières détachables et réglables dissimulées sous la jupe pour attacher facilement des accessoires de contrainte</li>
<li>Ajustement derrière la nuque offrant un maintien parfait même lors de sessions intenses</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Découvrez notre robe BDSM grande taille Adeline avec zip intégral, empiècements transparents et jarretières détachables. Livraison discrète et rapide ! |
| | keywords | | | title | | string | Robe Grande Taille BDSM Zip Intégral Jarretières | The BDSM Boudoir |
|
| | seotitle | | string | Robe grande taille BDSM similicuir zip intégral jarretières |
| | seouri | | string | grande-taille-robe-bdsm-similicuir-zip-integral-jarretieres |
| | specifications | | string | <ul>
<li>Composition : Similicuir haute qualité et dentelle transparente résistante</li>
<li>Style : Robe patineuse BDSM avec fermeture éclair frontale intégrale</li>
<li>Encolure : Ajustable avec attache renforcée derrière la nuque</li>
<li>Détails distinctifs : Empiècements en dentelle transparente, fermeture éclair robuste, jarretières détachables</li>
<li>Longueur : Mi-cuisse avec jupe évasée permettant une liberté de mouvement</li>
<li>Couleur : noir intense avec effet brillant fetish</li>
<li>Accessoires inclus : Jarretières détachables et réglables compatibles avec divers accessoires</li>
</ul> |
| | stylingtips | | string | <p>Pour une session de domination, associez cette robe avec des cuissardes en vinyle et des gants longs assortis pour une allure autoritaire irrésistible. Complétez avec un fouet ou une cravache de notre collection pour affirmer votre position dominante. Pour un look de soumission élégante, optez pour un collier avec laisse et des bas résille qui mettront en valeur les jarretières. Les accessoires métalliques comme des chaînes légères ou des pinces décoratives ajouteront une dimension visuelle supplémentaire qui intensifiera l'atmosphère de vos jeux de rôle. N'oubliez pas que l'attitude est aussi importante que la tenue - portez cette robe avec la confiance qu'elle inspire, que vous soyez dans un rôle dominant ou soumis.</p> |
| | summary | | string | <p>Maîtrisez l'art de la séduction avec notre robe Adeline, une création BDSM aussi audacieuse que dominante. Sa coupe patineuse met en valeur votre silhouette, tandis que sa fermeture éclair intégrale à l'avant offre un contrôle total sur le rythme du jeu.</p>
<p>Avec ses empiècements en dentelle transparente et ses jarretières détachables, cette robe incarne l'alliance parfaite entre esthétique fetish et fonctionnalité pour vos scénarios les plus intenses.</p> |
| | title | | string | Robe Adeline Domination - Sensualité provocante et contrôle absolu |
| | usageinstructions | | string | <p>Pour un ajustement optimal, commencez par fermer complètement la fermeture éclair avant d'enfiler la robe, puis attachez solidement la bride derrière la nuque. Les jarretières sont conçues pour supporter divers accessoires - fixez-les à vos bas ou à des liens de contrainte légers selon votre scénario.</p>
<p>La fermeture éclair frontale peut être utilisée comme élément central d'un jeu de pouvoir, où le dominant contrôle le rythme du dévoilement.</p>
<p>Pour intensifier l'expérience, combinez avec d'autres accessoires BDSM de notre collection comme des menottes ou un collier assorti.</p>
<p>Comme pour toute pratique BDSM, établissez toujours un mot de sécurité et assurez-vous du consentement mutuel avant chaque session.</p> |
|
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Abito Adeline in ecopelle e rete.<br /><br />Taglio skater, zip frontale per giocare con i nervi del partner.<br /><br />Regolabile dietro il collo.<br /><br />Giarrettiere staccabili sotto la gonna per una facile regolazione e rimozione. |
| | highlights | | string | <ul>
<li>Zip frontale completa per un controllo totale sul ritmo dei tuoi giochi di dominazione</li>
<li>Taglio skater lusinghiero che esalta la figura e consente un'essenziale libertà di movimento</li>
<li>Gli inserti in pizzo trasparente sui lati creano un contrasto visivo fetish con l'ecopelle lucida</li>
<li>Giarrettiere staccabili e regolabili nascoste sotto la gonna per un facile fissaggio degli accessori di contenzione</li>
<li>Regolazione dietro il collo per un sostegno perfetto anche durante le sessioni più intense</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Scoprite l'abito Adeline da The BDSM Boudoir, lo specialista della lingerie sexy per taglie grandi. Consegna rapida e gratuita. Negozio francese. |
| | keywords | | | title | | string | Abito Adeline taglia grande - The BDSM Boudoir |
|
| | seotitle | | string | Abito Adeline di taglia grande in ecopelle |
| | seouri | | string | abito-adeline-di-taglia-grande-in-ecopelle-nero-ou-rosso |
| | specifications | | string | <ul>
<li>Composizione: ecopelle di alta qualità e resistente pizzo trasparente</li>
<li>Stile: abito skater BDSM con zip frontale completa</li>
<li>Scollatura: regolabile con laccetto rinforzato dietro il collo</li>
<li>Caratteristiche distintive: inserti in pizzo trasparente, zip resistente, giarrettiere staccabili</li>
<li>Lunghezza: metà coscia con gonna svasata per libertà di movimento</li>
<li>Colore: nero intenso con effetto lucido fetish</li>
<li>Accessori inclusi: giarrettiere staccabili e regolabili compatibili con vari accessori</li>
</ul> |
| | stylingtips | | string | <p>Per una sessione di dominazione, abbinate questo abito a stivali alti in vinile e guanti lunghi coordinati per un irresistibile look di autorità. Completate il tutto con una frusta o un frustino della nostra collezione per affermare la vostra posizione dominante. Per un look elegantemente sottomesso, optate per una collana con guinzaglio e calze a rete per mostrare il reggicalze. Accessori metallici come catene luminose o clip decorative aggiungeranno una dimensione visiva extra che intensificherà l'atmosfera del vostro gioco di ruolo. Ricordate che l'atteggiamento è importante quanto l'abito: indossate questo vestito con la fiducia che ispira, sia che siate in un ruolo dominante o sottomesso.</p> |
| | summary | | string | Bellissimo mix di ecopelle elasticizzata e rete, giarrettiere staccabili. |
| | title | | string | Abito Adeline in ecopelle |
| | usageinstructions | | string | <p>Per una vestibilità ottimale, chiudere completamente la cerniera prima di indossare l'abito, quindi allacciare saldamente il cinturino dietro il collo. Le giarrettiere sono progettate per supportare una varietà di accessori: attaccatele alle calze o a lacci di contenzione leggeri, a seconda dello scenario.</p>
<p>La cerniera anteriore può essere utilizzata come fulcro di un gioco di potere, in cui il giocatore dominante controlla il ritmo dello svelamento.</p>
<p>Per intensificare l'esperienza, abbinatela ad altri accessori BDSM della nostra collezione, come le manette o una collana coordinata.</p>
<p>Come per tutte le pratiche BDSM, stabilire sempre una parola di sicurezza e assicurarsi del consenso reciproco prima di ogni sessione.</p> |
|
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Adeline jurk van imitatieleer en visnet.<br /><br />Skater model, rits aan de voorkant om met de zenuwen van je partner te spelen.<br /><br />Verstelbaar achter de hals.<br /><br />Afneembare kousenbanden onder de rok voor eenvoudig aanpassen en verwijderen. |
| | highlights | | string | <ul>
<li>Volledige ritssluiting aan de voorkant voor totale controle over het tempo van je dominantie spelletjes</li>
<li>Flatterende skater snit die je figuur verbetert terwijl het essentiële bewegingsvrijheid biedt</li>
<li>Sheer kanten inzetstukken aan de zijkanten creëren een fetisj visueel contrast met het glanzende kunstleer</li>
<li>Afneembare en verstelbare kousenbanden verborgen onder de rok voor eenvoudige bevestiging van boeien accessoires</li>
<li>Achter-de-hals aanpassing voor perfecte ondersteuning, zelfs tijdens intense sessies</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ontdek het Adeline jurkje van The BDSM Boudoir, de specialist in sexy lingerie voor grote maten. Gratis snelle levering. Franse winkel. |
| | keywords | | | title | | string | Adeline jurk grote maat - The BDSM Boudoir |
|
| | seotitle | | string | Adeline grote maat jurk van imitatieleer |
| | seouri | | string | adeline-grote-maat-jurk-van-imitatieleer-zwart-ou-rood |
| | specifications | | string | <ul>
<li>Samenstelling: Hoogwaardig kunstleer en bestendig transparant kant</li>
<li>Stijl: BDSM skaterjurk met volledige ritssluiting aan de voorkant</li>
<li>Halslijn: Verstelbaar met verstevigde band achter in de nek</li>
<li>Bijzondere kenmerken: Sheer kanten inzetstukken, stevige ritssluiting, afneembare kousenbanden</li>
<li>Lengte: Midden bovenbeen met uitlopende rok voor bewegingsvrijheid</li>
<li>Kleur: Intens zwart met fetish glanseffect</li>
<li>Meegeleverde accessoires: afneembare en verstelbare kousenbanden die compatibel zijn met diverse accessoires</li>
</ul> |
| | stylingtips | | string | <p>Voor een sessie van dominantie combineer je deze jurk met vinyl dijhoge laarzen en bijpassende lange handschoenen voor een onweerstaanbare uitstraling van autoriteit. Maak het af met een zweep of zweepzweep uit onze collectie om je dominante positie te laten gelden. Voor een elegante onderdanige look kies je voor een halsketting met leiband en netkousen om je kousenbanden te showen. Metallic accessoires zoals lichtgevende kettingen of decoratieve clips zullen een extra visuele dimensie toevoegen die de sfeer van je rollenspel zal versterken. Onthoud dat houding net zo belangrijk is als kleding - draag deze jurk met het zelfvertrouwen dat hij je geeft, of je nu een dominante of onderdanige rol speelt.</p> |
| | summary | | string | Mooie mix van stretch kunstleer en visnet, afneembare kousenbanden. |
| | title | | string | Adeline jurk van kunstleer |
| | usageinstructions | | string | <p>Voor de beste pasvorm rits je de jurk helemaal dicht voordat je hem aantrekt en maak je het bandje achter de nek goed vast. De kousenbanden zijn ontworpen om een verscheidenheid aan accessoires te ondersteunen - maak ze vast aan je kousen of lichtgewicht bindbandjes, afhankelijk van je scenario.</p>
<p>De ritssluiting aan de voorkant kan worden gebruikt als middelpunt van een machtsspel, waarbij de dominante speler het tempo van de onthulling bepaalt.</p>
<p>Om de ervaring te intensiveren kun je hem combineren met andere BDSM-accessoires uit onze collectie, zoals handboeien of een bijpassende ketting.</p>
<p>Zoals met alle BDSM-praktijken, moet je altijd een veilig woord spreken en zorgen voor wederzijdse toestemming voor elke sessie.</p> |
|
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Vestido Adeline em pele sintética e rede.<br /><br />Corte skater, fecho frontal para brincar com os nervos do seu parceiro.<br /><br />Ajustável atrás do pescoço.<br /><br />Ligas amovíveis por baixo da saia para ajustar e retirar facilmente. |
| | highlights | | string | <ul>
<li>Fecho frontal completo para controlo total do ritmo dos seus jogos de dominação</li>
<li>Corte de skater lisonjeiro que realça a sua figura enquanto permite a liberdade de movimentos essencial</li>
<li>As inserções de renda transparente nos lados criam um contraste visual fetichista com a pele sintética brilhante</li>
<li>Ligas amovíveis e ajustáveis escondidas sob a saia para facilitar a fixação de acessórios de restrição</li>
<li>Ajuste atrás do pescoço para um apoio perfeito mesmo durante sessões intensas</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra o vestido Adeline da The Bdsm Boudoir, especialista em lingerie sexy plus size. Entrega rápida e gratuita. Loja francesa. |
| | keywords | | | title | | string | Vestido Adeline plus size - The Bdsm Boudoir |
|
| | seotitle | | string | Vestido Adeline tamanho grande em pele sintética |
| | seouri | | string | vestido-adeline-tamanho-grande-em-pele-sintetica-preto-ou-vermelho |
| | specifications | | string | <ul>
<li>Composição: Pele sintética de alta qualidade e renda transparente resistente</li>
<li>Estilo: Vestido skater BDSM com fecho de correr à frente</li>
<li>Decote: ajustável com laço reforçado na parte de trás do pescoço</li>
<li>Caraterísticas distintivas: inserções de renda transparente, fecho de correr resistente, ligas amovíveis</li>
<li>Comprimento: A meio da coxa com saia larga para liberdade de movimentos</li>
<li>Cor: Preto intenso com efeito de brilho fetichista</li>
<li>Acessórios incluídos: Ligas amovíveis e ajustáveis compatíveis com vários acessórios</li>
</ul> |
| | stylingtips | | string | <p>Para uma sessão de dominação, combine este vestido com botas de vinil até à coxa e luvas compridas a condizer para um irresistível ar de autoridade. Complete-o com um chicote ou um chicote da nossa coleção para afirmar a sua posição dominante. Para um visual elegantemente submisso, opte por um colar de trela e meias de rede para mostrar as ligas. Acessórios metálicos, como correntes leves ou clipes decorativos, darão uma dimensão visual extra que intensificará a atmosfera do seu jogo de papéis. Lembre-se de que a atitude é tão importante quanto a roupa - use este vestido com a confiança que ele inspira, quer esteja num papel dominante ou submisso.</p> |
| | summary | | string | Bela mistura de pele sintética elástica e rede, ligas amovíveis. |
| | title | | string | Vestido Adeline em pele sintética |
| | usageinstructions | | string | <p>Para um melhor ajuste, feche o fecho completamente antes de vestir o vestido e, em seguida, aperte firmemente a correia atrás do pescoço. As ligas são concebidas para suportar uma variedade de acessórios - prenda-as às suas meias ou a laços de retenção leves, dependendo do seu cenário.</p>
<p>O fecho frontal pode ser utilizado como peça central de um jogo de poder, em que o jogador dominante controla o ritmo da revelação.</p>
<p>Para intensificar a experiência, combine com outros acessórios BDSM da nossa coleção, como algemas ou um colar a condizer.</p>
<p>Como em todas as práticas de BDSM, estabeleça sempre uma palavra de segurança e garanta o consentimento mútuo antes de cada sessão.</p> |
|
|
|
|
| name | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | C74B0521-2498-4C95-ADF7D85A1754DA3E |
|
| promountil | |
| rating | |
| recorduid | | string | C74B0521-2498-4C95-ADF7D85A1754DA3E |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.39 ms Record Count: 6 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype, product_variations.color, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED )) , SUBSTRING_INDEX(intlsize,'-',1) ) as param1, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)), MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize)) ) , SUBSTRING_INDEX(intlsize,'-',-1) ) as param2, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, 999999, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as groupavailable, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight from product_sizes left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_sizes.id_size,'1093,1137,1136,1888') > 0 and product_variations.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 | 1093 | 38-40 | intlsize | black | 38 | 40 | -1 | 999999 | 0 | w | plus | lingerie | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 92-100 | 74-82 | 98-106 | | | | | | | | 2 | 1093 | 38-40 | intlsize | red | 38 | 40 | -1 | 999999 | 0 | w | plus | lingerie | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 92-100 | 74-82 | 98-106 | | | | | | | | 3 | 1137 | 44-46 | intlsize | black | 44 | 46 | -1 | 999999 | 1 | w | plus | lingerie | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 102-108 | 86-92 | 108-114 | | | | | | | | 4 | 1137 | 44-46 | intlsize | red | 44 | 46 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 102-108 | 86-92 | 108-114 | | | | | | | | 5 | 1136 | 48-50 | intlsize | red | 48 | 50 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 110-116 | 96-102 | 116-122 | | | | | | | | 6 | 1136 | 48-50 | intlsize | black | 48 | 50 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 110-116 | 96-102 | 116-122 | | | | | | |
|
| sizeranges | |
| sizes | | string | 1093,1137,1136,1888 |
|
| 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.05 ms Record Count: 6 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1093 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1137 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1136 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1888 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 | C74B0521-2498-4C95-ADF7D85A1754DA3E | 126517FD-3C64-4F99-8E319287F9D15F92 | 1093 | black | #000000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | | R82347-10115 | -1 | 0 | all | | | 2 | C74B0521-2498-4C95-ADF7D85A1754DA3E | 14633B55-8DD1-4042-BF9DA122A97B9406 | 1093 | red | #F50000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 3 | C74B0521-2498-4C95-ADF7D85A1754DA3E | E077181A-5311-4107-8671F125AF631206 | 1137 | black | #000000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 6 | 0 | 0 | R82347-1 | R82347-10116 | 1 | 1 | all | | | 4 | C74B0521-2498-4C95-ADF7D85A1754DA3E | 0160240C-8791-42CF-872D21A017078448 | 1137 | red | #F50000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 5 | C74B0521-2498-4C95-ADF7D85A1754DA3E | ED8CBE4C-E87C-4610-A77E0D55A94A7BE9 | 1136 | black | #000000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 8 | 0 | 0 | R82347-1 | R82347-10117 | -1 | 0 | all | | | 6 | C74B0521-2498-4C95-ADF7D85A1754DA3E | 8F749448-DC7C-44C6-929E27B3C2D78009 | 1136 | red | #F50000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 9.14 ms Record Count: 6 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1093 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1137 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1136 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' 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 = 'C74B0521-2498-4C95-ADF7D85A1754DA3E' and product_variations.isactive = 1 and product_sizes.id_size = 1888 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 | 126517FD-3C64-4F99-8E319287F9D15F92 | 1093 | black | #000000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | | R82347-10115 | -1 | 0 | -1 | 0 | -1 | 1 | 0 | 33.2917 | all | | | 2 | 14633B55-8DD1-4042-BF9DA122A97B9406 | 1093 | red | #F50000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 3 | E077181A-5311-4107-8671F125AF631206 | 1137 | black | #000000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 6 | 0 | 0 | R82347-1 | R82347-10116 | 1 | 1 | -1 | 1 | -1 | 1 | 0 | 33.2917 | all | | | 4 | 0160240C-8791-42CF-872D21A017078448 | 1137 | red | #F50000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 1 | -1 | 0 | 0 | 33.2917 | all | | | 5 | ED8CBE4C-E87C-4610-A77E0D55A94A7BE9 | 1136 | black | #000000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 8 | 0 | 0 | R82347-1 | R82347-10117 | -1 | 0 | -1 | 0 | -1 | 1 | 0 | 33.2917 | all | | | 6 | 8F749448-DC7C-44C6-929E27B3C2D78009 | 1136 | red | #F50000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | |
|
| vatrate | |
| warehouse | |