Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | | string | divasboudoir,smboudoir |
|
| brandmedias | | string | {"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}} |
|
| brandmetas | | Struct | | de | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | el | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | en | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | es | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | fr | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | it | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | nl | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | pt | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
|
|
| brandname | |
| breasts | |
| careinstructions | |
| categories | | string | divasboudoir.wellbeing.secret.duo,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: 1.56 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'blackpurple') > 0 and product_variations.productuid = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 | blackpurple | color | bpur | blackpurple | purple | linear-gradient(90deg, #000000 50%, #9400D4 50%) | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2022-11-17 13:08:17'} |
|
| 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 | rc-vibrating-strap-on-05506550000 |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2024-01-03 17:41:39'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.659 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('fa6bbd71-3f1e-42c9-b964ab1d037f9cc0',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.35 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 <> 'CBWA5239' 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/yqfk/cbwa5239/05506550000_nor_e.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/yqfk/cbwa5239/05506550000_nor_i.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/yqfk/cbwa5239/05506550000_nor_a_-_copy.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | blackpurple | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/yqfk/cbwa5239/05506550000_nor_a_-_copy.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 | Ferngesteuertes Set<br /><br />Qualität, Design und Komfort.<br /><br />Verstellbare Größe bis zu 122 cm Taillenumfang (58-90)<br /><br />Mit den 7 Vibrationsmodi, die Sie mit der kabellosen Fernbedienung steuern können - von der sanftesten bis zur stärksten Vibration - erleben Sie den ultimativen Spaß.<br /><br />Er ist wasserdicht für feuchte Spiele...<br /><br />Der Dildo ist so geformt, dass er den G-Punkt der Frau und den P-Punkt (Prostata) des Mannes stimulieren kann und dank seines Saugnapfes perfekt an seinem Platz bleibt.<br /><br />Er ist wiederaufladbar und das Kabel ist im Lieferumfang enthalten.<br /><br />Sie können jeden anderen Dildo/Vibro an ihm befestigen, solange er über eine Saugnapfbasis verfügt.<br /><br />Er ist bis zu einem Hüftumfang von 167 cm und einem Oberschenkelumfang von 95 cm verstellbar.<br /><br />Vibro:<br />Gesamtlänge 24cm, einsetzbare Länge 22.5cm<br />Dicke: von 3.8cm bis 5.1cm<br /><br />Die Fernbedienung ist mit einer CR2032-Batterie ausgestattet.<br /><br />Der Vibrator ist wiederaufladbar.<br /><br />Ein Gleitmittel und ein Sextoy-Reiniger sind im Lieferumfang enthalten. |
| | guid | | string | https://dev.divasboudoir.com/de/ferngesteuertes-grosses-set-you2toys-schwarz-und-lila/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ein Harness und sein Dildo, verstellbar bis zu einem Hüftumfang von 167cm und vor allem ferngesteuert. Damit können Sie unglaubliche Momente mit Ihrem Partner verbringen. Größe verstellbar bis zu einem Taillenumfang von 122cm (56-58) und einem Oberschenkelumfang von 95cm. Wir legen ein Gleitmittel und einen Sextoy-Reiniger bei. |
| | keywords | | | title | | string | Ferngesteuertes Großes Set |
|
| | seotitle | | string | Ferngesteuertes Großes Set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ein Harness und sein Dildo, verstellbar bis zu einem Hüftumfang von 167cm und vor allem ferngesteuert. Damit können Sie unglaubliche Momente mit Ihrem Partner verbringen. Größe verstellbar bis zu einem Taillenumfang von 122cm (56-58) und einem Oberschenkelumfang von 95cm.<br />Wir legen ein Gleitmittel und einen Sextoy-Reiniger bei. |
| | title | | string | Ferngesteuertes Großes Set |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Σετ τηλεχειριστηρίου<br /><br />Ποιότητα, σχεδιασμός και άνεση.<br /><br />Μέγεθος ρυθμιζόμενο έως 122cm μέση (58-90)<br /><br />Μοιραστείτε στιγμές απόλυτης απόλαυσης χάρη στους 7 τρόπους δόνησης που μπορείτε να ελέγξετε με το ασύρματο τηλεχειριστήριο, από τον πιο απαλό έως τον πιο έντονο.<br /><br />Είναι αδιάβροχο για παιχνίδι σε υγρό περιβάλλον...<br /><br />Ο δονητής έχει σχήμα που διεγείρει το σημείο G για τις γυναίκες και το σημείο P (προστάτης) για τους άνδρες και θα παραμείνει τέλεια στη θέση του χάρη στη βάση του με εξαερισμό.<br /><br />Είναι επαναφορτιζόμενος και το καλώδιό του περιλαμβάνεται.<br /><br />Μπορείτε να τοποθετήσετε οποιοδήποτε άλλο dildo/vibro αρκεί να έχει αεριζόμενη βάση.<br /><br />Είναι ρυθμιζόμενο μέχρι 167 εκατοστά περιφέρεια γοφών και 95 εκατοστά περιφέρεια μηρών.<br /><br />Δονητής:<br />Μήκος: Συνολικό μήκος 24cm, μήκος εισαγωγής 22,5cm<br />Πάχος: από 3,8cm έως 5,1cm<br /><br />Το τηλεχειριστήριο είναι εφοδιασμένο με μια μπαταρία CR2032.<br /><br />Ο δονητής είναι επαναφορτιζόμενος.<br /><br />Περιλαμβάνονται λιπαντικό και καθαριστικό για σεξουαλικά παιχνίδια. |
| | guid | | string | https://dev.divasboudoir.com/el/megalo-thlecheirizomeno-set-you2toys-mayro-kai-mov/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Μια καλωδίωση και ένας δονητής, ρυθμιζόμενος σε μέγεθος μέσης και ισχίων 167 εκατοστών, και πάνω απ' όλα τηλεχειριζόμενος. Όλα όσα χρειάζεστε για να περάσετε απίστευτες στιγμές με τον σύντροφό σας. Μέγεθος ρυθμιζόμενο έως 122 εκατοστά στη μέση (56-58) και 95 εκατοστά στους μηρούς. Περιλαμβάνεται λιπαντικό και καθαριστικό για τα ερωτικά παιχνίδια. |
| | keywords | | | title | | string | Μεγάλο τηλεχειριζόμενο σετ |
|
| | seotitle | | string | Μεγάλο τηλεχειριζόμενο σετ |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Μια καλωδίωση και ένας δονητής, ρυθμιζόμενος σε μέγεθος μέσης και ισχίων 167 εκατοστών, και πάνω απ' όλα τηλεχειριζόμενος. Όλα όσα χρειάζεστε για να περάσετε απίστευτες στιγμές με τον σύντροφό σας. Μέγεθος ρυθμιζόμενο έως 122 εκατοστά στη μέση (56-58) και 95 εκατοστά στους μηρούς.<br />Περιλαμβάνεται λιπαντικό και καθαριστικό για τα ερωτικά παιχνίδια. |
| | title | | string | Μεγάλο τηλεχειριζόμενο σετ |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Remote Control Set<br /><br />Quality, design and comfort.<br /><br />Size adjustable up to 122cm waist (58-90)<br /><br />Share moments of absolute pleasure thanks to its 7 vibration modes that you can control with its wireless remote control, from the gentlest to the most vigorous.<br /><br />Waterproof for wet play...<br /><br />The dildo is shaped to stimulate the G-spot for the lady and the P-spot (prostate) for the gentleman, and will stay perfectly in place thanks to its vented base.<br /><br />It's rechargeable and comes with a cable.<br /><br />You can fit any other dildo/vibro as long as it has a vented base.<br /><br />It's adjustable up to 167cm hip circumference and 95cm thigh circumference.<br /><br />Vibro:<br />Total length 24cm, insertable length 22.5cm<br />Thickness: from 3.8cm to 5.1cm<br /><br />The remote control is equipped with a CR2032 battery.<br /><br />The vibro is rechargeable.<br /><br />Lubricant and sex toy cleaner included. |
| | guid | | string | https://dev.divasboudoir.com/en/remote-controlled-plus-size-set-you2toys-black-and-purple/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | A harness and dildo, adjustable up to a hip size of 167cm and, above all, remote-controlled. Enough to spend incredible moments with your partner. Size adjustable up to 122cm waist (56-58) and 95cm thigh. Lubricant and sex toy cleaner included. |
| | keywords | | | title | | string | Remote-controlled plus size set |
|
| | seotitle | | string | Remote-controlled plus size set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | A harness and dildo, adjustable up to a hip size of 167cm and, above all, remote-controlled. Enough to spend incredible moments with your partner. Size adjustable up to 122cm waist (56-58) and 95cm thigh.<br />Lubricant and sex toy cleaner included. |
| | title | | string | Remote-controlled plus size set |
| | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Conjunto de mando a distancia<br /><br />Calidad, diseño y comodidad.<br /><br />Talla ajustable hasta 122 cm de cintura (58-90)<br /><br />Comparte momentos de placer absoluto gracias a sus 7 modos de vibración que podrás controlar con su mando a distancia inalámbrico, desde el más suave al más vigoroso.<br /><br />Es resistente al agua para los juegos húmedos...<br /><br />El consolador está diseñado para estimular el punto G en la mujer y el punto P (próstata) en el hombre, y se mantiene perfectamente en su sitio gracias a su base ventilada.<br /><br />Es recargable y su cable está incluido.<br /><br />Se le puede acoplar cualquier otro consolador/vibrador siempre que tenga la base ventilada.<br /><br />Es ajustable hasta 167cm de circunferencia de cadera y 95cm de circunferencia de muslo.<br /><br />Vibro:<br />Longitud total 24cm, longitud insertable 22.5cm<br />Grosor: de 3,8cm a 5,1cm<br /><br />El mando a distancia lleva una pila CR2032.<br /><br />El vibrador es recargable.<br /><br />Se incluye lubricante y limpiador de juguetes sexuales. |
| | guid | | string | https://dev.divasboudoir.com/es/talla-grande-teledirigida-you2toys-negro-y-lila/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un arnés y un consolador, ajustables a un tamaño de cintura y cadera de 167 cm, y sobre todo con mando a distancia. Todo lo que necesitas para pasar momentos increíbles con tu pareja. Tamaño ajustable hasta 122 cm de cintura (56-58) y 95 cm de muslo. Lubricante y limpiador de juguetes sexuales incluidos. |
| | keywords | | | title | | string | Talla grande teledirigida |
|
| | seotitle | | string | Talla grande teledirigida |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un arnés y un consolador, ajustables a un tamaño de cintura y cadera de 167 cm, y sobre todo con mando a distancia. Todo lo que necesitas para pasar momentos increíbles con tu pareja. Tamaño ajustable hasta 122 cm de cintura (56-58) y 95 cm de muslo.<br />Lubricante y limpiador de juguetes sexuales incluidos. |
| | title | | string | Talla grande teledirigida |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Ensemble Télécommandé<br /><br />Qualité, design et confort. <br /><br />Taille ajustable jusqu'à 122cm de tour de taille (58-90)<br /><br />Partagez des moments de plaisirs absolus grâce à ses 7 modes de vibration que vous pourrez contrôler à l'aide de à sa télécommande sans fil. Du mode le plus doux au plus vigoureux. <br /><br />Il est étanche pour des jeux humides...<br /><br />Le dildo a une forme adaptée à la stimulation du point G pour madame et du point P (prostate) pour monsieur. Il restera parfaitement en place grâce à sa base ventousée. <br /><br />Il est rechargeable et son cable est inclus. <br /><br />Vous pourrez y ajuster n'importe quel autre dildo/vibro tant qu'ils soient dotés d'une base ventousée. <br /><br />Il est réglable jusqu'à 167cm de tour de hanches et 95cm de tour de cuisse.<br /><br />Vibro:<br />Longueur totale 24cm, longueur insérable 22.5cm<br />Epaisseur: de 3.8cm à 5.1cm<br /><br />La télécommande est equipée d'une pile CR2032. <br /><br />Le vibro est rechargeable.<br /><br />Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | guid | | string | https://dev.divasboudoir.com/fr/ensemble-grande-taille-telecommande-you2toys-noir-et-mauve/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un harnais et son gode, ajustables jusqu'à un tour de taille de hanches de 167cm et surtout télécommandé. De quoi passer des moments incroyables avec votre partenaire. Taille ajustable jusqu'à 122cm de tour de taille (56-58) et 95cm de tour de cuisse. Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | keywords | | | title | | string | Ensemble Grande taille Télécommandé |
|
| | seotitle | | string | Ensemble Grande taille Télécommandé |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un harnais et son gode, ajustables jusqu'à un tour de taille de hanches de 167cm et surtout télécommandé. De quoi passer des moments incroyables avec votre partenaire. Taille ajustable jusqu'à 122cm de tour de taille (56-58) et 95cm de tour de cuisse. <br />Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | title | | string | Ensemble Grande taille Télécommandé |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Set di telecomandi<br /><br />Qualità, design e comfort.<br /><br />Misura regolabile fino a 122 cm di vita (58-90)<br /><br />Condividete momenti di assoluto piacere grazie alle 7 modalità di vibrazione che potete controllare con il telecomando wireless, dalle più delicate alle più vigorose.<br /><br />È impermeabile per i giochi bagnati...<br /><br />Il dildo è sagomato per stimolare il punto G per le donne e il punto P (prostata) per gli uomini, e rimarrà perfettamente in posizione grazie alla sua base ventilata.<br /><br />È ricaricabile e il cavo è incluso.<br /><br />È possibile montare qualsiasi altro dildo/vibro purché abbia una base ventilata.<br /><br />È regolabile fino a 167 cm di circonferenza dei fianchi e 95 cm di circonferenza delle cosce.<br /><br />Vibro:<br />Lunghezza totale 24 cm, lunghezza inseribile 22,5 cm<br />Spessore: da 3,8cm a 5,1cm<br /><br />Il telecomando è dotato di una batteria CR2032.<br /><br />Il vibratore è ricaricabile.<br /><br />Il lubrificante e il detergente per giocattoli sessuali sono inclusi. |
| | guid | | string | https://dev.divasboudoir.com/it/grande-set-telecomandato-you2toys-nero-e-malva/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un'imbracatura e un dildo, regolabili fino a una misura di vita e fianchi di 167 cm, e soprattutto telecomandati. Tutto ciò di cui avete bisogno per trascorrere momenti incredibili con il vostro partner. Misura regolabile fino a 122 cm di vita (56-58) e 95 cm di coscia. Lubrificante e detergente per sex toy inclusi. |
| | keywords | | | title | | string | Grande set telecomandato |
|
| | seotitle | | string | Grande set telecomandato |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un'imbracatura e un dildo, regolabili fino a una misura di vita e fianchi di 167 cm, e soprattutto telecomandati. Tutto ciò di cui avete bisogno per trascorrere momenti incredibili con il vostro partner. Misura regolabile fino a 122 cm di vita (56-58) e 95 cm di coscia.<br />Lubrificante e detergente per sex toy inclusi. |
| | title | | string | Grande set telecomandato |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Set met afstandsbediening<br /><br />Kwaliteit, ontwerp en comfort.<br /><br />In maat verstelbaar tot 122 cm taille (58-90)<br /><br />Beleef momenten van absoluut genot dankzij de 7 vibratiestanden die je kunt bedienen met de draadloze afstandsbediening, van de zachtste tot de meest krachtige.<br /><br />Waterdicht voor nat spel...<br /><br />De dildo is zo gevormd dat hij de G-plek voor vrouwen en de P-plek (prostaat) voor mannen stimuleert, en blijft perfect op zijn plaats zitten dankzij de geventileerde basis.<br /><br />Hij is oplaadbaar en het snoer is inbegrepen.<br /><br />Je kunt elke andere dildo/vibro gebruiken zolang ze een geventileerde basis hebben.<br /><br />Hij is verstelbaar tot 167 cm heupomtrek en 95 cm dijomtrek.<br /><br />Vibro:<br />Totale lengte 24cm, inbrengbare lengte 22,5cm<br />Dikte: van 3,8cm tot 5,1cm<br /><br />De afstandsbediening is voorzien van een CR2032 batterij.<br /><br />De vibrator is oplaadbaar.<br /><br />Glijmiddel en seksspeeltjesreiniger zijn inbegrepen. |
| | guid | | string | https://dev.divasboudoir.com/nl/groote-maat-set-met-afstandsbediening-you2toys-zwart-en-mauve/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Een harnas en dildo, verstelbaar tot een taille- en heupomvang van 167 cm, en bovenal met afstandsbediening. Alles wat je nodig hebt om ongelooflijke momenten met je partner door te brengen. In maat verstelbaar tot 122cm taille (56-58) en 95cm dij. Inclusief glijmiddel en seksspeeltjesreiniger. |
| | keywords | | | title | | string | Groote maat set met afstandsbediening |
|
| | seotitle | | string | Groote maat set met afstandsbediening |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Een harnas en dildo, verstelbaar tot een taille- en heupomvang van 167 cm, en bovenal met afstandsbediening. Alles wat je nodig hebt om ongelooflijke momenten met je partner door te brengen. In maat verstelbaar tot 122cm taille (56-58) en 95cm dij.<br />Inclusief glijmiddel en seksspeeltjesreiniger. |
| | title | | string | Groote maat set met afstandsbediening |
| | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Conjunto de controlo remoto<br /><br />Qualidade, design e conforto.<br /><br />Tamanho ajustável até 122 cm de cintura (58-90)<br /><br />Partilhe momentos de prazer absoluto graças aos seus 7 modos de vibração que pode controlar através do seu telecomando sem fios, do mais suave ao mais vigoroso.<br /><br />É à prova de água para brincar com água...<br /><br />O dildo tem uma forma que estimula o ponto G para as mulheres e o ponto P (próstata) para os homens, e mantém-se perfeitamente no sítio graças à sua base ventilada.<br /><br />É recarregável e o seu cabo está incluído.<br /><br />Pode adaptar-se a qualquer outro dildo/vibro, desde que tenha uma base ventilada.<br /><br />É ajustável até 167 cm de circunferência da anca e 95 cm de circunferência da coxa.<br /><br />Vibro:<br />Comprimento total 24cm, comprimento inserível 22,5cm<br />Espessura: de 3,8 cm a 5,1 cm<br /><br />O controlo remoto está equipado com uma pilha CR2032.<br /><br />O vibrador é recarregável.<br /><br />Inclui um lubrificante e um produto de limpeza para brinquedos sexuais. |
| | guid | | string | https://dev.divasboudoir.com/pt/conjunto-grande-com-controlo-remoto-you2toys-preto-e-lilas/cbwa5239.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Um arnês e um vibrador, ajustáveis a uma cintura e anca de 167 cm e, sobretudo, com controlo remoto. Tudo o que precisa para passar momentos incríveis com o seu parceiro. Tamanho ajustável até 122cm de cintura (56-58) e 95cm de coxa. Inclui lubrificante e limpador de brinquedos sexuais. |
| | keywords | | | title | | string | Conjunto grande com controlo remoto |
|
| | seotitle | | string | Conjunto grande com controlo remoto |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Um arnês e um vibrador, ajustáveis a uma cintura e anca de 167 cm e, sobretudo, com controlo remoto. Tudo o que precisa para passar momentos incríveis com o seu parceiro. Tamanho ajustável até 122cm de cintura (56-58) e 95cm de coxa.<br />Inclui lubrificante e limpador de brinquedos sexuais. |
| | title | | string | Conjunto de controlo remoto grande |
| | 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 | Ferngesteuertes Set<br /><br />Qualität, Design und Komfort.<br /><br />Verstellbare Größe bis zu 122 cm Taillenumfang (58-90)<br /><br />Mit den 7 Vibrationsmodi, die Sie mit der kabellosen Fernbedienung steuern können - von der sanftesten bis zur stärksten Vibration - erleben Sie den ultimativen Spaß.<br /><br />Er ist wasserdicht für feuchte Spiele...<br /><br />Der Dildo ist so geformt, dass er den G-Punkt der Frau und den P-Punkt (Prostata) des Mannes stimulieren kann und dank seines Saugnapfes perfekt an seinem Platz bleibt.<br /><br />Er ist wiederaufladbar und das Kabel ist im Lieferumfang enthalten.<br /><br />Sie können jeden anderen Dildo/Vibro an ihm befestigen, solange er über eine Saugnapfbasis verfügt.<br /><br />Er ist bis zu einem Hüftumfang von 167 cm und einem Oberschenkelumfang von 95 cm verstellbar.<br /><br />Vibro:<br />Gesamtlänge 24cm, einsetzbare Länge 22.5cm<br />Dicke: von 3.8cm bis 5.1cm<br /><br />Die Fernbedienung ist mit einer CR2032-Batterie ausgestattet.<br /><br />Der Vibrator ist wiederaufladbar.<br /><br />Ein Gleitmittel und ein Sextoy-Reiniger sind im Lieferumfang enthalten. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Ein Harness und sein Dildo, verstellbar bis zu einem Hüftumfang von 167cm und vor allem ferngesteuert. Damit können Sie unglaubliche Momente mit Ihrem Partner verbringen. Größe verstellbar bis zu einem Taillenumfang von 122cm (56-58) und einem Oberschenkelumfang von 95cm. Wir legen ein Gleitmittel und einen Sextoy-Reiniger bei. |
| | keywords | | | title | | string | Ferngesteuertes Großes Set |
|
| | seotitle | | string | Ferngesteuertes Großes Set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Ein Harness und sein Dildo, verstellbar bis zu einem Hüftumfang von 167cm und vor allem ferngesteuert. Damit können Sie unglaubliche Momente mit Ihrem Partner verbringen. Größe verstellbar bis zu einem Taillenumfang von 122cm (56-58) und einem Oberschenkelumfang von 95cm.<br />Wir legen ein Gleitmittel und einen Sextoy-Reiniger bei. |
| | title | | string | Ferngesteuertes Großes Set |
| | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Σετ τηλεχειριστηρίου<br /><br />Ποιότητα, σχεδιασμός και άνεση.<br /><br />Μέγεθος ρυθμιζόμενο έως 122cm μέση (58-90)<br /><br />Μοιραστείτε στιγμές απόλυτης απόλαυσης χάρη στους 7 τρόπους δόνησης που μπορείτε να ελέγξετε με το ασύρματο τηλεχειριστήριο, από τον πιο απαλό έως τον πιο έντονο.<br /><br />Είναι αδιάβροχο για παιχνίδι σε υγρό περιβάλλον...<br /><br />Ο δονητής έχει σχήμα που διεγείρει το σημείο G για τις γυναίκες και το σημείο P (προστάτης) για τους άνδρες και θα παραμείνει τέλεια στη θέση του χάρη στη βάση του με εξαερισμό.<br /><br />Είναι επαναφορτιζόμενος και το καλώδιό του περιλαμβάνεται.<br /><br />Μπορείτε να τοποθετήσετε οποιοδήποτε άλλο dildo/vibro αρκεί να έχει αεριζόμενη βάση.<br /><br />Είναι ρυθμιζόμενο μέχρι 167 εκατοστά περιφέρεια γοφών και 95 εκατοστά περιφέρεια μηρών.<br /><br />Δονητής:<br />Μήκος: Συνολικό μήκος 24cm, μήκος εισαγωγής 22,5cm<br />Πάχος: από 3,8cm έως 5,1cm<br /><br />Το τηλεχειριστήριο είναι εφοδιασμένο με μια μπαταρία CR2032.<br /><br />Ο δονητής είναι επαναφορτιζόμενος.<br /><br />Περιλαμβάνονται λιπαντικό και καθαριστικό για σεξουαλικά παιχνίδια. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Μια καλωδίωση και ένας δονητής, ρυθμιζόμενος σε μέγεθος μέσης και ισχίων 167 εκατοστών, και πάνω απ' όλα τηλεχειριζόμενος. Όλα όσα χρειάζεστε για να περάσετε απίστευτες στιγμές με τον σύντροφό σας. Μέγεθος ρυθμιζόμενο έως 122 εκατοστά στη μέση (56-58) και 95 εκατοστά στους μηρούς. Περιλαμβάνεται λιπαντικό και καθαριστικό για τα ερωτικά παιχνίδια. |
| | keywords | | | title | | string | Μεγάλο τηλεχειριζόμενο σετ |
|
| | seotitle | | string | Μεγάλο τηλεχειριζόμενο σετ |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Μια καλωδίωση και ένας δονητής, ρυθμιζόμενος σε μέγεθος μέσης και ισχίων 167 εκατοστών, και πάνω απ' όλα τηλεχειριζόμενος. Όλα όσα χρειάζεστε για να περάσετε απίστευτες στιγμές με τον σύντροφό σας. Μέγεθος ρυθμιζόμενο έως 122 εκατοστά στη μέση (56-58) και 95 εκατοστά στους μηρούς.<br />Περιλαμβάνεται λιπαντικό και καθαριστικό για τα ερωτικά παιχνίδια. |
| | title | | string | Μεγάλο τηλεχειριζόμενο σετ |
| | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Remote Control Set<br /><br />Quality, design and comfort.<br /><br />Size adjustable up to 122cm waist (58-90)<br /><br />Share moments of absolute pleasure thanks to its 7 vibration modes that you can control with its wireless remote control, from the gentlest to the most vigorous.<br /><br />Waterproof for wet play...<br /><br />The dildo is shaped to stimulate the G-spot for the lady and the P-spot (prostate) for the gentleman, and will stay perfectly in place thanks to its vented base.<br /><br />It's rechargeable and comes with a cable.<br /><br />You can fit any other dildo/vibro as long as it has a vented base.<br /><br />It's adjustable up to 167cm hip circumference and 95cm thigh circumference.<br /><br />Vibro:<br />Total length 24cm, insertable length 22.5cm<br />Thickness: from 3.8cm to 5.1cm<br /><br />The remote control is equipped with a CR2032 battery.<br /><br />The vibro is rechargeable.<br /><br />Lubricant and sex toy cleaner included. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | A harness and dildo, adjustable up to a hip size of 167cm and, above all, remote-controlled. Enough to spend incredible moments with your partner. Size adjustable up to 122cm waist (56-58) and 95cm thigh. Lubricant and sex toy cleaner included. |
| | keywords | | | title | | string | Remote-controlled plus size set |
|
| | seotitle | | string | Remote-controlled plus size set |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | A harness and dildo, adjustable up to a hip size of 167cm and, above all, remote-controlled. Enough to spend incredible moments with your partner. Size adjustable up to 122cm waist (56-58) and 95cm thigh.<br />Lubricant and sex toy cleaner included. |
| | title | | string | Remote-controlled plus size set |
| | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Conjunto de mando a distancia<br /><br />Calidad, diseño y comodidad.<br /><br />Talla ajustable hasta 122 cm de cintura (58-90)<br /><br />Comparte momentos de placer absoluto gracias a sus 7 modos de vibración que podrás controlar con su mando a distancia inalámbrico, desde el más suave al más vigoroso.<br /><br />Es resistente al agua para los juegos húmedos...<br /><br />El consolador está diseñado para estimular el punto G en la mujer y el punto P (próstata) en el hombre, y se mantiene perfectamente en su sitio gracias a su base ventilada.<br /><br />Es recargable y su cable está incluido.<br /><br />Se le puede acoplar cualquier otro consolador/vibrador siempre que tenga la base ventilada.<br /><br />Es ajustable hasta 167cm de circunferencia de cadera y 95cm de circunferencia de muslo.<br /><br />Vibro:<br />Longitud total 24cm, longitud insertable 22.5cm<br />Grosor: de 3,8cm a 5,1cm<br /><br />El mando a distancia lleva una pila CR2032.<br /><br />El vibrador es recargable.<br /><br />Se incluye lubricante y limpiador de juguetes sexuales. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un arnés y un consolador, ajustables a un tamaño de cintura y cadera de 167 cm, y sobre todo con mando a distancia. Todo lo que necesitas para pasar momentos increíbles con tu pareja. Tamaño ajustable hasta 122 cm de cintura (56-58) y 95 cm de muslo. Lubricante y limpiador de juguetes sexuales incluidos. |
| | keywords | | | title | | string | Talla grande teledirigida |
|
| | seotitle | | string | Talla grande teledirigida |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un arnés y un consolador, ajustables a un tamaño de cintura y cadera de 167 cm, y sobre todo con mando a distancia. Todo lo que necesitas para pasar momentos increíbles con tu pareja. Tamaño ajustable hasta 122 cm de cintura (56-58) y 95 cm de muslo.<br />Lubricante y limpiador de juguetes sexuales incluidos. |
| | title | | string | Talla grande teledirigida |
| | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Ensemble Télécommandé<br /><br />Qualité, design et confort. <br /><br />Taille ajustable jusqu'à 122cm de tour de taille (58-90)<br /><br />Partagez des moments de plaisirs absolus grâce à ses 7 modes de vibration que vous pourrez contrôler à l'aide de à sa télécommande sans fil. Du mode le plus doux au plus vigoureux. <br /><br />Il est étanche pour des jeux humides...<br /><br />Le dildo a une forme adaptée à la stimulation du point G pour madame et du point P (prostate) pour monsieur. Il restera parfaitement en place grâce à sa base ventousée. <br /><br />Il est rechargeable et son cable est inclus. <br /><br />Vous pourrez y ajuster n'importe quel autre dildo/vibro tant qu'ils soient dotés d'une base ventousée. <br /><br />Il est réglable jusqu'à 167cm de tour de hanches et 95cm de tour de cuisse.<br /><br />Vibro:<br />Longueur totale 24cm, longueur insérable 22.5cm<br />Epaisseur: de 3.8cm à 5.1cm<br /><br />La télécommande est equipée d'une pile CR2032. <br /><br />Le vibro est rechargeable.<br /><br />Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un harnais et son gode, ajustables jusqu'à un tour de taille de hanches de 167cm et surtout télécommandé. De quoi passer des moments incroyables avec votre partenaire. Taille ajustable jusqu'à 122cm de tour de taille (56-58) et 95cm de tour de cuisse. Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | keywords | | | title | | string | Ensemble Grande taille Télécommandé |
|
| | seotitle | | string | Ensemble Grande taille Télécommandé |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un harnais et son gode, ajustables jusqu'à un tour de taille de hanches de 167cm et surtout télécommandé. De quoi passer des moments incroyables avec votre partenaire. Taille ajustable jusqu'à 122cm de tour de taille (56-58) et 95cm de tour de cuisse. <br />Nous y incluons un lubrifiant et un nettoyant pour sextoys. |
| | title | | string | Ensemble Grande taille Télécommandé |
| | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Set di telecomandi<br /><br />Qualità, design e comfort.<br /><br />Misura regolabile fino a 122 cm di vita (58-90)<br /><br />Condividete momenti di assoluto piacere grazie alle 7 modalità di vibrazione che potete controllare con il telecomando wireless, dalle più delicate alle più vigorose.<br /><br />È impermeabile per i giochi bagnati...<br /><br />Il dildo è sagomato per stimolare il punto G per le donne e il punto P (prostata) per gli uomini, e rimarrà perfettamente in posizione grazie alla sua base ventilata.<br /><br />È ricaricabile e il cavo è incluso.<br /><br />È possibile montare qualsiasi altro dildo/vibro purché abbia una base ventilata.<br /><br />È regolabile fino a 167 cm di circonferenza dei fianchi e 95 cm di circonferenza delle cosce.<br /><br />Vibro:<br />Lunghezza totale 24 cm, lunghezza inseribile 22,5 cm<br />Spessore: da 3,8cm a 5,1cm<br /><br />Il telecomando è dotato di una batteria CR2032.<br /><br />Il vibratore è ricaricabile.<br /><br />Il lubrificante e il detergente per giocattoli sessuali sono inclusi. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un'imbracatura e un dildo, regolabili fino a una misura di vita e fianchi di 167 cm, e soprattutto telecomandati. Tutto ciò di cui avete bisogno per trascorrere momenti incredibili con il vostro partner. Misura regolabile fino a 122 cm di vita (56-58) e 95 cm di coscia. Lubrificante e detergente per sex toy inclusi. |
| | keywords | | | title | | string | Grande set telecomandato |
|
| | seotitle | | string | Grande set telecomandato |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Un'imbracatura e un dildo, regolabili fino a una misura di vita e fianchi di 167 cm, e soprattutto telecomandati. Tutto ciò di cui avete bisogno per trascorrere momenti incredibili con il vostro partner. Misura regolabile fino a 122 cm di vita (56-58) e 95 cm di coscia.<br />Lubrificante e detergente per sex toy inclusi. |
| | title | | string | Grande set telecomandato |
| | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Set met afstandsbediening<br /><br />Kwaliteit, ontwerp en comfort.<br /><br />In maat verstelbaar tot 122 cm taille (58-90)<br /><br />Beleef momenten van absoluut genot dankzij de 7 vibratiestanden die je kunt bedienen met de draadloze afstandsbediening, van de zachtste tot de meest krachtige.<br /><br />Waterdicht voor nat spel...<br /><br />De dildo is zo gevormd dat hij de G-plek voor vrouwen en de P-plek (prostaat) voor mannen stimuleert, en blijft perfect op zijn plaats zitten dankzij de geventileerde basis.<br /><br />Hij is oplaadbaar en het snoer is inbegrepen.<br /><br />Je kunt elke andere dildo/vibro gebruiken zolang ze een geventileerde basis hebben.<br /><br />Hij is verstelbaar tot 167 cm heupomtrek en 95 cm dijomtrek.<br /><br />Vibro:<br />Totale lengte 24cm, inbrengbare lengte 22,5cm<br />Dikte: van 3,8cm tot 5,1cm<br /><br />De afstandsbediening is voorzien van een CR2032 batterij.<br /><br />De vibrator is oplaadbaar.<br /><br />Glijmiddel en seksspeeltjesreiniger zijn inbegrepen. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Een harnas en dildo, verstelbaar tot een taille- en heupomvang van 167 cm, en bovenal met afstandsbediening. Alles wat je nodig hebt om ongelooflijke momenten met je partner door te brengen. In maat verstelbaar tot 122cm taille (56-58) en 95cm dij. Inclusief glijmiddel en seksspeeltjesreiniger. |
| | keywords | | | title | | string | Groote maat set met afstandsbediening |
|
| | seotitle | | string | Groote maat set met afstandsbediening |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Een harnas en dildo, verstelbaar tot een taille- en heupomvang van 167 cm, en bovenal met afstandsbediening. Alles wat je nodig hebt om ongelooflijke momenten met je partner door te brengen. In maat verstelbaar tot 122cm taille (56-58) en 95cm dij.<br />Inclusief glijmiddel en seksspeeltjesreiniger. |
| | title | | string | Groote maat set met afstandsbediening |
| | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | Conjunto de controlo remoto<br /><br />Qualidade, design e conforto.<br /><br />Tamanho ajustável até 122 cm de cintura (58-90)<br /><br />Partilhe momentos de prazer absoluto graças aos seus 7 modos de vibração que pode controlar através do seu telecomando sem fios, do mais suave ao mais vigoroso.<br /><br />É à prova de água para brincar com água...<br /><br />O dildo tem uma forma que estimula o ponto G para as mulheres e o ponto P (próstata) para os homens, e mantém-se perfeitamente no sítio graças à sua base ventilada.<br /><br />É recarregável e o seu cabo está incluído.<br /><br />Pode adaptar-se a qualquer outro dildo/vibro, desde que tenha uma base ventilada.<br /><br />É ajustável até 167 cm de circunferência da anca e 95 cm de circunferência da coxa.<br /><br />Vibro:<br />Comprimento total 24cm, comprimento inserível 22,5cm<br />Espessura: de 3,8 cm a 5,1 cm<br /><br />O controlo remoto está equipado com uma pilha CR2032.<br /><br />O vibrador é recarregável.<br /><br />Inclui um lubrificante e um produto de limpeza para brinquedos sexuais. |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Um arnês e um vibrador, ajustáveis a uma cintura e anca de 167 cm e, sobretudo, com controlo remoto. Tudo o que precisa para passar momentos incríveis com o seu parceiro. Tamanho ajustável até 122cm de cintura (56-58) e 95cm de coxa. Inclui lubrificante e limpador de brinquedos sexuais. |
| | keywords | | | title | | string | Conjunto grande com controlo remoto |
|
| | seotitle | | string | Conjunto grande com controlo remoto |
| | seouri | | | specifications | | | stylingtips | | | summary | | string | Um arnês e um vibrador, ajustáveis a uma cintura e anca de 167 cm e, sobretudo, com controlo remoto. Tudo o que precisa para passar momentos incríveis com o seu parceiro. Tamanho ajustável até 122cm de cintura (56-58) e 95cm de coxa.<br />Inclui lubrificante e limpador de brinquedos sexuais. |
| | title | | string | Conjunto de controlo remoto grande |
| | usageinstructions | |
|
|
|
| name | | string | RC Vibrating Strap-On 05506550000 |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | FA6BBD71-3F1E-42C9-B964AB1D037F9CC0 |
|
| promountil | |
| rating | |
| recorduid | | string | FA6BBD71-3F1E-42C9-B964AB1D037F9CC0 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.07 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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.69 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 | FA6BBD71-3F1E-42C9-B964AB1D037F9CC0 | F61DA686-D28D-46EF-9FA7B2E83443583A | 471 | blackpurple | linear-gradient(90deg, #000000 50%, #9400D4 50%) | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 74.9583 | 0 | | STOCK01 | 0 | 3 | 0 | -1 | 0 | 6 | 0 | 0 | 05506550000 | 4024144553075 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 2.41 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 = 'FA6BBD71-3F1E-42C9-B964AB1D037F9CC0' 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 | F61DA686-D28D-46EF-9FA7B2E83443583A | 471 | blackpurple | linear-gradient(90deg, #000000 50%, #9400D4 50%) | na | na | | na | | | na | | | | | | na | default | | na | intlsize | 74.9583 | 0 | | STOCK01 | 0 | 3 | 0 | -1 | 0 | 6 | 0 | 0 | 05506550000 | 4024144553075 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 74.9583 | all | |
|
| vatrate | |
| warehouse | |