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.packs.pleasure,divasboudoir.wellbeing.secret.attach,divasboudoir.wellbeing.secret.punish |
|
| 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.717 ms Record Count: 4 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,pink,purple,red') > 0 and product_variations.productuid = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 | | 2 | pink | color | pink | pink | pink | #FE70BD | -1 | 0 | | 3 | purple | color | purp | purple | purple | #9400D4 | 0 | 0 | | 4 | red | color | red | red | red | #F50000 | 0 | 0 |
|
| colorrange | |
| colors | | string | black,pink,purple,red |
|
| 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 '2022-06-14 11:56:56'} |
|
| 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 | ensemble-bondage-rouge---10-pieces---som-013red |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2023-11-17 17:20:11'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.651 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select cart_actions.* from cart_actions where cart_actions.branding IN ('all','divasboudoir') and cart_actions.language IN ('all','fr') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('aec8ee8b-a83d-44a7-89487ed23aa9ba2c',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.31 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','fr') and product_categories.language in ('all','fr') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'PSBA6345' 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/mzcr/psba6345/ag989-female-model-001.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/my-first-fetish-kit.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/ag989-female-model-002.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/my-first-fetish-kit.jpg |
| | type | | | width | |
| | pink | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/my-first-fetish-kit_1.jpg |
| | type | | | width | |
| | purple | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/my-first-fetish-kit_2.jpg |
| | type | | | width | |
| | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/mzcr/psba6345/my-first-fetish-kit-rouge.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: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 13 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Mit diesem Set Mein erstes Fetisch-Set können Sie all Ihre Fantasien, die Sie für sich behalten, in die Tat umsetzen...<br /><br />Es enthält:<br /><br />Eine Verdunkelungsmaske, um Ihren Partner zu blenden und ihn zu erraten, was Sie mit ihm tun werden<br /><br />Ein verstellbarer Ballknebel, der das Atmen ermöglicht, aber seine Schreie erstickt...<br /><br />Verstellbare Handfesseln für die Handgelenke<br /><br />Handschellen für die Fußgelenke, ebenfalls verstellbar<br /><br />Ein weiches Seil, um Ihren Partner zu fesseln<br /><br />Eine Peitsche.... es liegt an Ihnen, sie zärtlich oder hart einzusetzen<br /><br />Ein verstellbares Halsband<br /><br />Eine Leine mit einem Karabinerhaken |
| | guid | | string | https://dev.divasboudoir.com/de/set-mein-erstes-fetischisten-set-schwarz-rosa-malvenfarben-ou-rot/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ein sehr komplettes Set, um sich in die Freuden der Bondage, der Unterwerfung und der Schmerzen einzuführen, die je nach Ihren momentanen Wünschen mehr oder weniger leicht sind ... |
| | keywords | | | title | | string | Set Mein erstes Fetischisten-Set |
|
| | seotitle | | string | Set Mein erstes Fetischisten-Set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ein sehr komplettes Set, um sich in die Freuden der Bondage, der Unterwerfung und der Schmerzen einzuführen, die je nach Ihren momentanen Wünschen mehr oder weniger leicht sind ... |
| | title | | string | Set Mein erstes Fetischisten-Set |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Αυτό το σετ Mon Premier Kit Fétichiste θα σας επιτρέψει να κάνετε πράξη όλες τις φαντασιώσεις που κρατούσατε για τον εαυτό σας...<br /><br />Περιέχει:<br /><br />Μια μάσκα συσκότισης για να τυφλώσετε τον σύντροφό σας και να τον αφήσετε να μαντέψει τι πρόκειται να του κάνετε<br /><br />Μια ρυθμιζόμενη φίμωση με μπάλα, η οποία σας επιτρέπει να αναπνέετε αλλά θα πνίξει τις κραυγές της...<br /><br />Ρυθμιζόμενες χειροπέδες καρπού<br /><br />Χειροπέδες στον αστράγαλο, επίσης ρυθμιζόμενες<br /><br />Μαλακό σχοινί για να δέσετε τον σύντροφό σας<br /><br />Ένα μαστίγιο.... από εσάς εξαρτάται αν θα το χρησιμοποιήσετε απαλά ή δυνατά.<br /><br />Ένα ρυθμιζόμενο κολάρο<br /><br />Ένα λουρί με αγκίστρι |
| | guid | | string | https://dev.divasboudoir.com/el/to-prwto-moy-set-fetich-mayro-roz-mwv-ou-kokkino/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ένα πλήρες σετ για να σας εισαγάγει στις απολαύσεις της δουλείας, της υποταγής και του ελαφρού ή λιγότερο ελαφρού πόνου, ανάλογα με τη διάθεσή σας εκείνη τη στιγμή... |
| | keywords | | | title | | string | Το πρώτο μου σετ φετίχ |
|
| | seotitle | | string | Το πρώτο μου σετ φετίχ |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ένα πλήρες σετ για να σας εισαγάγει στις απολαύσεις της δουλείας, της υποταγής και του ελαφρού ή λιγότερο ελαφρού πόνου, ανάλογα με τη διάθεσή σας εκείνη τη στιγμή... |
| | title | | string | Το πρώτο μου σετ φετίχ |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | This Mon Premier Kit Fétichiste set will enable you to put into practice all the fantasies you've been keeping to yourself...<br /><br />It contains:<br /><br />A black-out mask to blind your partner and let him guess what you're going to do to him<br /><br />An adjustable ball gag, which allows you to breathe, but will stifle her screams...<br /><br />Adjustable wrist cuffs<br /><br />Ankle cuffs, also adjustable<br /><br />Soft rope to tie up your partner<br /><br />A whip.... it's up to you to use it with tenderness or firmness<br /><br />An adjustable collar<br /><br />A leash with a snap hook |
| | guid | | string | https://dev.divasboudoir.com/en/mon-premier-kit-fetichiste-set-black-pink-purple-ou-red/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | A complete set to initiate you to the pleasures of bondage, submission and pain, more or less light, according to your desires of the moment ... |
| | keywords | | | title | | string | Mon Premier Kit Fétichiste set |
|
| | seotitle | | string | Mon Premier Kit Fétichiste set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | A complete set to initiate you to the pleasures of bondage, submission and pain, more or less light, according to your desires of the moment ... |
| | title | | string | Mon Premier Kit Fétichiste set |
| | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Este set Mon Premier Kit Fétichiste le permitirá poner en práctica todas las fantasías que ha estado guardando para sí...<br /><br />Contiene:<br /><br />Una máscara black-out para cegar a su pareja y dejarle adivinar lo que le va a hacer<br /><br />Una mordaza de bola ajustable, que te permitirá respirar pero ahogará sus gritos...<br /><br />Muñequeras ajustables<br /><br />Esposas para los tobillos, también ajustables<br /><br />Cuerda suave para atar a tu pareja<br /><br />Un látigo.... tú decides si usarlo con suavidad o con firmeza.<br /><br />Un collar ajustable<br /><br />Una correa con mosquetón |
| | guid | | string | https://dev.divasboudoir.com/es/mi-primer-kit-fetichista-negro-rosa-lila-ou-rojo/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un juego completo para iniciarte en los placeres del bondage, la sumisión y el dolor más o menos leve, según tu estado de ánimo en ese momento ... |
| | keywords | | | title | | string | Mi primer kit fetichista |
|
| | seotitle | | string | Mi primer kit fetichista |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un juego completo para iniciarte en los placeres del bondage, la sumisión y el dolor más o menos leve, según tu estado de ánimo en ese momento ... |
| | title | | string | Mi primer kit fetichista |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Cet ensemble Mon Premier Kit Fétichiste vous permettra de mettre en pratique tous les phantasmes que vous gardez pour vous...<br /><br />Il contient: <br /><br />Un masque occultant pour aveugler votre partenaire et le deviner ce que vous allez lui faire<br /><br />Un baillont boule réglable, il permet de respirer mais étouffera ses cris...<br /><br />Des menottes pour les poignets, réglables<br /><br />Des menottes pour les chevilles, réglables également<br /><br />Une corde douce pour attacher votre partenaire<br /><br />Un fouet.... à vous de l'utiliser avec tendresse ou fermeté<br /><br />Un collier réglable<br /><br />Une laisse avec un mousqueton |
| | guid | | string | https://dev.divasboudoir.com/fr/ensemble-mon-premier-kit-fetichiste-noir-rose-mauve-ou-rouge/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un ensemble très complet pour s'initier aux plaisirs du bondage, de la soumission et de la douleur plus ou moins légères selon vos envies du moment ... |
| | keywords | | | title | | string | Ensemble Mon Premier Kit Fétichiste |
|
| | seotitle | | string | Ensemble Mon Premier Kit Fétichiste |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un ensemble très complet pour s'initier aux plaisirs du bondage, de la soumission et de la douleur plus ou moins légères selon vos envies du moment ... |
| | title | | string | Ensemble Mon Premier Kit Fétichiste |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Questo set Mon Premier Kit Fétichiste vi permetterà di mettere in pratica tutte le fantasie che avete tenuto per voi...<br /><br />Contiene:<br /><br />Una maschera oscurante per accecare il vostro partner e lasciargli indovinare cosa gli farete<br /><br />Una ball gag regolabile, che vi permetterà di respirare ma soffocherà le sue urla...<br /><br />Polsini regolabili<br /><br />Manette per le caviglie, anch'esse regolabili<br /><br />Una corda morbida per legare il partner<br /><br />Una frusta.... sta a voi usarlo con delicatezza o con fermezza<br /><br />Un collare regolabile<br /><br />Un guinzaglio con moschettone |
| | guid | | string | https://dev.divasboudoir.com/it/il-mio-primo-kit-fetish-nero-rosa-malva-ou-rosso/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un set completo per introdurvi ai piaceri del bondage, della sottomissione e del dolore più o meno leggero, a seconda del vostro umore del momento... |
| | keywords | | | title | | string | Il mio primo kit fetish |
|
| | seotitle | | string | Il mio primo kit fetish |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un set completo per introdurvi ai piaceri del bondage, della sottomissione e del dolore più o meno leggero, a seconda del vostro umore del momento... |
| | title | | string | Il mio primo kit fetish |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Met deze Mon Premier Kit Fétichiste set kun je alle fantasieën die je voor jezelf hebt gehouden in de praktijk brengen...<br /><br />Het bevat:<br /><br />Een black-out masker om je partner te verblinden en hem te laten raden wat je met hem gaat doen<br /><br />Een verstelbare bal gag, die u toelaat om te ademen, maar zal smoren haar geschreeuw ...<br /><br />Verstelbare polsboeien<br /><br />Enkelboeien, ook verstelbaar<br /><br />Zacht touw om je partner vast te binden<br /><br />Een zweep.... het is aan jou om het zachtjes of stevig te gebruiken<br /><br />Een verstelbare halsband<br /><br />Een riem met karabijnhaak |
| | guid | | string | https://dev.divasboudoir.com/nl/mijn-eerste-fetisj-pakket-zwart-roze-mauve-ou-rood/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Een complete set om je kennis te laten maken met het plezier van bondage, onderwerping en meer of minder lichte pijn, afhankelijk van je stemming op dat moment ... |
| | keywords | | | title | | string | Mijn eerste fetisj pakket |
|
| | seotitle | | string | Mijn eerste fetisj pakket |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Een complete set om je kennis te laten maken met het plezier van bondage, onderwerping en meer of minder lichte pijn, afhankelijk van je stemming op dat moment ... |
| | title | | string | Mijn eerste fetisj pakket |
| | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Este conjunto Mon Premier Kit Fétichiste permitir-lhe-á pôr em prática todas as fantasias que tem guardado para si...<br /><br />Contém:<br /><br />Uma máscara de escurecimento para cegar o seu parceiro e deixá-lo adivinhar o que lhe vai fazer<br /><br />Uma mordaça de bola ajustável, que te permite respirar mas que abafa os gritos dela...<br /><br />Algemas ajustáveis para os pulsos<br /><br />Algemas para os tornozelos, também ajustáveis<br /><br />Uma corda macia para amarrar o teu parceiro<br /><br />Um chicote.... depende de si usá-lo com suavidade ou com firmeza<br /><br />Uma coleira ajustável<br /><br />Uma trela com um gancho |
| | guid | | string | https://dev.divasboudoir.com/pt/o-meu-primeiro-kit-fetiche-preto-cor-de-rosa-lilas-ou-vermelho/psba6345.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Um conjunto completo para o introduzir nos prazeres do bondage, da submissão e da dor mais ou menos ligeira, consoante a sua disposição no momento ... |
| | keywords | | | title | | string | O meu primeiro kit fetiche |
|
| | seotitle | | string | O meu primeiro kit fetiche |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Um conjunto completo para o introduzir nos prazeres do bondage, da submissão e da dor mais ou menos ligeira, consoante a sua disposição no momento ... |
| | title | | string | O meu primeiro kit fetiche |
| | 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 | Mit diesem Set Mein erstes BDSM-Set können Sie all Ihre Fantasien, die Sie bisher für sich behalten haben, in die Tat umsetzen...<br /><br />Es enthält:<br /><br />Eine Verdunkelungsmaske, um Ihren Partner zu blenden und ihn zu erraten, was Sie mit ihm tun werden<br /><br />Ein verstellbarer Ballknebel, der das Atmen ermöglicht, aber seine Schreie erstickt...<br /><br />Verstellbare Handfesseln für die Handgelenke<br /><br />Handschellen für die Fußgelenke, ebenfalls verstellbar<br /><br />Ein weiches Seil, um Ihren Partner zu fesseln<br /><br />Eine Peitsche.... es liegt an Ihnen, sie zärtlich oder hart einzusetzen<br /><br />Ein verstellbares Halsband<br /><br />Eine Leine mit einem Karabinerhaken |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ein sehr komplettes Set, um sich in die Freuden der Bondage, der Unterwerfung und der Schmerzen einzuführen, die je nach Ihren momentanen Wünschen mehr oder weniger leicht sind ... |
| | keywords | | | title | | string | Set Mein erstes BDSM-Set |
|
| | seotitle | | string | Set Mein erstes BDSM-Set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ein sehr komplettes Set, um sich in die Freuden der Bondage, der Unterwerfung und der Schmerzen einzuführen, die je nach Ihren momentanen Wünschen mehr oder weniger leicht sind ... |
| | title | | string | Set Mein erstes BDSM-Set |
| | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Αυτό το My First BDSM Kit θα σας επιτρέψει να κάνετε πράξη όλες τις φαντασιώσεις που κρατούσατε για τον εαυτό σας...<br /><br />Περιέχει:<br /><br />Μια μάσκα συσκότισης για να τυφλώσεις τον σύντροφό σου και να τον αφήσεις να μαντέψει τι πρόκειται να του κάνεις<br /><br />Μια ρυθμιζόμενη φίμωση με μπάλα, η οποία σας επιτρέπει να αναπνέετε αλλά θα πνίξει τις κραυγές της...<br /><br />Ρυθμιζόμενες χειροπέδες καρπού<br /><br />Χειροπέδες στον αστράγαλο, επίσης ρυθμιζόμενες<br /><br />Μαλακό σχοινί για να δέσετε τον σύντροφό σας<br /><br />Ένα μαστίγιο.... από εσάς εξαρτάται αν θα το χρησιμοποιήσετε απαλά ή δυνατά.<br /><br />Ένα ρυθμιζόμενο κολάρο<br /><br />Ένα λουρί με αγκίστρι |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ένα πλήρες σετ για να σας εισαγάγει στις απολαύσεις της δουλείας, της υποταγής και του πόνου, περισσότερο ή λιγότερο έντονα ανάλογα με τη διάθεσή σας... |
| | keywords | | | title | | string | Το πρώτο μου κιτ BDSM |
|
| | seotitle | | string | Το πρώτο μου κιτ BDSM |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ένα πλήρες σετ για να σας εισαγάγει στις απολαύσεις της δουλείας, της υποταγής και του πόνου, περισσότερο ή λιγότερο έντονα ανάλογα με τη διάθεσή σας... |
| | title | | string | Το πρώτο μου κιτ BDSM |
| | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | This Mon premier Kit BDSM set will allow you to put into practice all the fantasies you've been keeping to yourself...<br /><br />It contains:<br /><br />A black-out mask to blind your partner and let him guess what you're going to do to him<br /><br />An adjustable ball gag, which allows you to breathe, but will stifle her screams...<br /><br />Adjustable wrist cuffs<br /><br />Ankle cuffs, also adjustable<br /><br />Soft rope to tie up your partner<br /><br />A whip.... it's up to you to use it with tenderness or firmness<br /><br />An adjustable collar<br /><br />A leash with a snap hook |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | A complete kit to introduce you to the pleasures of bondage, submission and pain, more or less light, according to your desires of the moment... |
| | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | A complete kit to introduce you to the pleasures of bondage, submission and pain, more or less light, according to your desires of the moment... |
| | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Este Kit Mi Primer BDSM te permitirá poner en práctica todas las fantasías que has estado guardando para ti...<br /><br />Contiene:<br /><br />Una máscara black-out para cegar a tu pareja y que adivine lo que le vas a hacer<br /><br />Una mordaza de bola ajustable, que te permitirá respirar pero ahogará sus gritos...<br /><br />Muñequeras ajustables<br /><br />Esposas para los tobillos, también ajustables<br /><br />Cuerda suave para atar a tu pareja<br /><br />Un látigo.... tú decides si usarlo con suavidad o con firmeza.<br /><br />Un collar ajustable<br /><br />Una correa con mosquetón |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un kit completo para iniciarte en los placeres del bondage, la sumisión y el dolor, más o menos intenso según tu estado de ánimo ... |
| | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | Un kit completo para iniciarte en los placeres del bondage, la sumisión y el dolor, más o menos intenso según tu estado de ánimo ... |
| | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Cet ensemble Mon premier Kit BDSM vous permettra de mettre en pratique tous les phantasmes que vous gardez pour vous...<br /><br />Il contient: <br /><br />Un masque occultant pour aveugler votre partenaire et le deviner ce que vous allez lui faire<br /><br />Un baillont boule réglable, il permet de respirer mais étouffera ses cris...<br /><br />Des menottes pour les poignets, réglables<br /><br />Des menottes pour les chevilles, réglables également<br /><br />Une corde douce pour attacher votre partenaire<br /><br />Un fouet.... à vous de l'utiliser avec tendresse ou fermeté<br /><br />Un collier réglable<br /><br />Une laisse avec un mousqueton |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un kit très complet pour s'initier aux plaisirs du bondage, de la soumission et de la douleur plus ou moins légères selon vos envies du moment ... |
| | keywords | | | title | | string | Ensemble Mon Premier Kit BDSM |
|
| | seotitle | | string | Ensemble Mon Premier Kit BDSM |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un kit très complet pour s'initier aux plaisirs du bondage, de la soumission et de la douleur plus ou moins légères selon vos envies du moment ... |
| | title | | string | Ensemble Mon Premier Kit BDSM |
| | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Questo kit My First BDSM vi permetterà di mettere in pratica tutte le fantasie che avete tenuto per voi...<br /><br />Contiene:<br /><br />Una maschera oscurante per accecare il vostro partner e lasciargli indovinare cosa gli farete<br /><br />Una ball gag regolabile, che vi permetterà di respirare ma soffocherà le sue urla...<br /><br />Polsini regolabili<br /><br />Manette per le caviglie, anch'esse regolabili<br /><br />Una corda morbida per legare il partner<br /><br />Una frusta.... sta a voi usarla con delicatezza o con fermezza<br /><br />Un collare regolabile<br /><br />Un guinzaglio con moschettone |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un kit completo per introdurvi ai piaceri del bondage, della sottomissione e del dolore, più o meno intenso a seconda del vostro umore... |
| | keywords | | | title | | string | Il mio primo kit BDSM |
|
| | seotitle | | string | Il mio primo kit BDSM |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un kit completo per introdurvi ai piaceri del bondage, della sottomissione e del dolore, più o meno intenso a seconda del vostro umore... |
| | title | | string | Il mio primo kit BDSM |
| | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Met deze My First BDSM Kit kun je alle fantasieën die je voor jezelf hebt gehouden in de praktijk brengen...<br /><br />Het bevat:<br /><br />Een black-out masker om je partner te verblinden en hem te laten raden wat je met hem gaat doen<br /><br />Een verstelbare bal gag, die u toelaat om te ademen, maar zal smoren haar geschreeuw ...<br /><br />Verstelbare polsboeien<br /><br />Enkelboeien, ook verstelbaar<br /><br />Zacht touw om je partner vast te binden<br /><br />Een zweep.... het is aan jou om het zachtjes of stevig te gebruiken<br /><br />Een verstelbare halsband<br /><br />Een riem met karabijnhaak |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Een complete set om je kennis te laten maken met het plezier van bondage, onderwerping en pijn, meer of minder intens afhankelijk van je stemming ... |
| | keywords | | | title | | string | Mijn eerste BDSM-set |
|
| | seotitle | | string | Mijn eerste BDSM-set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Een complete set om je kennis te laten maken met het plezier van bondage, onderwerping en pijn, meer of minder intens afhankelijk van je stemming ... |
| | title | | string | Mijn eerste BDSM-set |
| | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Este Kit My First BDSM vai permitir-lhe pôr em prática todas as fantasias que tem guardado para si...<br /><br />Contém:<br /><br />Uma máscara de escurecimento para cegar o teu parceiro e deixá-lo adivinhar o que lhe vais fazer<br /><br />Uma mordaça de bola ajustável, que te permite respirar mas que abafa os gritos dela...<br /><br />Algemas ajustáveis para os pulsos<br /><br />Algemas para os tornozelos, também ajustáveis<br /><br />Uma corda macia para amarrar o teu parceiro<br /><br />Um chicote.... depende de si usá-lo com suavidade ou com firmeza<br /><br />Uma coleira ajustável<br /><br />Uma trela com um gancho |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Um kit completo para o introduzir nos prazeres do bondage, da submissão e da dor, mais ou menos intensos consoante a sua disposição ... |
| | keywords | | | title | | string | O meu primeiro kit BDSM |
|
| | seotitle | | string | O meu primeiro kit BDSM |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Um kit completo para o introduzir nos prazeres do bondage, da submissão e da dor, mais ou menos intensos consoante a sua disposição ... |
| | title | | string | O meu primeiro kit BDSM |
| | usageinstructions | |
|
|
|
| name | | string | Ensemble Bondage Rouge - 10 Pièces - SOM-013RED |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C |
|
| promountil | |
| rating | |
| recorduid | | string | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.15 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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: 1.98 ms Record Count: 4 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C | 74C49060-9B9C-4192-907F4F84A1B33230 | 471 | black | #000000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 14 | 0 | 0 | | 3700992735696 | -1 | 0 | all | | | 2 | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C | D95CEB8A-53F7-42D6-9AFA5F8DFBF76A37 | 471 | pink | #FE70BD | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 80689 | 2811309310008 | -1 | 0 | all | | | 3 | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C | 8F7134BF-3A47-4C8C-BA7EC63BC31294DF | 471 | purple | #9400D4 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 80689 | 2811309310015 | 0 | 0 | all | | | 4 | AEC8EE8B-A83D-44A7-89487ED23AA9BA2C | D7B36B42-B51A-455E-8FAB32659FA20078 | 471 | red | #F50000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | SOM-013RED | 3700992735726 | 0 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 2.78 ms Record Count: 4 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 = 'AEC8EE8B-A83D-44A7-89487ED23AA9BA2C' 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 | 74C49060-9B9C-4192-907F4F84A1B33230 | 471 | black | #000000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 14 | 0 | 0 | | 3700992735696 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 2 | D95CEB8A-53F7-42D6-9AFA5F8DFBF76A37 | 471 | pink | #FE70BD | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 80689 | 2811309310008 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 33.2917 | all | | | 3 | 8F7134BF-3A47-4C8C-BA7EC63BC31294DF | 471 | purple | #9400D4 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 80689 | 2811309310015 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 33.2917 | all | | | 4 | D7B36B42-B51A-455E-8FAB32659FA20078 | 471 | red | #F50000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 33.2917 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | SOM-013RED | 3700992735726 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 33.2917 | all | |
|
| vatrate | |
| warehouse | |