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.wellbeing.secret.attach |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | 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.598 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,'red') > 0 and product_variations.productuid = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 | red | color | red | red | red | #F50000 | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2021-04-01 14:19:42'} |
|
| 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 | bed-restraint-set-24928653001 |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-10-15 13:31:34'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.658 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','en') 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('09d7dee4-37fa-4e82-92e79b3cd3ffdced',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.33 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','en') and product_categories.language in ('all','en') 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 <> 'ATKI6835' 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/bdxa/atki6835/24928653001_nor_a.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdxa/atki6835/24928653001_nor_c.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdxa/atki6835/24928653001_nor_b.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/bdxa/atki6835/24928653001_nor_b.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Zwangsset für das Bett<br /><br />Es enthält X-förmige Gurte, die Sie unter der Matratze anbringen können, um Ihr Bett zu Ihrem Lieblingsspielplatz zu machen!<br /><br />Die Gurte sind verstellbar, sodass sie für die meisten Größen passen.</div>
<div> </div>
<div><br />Es enthält außerdemein Paar Handfesseln für die Handgelenke und ein Paar Fußfesseln für die Fußgelenke. <br /><br />Die Handschellen werden mit Klettverschlüssen geschlossen und sind mit D-Ringen ausgestattet, um die Karabinerhaken am Ende der vier Riemen, die das X bilden, einzuhängen.</div>
<div> </div>
<div>Sie bestehen aus weichem, strapazierfähigem Kunstleder und sind bequem genug, um Ihre Fantasien als Paar auszuleben!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/de/constraint-kit-fur-das-bett-rot/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Entdecken Sie die Freuden des Bondage und experimentieren Sie mit neuen Stellungen oder intensiven BDSM-Sitzungen und für unerwartete Freuden. |
| | keywords | | | title | | string | Constraint Kit für das Bett |
|
| | seotitle | | string | Constraint Kit für das Bett |
| | seouri | | string | constraint-kit-fur-das-bett-rot |
| | specifications | | | stylingtips | | | summary | | string | Entdecken Sie die Freuden des Bondage und experimentieren Sie mit neuen Stellungen oder intensiven BDSM-Sitzungen und für unerwartete Freuden. |
| | title | | string | Constraint Kit für das Bett |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Κιτ περιορισμού κρεβατιού<br /><br />Περιλαμβάνει ιμάντες σε σχήμα Χ για να τοποθετήσετε κάτω από το στρώμα για να κάνετε το κρεβάτι σας την αγαπημένη σας παιδική χαρά!<br /><br />Οι ιμάντες είναι ρυθμιζόμενοι για να ταιριάζουν στα περισσότερα μεγέθη.</div>
<div> </div>
<div><br />Περιλαμβάνει επίσης ένα ζευγάρι χειροπέδες για τους καρπούς και ένα ζευγάρι χειροπέδες για τον αστράγαλο. <br /><br />Οι χειροπέδες διαθέτουν κούμπωμα Velcro και κρίκους D για να στερεώσετε τους καραμπίνερ στο άκρο των 4 ιμάντων που σχηματίζουν το Χ.</div>
<div> </div>
<div>Κατασκευασμένες από εύκαμπτο, ανθεκτικό δέρμα απομίμησης, είναι αρκετά άνετες για να σας αφήσουν να εκπληρώσετε τις φαντασιώσεις σας ως ζευγάρι!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/el/kit-periorismoy-krevatioy-kokkino/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ανακαλύψτε την ευχαρίστηση της δουλείας και πειραματιστείτε με νέες στάσεις ή έντονες συνεδρίες BDSM για απροσδόκητες απολαύσεις. |
| | keywords | | | title | | string | Κιτ περιορισμού κρεβατιού |
|
| | seotitle | | string | Κιτ περιορισμού κρεβατιού |
| | seouri | | string | kit-periorismoy-krevatioy-kokkino |
| | specifications | | | stylingtips | | | summary | | string | Ανακαλύψτε την ευχαρίστηση της δουλείας και πειραματιστείτε με νέες στάσεις ή έντονες συνεδρίες BDSM για απροσδόκητες απολαύσεις. |
| | title | | string | Κιτ περιορισμού κρεβατιού |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Bed Constraint Kit<br /><br />Includes X-shaped straps to place under the mattress to make your bed your favorite playground!<br /><br />Straps are adjustable to fit most sizes.</div>
<div> </div>
<div><br />It also includes a pair of wrist cuffs and a pair of ankle cuffs. <br /><br />The handcuffs close with Velcro fasteners and are fitted with D-rings to attach carabiners to the ends of the 4 straps that form the X.</div>
<div> </div>
<div>Made from supple, hard-wearing imitation leather, they're comfortable enough to let you fulfill your fantasies as a couple!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/en/bed-constraint-kit-red/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Discover the pleasure of bondage, and experiment new positions or intense BDSM sessions for unexpected pleasures. |
| | keywords | | | title | |
| | seotitle | | | seouri | | string | bed-constraint-kit-red |
| | specifications | | | stylingtips | | | summary | | string | Discover the pleasure of bondage, and experiment new positions or intense BDSM sessions for unexpected pleasures. |
| | title | | | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Kit de restricción de cama<br /><br />Incluye correas en forma de X para colocar debajo del colchón y convertir la cama en su zona de juegos favorita<br /><br />Las correas son ajustables para adaptarse a la mayoría de los tamaños.</div>
<div> </div>
<div><br />También incluye un par de esposas para las muñecas y un par de esposas para los tobillos. <br /><br />Las esposas tienen cierres de velcro y anillas en D para fijar los mosquetones al extremo de las 4 correas que forman la X.</div>
<div> </div>
<div>Fabricadas en imitación de cuero flexible y resistente, son lo suficientemente cómodas como para que puedas hacer realidad tus fantasías en pareja</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/es/kit-de-restriccion-de-camas-rojo/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubre el placer del bondage y experimenta con nuevas posturas o intensas sesiones de BDSM para obtener placeres inesperados. |
| | keywords | | | title | | string | Kit de restricción de camas |
|
| | seotitle | | string | Kit de restricción de camas |
| | seouri | | string | kit-de-restriccion-de-camas-rojo |
| | specifications | | | stylingtips | | | summary | | string | Descubre el placer del bondage y experimenta con nuevas posturas o intensas sesiones de BDSM para obtener placeres inesperados. |
| | title | | string | Kit de restricción de camas |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Kit de Contraintes pour le Lit<br /><br />Il comprend des sangles en X à placer sous le matelas pour faire de votre lit votre terrain de jeux préféré !<br /><br />Les sangles sont ajustables pour s’adapter à la plupart des tailles.</div>
<div> </div>
<div> <br />Il comprend égalementune paire de menottes pour les poignets et une paire de menottes pour les chevilles. <br /><br />Les menottes se ferment avec des scratchs et sont équipées d’anneaux en D afin d’y accrocher les mousquetons au bout des 4 sangles qui forment le X.</div>
<div> </div>
<div>Fabriquées en similicuir souple et résistant, elles seront suffisamment confortables pour vous permettre de réaliser vos fantasmes en couple !</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/fr/kit-de-contraintes-pour-le-lit-rouge/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Découvrez le plaisir du bondage, et expérimentez de nouvelles positions ou de séances BDSM intenses et pour des plaisirs innatendus. |
| | keywords | | | title | | string | Kit de Contraintes pour le Lit |
|
| | seotitle | | string | Kit de Contraintes pour le Lit |
| | seouri | | string | kit-de-contraintes-pour-le-lit-rouge |
| | specifications | | | stylingtips | | | summary | | string | Découvrez le plaisir du bondage, et expérimentez de nouvelles positions ou de séances BDSM intenses et pour des plaisirs innatendus. |
| | title | | string | Kit de Contraintes pour le Lit |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Kit di vincoli per il letto<br /><br />Include cinghie a forma di X da posizionare sotto il materasso per rendere il letto il vostro parco giochi preferito!<br /><br />Le cinghie sono regolabili per adattarsi alla maggior parte delle taglie.</div>
<div> </div>
<div><br />Include anche un paio di manette per i polsi e un paio di manette per le caviglie. <br /><br />Le manette sono dotate di chiusure in velcro e di anelli a D per collegare i moschettoni all'estremità delle 4 cinghie che formano la X.</div>
<div> </div>
<div>Realizzate in finta pelle morbida e resistente, sono abbastanza comode da permettervi di realizzare le vostre fantasie di coppia!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/it/kit-di-vincoli-per-il-letto-rosso/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Scoprite il piacere del bondage e sperimentate nuove posizioni o intense sessioni BDSM per ottenere piaceri inaspettati. |
| | keywords | | | title | | string | Kit di vincoli per il letto |
|
| | seotitle | | string | Kit di vincoli per il letto |
| | seouri | | string | kit-di-vincoli-per-il-letto-rosso |
| | specifications | | | stylingtips | | | summary | | string | Scoprite il piacere del bondage e sperimentate nuove posizioni o intense sessioni BDSM per ottenere piaceri inaspettati. |
| | title | | string | Kit di vincoli per il letto |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Bed Constraint Kit<br /><br />Inclusief X-vormige riemen om onder het matras te plaatsen om van je bed je favoriete speelplaats te maken!<br /><br />De riemen zijn verstelbaar voor de meeste maten.</div>
<div> </div>
<div><br />Er zitten ook een paar polsboeien en een paar enkelboeien bij. <br /><br />De handboeien hebben klittenband en D-ringen om de karabijnhaken te bevestigen aan de uiteinden van de 4 riemen die de X vormen.</div>
<div> </div>
<div>Ze zijn gemaakt van soepel, slijtvast imitatieleer en zijn comfortabel genoeg om je fantasieën als stel te laten uitkomen!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/nl/bedbegrenzingsset-rood/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ontdek het plezier van bondage en experimenteer met nieuwe posities of intense BDSM-sessies voor onverwacht plezier. |
| | keywords | | | title | |
| | seotitle | | | seouri | | string | bedbegrenzingsset-rood |
| | specifications | | | stylingtips | | | summary | | string | Ontdek het plezier van bondage en experimenteer met nieuwe posities of intense BDSM-sessies voor onverwacht plezier. |
| | title | | | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <div>Kit de contenção de cama<br /><br />Inclui correias em forma de X para colocar debaixo do colchão e fazer da sua cama o seu parque de diversões preferido!<br /><br />As correias são ajustáveis para se adaptarem à maioria dos tamanhos.</div>
<div> </div>
<div><br />Inclui também um par de algemas para os pulsos e um par de algemas para os tornozelos. <br /><br />As algemas têm fechos de velcro e argolas em D para fixar os mosquetões na extremidade das 4 correias que formam o X.</div>
<div> </div>
<div>Fabricadas em imitação de pele flexível e resistente, são suficientemente confortáveis para vos permitir realizar as vossas fantasias em casal!</div>
<div> </div>
<div> </div> |
| | guid | | string | https://dev.divasboudoir.com/pt/kit-de-restricao-de-cama-vermelho/atki6835.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra o prazer do bondage e experimente novas posições ou sessões intensas de BDSM para obter prazeres inesperados. |
| | keywords | | | title | | string | Kit de restrição de cama |
|
| | seotitle | | string | Kit de restrição de cama |
| | seouri | | string | kit-de-restricao-de-cama-vermelho |
| | specifications | | | stylingtips | | | summary | | string | Descubra o prazer do bondage e experimente novas posições ou sessões intensas de BDSM para obter prazeres inesperados. |
| | title | | string | Kit de restrição de cama |
| | usageinstructions | |
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Set mit roten Zwängen für das Bett<br /><br />Es enthält X-förmige Gurte, die Sie unter der Matratze anbringen können, um Ihr Bett zu Ihrem Lieblingsspielplatz zu machen!<br /><br />Die Gurte sind verstellbar, sodass sie für die meisten Größen passen.</div>
<div> </div>
<div><br />Es enthält außerdemein Paar Handfesseln für die Handgelenke und ein Paar Fußfesseln für die Fußgelenke. <br /><br />Die Handschellen werden mit Klettverschlüssen geschlossen und sind mit D-Ringen ausgestattet, um die Karabinerhaken am Ende der vier Riemen, die das X bilden, einzuhängen.</div>
<div> </div>
<div>Sie bestehen aus weichem, strapazierfähigem Kunstleder und sind bequem genug, um Ihre Fantasien als Paar auszuleben!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Entdecken Sie die Freuden des Bondage und experimentieren Sie mit neuen Stellungen oder intensiven BDSM-Sitzungen zu zweit für ungeahnte Freuden. |
| | keywords | | | title | | string | Rotes Zwangsset für das Bett |
|
| | seotitle | | string | Rotes Zwangsset für das Bett |
| | seouri | | string | rotes-zwangsset-fur-das-bett-rot |
| | specifications | | | stylingtips | | | summary | | string | Entdecken Sie die Freuden des Bondage und experimentieren Sie mit neuen Stellungen oder intensiven BDSM-Sitzungen zu zweit für ungeahnte Freuden. |
| | title | | string | Rotes Zwangsset für das Bett |
| | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Κόκκινο κιτ περιορισμών κρεβατιού<br /><br />Περιλαμβάνει ιμάντες σε σχήμα Χ για να τοποθετήσετε κάτω από το στρώμα για να κάνετε το κρεβάτι σας την αγαπημένη σας παιδική χαρά!<br /><br />Οι ιμάντες είναι ρυθμιζόμενοι για να ταιριάζουν στα περισσότερα μεγέθη.</div>
<div> </div>
<div><br />Περιλαμβάνει επίσης ένα ζευγάρι χειροπέδες για τους καρπούς και ένα ζευγάρι χειροπέδες για τον αστράγαλο. <br /><br />Οι χειροπέδες διαθέτουν κούμπωμα Velcro και κρίκους D για να στερεώσετε τους καραμπίνερ στο άκρο των 4 ιμάντων που σχηματίζουν το Χ.</div>
<div> </div>
<div>Κατασκευασμένες από εύκαμπτο, ανθεκτικό δέρμα απομίμησης, είναι αρκετά άνετες για να σας αφήσουν να εκπληρώσετε τις φαντασιώσεις σας ως ζευγάρι!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ανακαλύψτε την ευχαρίστηση της δουλείας και πειραματιστείτε με νέες στάσεις ή έντονες συνεδρίες BDSM για δύο για απροσδόκητες απολαύσεις. |
| | keywords | | | title | | string | Κόκκινο κιτ συγκράτησης για κρεβάτι |
|
| | seotitle | | string | Κόκκινο κιτ συγκράτησης για κρεβάτι |
| | seouri | | string | kokkino-kit-sygkrathshs-gia-krevati-kokkino |
| | specifications | | | stylingtips | | | summary | | string | Ανακαλύψτε την ευχαρίστηση της δουλείας και πειραματιστείτε με νέες στάσεις ή έντονες συνεδρίες BDSM για δύο για απροσδόκητες απολαύσεις. |
| | title | | string | Κόκκινο κιτ συγκράτησης για κρεβάτι |
| | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Red Bed Restraints Kit<br /><br />Includes X-shaped straps to place under the mattress to make your bed your favorite playground!<br /><br />Straps are adjustable to fit most sizes.</div>
<div> </div>
<div><br />It also includes a pair of wrist cuffs and a pair of ankle cuffs. <br /><br />The handcuffs close with Velcro fasteners and are fitted with D-rings to attach carabiners to the ends of the 4 straps that form the X.</div>
<div> </div>
<div>Made from supple, hard-wearing imitation leather, they're comfortable enough to let you fulfill your fantasies as a couple!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Discover the pleasure of bondage, and experiment new positions or intense BDSM sessions for two for unexpected pleasures. |
| | keywords | | | title | | string | Red Bed Restraints Kit |
|
| | seotitle | | string | Red Bed Restraints Kit |
| | seouri | | string | red-bed-restraints-kit-red |
| | specifications | | | stylingtips | | | summary | | string | Discover the pleasure of bondage, and experiment new positions or intense BDSM sessions for two for unexpected pleasures. |
| | title | | string | Red Bed Restraints Kit |
| | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Kit de sujeciones de cama rojo<br /><br />Incluye correas en forma de X para colocar debajo del colchón y convertir la cama en su zona de juegos favorita<br /><br />Las correas son ajustables para adaptarse a la mayoría de los tamaños.</div>
<div> </div>
<div><br />También incluye un par de esposas para las muñecas y un par de esposas para los tobillos. <br /><br />Las esposas tienen cierres de velcro y anillas en D para fijar los mosquetones al extremo de las 4 correas que forman la X.</div>
<div> </div>
<div>Fabricadas en imitación de cuero flexible y resistente, son lo suficientemente cómodas como para que puedas hacer realidad tus fantasías en pareja</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubre el placer del bondage y experimenta con nuevas posturas o intensas sesiones de BDSM para dos para disfrutar de placeres inesperados. |
| | keywords | | | title | | string | Kit de sujeción rojo para cama |
|
| | seotitle | | string | Kit de sujeción rojo para cama |
| | seouri | | string | kit-de-sujecion-rojo-para-cama-rojo |
| | specifications | | | stylingtips | | | summary | | string | Descubre el placer del bondage y experimenta con nuevas posturas o intensas sesiones de BDSM para dos para disfrutar de placeres inesperados. |
| | title | | string | Kit de sujeción rojo para cama |
| | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Kit de Contraintes rouges pour le Lit<br><br>Il comprend des sangles en X à placer sous le matelas pour faire de votre lit votre terrain de jeux préféré !<br><br>Les sangles sont ajustables pour s’adapter à la plupart des tailles.</div>
<div> </div>
<div> <br>Il comprend égalementune paire de menottes pour les poignets et une paire de menottes pour les chevilles. <br><br>Les menottes se ferment avec des scratchs et sont équipées d’anneaux en D afin d’y accrocher les mousquetons au bout des 4 sangles qui forment le X.</div>
<div> </div>
<div>Fabriquées en similicuir souple et résistant, elles seront suffisamment confortables pour vous permettre de réaliser vos fantasmes en couple !</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Découvrez le plaisir du bondage, et expérimentez de nouvelles positions ou de séances BDSM intenses à deux pour des plaisirs innatendus. |
| | keywords | | | title | | string | Kit de Contraintes rouges pour le Lit |
|
| | seotitle | | string | Kit de Contraintes rouges pour le Lit |
| | seouri | | string | kit-de-contraintes-rouges-pour-le-lit-rouge |
| | specifications | | | stylingtips | | | summary | | string | <p>Découvrez le plaisir du bondage, et expérimentez de nouvelles positions ou de séances BDSM intenses à deux pour des plaisirs innatendus.</p> |
| | title | | string | Kit de Contraintes rouges pour le Lit |
| | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Kit di cinghie da letto rosse<br /><br />Include cinghie a forma di X da posizionare sotto il materasso per rendere il letto il vostro parco giochi preferito!<br /><br />Le cinghie sono regolabili per adattarsi alla maggior parte delle taglie.</div>
<div> </div>
<div><br />Include anche un paio di manette per i polsi e un paio di manette per le caviglie. <br /><br />Le manette sono dotate di chiusure in velcro e di anelli a D per collegare i moschettoni all'estremità delle 4 cinghie che formano la X.</div>
<div> </div>
<div>Realizzate in finta pelle morbida e resistente, sono abbastanza comode da permettervi di realizzare le vostre fantasie di coppia!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Scoprite il piacere del bondage e sperimentate nuove posizioni o intense sessioni BDSM a due per ottenere piaceri inaspettati. |
| | keywords | | | title | | string | Kit di ritenuta rosso per letto |
|
| | seotitle | | string | Kit di ritenuta rosso per letto |
| | seouri | | string | kit-di-ritenuta-rosso-per-letto-rosso |
| | specifications | | | stylingtips | | | summary | | string | Scoprite il piacere del bondage e sperimentate nuove posizioni o intense sessioni BDSM a due per ottenere piaceri inaspettati. |
| | title | | string | Kit di ritenuta rosso per letto |
| | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Rode bedbeveiligingsset<br /><br />Inclusief X-vormige riemen om onder het matras te plaatsen om van je bed je favoriete speelplaats te maken!<br /><br />De riemen zijn verstelbaar voor de meeste maten.</div>
<div> </div>
<div><br />Er zitten ook een paar polsboeien en een paar enkelboeien bij. <br /><br />De handboeien hebben klittenband en D-ringen om de karabijnhaken te bevestigen aan het uiteinde van de 4 riemen die de X vormen.</div>
<div> </div>
<div>Ze zijn gemaakt van soepel, slijtvast imitatieleer en zijn comfortabel genoeg om je fantasieën als stel te laten uitkomen!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ontdek het plezier van bondage en experimenteer met nieuwe posities of intense BDSM-sessies voor twee voor onverwacht plezier. |
| | keywords | | | title | | string | Rode bevestigingsset voor bed |
|
| | seotitle | | string | Rode bevestigingsset voor bed |
| | seouri | | string | rode-bevestigingsset-voor-bed-rood |
| | specifications | | | stylingtips | | | summary | | string | Ontdek het plezier van bondage en experimenteer met nieuwe posities of intense BDSM-sessies voor twee voor onverwacht plezier. |
| | title | | string | Rode bevestigingsset voor bed |
| | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <div>Kit vermelho de contenção de cama<br /><br />Inclui correias em forma de X para colocar debaixo do colchão e fazer da sua cama o seu parque de diversões preferido!<br /><br />As correias são ajustáveis para se adaptarem à maioria dos tamanhos.</div>
<div> </div>
<div><br />Inclui também um par de algemas para os pulsos e um par de algemas para os tornozelos. <br /><br />As algemas têm fechos de velcro e argolas em D para fixar os mosquetões na extremidade das 4 correias que formam o X.</div>
<div> </div>
<div>Fabricadas em imitação de pele flexível e resistente, são suficientemente confortáveis para vos permitir realizar as vossas fantasias em casal!</div>
<div> </div>
<div> </div> |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Descubra o prazer do bondage e experimente novas posições ou sessões intensas de BDSM a dois para prazeres inesperados. |
| | keywords | | | title | | string | Kit de retenção vermelho para cama |
|
| | seotitle | | string | Kit de retenção vermelho para cama |
| | seouri | | string | kit-de-retencao-vermelho-para-cama-vermelho |
| | specifications | | | stylingtips | | | summary | | string | Descubra o prazer do bondage e experimente novas posições ou sessões intensas de BDSM a dois para prazeres inesperados. |
| | title | | string | Kit de retenção vermelho para cama |
| | usageinstructions | |
|
|
|
| name | | string | Bed Restraint Set 24928653001 |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 09D7DEE4-37FA-4E82-92E79B3CD3FFDCED |
|
| promountil | |
| rating | |
| recorduid | | string | 09D7DEE4-37FA-4E82-92E79B3CD3FFDCED |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.12 ms Record Count: 0 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,'471') > 0 and product_variations.productuid = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 |
|
| sizeranges | |
| sizes | |
| 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: 2.08 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' and product_variations.isactive = 1 and product_sizes.id_size = 471 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 | 09D7DEE4-37FA-4E82-92E79B3CD3FFDCED | 8A19FB21-2FE7-4DBF-A3182495192D1FA2 | 471 | red | #F50000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 49.9583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 2.43 ms Record Count: 1 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' 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 = '09D7DEE4-37FA-4E82-92E79B3CD3FFDCED' and product_variations.isactive = 1 and product_sizes.id_size = 471 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 | 8A19FB21-2FE7-4DBF-A3182495192D1FA2 | 471 | red | #F50000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 49.9583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 49.9583 | all | |
|
| vatrate | |
| warehouse | |