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.lingerie.sexylingerie.bustier |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/sexylingerie/bustier.jpg |
| | type | | | width | |
| | divasboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | fetishboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | latexboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | legsboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | lustboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | private | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/private/default.jpg |
| | type | | | width | |
| | smboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
|
|
| categorysizerange | |
| colorinfos | Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.701 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = '6C3F43DB-C690-4705-998F66BB8331A990' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2023-04-20 10:46:27'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | | string | guepiere-en-simili-cuir-grande-taille-avec-porte-jarretelles-et-menottes-dg12820xblk |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-11-03 18:31:26'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.606 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','el') 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('6c3f43db-c690-4705-998f66bb8331a990',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','el') and product_categories.language in ('all','el') 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 <> 'DRBU9040' 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/ddru/drbu9040/ensemble_bdsm_grande_taille_dos.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/drbu9040/guepiere-en-simili-cuir-avec-porte-jarretelles-et-menottes-dg12820blk_1.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/drbu9040/ensemble_bdsm_grande_taille.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/drbu9040/ensemble_bdsm_grande_taille.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Sanft mit lauwarmem Wasser und einer milden Spezialseife für Kunstleder reinigen</li>
<li>Natürlich an der Luft trocknen, vor direktem Licht geschützt</li>
<li>Gelegentlich ein Pflegemittel für Kunstleder auftragen</li>
<li>An einem trockenen Ort aufbewahren, um die Geschmeidigkeit des Materials zu erhalten</li>
<li>Überprüfen Sie regelmäßig den Zustand der Handschellen und der Fesseln für die Sicherheit</li>
</ul> |
| | description | | string | Dieses lange Mieder besteht aus Kunstleder mit Stretchanteil und ist angenehm zu tragen.<br /><br />Es enthält drei Schmuckstücke, die Ihren Partner dazu auffordern, Ihnen den Hintern zu versohlen, ob er dem widerstehen kann?<br /><br />Verstellbare Strumpfbänder, String und Handschellen sind im Lieferumfang enthalten. |
| | guid | | string | https://dev.divasboudoir.com/de/lang-grosse-grosse-guepiere-spanking-schwarz/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Integrierte Handschellen</strong> für ein umfassendes und sicheres BDSM-Erlebnis</li>
<li>Bequemes und strapazierfähiges<strong>Premium-Stretch-Kunstleder</strong> für alle Spiele</li>
<li><strong>Provokantes Design</strong> mit goldenen "SPANKME"-Details, um Ihre Wünsche zu unterstreichen</li>
<li><strong>Komplettes Set</strong> aus Mieder, String und Handschellen für totale Verführung</li>
<li><strong>Verstellbare Strumpfbänder</strong> für eine perfekte Passform und optimalen Halt</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Wenn Sie dieses wunderschöne lange Mieder in Übergröße aus Kunstleder tragen, werden Sie nichts von Ihren Wünschen verbergen. |
| | keywords | | | title | | string | Lang Große Größe Guêpière Spanking |
|
| | seotitle | | string | Lang Große Größe Guêpière Spanking |
| | seouri | | string | lang-grosse-grosse-guepiere-spanking-schwarz |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Premium-Stretch-Kunstleder, Baumwollfutter</li>
<li><strong>Farbe:</strong> Schwarz mit goldenen Details</li>
<li><strong>Zusammensetzung:</strong> Langes Guêpière, passender String, integrierte Handschellen</li>
<li><strong>Verschluss: Ver</strong> stellbare Schnürsenkel im Rücken</li>
<li><strong>Strumpfbänder:</strong> 4 verstellbare Strumpfbänder enthalten</li>
<li><strong>Details:</strong> Goldene "SPANKME"-Schriftzüge vorne und hinten</li>
</ul> |
| | stylingtips | | string | <p>Vervollständigen Sie diesen Look der <strong>selbstbewussten Domina</strong> mit <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">Fetisch-Strümpfen in Übergröße</a> aus Netz oder Vinyl, um eine perfekte Übereinstimmung zu erzielen. Für Standardgrößen bieten unsere <a href="https://www.thebdsmboudoir.com/de/latexstrumpfe/">Strümpfe in Standardgrößen</a> ebenfalls hervorragende Kombinationsmöglichkeiten. Fügen Sie <strong>ergänzende BDSM-Accessoires</strong> wie eine Halskette oder Armbänder hinzu, um den Effekt zu intensivieren. Das Ensemble steht für sich allein, kann aber je nach Vorliebe mit <strong> zusätzlichen Zwangselementen</strong> angereichert werden. Der Schwarz-Gold-Kontrast harmoniert perfekt mit Metall-Accessoires für einen <strong>stimmigen Fetisch-Stil</strong>.</p> |
| | summary | | string | Wenn Sie dieses wunderschöne lange Mieder in Übergröße aus Kunstleder tragen, werden Sie nichts von Ihren Wünschen verbergen. |
| | title | | string | Langes verhauenes Guêpière |
| | usageinstructions | | string | <p>Dieses Set erfordert eine <strong>klare Kommunikation mit Ihrem Partner</strong> vor der Benutzung. Die <strong>eingebauten Handschellen</strong> bieten eine kontrollierte Einschränkung - legen Sie vor Ihren Spielen immer ein <strong>Sicherheitswort</strong> fest. Das stretchige Kunstleder ermöglicht Bewegungsfreiheit, während der Aspekt der <strong>visuellen Dominanz</strong> erhalten bleibt. Für <strong>optimalen Tragekomfort</strong> tragen Sie das Set zunächst einige Minuten, um sich an das Gefühl zu gewöhnen.</p>
<p>Die <strong>verstellbaren Strumpfbänder</strong> passen sich Ihrer Körperform an - stellen Sie sie schrittweise ein, um Beschwerden zu vermeiden. Der Schriftzug "SPANKME" erzeugt eine starke <strong>psychologische Dynamik</strong>, die das Erlebnis für beide Partner intensiviert.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Καθαρίστε απαλά με χλιαρό νερό και ένα ήπιο σαπούνι για δερματίνη</li>
<li>Στεγνώστε φυσικά στον καθαρό αέρα, μακριά από το άμεσο φως</li>
<li>Εφαρμόζετε περιστασιακά ένα προϊόν περιποίησης δερματίνης</li>
<li>Αποθηκεύστε σε ξηρό μέρος για να διατηρήσετε την ελαστικότητα του υλικού</li>
<li>Ελέγχετε τακτικά την κατάσταση των χειροπέδων και των συνδέσμων για την ασφάλεια</li>
</ul> |
| | description | | string | Αυτή η μακριά καλτσοδέτα είναι κατασκευασμένη από ελαστικό δέρμα και είναι άνετη στη χρήση.<br /><br />Ενσωματώνει τρία κοσμήματα που ζητούν από τον σύντροφό σας να σας δείρει - θα μπορέσει να αντισταθεί;<br /><br />Περιλαμβάνονται ρυθμιζόμενες καλτσοδέτες, στρινγκ και χειροπέδες. |
| | guid | | string | https://dev.divasboudoir.com/el/makry-megalo-megethos-spanking-guepiere-mayro/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Ενσωματωμένες χειροπέδες</strong> για μια πλήρη και ασφαλή εμπειρία BDSM</li>
<li>Άνετη και ανθεκτική<strong>premium stretch δερματίνη</strong> για όλα τα παιχνίδια</li>
<li><strong>Προκλητικός σχεδιασμός</strong> με χρυσές λεπτομέρειες "SPANKME" για να διεκδικήσετε τις επιθυμίες σας</li>
<li><strong>Πλήρες σετ</strong> καλτσοδέτας, στρινγκ και χειροπέδων για απόλυτη αποπλάνηση</li>
<li><strong>Ρυθμιζόμενες καλτσοδέτες</strong> για τέλεια εφαρμογή και βέλτιστη στήριξη</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Φορέστε αυτό το υπέροχο μακρύ, μεγάλο μπουστάκι από ψεύτικο δέρμα και δεν υπάρχει περίπτωση να κρύψετε αυτό που θέλετε. |
| | keywords | | | title | | string | Μακρύ μεγάλο μέγεθος Spanking Guêpière |
|
| | seotitle | | string | Μακρύ μεγάλο μέγεθος Spanking Guêpière |
| | seouri | | string | makry-megalo-megethos-spanking-guepiere-mayro |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Premium stretch faux leather, βαμβακερή επένδυση</li>
<li><strong>Χρώμα:</strong> μαύρο με χρυσές λεπτομέρειες</li>
<li><strong>Σύνθεση:</strong> Μακρύ μπουστάκι, ασορτί στρινγκ, ενσωματωμένες χειροπέδες</li>
<li><strong>Κλείσιμο:</strong> Ρυθμιζόμενα κορδόνια στο πίσω μέρος</li>
<li><strong>Καλτσοδέτες</strong>: Περιλαμβάνονται 4 ρυθμιζόμενες καλτσοδέτες</li>
<li><strong>Λεπτομέρειες:</strong> Χρυσά γράμματα "SPANKME" μπροστά και πίσω</li>
</ul> |
| | stylingtips | | string | <p>Ολοκληρώστε την εμφάνιση <strong>dominatrix</strong> με <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">κάλτσες φετίχ από δίχτυ</a> ή βινύλιο για τέλεια συνοχή. Για τα τυπικά μεγέθη, οι <a href="https://www.thebdsmboudoir.com/el/kaltses-latex/">τυποποιημένες κάλτσες</a> μας προσφέρουν επίσης εξαιρετικές επιλογές ταιριάσματος. Προσθέστε <strong>συμπληρωματικά αξεσουάρ BDSM</strong>, όπως ένα κολιέ ή βραχιόλια, για να εντείνετε το αποτέλεσμα. Το σετ στέκεται από μόνο του, αλλά μπορεί να ενισχυθεί με <strong> πρόσθετα στοιχεία περιορισμού</strong> ανάλογα με τις προτιμήσεις σας. Η αντίθεση του μαύρου και του χρυσού λειτουργεί τέλεια με μεταλλικά αξεσουάρ για ένα <strong>συνεπές φετίχ στυλ</strong>.</p> |
| | summary | | string | Φορέστε αυτό το υπέροχο μακρύ, μεγάλο μπουστάκι από ψεύτικο δέρμα και δεν υπάρχει περίπτωση να κρύψετε αυτό που θέλετε. |
| | title | | string | Μακρυά Spanked Bustier |
| | usageinstructions | | string | <p>Αυτό το σετ απαιτεί <strong>σαφή επικοινωνία με τον σύντροφό σας</strong> πριν από τη χρήση. <strong>Οι ενσωματωμένες χειροπέδες</strong> παρέχουν ελεγχόμενη συγκράτηση - πάντα να καθορίζετε μια <strong>ασφαλή λέξη</strong> πριν από το παιχνίδι σας. Το ελαστικό ψεύτικο δέρμα επιτρέπει την ελευθερία κινήσεων, διατηρώντας παράλληλα την <strong>οπτική κυριαρχία</strong>. Για <strong>βέλτιστη άνεση</strong>, φορέστε πρώτα το σετ για λίγα λεπτά για να συνηθίσετε την αίσθηση.</p>
<p>Οι <strong>ρυθμιζόμενες καλτσοδέτες</strong> προσαρμόζονται στο σχήμα του σώματός σας - ρυθμίστε τις σταδιακά για να αποφύγετε οποιαδήποτε δυσφορία. Η επιγραφή "SPANKME" δημιουργεί μια ισχυρή <strong>ψυχολογική δυναμική</strong> που εντείνει την εμπειρία και για τους δύο συντρόφους.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Gently clean with lukewarm water and a mild leatherette soap</li>
<li>Dry naturally in the open air, away from direct light</li>
<li>Occasionally apply a leatherette care product</li>
<li>Store in a dry place to preserve the suppleness of the material</li>
<li>Regularly check the condition of handcuffs and safety fasteners</li>
</ul> |
| | description | | string | This long garter is made of stretch imitation leather and is comfortable to wear.<br /><br />It incorporates three jewels that ask your partner to spank you - will he be able to resist?<br /><br />Adjustable garters, thong and handcuffs included. |
| | guid | | string | https://dev.divasboudoir.com/en/long-plus-size-guepiere-spanking-black/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Integrated handcuffs</strong> for a complete and secure BDSM experience</li>
<li>Comfortable, durable<strong>premium stretch imitation leather</strong> for all types of play</li>
<li><strong>Provocative design</strong> with gold "SPANKME" details to assert your desires</li>
<li><strong>Complete</strong> garter, thong and handcuff<strong>set</strong> for total seduction</li>
<li><strong>Adjustable garters</strong> for a perfect fit and optimum support</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Wearing this superb long, plus-size, faux-leather guêpière, you'll hide nothing of your desires. |
| | keywords | | | title | | string | Long plus size Guêpière Spanking |
|
| | seotitle | | string | Long plus size Guêpière Spanking |
| | seouri | | string | long-plus-size-guepiere-spanking-black |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Premium stretch leatherette, cotton lining</li>
<li><strong>Color:</strong> black with gold details</li>
<li><strong>Composition:</strong> Long basque, matching thong, integrated handcuffs</li>
<li><strong>Closure:</strong> Adjustable back laces</li>
<li><strong>Garters:</strong> 4 adjustable garters included</li>
<li><strong>Details:</strong> Gold "SPANKME" lettering front and back</li>
</ul> |
| | stylingtips | | string | <p>Complement this <strong>confident dominatrix</strong> look with <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">plus size fetish stockings</a> in fishnet or vinyl for perfect consistency. For standard sizes, our <a href="https://www.thebdsmboudoir.com/en/latex-stockings/">standard stockings</a> also offer excellent matching options. Add <strong>complementary BDSM accessories</strong> like a necklace or bracelets to intensify the effect. The set stands on its own, but can be enriched with <strong> additional constraining elements</strong> to suit your preferences. Black and gold contrast perfectly with metallic accessories for a <strong>consistent fetish style</strong>.</p> |
| | summary | | string | Wearing this superb long, plus-size, faux-leather guêpière, you'll hide nothing of your desires. |
| | title | | string | Long Spanked Bustier |
| | usageinstructions | | string | <p>This set requires <strong>clear communication with your partner</strong> before use. <strong>Integrated handcuffs</strong> offer controlled restraint - always establish a <strong>safe word</strong> before your play. Stretch faux leather allows freedom of movement while maintaining <strong>visual dominance</strong>. For <strong>optimum comfort</strong>, first wear the set for a few minutes to get used to the sensations.</p>
<p>The <strong>adjustable garters</strong> adapt to your body shape - adjust them gradually to avoid any discomfort. The "SPANKME" inscription creates a powerful <strong>psychological dynamic</strong> that intensifies the experience for both partners.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Limpiar suavemente con agua tibia y un jabón suave para cuero artificial</li>
<li>Secar de forma natural al aire libre, lejos de la luz directa</li>
<li>Aplique de vez en cuando un producto para el cuidado del polipiel</li>
<li>Guardar en un lugar seco para preservar la flexibilidad del material</li>
<li>Compruebe regularmente el estado de las esposas y los cierres para mayor seguridad</li>
</ul> |
| | description | | string | Este liguero largo está fabricado en piel sintética elástica y es muy cómodo de llevar.<br /><br />Incorpora tres joyas que piden a tu pareja que te azote - ¿podrá resistirse?<br /><br />Incluye ligueros ajustables, tanga y esposas. |
| | guid | | string | https://dev.divasboudoir.com/es/spanking-guepiere-larga-talla-grande-negro/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Esposas integradas</strong> para una experiencia BDSM completa y segura</li>
<li>Cómoda y resistente<strong>polipiel elástica premium</strong> para todos los juegos</li>
<li><strong>Diseño provocativo</strong> con detalles dorados "SPANKME" para reafirmar tus deseos</li>
<li><strong>Juego completo de</strong> liguero, tanga y esposas para una seducción total</li>
<li><strong>Ligas ajustables</strong> para un ajuste perfecto y una sujeción óptima</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ponte este magnífico corpiño largo y grande de imitación de cuero y no podrás ocultar lo que quieres. |
| | keywords | | | title | | string | Spanking Guêpière larga talla grande |
|
| | seotitle | | string | Spanking Guêpière larga talla grande |
| | seouri | | string | spanking-guepiere-larga-talla-grande-negro |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Piel sintética elástica de primera calidad, forro de algodón</li>
<li><strong>Color:</strong> negro con detalles dorados</li>
<li><strong>Composición:</strong> corpiño largo, tanga a juego, esposas integradas</li>
<li><strong>Cierre:</strong> cordones ajustables en la espalda</li>
<li><strong>Ligueros</strong>: 4 ligueros ajustables incluidos</li>
<li><strong>Detalles:</strong> Letras doradas "SPANKME" en la parte delantera y trasera</li>
</ul> |
| | stylingtips | | string | <p>Completa este look <strong>de dominatrix segura de sí misma</strong> con <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">medias fetiche de rejilla</a> o vinilo <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">de talla grande</a> para una consistencia perfecta. Para tallas estándar, nuestras <a href="https://www.thebdsmboudoir.com/es/medias-de-latex/">medias estándar</a> también ofrecen excelentes opciones de combinación. Añade <strong>accesorios BDSM complementarios</strong> como un collar o pulseras para intensificar el efecto. El conjunto se sostiene por sí solo, pero puede mejorarse con <strong> elementos de sujeción adicionales</strong> para adaptarlo a sus preferencias. El contraste negro y dorado funciona perfectamente con accesorios metálicos para un <strong>estilo fetichista coherente</strong>.</p> |
| | summary | | string | Ponte este magnífico corpiño largo y grande de imitación de cuero y no podrás ocultar lo que quieres. |
| | title | | string | Bustier largo azotado |
| | usageinstructions | | string | <p>Este juego requiere <strong>una comunicación clara con su pareja</strong> antes de usarlo. <strong>Las esposas integradas</strong> proporcionan una inmovilización controlada: establece siempre una <strong>palabra de seguridad</strong> antes de jugar. La piel sintética elástica permite libertad de movimientos a la vez que mantiene <strong>el dominio visual</strong>. Para <strong>una comodidad óptima</strong>, primero usa el conjunto durante unos minutos para acostumbrarte a la sensación.</p>
<p>Los <strong>ligueros ajustables</strong> se adaptan a la forma de tu cuerpo: ajústalos gradualmente para evitar cualquier molestia. La inscripción "SPANKME" crea una potente <strong>dinámica psicológica</strong> que intensifica la experiencia para ambos miembros de la pareja.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Nettoyer délicatement à l'eau tiède avec un savon doux spécial similicuir</li>
<li>Sécher naturellement à l'air libre, à l'abri de la lumière directe</li>
<li>Appliquer occasionnellement un produit d'entretien pour similicuir</li>
<li>Ranger dans un endroit sec pour préserver la souplesse du matériau</li>
<li>Vérifier régulièrement l'état des menottes et des attaches pour la sécurité</li>
</ul> |
| | description | | string | <p>Cette longue guêpière est en similicuir stretch, agréable à porter.<br><br>Elle incorpore trois bijoux qui demandent à votre partenaire de vous donner la fessée, saura-t'il résister? <br><br>Jarretières réglables, string et menottes incluses.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/longue-grande-taille-guepiere-fessee-noir/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Menottes intégrées</strong> pour une expérience BDSM complète et sécurisée</li>
<li><strong>Similicuir stretch premium</strong> confortable et résistant pour tous les jeux</li>
<li><strong>Design provocant</strong> avec détails dorés "SPANKME" pour affirmer vos désirs</li>
<li><strong>Ensemble complet</strong> guêpière, string et menottes pour une séduction totale</li>
<li><strong>Jarretières réglables</strong> pour un ajustement parfait et un maintien optimal</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | En portant cette superbe longue guêpière grande taille en similicuir, vous ne cacherez rien de vos désirs. |
| | keywords | | | title | | string | Longue grande taille Guêpière Fessée |
|
| | seotitle | | string | Guêpière Fessée grande taille |
| | seouri | | string | longue-grande-taille-guepiere-fessee-noir |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Similicuir stretch premium, doublure coton</li>
<li><strong>Couleur :</strong> noir avec détails dorés</li>
<li><strong>Composition :</strong> Guêpière longue, string assorti, menottes intégrées</li>
<li><strong>Fermeture :</strong> Lacets ajustables au dos</li>
<li><strong>Jarretières :</strong> 4 jarretières réglables incluses</li>
<li><strong>Détails :</strong> Inscriptions dorées "SPANKME" avant et arrière</li>
</ul> |
| | stylingtips | | | summary | | string | <p>En portant cette superbe longue guêpière grande taille en similicuir, vous ne cacherez rien de vos désirs.</p> |
| | title | | string | Longue Guêpière Fessée |
| | usageinstructions | | string | <p>Cet ensemble nécessite une <strong>communication claire avec votre partenaire</strong> avant utilisation. Les <strong>menottes intégrées</strong> offrent une restriction contrôlée - établissez toujours un <strong>mot de sécurité</strong> avant vos jeux. Le similicuir stretch permet une grande liberté de mouvement tout en maintenant l'aspect <strong>domination visuelle</strong>. Pour un <strong>confort optimal</strong>, portez d'abord l'ensemble quelques minutes pour vous habituer aux sensations.</p>
<p>Les <strong>jarretières réglables</strong> s'adaptent à votre morphologie - ajustez-les progressivement pour éviter toute gêne. L'inscription "SPANKME" crée une <strong>dynamique psychologique</strong> puissante qui intensifie l'expérience pour les deux partenaires.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Pulire delicatamente con acqua tiepida e un sapone delicato per similpelle</li>
<li>Asciugare naturalmente all'aria aperta, lontano dalla luce diretta</li>
<li>Applicare di tanto in tanto un prodotto per la cura della similpelle</li>
<li>Conservare in un luogo asciutto per preservare l'elasticità del materiale</li>
<li>Controllare regolarmente le condizioni delle manette e delle chiusure per verificarne la sicurezza.</li>
</ul> |
| | description | | string | Questa giarrettiera lunga è realizzata in ecopelle elasticizzata ed è comoda da indossare.<br /><br />Incorpora tre gioielli che chiedono al vostro partner di sculacciarvi: riuscirà a resistere?<br /><br />Giarrettiera, perizoma e manette regolabili inclusi. |
| | guid | | string | https://dev.divasboudoir.com/it/sculacciata-lunga-di-taglia-grande-guepiere-nero/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Manette integrate</strong> per un'esperienza BDSM completa e sicura</li>
<li>Comoda e resistente<strong>similpelle elasticizzata</strong> per tutti i giochi</li>
<li><strong>Design provocante</strong> con dettagli dorati "SPANKME" per affermare i vostri desideri</li>
<li><strong>Set completo di</strong> giarrettiera, perizoma e manette per una seduzione totale</li>
<li><strong>Giarrettiere regolabili</strong> per una vestibilità perfetta e un sostegno ottimale</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Indossate questo superbo bustier lungo e largo in ecopelle e non potrete più nascondere quello che volete. |
| | keywords | | | title | | string | Sculacciata lunga di taglia grande Guêpière |
|
| | seotitle | | string | Sculacciata lunga di taglia grande Guêpière |
| | seouri | | string | sculacciata-lunga-di-taglia-grande-guepiere-nero |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> ecopelle premium elasticizzata, fodera in cotone</li>
<li><strong>Colore:</strong> nero con dettagli dorati</li>
<li><strong>Composizione:</strong> bustier lungo, perizoma coordinato, manette integrate</li>
<li><strong>Chiusura:</strong> lacci regolabili sul retro</li>
<li><strong>Giarrettiere</strong>: 4 giarrettiere regolabili incluse</li>
<li><strong>Dettagli:</strong> scritta dorata "SPANKME" sul davanti e sul retro</li>
</ul> |
| | stylingtips | | string | <p>Completate questo look <strong>da dominatrice sicura di sé</strong> con <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">calze fetish a rete</a> o in vinile <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">di taglia grande</a> per una coerenza perfetta. Per le taglie standard, anche le nostre <a href="https://www.thebdsmboudoir.com/it/calze-in-lattice/">calze standard</a> offrono eccellenti opzioni di abbinamento. Aggiungete <strong>accessori BDSM complementari</strong> come collane o bracciali per intensificare l'effetto. Il set è indipendente, ma può essere arricchito con <strong> ulteriori elementi di costrizione</strong> in base alle vostre preferenze. Il contrasto nero e oro funziona perfettamente con gli accessori metallici per uno <strong>stile fetish coerente</strong>.</p> |
| | summary | | string | Indossate questo superbo bustier lungo e largo in ecopelle e non potrete più nascondere quello che volete. |
| | title | | string | Bustier lungo sculacciato |
| | usageinstructions | | string | <p>Questo set richiede <strong>una comunicazione chiara con il partner</strong> prima dell'uso. Le <strong>manette integrate</strong> assicurano una costrizione controllata: prima di giocare, stabilite sempre una <strong>parola di sicurezza</strong>. L'ecopelle elasticizzata consente libertà di movimento pur mantenendo il <strong>dominio visivo</strong>. Per un <strong>comfort ottimale</strong>, indossate il set per qualche minuto per abituarvi alla sensazione.</p>
<p>I <strong>reggicalze regolabili</strong> si adattano alla forma del corpo: regolateli gradualmente per evitare qualsiasi disagio. La scritta "SPANKME" crea una potente <strong>dinamica psicologica</strong> che intensifica l'esperienza per entrambi i partner.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Voorzichtig reinigen met lauw water en een milde zeep voor kunstleer</li>
<li>Droog op natuurlijke wijze in de open lucht, uit de buurt van direct licht</li>
<li>Af en toe een onderhoudsmiddel voor kunstleer gebruiken</li>
<li>Bewaar op een droge plaats om de soepelheid van het materiaal te behouden</li>
<li>Controleer regelmatig de staat van handboeien en sluitingen op veiligheid</li>
</ul> |
| | description | | string | Deze lange kousenband is gemaakt van stretch kunstleer en is comfortabel om te dragen.<br /><br />Het bevat drie juwelen die je partner vragen om je te slaan - zal hij je kunnen weerstaan?<br /><br />Inclusief verstelbare kousenbanden, string en handboeien. |
| | guid | | string | https://dev.divasboudoir.com/nl/lange-groote-maat-spanking-guepiere-zwart/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Geïntegreerde handboeien</strong> voor een complete en veilige BDSM-ervaring</li>
<li>Comfortabel en bestendig<strong>premium stretch kunstleer</strong> voor alle spelletjes</li>
<li><strong>Provocerend ontwerp</strong> met gouden "SPANKME" details om je verlangens te laten gelden</li>
<li><strong>Complete</strong> kousenband, string en handboeien<strong>set</strong> voor totale verleiding</li>
<li><strong>Verstelbare kousenbanden</strong> voor een perfecte pasvorm en optimale ondersteuning</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Draag deze prachtige lange, grote bustier van imitatieleer en je kunt niet verbergen wat je wilt. |
| | keywords | | | title | | string | Lange groote maat Spanking Guêpière |
|
| | seotitle | | string | Lange groote maat Spanking Guêpière |
| | seouri | | string | lange-groote-maat-spanking-guepiere-zwart |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Premium stretch kunstleer, katoenen voering</li>
<li><strong>Kleur:</strong> zwart met gouden details</li>
<li><strong>Samenstelling:</strong> Lange bustier, bijpassende string, geïntegreerde handboeien</li>
<li><strong>Sluiting:</strong> Verstelbare veters aan de achterkant</li>
<li><strong>Kousenband</strong>: 4 verstelbare kousenbanden inbegrepen</li>
<li><strong>Details:</strong> Gouden "SPANKME" belettering op voor- en achterkant</li>
</ul> |
| | stylingtips | | string | <p>Maak deze <strong>zelfverzekerde dominatrix</strong> look compleet met <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">grote maten visnet</a> of vinyl <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">fetisj kousen</a> voor een perfecte consistentie. Voor standaardmaten bieden onze <a href="https://www.thebdsmboudoir.com/nl/latex-kousen/">standaard kousen</a> ook uitstekende bijpassende opties. Voeg <strong>aanvullende BDSM-accessoires</strong> toe zoals een ketting of armbanden om het effect te versterken. De set staat op zichzelf, maar kan naar wens worden uitgebreid met <strong> extra boeien</strong>. Het contrast van zwart en goud werkt perfect met metallic accessoires voor een <strong>consistente fetisjstijl</strong>.</p> |
| | summary | | string | Draag deze prachtige lange, grote bustier van imitatieleer en je kunt niet verbergen wat je wilt. |
| | title | | string | Lange gespankte bustier |
| | usageinstructions | | string | <p>Deze set vereist <strong>duidelijke communicatie met je partner</strong> voor gebruik. <strong>Geïntegreerde handboeien</strong> zorgen voor gecontroleerde fixatie - spreek altijd een <strong>veilig woord</strong> af voordat je gaat spelen. Stretch kunstleer zorgt voor bewegingsvrijheid met behoud van <strong>visuele dominantie</strong>. Voor <strong>optimaal comfort</strong> draag je de set eerst een paar minuten om aan het gevoel te wennen.</p>
<p>De <strong>verstelbare kousenbanden</strong> passen zich aan je lichaamsvorm aan - pas ze geleidelijk aan om ongemak te voorkomen. De "SPANKME" inscriptie creëert een krachtige <strong>psychologische dynamiek</strong> die de ervaring voor beide partners intensiveert.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Limpar suavemente com água morna e um sabão suave para couro sintético</li>
<li>Secar naturalmente ao ar livre, longe da luz direta</li>
<li>Aplicar ocasionalmente um produto de tratamento para couro sintético</li>
<li>Conservar num local seco para preservar a flexibilidade do material</li>
<li>Verificar regularmente o estado das algemas e dos fechos para garantir a sua segurança</li>
</ul> |
| | description | | string | Esta liga comprida é feita de pele sintética elástica e é confortável de usar.<br /><br />Inclui três jóias que pedem ao seu parceiro para a espancar - será ele capaz de resistir?<br /><br />Inclui ligas ajustáveis, tanga e algemas. |
| | guid | | string | https://dev.divasboudoir.com/pt/guepiere-spanking-tamanho-grande-e-comprido-preto/drbu9040.htm |
| | highlights | | string | <ul>
<li><strong>Algemas integradas</strong> para uma experiência BDSM completa e segura</li>
<li><strong>Couro sintético elástico de primeira qualidade</strong>, confortável e resistente para todos os jogos</li>
<li><strong>Design provocante</strong> com detalhes dourados "SPANKME" para afirmar os seus desejos</li>
<li><strong>Conjunto completo de</strong> liga, tanga e algemas para uma sedução total</li>
<li><strong>Ligas ajustáveis</strong> para um ajuste perfeito e um apoio ótimo</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Use este magnífico corpete comprido, grande e em pele sintética e não há como esconder o que quer. |
| | keywords | | | title | | string | Guêpière Spanking tamanho grande e comprido |
|
| | seotitle | | string | Guêpière Spanking tamanho grande e comprido |
| | seouri | | string | guepiere-spanking-tamanho-grande-e-comprido-preto |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Pele sintética elástica de alta qualidade, forro de algodão</li>
<li><strong>Cor:</strong> preto com pormenores dourados</li>
<li><strong>Composição:</strong> Corpete comprido, tanga a condizer, algemas integradas</li>
<li><strong>Aperto:</strong> atacadores ajustáveis nas costas</li>
<li><strong>Ligas</strong>: 4 ligas ajustáveis incluídas</li>
<li><strong>Pormenores:</strong> letras douradas "SPANKME" na frente e nas costas</li>
</ul> |
| | stylingtips | | string | <p>Complete este look <strong>de dominatrix confiante</strong> com <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">meias de rede</a> ou <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">meias</a> de vinil de <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">fetiche</a> de tamanho grande para uma consistência perfeita. Para tamanhos normais, <a href="https://www.thebdsmboudoir.com/pt/meias-de-latex/">as</a> nossas <a href="https://www.thebdsmboudoir.com/pt/meias-de-latex/">meias normais</a> também oferecem excelentes opções de combinação. Adicione <strong>acessórios BDSM complementares</strong> como um colar ou pulseiras para intensificar o efeito. O conjunto mantém-se por si só, mas pode ser melhorado com <strong> elementos de contenção adicionais</strong> de acordo com as suas preferências. O contraste preto e dourado funciona perfeitamente com acessórios metálicos para um <strong>estilo fetiche consistente</strong>.</p> |
| | summary | | string | Use este magnífico corpete comprido, grande e em pele sintética e não há como esconder o que quer. |
| | title | | string | Corpete comprido com palmatória |
| | usageinstructions | | string | <p>Este conjunto requer <strong>uma comunicação clara com o seu parceiro</strong> antes de ser utilizado. <strong>As algemas integradas</strong> proporcionam uma contenção controlada - estabeleça sempre uma <strong>palavra de segurança</strong> antes de brincar. A pele sintética elástica permite liberdade de movimentos enquanto mantém <strong>o domínio visual</strong>. Para um <strong>conforto ótimo</strong>, use primeiro o conjunto durante alguns minutos para se habituar à sensação.</p>
<p>As <strong>ligas ajustáveis</strong> adaptam-se à forma do seu corpo - ajuste-as gradualmente para evitar qualquer desconforto. A inscrição "SPANKME" cria uma poderosa <strong>dinâmica psicológica</strong> que intensifica a experiência para ambos os parceiros.</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 | | string | <ul>
<li>Sanft mit lauwarmem Wasser und einer milden Spezialseife für Kunstleder reinigen</li>
<li>Natürlich an der Luft trocknen, vor direktem Licht geschützt</li>
<li>Gelegentlich ein Pflegemittel für Kunstleder auftragen</li>
<li>An einem trockenen Ort aufbewahren, um die Geschmeidigkeit des Materials zu erhalten</li>
<li>Überprüfen Sie regelmäßig den Zustand der Handschellen und der Fesseln für die Sicherheit</li>
</ul> |
| | description | | string | Dieses Set besteht aus einem langen Mieder aus Kunstleder mit Stretchanteil, das angenehm zu tragen ist.<br /><br />Es enthält drei Schmuckstücke, die Ihren Partner dazu auffordern, Ihnen den Hintern zu versohlen, ob er dem widerstehen kann?<br /><br />Verstellbare Strumpfbänder, String und Handschellen sind im Lieferumfang enthalten. |
| | highlights | | string | <ul>
<li><strong>Integrierte Handschellen</strong> für ein umfassendes und sicheres BDSM-Erlebnis</li>
<li>Bequemes und strapazierfähiges<strong>Premium-Stretch-Kunstleder</strong> für alle Spiele</li>
<li><strong>Provokantes Design</strong> mit goldenen "SPANKME"-Details, um Ihre Wünsche zu unterstreichen</li>
<li><strong>Komplettes Set</strong> aus Mieder, String und Handschellen für totale Verführung</li>
<li><strong>Verstellbare Strumpfbänder</strong> für eine perfekte Passform und optimalen Halt</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Wenn Sie dieses wunderschöne lange Mieder aus Kunstleder tragen, werden Sie nichts von Ihren Wünschen verbergen. |
| | keywords | | | title | | string | Kunstleder-Set Prügel |
|
| | seotitle | | string | Kunstleder-Set Prügel |
| | seouri | | string | kunstleder-set-prugel-schwarz |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Premium-Stretch-Kunstleder, Baumwollfutter</li>
<li><strong>Farbe:</strong> Schwarz mit goldenen Details</li>
<li><strong>Zusammensetzung:</strong> Langes Guêpière, passender String, integrierte Handschellen</li>
<li><strong>Verschluss: Ver</strong> stellbare Schnürsenkel im Rücken</li>
<li><strong>Strumpfbänder:</strong> 4 verstellbare Strumpfbänder enthalten</li>
<li><strong>Details:</strong> Goldene "SPANKME"-Schriftzüge vorne und hinten</li>
</ul> |
| | stylingtips | | string | <p>Vervollständigen Sie diesen Look der <strong>selbstbewussten Domina</strong> mit <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">Fetisch-Strümpfen in Übergröße</a> aus Netz oder Vinyl, um eine perfekte Übereinstimmung zu erzielen. Für Standardgrößen bieten unsere <a href="https://www.thebdsmboudoir.com/de/latexstrumpfe/">Strümpfe in Standardgrößen</a> ebenfalls hervorragende Kombinationsmöglichkeiten. Fügen Sie <strong>ergänzende BDSM-Accessoires</strong> wie eine Halskette oder Armbänder hinzu, um den Effekt zu intensivieren. Das Ensemble steht für sich allein, kann aber je nach Vorliebe mit <strong> zusätzlichen Zwangselementen</strong> angereichert werden. Der Schwarz-Gold-Kontrast harmoniert perfekt mit Metall-Accessoires für einen <strong>stimmigen Fetisch-Stil</strong>.</p> |
| | summary | | string | Wenn Sie dieses wunderschöne lange Mieder aus Kunstleder tragen, werden Sie nichts von Ihren Wünschen verbergen. |
| | title | | string | Kunstleder-Set Prügel |
| | usageinstructions | | string | <p>Dieses Set erfordert eine <strong>klare Kommunikation mit Ihrem Partner</strong> vor der Benutzung. Die <strong>eingebauten Handschellen</strong> bieten eine kontrollierte Einschränkung - legen Sie vor Ihren Spielen immer ein <strong>Sicherheitswort</strong> fest. Das stretchige Kunstleder ermöglicht Bewegungsfreiheit, während der Aspekt der <strong>visuellen Dominanz</strong> erhalten bleibt. Für <strong>optimalen Tragekomfort</strong> tragen Sie das Set zunächst einige Minuten, um sich an das Gefühl zu gewöhnen.</p>
<p>Die <strong>verstellbaren Strumpfbänder</strong> passen sich Ihrer Körperform an - stellen Sie sie schrittweise ein, um Beschwerden zu vermeiden. Der Schriftzug "SPANKME" erzeugt eine starke <strong>psychologische Dynamik</strong>, die das Erlebnis für beide Partner intensiviert.</p> |
|
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Καθαρίστε απαλά με χλιαρό νερό και ένα ήπιο σαπούνι για δερματίνη</li>
<li>Στεγνώστε φυσικά στον καθαρό αέρα, μακριά από το άμεσο φως</li>
<li>Εφαρμόζετε περιστασιακά ένα προϊόν περιποίησης δερματίνης</li>
<li>Αποθηκεύστε σε ξηρό μέρος για να διατηρήσετε την ελαστικότητα του υλικού</li>
<li>Ελέγχετε τακτικά την κατάσταση των χειροπέδων και των συνδέσμων για την ασφάλεια</li>
</ul> |
| | description | | string | Αυτό το σετ αποτελείται από μια μακριά καλτσοδέτα από ελαστικό faux leather που φοριέται άνετα.<br /><br />Ενσωματώνει τρία κοσμήματα που ζητούν από τον σύντροφό σας να σας δείρει - θα μπορέσει να αντισταθεί;<br /><br />Περιλαμβάνονται ρυθμιζόμενες καλτσοδέτες, στρινγκ και χειροπέδες. |
| | highlights | | string | <ul>
<li><strong>Ενσωματωμένες χειροπέδες</strong> για μια πλήρη και ασφαλή εμπειρία BDSM</li>
<li>Άνετη και ανθεκτική<strong>premium stretch δερματίνη</strong> για όλα τα παιχνίδια</li>
<li><strong>Προκλητικός σχεδιασμός</strong> με χρυσές λεπτομέρειες "SPANKME" για να διεκδικήσετε τις επιθυμίες σας</li>
<li><strong>Πλήρες σετ</strong> καλτσοδέτας, στρινγκ και χειροπέδων για απόλυτη αποπλάνηση</li>
<li><strong>Ρυθμιζόμενες καλτσοδέτες</strong> για τέλεια εφαρμογή και βέλτιστη στήριξη</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Φορέστε αυτό το υπέροχο μακρύ μπουστάκι από ψεύτικο δέρμα και δεν θα κρύψετε τις επιθυμίες σας. |
| | keywords | | | title | |
| | seotitle | | | seouri | | string | set-apo-dermatinh-mayro |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Premium stretch faux leather, βαμβακερή επένδυση</li>
<li><strong>Χρώμα:</strong> μαύρο με χρυσές λεπτομέρειες</li>
<li><strong>Σύνθεση:</strong> Μακρύ μπουστάκι, ασορτί στρινγκ, ενσωματωμένες χειροπέδες</li>
<li><strong>Κλείσιμο:</strong> Ρυθμιζόμενα κορδόνια στο πίσω μέρος</li>
<li><strong>Καλτσοδέτες</strong>: Περιλαμβάνονται 4 ρυθμιζόμενες καλτσοδέτες</li>
<li><strong>Λεπτομέρειες:</strong> Χρυσά γράμματα "SPANKME" μπροστά και πίσω</li>
</ul> |
| | stylingtips | | string | <p>Ολοκληρώστε την εμφάνιση <strong>dominatrix</strong> με <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">κάλτσες φετίχ από δίχτυ</a> ή βινύλιο για τέλεια συνοχή. Για τα τυπικά μεγέθη, οι <a href="https://www.thebdsmboudoir.com/el/kaltses-latex/">τυποποιημένες κάλτσες</a> μας προσφέρουν επίσης εξαιρετικές επιλογές ταιριάσματος. Προσθέστε <strong>συμπληρωματικά αξεσουάρ BDSM</strong>, όπως ένα κολιέ ή βραχιόλια, για να εντείνετε το αποτέλεσμα. Το σετ στέκεται από μόνο του, αλλά μπορεί να ενισχυθεί με <strong> πρόσθετα στοιχεία περιορισμού</strong> ανάλογα με τις προτιμήσεις σας. Η αντίθεση του μαύρου και του χρυσού λειτουργεί τέλεια με μεταλλικά αξεσουάρ για ένα <strong>συνεπές φετίχ στυλ</strong>.</p> |
| | summary | | string | Φορέστε αυτό το υπέροχο μακρύ μπουστάκι από ψεύτικο δέρμα και δεν θα κρύψετε τις επιθυμίες σας. |
| | title | | | usageinstructions | | string | <p>Αυτό το σετ απαιτεί <strong>σαφή επικοινωνία με τον σύντροφό σας</strong> πριν από τη χρήση. <strong>Οι ενσωματωμένες χειροπέδες</strong> παρέχουν ελεγχόμενη συγκράτηση - πάντα να καθορίζετε μια <strong>ασφαλή λέξη</strong> πριν από το παιχνίδι σας. Το ελαστικό ψεύτικο δέρμα επιτρέπει την ελευθερία κινήσεων, διατηρώντας παράλληλα την <strong>οπτική κυριαρχία</strong>. Για <strong>βέλτιστη άνεση</strong>, φορέστε πρώτα το σετ για λίγα λεπτά για να συνηθίσετε την αίσθηση.</p>
<p>Οι <strong>ρυθμιζόμενες καλτσοδέτες</strong> προσαρμόζονται στο σχήμα του σώματός σας - ρυθμίστε τις σταδιακά για να αποφύγετε οποιαδήποτε δυσφορία. Η επιγραφή "SPANKME" δημιουργεί μια ισχυρή <strong>ψυχολογική δυναμική</strong> που εντείνει την εμπειρία και για τους δύο συντρόφους.</p> |
|
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Gently clean with lukewarm water and a mild leatherette soap</li>
<li>Dry naturally in the open air, away from direct light</li>
<li>Occasionally apply a leatherette care product</li>
<li>Store in a dry place to preserve the suppleness of the material</li>
<li>Regularly check the condition of handcuffs and safety fasteners</li>
</ul> |
| | description | | string | This set consists of a long garter in stretch imitation leather, comfortable to wear.<br /><br />It incorporates three jewels that ask your partner to spank you - will he be able to resist?<br /><br />Adjustable garters, thong and handcuffs included. |
| | highlights | | string | <ul>
<li><strong>Integrated handcuffs</strong> for a complete and secure BDSM experience</li>
<li>Comfortable, durable<strong>premium stretch imitation leather</strong> for all types of play</li>
<li><strong>Provocative design</strong> with gold "SPANKME" details to assert your desires</li>
<li><strong>Complete</strong> garter, thong and handcuff<strong>set</strong> for total seduction</li>
<li><strong>Adjustable garters</strong> for a perfect fit and optimum support</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | When you wear this gorgeous, long, faux-leather guêpière, you'll hide nothing of your desires. |
| | keywords | | | title | | string | Spanked leatherette set |
|
| | seotitle | | string | Spanked leatherette set |
| | seouri | | string | spanked-leatherette-set-black |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Premium stretch leatherette, cotton lining</li>
<li><strong>Color:</strong> black with gold details</li>
<li><strong>Composition:</strong> Long basque, matching thong, integrated handcuffs</li>
<li><strong>Closure:</strong> Adjustable back laces</li>
<li><strong>Garters:</strong> 4 adjustable garters included</li>
<li><strong>Details:</strong> Gold "SPANKME" lettering front and back</li>
</ul> |
| | stylingtips | | string | <p>Complement this <strong>confident dominatrix</strong> look with <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">plus size fetish stockings</a> in fishnet or vinyl for perfect consistency. For standard sizes, our <a href="https://www.thebdsmboudoir.com/en/latex-stockings/">standard stockings</a> also offer excellent matching options. Add <strong>complementary BDSM accessories</strong> like a necklace or bracelets to intensify the effect. The set stands on its own, but can be enriched with <strong> additional constraining elements</strong> to suit your preferences. Black and gold contrast perfectly with metallic accessories for a <strong>consistent fetish style</strong>.</p> |
| | summary | | string | When you wear this gorgeous, long, faux-leather guêpière, you'll hide nothing of your desires. |
| | title | | string | Spanked leatherette set |
| | usageinstructions | | string | <p>This set requires <strong>clear communication with your partner</strong> before use. <strong>Integrated handcuffs</strong> offer controlled restraint - always establish a <strong>safe word</strong> before your play. Stretch faux leather allows freedom of movement while maintaining <strong>visual dominance</strong>. For <strong>optimum comfort</strong>, first wear the set for a few minutes to get used to the sensations.</p>
<p>The <strong>adjustable garters</strong> adapt to your body shape - adjust them gradually to avoid any discomfort. The "SPANKME" inscription creates a powerful <strong>psychological dynamic</strong> that intensifies the experience for both partners.</p> |
|
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Limpiar suavemente con agua tibia y un jabón suave para cuero artificial</li>
<li>Secar de forma natural al aire libre, lejos de la luz directa</li>
<li>Aplique de vez en cuando un producto para el cuidado del polipiel</li>
<li>Guardar en un lugar seco para preservar la flexibilidad del material</li>
<li>Compruebe regularmente el estado de las esposas y los cierres para mayor seguridad</li>
</ul> |
| | description | | string | Este conjunto consta de un liguero largo de piel sintética elástica muy cómodo de llevar.<br /><br />Incorpora tres joyas que piden a tu pareja que te azote - ¿podrá resistirse?<br /><br />Incluye ligueros ajustables, tanga y esposas. |
| | highlights | | string | <ul>
<li><strong>Esposas integradas</strong> para una experiencia BDSM completa y segura</li>
<li>Cómoda y resistente<strong>polipiel elástica premium</strong> para todos los juegos</li>
<li><strong>Diseño provocativo</strong> con detalles dorados "SPANKME" para reafirmar tus deseos</li>
<li><strong>Juego completo de</strong> liguero, tanga y esposas para una seducción total</li>
<li><strong>Ligas ajustables</strong> para un ajuste perfecto y una sujeción óptima</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ponte este magnífico corpiño largo de piel sintética y no ocultarás tus deseos. |
| | keywords | | | title | |
| | seotitle | | | seouri | | string | juego-de-polipiel-negro |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Piel sintética elástica de primera calidad, forro de algodón</li>
<li><strong>Color:</strong> negro con detalles dorados</li>
<li><strong>Composición:</strong> corpiño largo, tanga a juego, esposas integradas</li>
<li><strong>Cierre:</strong> cordones ajustables en la espalda</li>
<li><strong>Ligueros</strong>: 4 ligueros ajustables incluidos</li>
<li><strong>Detalles:</strong> Letras doradas "SPANKME" en la parte delantera y trasera</li>
</ul> |
| | stylingtips | | string | <p>Completa este look <strong>de dominatrix segura de sí misma</strong> con <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">medias fetiche de rejilla</a> o vinilo <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">de talla grande</a> para una consistencia perfecta. Para tallas estándar, nuestras <a href="https://www.thebdsmboudoir.com/es/medias-de-latex/">medias estándar</a> también ofrecen excelentes opciones de combinación. Añade <strong>accesorios BDSM complementarios</strong> como un collar o pulseras para intensificar el efecto. El conjunto se sostiene por sí solo, pero puede mejorarse con <strong> elementos de sujeción adicionales</strong> para adaptarlo a sus preferencias. El contraste negro y dorado funciona perfectamente con accesorios metálicos para un <strong>estilo fetichista coherente</strong>.</p> |
| | summary | | string | Ponte este magnífico corpiño largo de piel sintética y no ocultarás tus deseos. |
| | title | | | usageinstructions | | string | <p>Este juego requiere <strong>una comunicación clara con su pareja</strong> antes de usarlo. <strong>Las esposas integradas</strong> proporcionan una inmovilización controlada: establece siempre una <strong>palabra de seguridad</strong> antes de jugar. La piel sintética elástica permite libertad de movimientos a la vez que mantiene <strong>el dominio visual</strong>. Para <strong>una comodidad óptima</strong>, primero usa el conjunto durante unos minutos para acostumbrarte a la sensación.</p>
<p>Los <strong>ligueros ajustables</strong> se adaptan a la forma de tu cuerpo: ajústalos gradualmente para evitar cualquier molestia. La inscripción "SPANKME" crea una potente <strong>dinámica psicológica</strong> que intensifica la experiencia para ambos miembros de la pareja.</p> |
|
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Nettoyer délicatement à l'eau tiède avec un savon doux spécial similicuir</li>
<li>Sécher naturellement à l'air libre, à l'abri de la lumière directe</li>
<li>Appliquer occasionnellement un produit d'entretien pour similicuir</li>
<li>Ranger dans un endroit sec pour préserver la souplesse du matériau</li>
<li>Vérifier régulièrement l'état des menottes et des attaches pour la sécurité</li>
</ul> |
| | description | | string | <p>Cet ensemble fétichiste noir incarne la <strong>provocation assumée</strong> et l'<strong>expérience BDSM authentique</strong>. La longue guêpière en <strong>similicuir stretch hypoallergénique certifié</strong> épouse parfaitement les courbes tout en offrant un confort optimal durant vos jeux les plus intenses. Les <strong>menottes intégrées</strong> transforment cet ensemble en véritable <strong>accessoire de soumission sécurisé</strong>, permettant une exploration du BDSM en toute confiance.</p>
<p>Les détails dorés "SPANKME" (FESSEZ-MOI) à l'avant et à l'arrière affirment clairement vos intentions, créant une <strong>tension érotique immédiate</strong> avec votre partenaire.</p>
<p>Le <strong>système de jarretières réglables</strong> assure un maintien parfait tout en facilitant l'association avec vos bas préférés. Cet ensemble <strong>haut de gamme</strong> combine esthétique provocante et envie <strong>BDSM </strong>pour une expérience de domination et soumission inoubliable.</p> |
| | highlights | | string | <ul>
<li><strong>Menottes intégrées</strong> pour une expérience BDSM complète et sécurisée</li>
<li><strong>Similicuir stretch premium</strong> confortable et résistant pour tous les jeux</li>
<li><strong>Design provocant</strong> avec détails dorés "SPANKME" pour affirmer vos désirs</li>
<li><strong>Ensemble complet</strong> guêpière, string et menottes pour une séduction totale</li>
<li><strong>Jarretières réglables</strong> pour un ajustement parfait et un maintien optimal</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ensemble fétichiste noir similicuir avec menottes intégrées. Guêpière longue, string et jarretières pour expérience BDSM authentique. Livraison discrète. The BDSM Boudoir. |
| | keywords | | | title | | string | Ensemble BDSM Menottes Intégrées Grande Taille | The BDSM Boudoir |
|
| | seotitle | | string | Ensemble BDSM grande taille similicuir noir avec menottes intégrées |
| | seouri | | string | ensemble-bdsm-menottes-integrees-grande-taille |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Similicuir stretch premium, doublure coton</li>
<li><strong>Couleur :</strong> noir avec détails dorés</li>
<li><strong>Composition :</strong> Guêpière longue, string assorti, menottes intégrées</li>
<li><strong>Fermeture :</strong> Lacets ajustables au dos</li>
<li><strong>Jarretières :</strong> 4 jarretières réglables incluses</li>
<li><strong>Détails :</strong> Inscriptions dorées "SPANKME" avant et arrière</li>
</ul> |
| | stylingtips | | string | <p>Complétez ce look <strong>dominatrice assumée</strong> avec des <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">bas fétichistes grande taille</a> en résille ou vinyle pour une cohérence parfaite. Pour les tailles standard, nos <a href="https://www.thebdsmboudoir.com/fr/bas-en-latex/">bas taille standard</a> offrent également d'excellentes options d'association. Ajoutez des <strong>accessoires BDSM complémentaires</strong> comme un collier ou des bracelets pour intensifier l'effet. L'ensemble se suffit à lui-même mais peut être enrichi par des <strong>éléments de contrainte supplémentaires</strong> selon vos préférences. Le contraste noir et doré s'harmonise parfaitement avec des accessoires métalliques pour un <strong>style fétichiste cohérent</strong>.</p> |
| | summary | | string | <p>Ensemble fétichiste complet en similicuir stretch noir composé d'une longue guêpière et de son string assorti.</p>
<p>Avec menottes intégrées et message provocant "<strong>SPANKME</strong>" (FESSEZ-MOI) en détails dorés pour une expérience BDSM authentique et sécurisée.</p> |
| | title | | string | Ensemble fétichiste noir similicuir avec menottes intégrées. |
| | usageinstructions | | string | <p>Cet ensemble nécessite une <strong>communication claire avec votre partenaire</strong> avant utilisation. Les <strong>menottes intégrées</strong> offrent une restriction contrôlée - établissez toujours un <strong>mot de sécurité</strong> avant vos jeux. Le similicuir stretch permet une grande liberté de mouvement tout en maintenant l'aspect <strong>domination visuelle</strong>. Pour un <strong>confort optimal</strong>, portez d'abord l'ensemble quelques minutes pour vous habituer aux sensations.</p>
<p>Les <strong>jarretières réglables</strong> s'adaptent à votre morphologie - ajustez-les progressivement pour éviter toute gêne. L'inscription "SPANKME" crée une <strong>dynamique psychologique</strong> puissante qui intensifie l'expérience pour les deux partenaires.</p> |
|
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Pulire delicatamente con acqua tiepida e un sapone delicato per similpelle</li>
<li>Asciugare naturalmente all'aria aperta, lontano dalla luce diretta</li>
<li>Applicare di tanto in tanto un prodotto per la cura della similpelle</li>
<li>Conservare in un luogo asciutto per preservare l'elasticità del materiale</li>
<li>Controllare regolarmente le condizioni delle manette e delle chiusure per verificarne la sicurezza.</li>
</ul> |
| | description | | string | Questo set è composto da una giarrettiera lunga in ecopelle elasticizzata, comoda da indossare.<br /><br />Incorpora tre gioielli che chiedono al vostro partner di sculacciarvi: riuscirà a resistere?<br /><br />Giarrettiera, perizoma e manette regolabili inclusi. |
| | highlights | | string | <ul>
<li><strong>Manette integrate</strong> per un'esperienza BDSM completa e sicura</li>
<li>Comoda e resistente<strong>similpelle elasticizzata</strong> per tutti i giochi</li>
<li><strong>Design provocante</strong> con dettagli dorati "SPANKME" per affermare i vostri desideri</li>
<li><strong>Set completo di</strong> giarrettiera, perizoma e manette per una seduzione totale</li>
<li><strong>Giarrettiere regolabili</strong> per una vestibilità perfetta e un sostegno ottimale</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Indossate questo superbo bustier lungo in ecopelle e non farete mistero dei vostri desideri. |
| | keywords | | | title | | string | Set in similpelle sculacciata |
|
| | seotitle | | string | Set in similpelle sculacciata |
| | seouri | | string | set-in-similpelle-sculacciata-nero |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> ecopelle premium elasticizzata, fodera in cotone</li>
<li><strong>Colore:</strong> nero con dettagli dorati</li>
<li><strong>Composizione:</strong> bustier lungo, perizoma coordinato, manette integrate</li>
<li><strong>Chiusura:</strong> lacci regolabili sul retro</li>
<li><strong>Giarrettiere</strong>: 4 giarrettiere regolabili incluse</li>
<li><strong>Dettagli:</strong> scritta dorata "SPANKME" sul davanti e sul retro</li>
</ul> |
| | stylingtips | | string | <p>Completate questo look <strong>da dominatrice sicura di sé</strong> con <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">calze fetish a rete</a> o in vinile <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">di taglia grande</a> per una coerenza perfetta. Per le taglie standard, anche le nostre <a href="https://www.thebdsmboudoir.com/it/calze-in-lattice/">calze standard</a> offrono eccellenti opzioni di abbinamento. Aggiungete <strong>accessori BDSM complementari</strong> come collane o bracciali per intensificare l'effetto. Il set è indipendente, ma può essere arricchito con <strong> ulteriori elementi di costrizione</strong> in base alle vostre preferenze. Il contrasto nero e oro funziona perfettamente con gli accessori metallici per uno <strong>stile fetish coerente</strong>.</p> |
| | summary | | string | Indossate questo superbo bustier lungo in ecopelle e non farete mistero dei vostri desideri. |
| | title | | string | Set in similpelle sculacciata |
| | usageinstructions | | string | <p>Questo set richiede <strong>una comunicazione chiara con il partner</strong> prima dell'uso. Le <strong>manette integrate</strong> assicurano una costrizione controllata: prima di giocare, stabilite sempre una <strong>parola di sicurezza</strong>. L'ecopelle elasticizzata consente libertà di movimento pur mantenendo il <strong>dominio visivo</strong>. Per un <strong>comfort ottimale</strong>, indossate il set per qualche minuto per abituarvi alla sensazione.</p>
<p>I <strong>reggicalze regolabili</strong> si adattano alla forma del corpo: regolateli gradualmente per evitare qualsiasi disagio. La scritta "SPANKME" crea una potente <strong>dinamica psicologica</strong> che intensifica l'esperienza per entrambi i partner.</p> |
|
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Voorzichtig reinigen met lauw water en een milde zeep voor kunstleer</li>
<li>Droog op natuurlijke wijze in de open lucht, uit de buurt van direct licht</li>
<li>Af en toe een onderhoudsmiddel voor kunstleer gebruiken</li>
<li>Bewaar op een droge plaats om de soepelheid van het materiaal te behouden</li>
<li>Controleer regelmatig de staat van handboeien en sluitingen op veiligheid</li>
</ul> |
| | description | | string | Deze set bestaat uit een lange kousenband van stretch kunstleer die comfortabel zit.<br /><br />Het bevat drie juwelen die je partner vragen om je te slaan - zal hij je kunnen weerstaan?<br /><br />Inclusief verstelbare kousenbanden, string en handboeien. |
| | highlights | | string | <ul>
<li><strong>Geïntegreerde handboeien</strong> voor een complete en veilige BDSM-ervaring</li>
<li>Comfortabel en bestendig<strong>premium stretch kunstleer</strong> voor alle spelletjes</li>
<li><strong>Provocerend ontwerp</strong> met gouden "SPANKME" details om je verlangens te laten gelden</li>
<li><strong>Complete</strong> kousenband, string en handboeien<strong>set</strong> voor totale verleiding</li>
<li><strong>Verstelbare kousenbanden</strong> voor een perfecte pasvorm en optimale ondersteuning</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Draag deze prachtige lange bustier van imitatieleer en je zult geen geheim maken van je verlangens. |
| | keywords | | | title | | string | Gestreepte kunstlederen set |
|
| | seotitle | | string | Gestreepte kunstlederen set |
| | seouri | | string | gestreepte-kunstlederen-set-zwart |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Premium stretch kunstleer, katoenen voering</li>
<li><strong>Kleur:</strong> zwart met gouden details</li>
<li><strong>Samenstelling:</strong> Lange bustier, bijpassende string, geïntegreerde handboeien</li>
<li><strong>Sluiting:</strong> Verstelbare veters aan de achterkant</li>
<li><strong>Kousenband</strong>: 4 verstelbare kousenbanden inbegrepen</li>
<li><strong>Details:</strong> Gouden "SPANKME" belettering op voor- en achterkant</li>
</ul> |
| | stylingtips | | string | <p>Maak deze <strong>zelfverzekerde dominatrix</strong> look compleet met <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">grote maten visnet</a> of vinyl <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">fetisj kousen</a> voor een perfecte consistentie. Voor standaardmaten bieden onze <a href="https://www.thebdsmboudoir.com/nl/latex-kousen/">standaard kousen</a> ook uitstekende bijpassende opties. Voeg <strong>aanvullende BDSM-accessoires</strong> toe zoals een ketting of armbanden om het effect te versterken. De set staat op zichzelf, maar kan naar wens worden uitgebreid met <strong> extra boeien</strong>. Het contrast van zwart en goud werkt perfect met metallic accessoires voor een <strong>consistente fetisjstijl</strong>.</p> |
| | summary | | string | Draag deze prachtige lange bustier van imitatieleer en je zult geen geheim maken van je verlangens. |
| | title | | string | Gestreepte kunstlederen set |
| | usageinstructions | | string | <p>Deze set vereist <strong>duidelijke communicatie met je partner</strong> voor gebruik. <strong>Geïntegreerde handboeien</strong> zorgen voor gecontroleerde fixatie - spreek altijd een <strong>veilig woord</strong> af voordat je gaat spelen. Stretch kunstleer zorgt voor bewegingsvrijheid met behoud van <strong>visuele dominantie</strong>. Voor <strong>optimaal comfort</strong> draag je de set eerst een paar minuten om aan het gevoel te wennen.</p>
<p>De <strong>verstelbare kousenbanden</strong> passen zich aan je lichaamsvorm aan - pas ze geleidelijk aan om ongemak te voorkomen. De "SPANKME" inscriptie creëert een krachtige <strong>psychologische dynamiek</strong> die de ervaring voor beide partners intensiveert.</p> |
|
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Limpar suavemente com água morna e um sabão suave para couro sintético</li>
<li>Secar naturalmente ao ar livre, longe da luz direta</li>
<li>Aplicar ocasionalmente um produto de tratamento para couro sintético</li>
<li>Conservar num local seco para preservar a flexibilidade do material</li>
<li>Verificar regularmente o estado das algemas e dos fechos para garantir a sua segurança</li>
</ul> |
| | description | | string | Este conjunto é composto por uma liga comprida em pele sintética elástica que é confortável de usar.<br /><br />Incorpora três jóias que pedem ao seu parceiro para a espancar - será ele capaz de resistir?<br /><br />Inclui ligas ajustáveis, tanga e algemas. |
| | highlights | | string | <ul>
<li><strong>Algemas integradas</strong> para uma experiência BDSM completa e segura</li>
<li><strong>Couro sintético elástico de primeira qualidade</strong>, confortável e resistente para todos os jogos</li>
<li><strong>Design provocante</strong> com detalhes dourados "SPANKME" para afirmar os seus desejos</li>
<li><strong>Conjunto completo de</strong> liga, tanga e algemas para uma sedução total</li>
<li><strong>Ligas ajustáveis</strong> para um ajuste perfeito e um apoio ótimo</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Use este magnífico corpete comprido em pele sintética e não fará segredo dos seus desejos. |
| | keywords | | | title | | string | Conjunto de couro sintético batido |
|
| | seotitle | | string | Conjunto de couro sintético batido |
| | seouri | | string | conjunto-de-couro-sintetico-batido-preto |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Pele sintética elástica de alta qualidade, forro de algodão</li>
<li><strong>Cor:</strong> preto com pormenores dourados</li>
<li><strong>Composição:</strong> Corpete comprido, tanga a condizer, algemas integradas</li>
<li><strong>Aperto:</strong> atacadores ajustáveis nas costas</li>
<li><strong>Ligas</strong>: 4 ligas ajustáveis incluídas</li>
<li><strong>Pormenores:</strong> letras douradas "SPANKME" na frente e nas costas</li>
</ul> |
| | stylingtips | | string | <p>Complete este look <strong>de dominatrix confiante</strong> com <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">meias de rede</a> ou <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">meias</a> de vinil de <a href="https://www.thebdsmboudoir.com/fr/bas-fetichistes-grande-taille/">fetiche</a> de tamanho grande para uma consistência perfeita. Para tamanhos normais, <a href="https://www.thebdsmboudoir.com/pt/meias-de-latex/">as</a> nossas <a href="https://www.thebdsmboudoir.com/pt/meias-de-latex/">meias normais</a> também oferecem excelentes opções de combinação. Adicione <strong>acessórios BDSM complementares</strong> como um colar ou pulseiras para intensificar o efeito. O conjunto mantém-se por si só, mas pode ser melhorado com <strong> elementos de contenção adicionais</strong> de acordo com as suas preferências. O contraste preto e dourado funciona perfeitamente com acessórios metálicos para um <strong>estilo fetiche consistente</strong>.</p> |
| | summary | | string | Use este magnífico corpete comprido em pele sintética e não fará segredo dos seus desejos. |
| | title | | string | Conjunto de couro sintético batido |
| | usageinstructions | | string | <p>Este conjunto requer <strong>uma comunicação clara com o seu parceiro</strong> antes de ser utilizado. <strong>As algemas integradas</strong> proporcionam uma contenção controlada - estabeleça sempre uma <strong>palavra de segurança</strong> antes de brincar. A pele sintética elástica permite liberdade de movimentos enquanto mantém <strong>o domínio visual</strong>. Para um <strong>conforto ótimo</strong>, use primeiro o conjunto durante alguns minutos para se habituar à sensação.</p>
<p>As <strong>ligas ajustáveis</strong> adaptam-se à forma do seu corpo - ajuste-as gradualmente para evitar qualquer desconforto. A inscrição "SPANKME" cria uma poderosa <strong>dinâmica psicológica</strong> que intensifica a experiência para ambos os parceiros.</p> |
|
|
|
|
| name | | string | Guépière En Simili Cuir Grande Taille Avec Porte Jarretelles Et Menottes DG12820XBLK |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 6C3F43DB-C690-4705-998F66BB8331A990 |
|
| promountil | |
| rating | |
| recorduid | | string | 6C3F43DB-C690-4705-998F66BB8331A990 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.35 ms Record Count: 3 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,'333,1149,1387,1813,1815') > 0 and product_variations.productuid = '6C3F43DB-C690-4705-998F66BB8331A990' 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 | 333 | Queen | intlsize | black | Queen | Queen | -1 | 999999 | 0 | w | plus | lingerie | Queen | Queen | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | 102-112 | 91-97 | 107-112 | | | | | | | | 2 | 1387 | Queen++ | intlsize | black | Queen++ | Queen++ | -1 | 999999 | 0 | w | plus | lingerie | Queen | Queen++ | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 122-132 | 102-107 | 122-132 | | | | | | | | 3 | 1149 | Queen+ | intlsize | black | Queen+ | Queen+ | -1 | 999999 | 0 | w | plus | lingerie | Queen | Queen+ | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 112-122 | 97-102 | 112-122 | | | | | | |
|
| sizeranges | |
| sizes | | string | 333,1149,1387,1813,1815 |
|
| sizetype | |
| specifications | Struct Entries: 23 | | belly | | | bones | | | bra | | | breasts | | | bust | | | closing | | | crochtless | | | cups | | | cut | | | garter | | | halter | | | lacing | | | lining | | | modestypanel | | | panty | | | sheathing | | | sleeves | | | stocking | | | straps | | | stretch | | | suspenders | | | transparency | | | underwires | |
|
| stock | |
| stocks | Query Template: /system/api/product/stocks.cfc:25 Execution Time: 9.53 ms Record Count: 1 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 333 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1149 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1387 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1813 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1815 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 | 6C3F43DB-C690-4705-998F66BB8331A990 | A54C0990-B738-4D20-A9A6B0EED73C4BE7 | 333 | black | #000000 | Queen | Queen | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | Queen | intlsize | 49.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 12 | 0 | 0 | 12820X | 888368332557 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 8.75 ms Record Count: 3 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 333 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1149 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1387 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1813 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' 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 = '6C3F43DB-C690-4705-998F66BB8331A990' and product_variations.isactive = 1 and product_sizes.id_size = 1815 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 | A54C0990-B738-4D20-A9A6B0EED73C4BE7 | 333 | black | #000000 | Queen | Queen | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | Queen | intlsize | 49.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 12 | 0 | 0 | 12820X | 888368332557 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 49.125 | all | | | 2 | A54C0990-B738-4D20-A9A6B0EED73C4BE7 | 1149 | black | #000000 | Queen | Queen+ | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | Queen+ | intlsize | 49.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 12 | 0 | 0 | 12820X | 888368332557 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 49.125 | all | | | 3 | A54C0990-B738-4D20-A9A6B0EED73C4BE7 | 1387 | black | #000000 | Queen | Queen++ | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | Queen++ | intlsize | 49.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 12 | 0 | 0 | 12820X | 888368332557 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 49.125 | all | |
|
| vatrate | |
| warehouse | |