Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | |
| brandmedias | | string | {"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}} |
|
| brandmetas | | Struct | | de | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | el | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | en | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | es | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | fr | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | it | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | nl | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | pt | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
|
|
| brandname | |
| breasts | |
| careinstructions | |
| categories | | string | divasboudoir.wellbeing.secret.penetrate |
|
| 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.989 ms Record Count: 3 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,turquoise,pink') > 0 and product_variations.productuid = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 | turquoise | color | turq | turquoise | blue | #42E0D1 | 0 | 0 | | 3 | pink | color | pink | pink | pink | #FE70BD | 0 | 0 |
|
| colorrange | |
| colors | | string | black,turquoise,pink |
|
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2023-10-27 11:10:19'} |
|
| 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 | 13x-silicone-pulsing--vibrating-rabbit |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-04-11 10:51:42'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.888 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('e2ec1081-267f-426b-8f0e5b103a529dcb',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.66 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 <> 'ESBI5164' 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/sjpa/esbi5164/ag507-black_dupe4.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/sjpa/esbi5164/ag507-pink_dupe2.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/sjpa/esbi5164/ag507-black_dupe2.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/sjpa/esbi5164/ag507-black_dupe4.jpg |
| | type | | | width | |
| | pink | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/sjpa/esbi5164/ag507-pink_dupe1.jpg |
| | type | | | width | |
| | turquoise | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/sjpa/esbi5164/ag507-teal_4_1.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 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 | <p><span>Machen Sie sich bereit für eine 5-Sterne-Behandlung mit diesem luxuriösen Hasen-Vibrator! Er wurde für intensives Vergnügen sowohl an Ihrer Klitoris als auch an Ihrem G-Punkt entworfen. Seine subtil gebogene Form ist perfekt geeignet, um Ihre empfindlichen Bereiche zu stimulieren. Ausgestattet mit zwei leistungsstarken internen Motoren ist er ideal für den Solo- oder Paargebrauch!</span><br /><br /><span>Wählen Sie aus 3 klitoralen Pulsationsmustern und 10 Vibrationsfunktionen, um sowohl die Innen- als auch die Außenseite Ihres Körpers zu stimulieren! Jede Funktion kann unabhängig verwendet werden, sodass Sie verschiedene Empfindungen nach Ihren einzigartigen Vorlieben kombinieren können. Sie können auch die Augen Ihres Partners verbinden und ihn bei jeder Anwendung mit anderen Empfindungen überraschen.</span><br /><br /><span>Spüren Sie die samtige Weichheit dieses Vibrators dank seiner angenehmen Textur, die sich gut anfühlt. Hergestellt aus hochwertigen Materialien ist er nicht nur sicher für Ihren Körper, sondern auch leicht zu reinigen.</span><br /><br /><span>Dieser vibrierende Hasen-Vibrator mit Luftzufuhr ist der perfekte Begleiter für intensive und luxuriöse Lustmomente. Lassen Sie sich von unglaublichen Gefühlen mitreißen und entdecken Sie neue Höhen der Lust mit diesem hochwertigen Erotikspielzeug.</span><br /><br /><span>Gönnen Sie sich das Beste mit diesem hochwertigen Hasen-Vibrator und erleben Sie unvergessliche Momente der Lust. Geben Sie sich nicht mit weniger zufrieden, wählen Sie das Beste für Ihre persönliche Befriedigung.<br /><br />Einführbarer Durchmesser: 3.5cm<br />Einführbare Länge: 10.9cm<br />Anzahl der Geschwindigkeiten: 13<br />USB-Ladegerät: Inklusive<br />Wasserdicht: Ja<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/de/rabbit-mit-umluft-schwarz-turkis-or-rosa/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Genießen Sie ein unvergleichliches Erlebnis mit dem Vibrant & Air Pulsed Rabbit. Intensive Stimulation und einzigartige Gefühle sind garantiert. Bestellen Sie jetzt und erleben Sie intensive Lustmomente. |
| | keywords | | | title | | string | Vibrierendes Kaninchen und Pulsierende Luft - Entdecken Sie das ultimative Vergnügen |
|
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | Gönnen Sie sich das Beste mit diesem hochwertigen Hasen-Vibrator und erleben Sie unvergessliche Momente der Lust. Geben Sie sich nicht mit weniger zufrieden, wählen Sie das Beste für Ihre persönliche Zufriedenheit. |
| | title | | string | Vibrierendes Kaninchen und Pulsierende Luft |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Ετοιμαστείτε για μια θεραπεία 5 αστέρων με αυτόν τον πολυτελή δονητή κουνελιού! Σχεδιασμένος για έντονη απόλαυση τόσο στην κλειτορίδα όσο και στο σημείο G, το διακριτικά καμπυλωτό σχήμα του είναι ιδανικό για να διεγείρει τις ευαίσθητες περιοχές σας. Εξοπλισμένος με δύο ισχυρούς εσωτερικούς κινητήρες, είναι ιδανικός για χρήση μόνος ή ως ζευγάρι!</span><br /><br /><span>Επιλέξτε ανάμεσα σε 3 μοτίβα παλμών κλειτορίδας και 10 λειτουργίες δόνησης για να διεγείρετε τόσο το εσωτερικό όσο και το εξωτερικό του σώματός σας! Κάθε λειτουργία μπορεί να χρησιμοποιηθεί ανεξάρτητα, επιτρέποντάς σας να συνδυάσετε διαφορετικές αισθήσεις που ταιριάζουν στις μοναδικές σας προτιμήσεις. Μπορείτε επίσης να δέσετε τα μάτια του συντρόφου σας και να τον εκπλήξετε με διαφορετικές αισθήσεις κάθε φορά που το χρησιμοποιείτε.</span><br /><br /><span>Νιώστε τη βελούδινη απαλότητα αυτού του δονητή χάρη στην ευχάριστη στην αφή υφή του. Κατασκευασμένος από υλικά υψηλής ποιότητας, δεν είναι μόνο ασφαλής για το σώμα σας, αλλά και εύκολος στον καθαρισμό.</span><br /><br /><span>Αυτός ο δονητής κουνελιού είναι ο ιδανικός σύντροφος για έντονη, πολυτελή απόλαυση. Αφήστε τον εαυτό σας να παρασυρθεί από απίστευτες αισθήσεις και ανακαλύψτε νέα ύψη απόλαυσης με αυτό το κορυφαίο ερωτικό παιχνίδι.</span><br /><br /><span>Χαρίστε στον εαυτό σας το καλύτερο με αυτόν τον κορυφαίας ποιότητας δονητή κουνελιού και ζήστε αξέχαστες στιγμές απόλαυσης. Μη συμβιβάζεστε με λιγότερα, επιλέξτε το καλύτερο για την προσωπική σας ικανοποίηση.<br /><br />Διάμετρος εισαγωγής: 3,5cm<br />Μήκος εισαγωγής: 10,9cm<br />Αριθμός ταχυτήτων: 13<br />Φορτιστής USB: περιλαμβάνεται<br />Αδιάβροχο: Ναι<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/el/koyneli-me-exanagkasmeno-aera-mayro-tyrkoyaz-or-roz/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Απολαύστε μια απαράμιλλη εμπειρία με το Vibrating Rabbit και το Pulsed Air. Εγγυημένη έντονη διέγερση και μοναδικές αισθήσεις. Παραγγείλτε τώρα και απολαύστε στιγμές έντονης απόλαυσης. |
| | keywords | | | title | | string | Κουνέλι με εξαναγκασμένο αέρα |
|
| | seotitle | | string | Κουνέλι με εξαναγκασμένο αέρα |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Χαρίστε στον εαυτό σας το καλύτερο με αυτόν τον δονητή κουνελιού κορυφαίας ποιότητας και ζήστε αξέχαστες στιγμές απόλαυσης. Μην συμβιβάζεστε με λιγότερα, επιλέξτε το καλύτερο για την προσωπική σας ικανοποίηση. |
| | title | | string | Δονητικό κουνέλι και παλλόμενος αέρας |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Get ready for a 5-star treatment with this deluxe rabbit vibrator! Designed for intense pleasure on both your clitoris and G-spot, its subtly curved shape is perfectly suited to stimulating your sensitive areas. Equipped with two powerful internal motors, it's ideal for solo or couple use!</span><br /><br /><span>Choose from 3 clitoral pulse patterns and 10 vibration functions to stimulate both the inside and outside of your body! Each function can be used independently, allowing you to combine different sensations according to your unique preferences. You can also blindfold your partner and surprise him or her with different sensations with each use.</span><br /><br /><span>Feel the velvety softness of this vibrator thanks to its pleasant-to-touch texture. Made from high-quality materials, it's not only safe for your body, but also easy to clean.</span><br /><br /><span>This vibrating rabbit vibrator is the ideal companion for moments of intense, luxurious pleasure. Let yourself be swept away by incredible sensations and discover new heights of pleasure with this top-of-the-range erotic toy.</span><br /><br /><span>Treat yourself to the best with this top-quality rabbit vibrator and experience unforgettable moments of pleasure. Don't settle for less, choose the best for your personal satisfaction.<br /><br />Insertable diameter: 3.5cm<br />Insertable length: 10.9cm<br />Number of speeds: 13<br />USB charger: included<br />Waterproof: Yes<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/en/forced-air-rabbit-black-turquoise-or-pink/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Enjoy an unparalleled experience with the Vibrating Rabbit and Pulsed Air. Intense stimulation and unique sensations guaranteed. Order now and experience intense pleasure. |
| | keywords | | | title | | string | Vibrating Rabbit and Pulsating Air - Discover the ultimate pleasure |
|
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | Treat yourself to the best with this top-quality rabbit vibrator and experience unforgettable moments of pleasure. Don't settle for less, choose the best for your personal satisfaction. |
| | title | | string | Vibrating Rabbit and Pulsed Air |
| | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Prepárate para un tratamiento 5 estrellas con este lujoso vibrador con forma de conejo Diseñado para un placer intenso tanto en el clítoris como en el punto G, su forma sutilmente curvada se adapta perfectamente a la estimulación de tus zonas sensibles. Equipado con dos potentes motores internos, es ideal para usarlo en solitario o en pareja</span><br /><br /><span>Elige entre 3 patrones de pulsación para el clítoris y 10 funciones de vibración para estimular tanto el interior como el exterior de tu cuerpo Cada función puede utilizarse de forma independiente, lo que te permite combinar diferentes sensaciones para adaptarlas a tus preferencias únicas. También puedes vendarle los ojos a tu pareja y sorprenderla con sensaciones diferentes cada vez que lo utilices.</span><br /><br /><span>Siente la suavidad aterciopelada de este vibrador gracias a su textura agradable al tacto. Fabricado con materiales de alta calidad, no sólo es seguro para tu cuerpo, sino también fácil de limpiar.</span><br /><br /><span>Este conejito vibrador es el compañero ideal para un placer intenso y lujoso. Déjate llevar por sensaciones increíbles y descubre nuevas cotas de placer con este juguete erótico de alta gama.</span><br /><br /><span>Regálate lo mejor con este vibrador conejito de alta calidad y vive momentos de placer inolvidables. No te conformes con menos, elige lo mejor para tu satisfacción personal.<br /><br />Diámetro insertable: 3,5 cm<br />Longitud insertable: 10,9 cm<br />Número de velocidades: 13<br />Cargador USB: incluido<br />Resistente al agua: Sí<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/es/conejo-de-aire-forzado-negro-turqueza-or-rosa/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Disfruta de una experiencia inigualable con el Conejo Vibrador y el Aire Pulsado. Estimulación intensa y sensaciones únicas garantizadas. Pídalo ahora y disfrute de momentos de intenso placer. |
| | keywords | | | title | | string | Vibrating Rabbit y Pulsed Air - Descubre el placer definitivo |
|
| | seotitle | | string | Conejo de aire forzado |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Regálate lo mejor con este vibrador conejito de alta calidad y vive momentos de placer inolvidables. No te conformes con menos, elige lo mejor para tu satisfacción personal. |
| | title | | string | Conejo vibrador y aire pulsado |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Préparez-vous à un traitement 5 étoiles avec ce vibromasseur lapin de luxe ! Conçu pour un plaisir intense à la fois sur votre clitoris et votre point G, sa forme subtilement courbée est parfaitement adaptée pour stimuler vos zones sensibles. Doté de deux moteurs internes puissants, il est idéal pour une utilisation en solo ou en couple !</span><br /><br /><span>Choisissez parmi 3 motifs de pulsations clitoridiennes et 10 fonctions de vibrations pour stimuler à la fois l'intérieur et l'extérieur de votre corps ! Chaque fonction peut être utilisée indépendamment, vous permettant ainsi de combiner différentes sensations selon vos préférences uniques. Vous pouvez également bander les yeux de votre partenaire et le surprendre avec des sensations différentes à chaque utilisation.</span><br /><br /><span>Sentez la douceur veloutée de ce vibromasseur grâce à sa texture agréable au toucher. Fabriqué avec des matériaux de haute qualité, il est non seulement sûr pour votre corps, mais aussi facile à nettoyer.</span><br /><br /><span>Ce vibromasseur lapin vibrant à air pulsé est le compagnon idéal pour des moments de plaisir intenses et luxueux. Laissez-vous emporter par des sensations incroyables et découvrez de nouveaux sommets de plaisir avec ce jouet érotique haut de gamme.</span><br /><br /><span>Offrez-vous le meilleur avec ce vibromasseur lapin de qualité supérieure et vivez des moments de plaisir inoubliables. Ne vous contentez pas de moins, choisissez le meilleur pour votre satisfaction personnelle.<br /><br />Diamètre insérable: 3.5cm<br />Longueur insérable: 10.9cm<br />Nombre de vitesses: 13<br />Chargeur USB : inclus<br />Waterproof: Oui<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/fr/rabbit-a-air-pulse-noir-turquoise-or-rose/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Profitez d'une expérience inégalée avec le Rabbit Vibrant et Air Pulsé. Stimulation intense et sensations uniques garanties. Commandez maintenant et vivez des moments de plaisir intenses. |
| | keywords | | | title | | string | Rabbit Vibrant et Air Pulsé - Découvrez le plaisir ultime |
|
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | Offrez-vous le meilleur avec ce vibromasseur lapin de qualité supérieure et vivez des moments de plaisir inoubliables. Ne vous contentez pas de moins, choisissez le meilleur pour votre satisfaction personnelle. |
| | title | | string | Rabbit Vibrant et Air Pulsé |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Preparatevi a un trattamento a 5 stelle con questo lussuoso vibratore rabbit! Progettato per un piacere intenso sia sul clitoride che sul punto G, la sua forma sottilmente curva è perfettamente adatta a stimolare le vostre aree sensibili. Dotato di due potenti motori interni, è ideale per l'uso da soli o in coppia!</span><br /><br /><span>Scegliete tra 3 pulsazioni clitoridee e 10 funzioni di vibrazione per stimolare sia l'interno che l'esterno del vostro corpo! Ciascuna funzione può essere utilizzata in modo indipendente, consentendovi di combinare diverse sensazioni in base alle vostre preferenze. Potete anche bendare il vostro partner e sorprenderlo con sensazioni diverse ad ogni utilizzo.</span><br /><br /><span>Sentite la morbidezza vellutata di questo vibratore grazie alla sua texture piacevole al tatto. Realizzato con materiali di alta qualità, non solo è sicuro per il corpo, ma è anche facile da pulire.</span><br /><br /><span>Questo vibratore rabbit è il compagno ideale per un piacere intenso e lussuoso. Lasciatevi trasportare da sensazioni incredibili e scoprite nuove vette di piacere con questo giocattolo erotico di alta gamma.</span><br /><br /><span>Concedetevi il meglio con questo vibratore rabbit di alta qualità e vivete momenti di piacere indimenticabili. Non accontentatevi di poco, scegliete il meglio per la vostra soddisfazione personale.<br /><br />Diametro inseribile: 3,5 cm<br />Lunghezza inseribile: 10,9 cm<br />Numero di velocità: 13<br />Caricatore USB: incluso<br />Impermeabile: Sì<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/it/coniglio-ad-aria-forzata-nero-turchese-or-rosa/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Godetevi un'esperienza senza precedenti con il Rabbit vibrante e l'aria pulsata. Stimolazione intensa e sensazioni uniche garantite. Ordinate ora e godetevi momenti di intenso piacere. |
| | keywords | | | title | | string | Rabbit vibrante e aria pulsata - Scoprite il massimo del piacere |
|
| | seotitle | | string | Coniglio ad aria forzata |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Concedetevi il meglio con questo vibratore rabbit di alta qualità e vivete momenti di piacere indimenticabili. Non accontentatevi di poco, scegliete il meglio per la vostra soddisfazione personale. |
| | title | | string | Coniglio vibrante e aria pulsata |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Maak je klaar voor een 5-sterren behandeling met deze luxe rabbit vibrator! Ontworpen voor intens genot op zowel je clitoris als je G-spot, is de subtiel gebogen vorm perfect geschikt om je gevoelige plekjes te stimuleren. Uitgerust met twee krachtige interne motoren, is hij ideaal om alleen of met z'n tweeën te gebruiken!</span><br /><br /><span>Kies uit 3 clitorale pulspatronen en 10 vibratie functies om zowel de binnenkant als de buitenkant van je lichaam te stimuleren! Elke functie kan onafhankelijk worden gebruikt, zodat je verschillende sensaties kunt combineren om aan jouw unieke voorkeuren te voldoen. Je kunt ook je partner blinddoeken en hem verrassen met verschillende sensaties elke keer dat je hem gebruikt.</span><br /><br /><span>Voel de fluweelzachtheid van deze vibrator dankzij de prettig aanvoelende textuur. Gemaakt van hoogwaardige materialen, is hij niet alleen veilig voor je lichaam, maar ook gemakkelijk schoon te maken.</span><br /><br /><span>Deze vibrerende rabbit vibrator is de ideale metgezel voor intens, luxueus genot. Laat je meeslepen door ongelooflijke sensaties en ontdek nieuwe hoogten van genot met dit erotische speeltje van topklasse.</span><br /><br /><span>Verwen jezelf met het allerbeste met deze rabbit vibrator van topkwaliteit en beleef onvergetelijke momenten van genot. Neem geen genoegen met minder, kies het beste voor jouw persoonlijke bevrediging.<br /><br />Inbrengbare diameter: 3.5cm<br />Inbrengbare lengte: 10.9cm<br />Aantal snelheden: 13<br />USB oplader: inbegrepen<br />Waterdicht: Ja<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/nl/luchthaas-zwart-turquoise-or-roze/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Geniet van een ongeëvenaarde ervaring met de Vibrating Rabbit en Pulsed Air. Intense stimulatie en unieke sensaties gegarandeerd. Bestel nu en geniet van momenten van intens genot. |
| | keywords | | | title | | string | Vibrerend konijn en gepulseerde lucht - Ontdek het ultieme genot |
|
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | string | Gun jezelf het beste met deze rabbit vibrator van topkwaliteit en beleef onvergetelijke momenten van genot. Neem geen genoegen met minder, kies het beste voor jouw persoonlijke bevrediging. |
| | title | | string | Trillend konijn en gepulseerde lucht |
| | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Prepare-se para um tratamento de 5 estrelas com este luxuoso vibrador rabbit! Concebido para um prazer intenso tanto no clitóris como no ponto G, a sua forma subtilmente curvada é perfeitamente adequada para estimular as suas zonas sensíveis. Equipado com dois potentes motores internos, é ideal para ser utilizado a solo ou em casal!</span><br /><br /><span>Escolha entre 3 padrões de pulsação clitoriana e 10 funções de vibração para estimular o interior e o exterior do seu corpo! Cada função pode ser utilizada de forma independente, permitindo-lhe combinar diferentes sensações de acordo com as suas preferências. Também pode vendar os olhos ao seu parceiro e surpreendê-lo com sensações diferentes cada vez que o utilizar.</span><br /><br /><span>Sinta a suavidade aveludada deste vibrador graças à sua textura agradável ao tato. Fabricado com materiais de alta qualidade, não só é seguro para o seu corpo, como também é fácil de limpar.</span><br /><br /><span>Este vibrador rabbit é o companheiro ideal para um prazer intenso e luxuoso. Deixe-se levar por sensações incríveis e descubra novos patamares de prazer com este brinquedo erótico topo de gama.</span><br /><br /><span>Ofereça a si própria o melhor com este vibrador rabbit de qualidade superior e viva momentos de prazer inesquecíveis. Não se contente com menos, escolha o melhor para a sua satisfação pessoal.<br /><br />Diâmetro inserível: 3,5cm<br />Comprimento inserível: 10,9cm<br />Número de velocidades: 13<br />Carregador USB: incluído<br />À prova de água: Sim<br /><br /></span></p> |
| | guid | | string | https://dev.divasboudoir.com/pt/coelho-de-ar-forcado-preto-turquesa-or-cor-de-rosa/esbi5164.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Desfrute de uma experiência inigualável com o Vibrating Rabbit e o Pulsed Air. Estimulação intensa e sensações únicas garantidas. Encomende já e desfrute de momentos de intenso prazer. |
| | keywords | | | title | | string | Vibrating Rabbit e Pulsed Air - Descubra o prazer supremo |
|
| | seotitle | | string | Coelho de ar forçado |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ofereça a si própria o melhor com este vibrador rabbit de qualidade superior e viva momentos de prazer inesquecíveis. Não se contente com menos, escolha o melhor para a sua satisfação pessoal. |
| | title | | string | Coelho vibratório e ar pulsado |
| | 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 | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | | string | 13X Silicone Pulsing & Vibrating Rabbit |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | E2EC1081-267F-426B-8F0E5B103A529DCB |
|
| promountil | |
| rating | |
| recorduid | | string | E2EC1081-267F-426B-8F0E5B103A529DCB |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.49 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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.68 ms Record Count: 3 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 | E2EC1081-267F-426B-8F0E5B103A529DCB | 05E75EBC-D0F5-4973-BA653A4DD3EC3CEE | 471 | black | #000000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | AG507 | 848518038937 | -1 | 0 | all | | | 2 | E2EC1081-267F-426B-8F0E5B103A529DCB | 912A5608-A5DA-40DA-8F773AD047068E4B | 471 | pink | #FE70BD | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | all | | | 3 | E2EC1081-267F-426B-8F0E5B103A529DCB | 5FDF9B6B-FFE1-41D1-B70B9D00263568A0 | 471 | turquoise | #42E0D1 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 4 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 = 'E2EC1081-267F-426B-8F0E5B103A529DCB' 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 | 05E75EBC-D0F5-4973-BA653A4DD3EC3CEE | 471 | black | #000000 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | AG507 | 848518038937 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 99.9583 | all | | | 2 | 912A5608-A5DA-40DA-8F773AD047068E4B | 471 | pink | #FE70BD | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 99.9583 | all | | | 3 | 5FDF9B6B-FFE1-41D1-B70B9D00263568A0 | 471 | turquoise | #42E0D1 | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 99.9583 | 0 | | STOCK01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 99.9583 | all | |
|
| vatrate | |
| warehouse | |