Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | |
| brandmedias | | string | {"default":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"editorial":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""},"logo":{"height":"","width":"","type":"","rating":"","src":"","isprivate":""}} |
|
| brandmetas | | Struct | | de | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | el | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | en | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | es | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | fr | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | it | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | nl | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
| | pt | | Struct | | currentseouri | | | description | | | metas | | Struct | | description | | | keywords | | | title | |
| | name | | | seotitle | | | seouri | | | subtitle | | | summary | |
|
|
| brandname | |
| breasts | |
| careinstructions | |
| categories | | string | divasboudoir.lingerie.briefs.openpanty |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/sexylingerie/openpanty.jpg |
| | type | | | width | |
| | divasboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | fetishboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | latexboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | legsboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | lustboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| | private | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/private/default.jpg |
| | type | | | width | |
| | smboudoir | | Struct | | plus | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | small | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
| | standard | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | variations | | | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
|
|
| categorysizerange | |
| colorinfos | Query Template: /system/api/product/colors.cfc:13 Execution Time: 0.701 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | 2 | 2 |
|
| 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 '2025-08-21 18:20:01'} |
|
| 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 | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-09-12 16:16:19'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.653 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','it') 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('7d140d94-3a6f-4dae-a8bfac87d635b499',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.36 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','it') and product_categories.language in ('all','it') 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 <> 'SBGA7932' 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/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah_2.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/hecs/sbga7932/culotte_ouverte_garnde_taille_dalilah.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 | | string | products.houseofdesire.sbga7932 |
|
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwäsche mit kaltem Wasser, um die bestickte Spitze zu erhalten</li>
<li>Verwenden Sie ein mildes Waschmittel ohne Bleichmittel</li>
<li>Chlorfreie Bleiche nur wenn nötig</li>
<li>Trocknen auf dem Bügel, um die Form zu erhalten</li>
<li>Nicht bügeln, um Schäden an der Stickerei zu vermeiden</li>
<li>Träger beim Waschen vorsichtig handhaben</li>
</ul> |
| | description | | string | <p>Der bestickte Hipster Delilah verkörpert perfekt die Kunst, die Regeln zu brechen und gleichzeitig eine raffinierte Eleganz zu bewahren. Seine <strong>transparente, fein bestickte Spitze</strong> erzeugt ein kalkuliertes Spiel der Transparenz, das subtil enthüllt.</p>
<p>Das Mehrträgerdesign mit verstellbaren Schiebern <strong>passt sich perfekt an jede Körperform</strong> an und bietet eine individuelle Passform und optimalen Tragekomfort. Die Konstruktion ohne Schritt und Rücken verwandelt dieses Stück in ein wahres Kunstwerk der Verführung, während das gekreuzte Rückenteil eine auffallende visuelle Dimension hinzufügt, die <strong>großzügige Kurven</strong> hervorhebt.</p>
<p>Der Hipster Delilah definiert die Codes für sexy Dessous mit einem modernen und anspruchsvollen Ansatz neu.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/offenes-hoschen-schwarz/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Transparente, bestickte Spitze</strong> für raffinierte Eleganz</li>
<li><strong>Mehrträger-Design</strong> mit verstellbaren Schiebern</li>
<li><strong>Ohne Schritt und Rücken</strong> für ultimative Verführung</li>
<li>Gekreuzter<strong>Rücken</strong>, der die Kurven subtil enthüllt</li>
<li><strong>Zarte Konstruktion</strong>, die die Silhouette sublimiert</li>
<li><strong>Verstellbare Träger</strong> für individuellen Komfort</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah große Taille transparente bestickte Spitze, mehrträgerig ohne Schritt. Gewagtes überkreuztes Rückendesign. Kostenlose Lieferung ab 59€ bei Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Bestickt Multi-Träger Große Größen | Diva's Boudoir |
|
| | seotitle | | string | Hipster große Taille bestickte Spitze Multiträger ohne Schritt |
| | seouri | | string | offenes-hoschen-schwarz |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 100% Polyester (exklusive Besätze und Gummibänder)</li>
<li><strong>Stil:</strong> Mehrträger-Hipster ohne Zwickel</li>
<li><strong>Details:</strong> Transparente, bestickte Spitze, gekreuztes Rückendesign</li>
<li><strong>Träger:</strong> Verstellbar mit Schiebereglern<strong></strong> </li>
<li><strong>Konstruktion:</strong> Ohne Schritt, ohne Rücken</li>
<li><strong>Abschlüsse:</strong> Zarte Stickereien, gekreuzte Details</li>
</ul> |
| | stylingtips | | string | <p>Der Hipster Delilah lässt sich perfekt mit <a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/"><strong>Netzstrümpfen</strong></a> kombinieren, um die verwegene Seite zu betonen, oder mit passenden <strong>Bruststraffern</strong>, um ein raffiniertes Ensemble zu schaffen.</p>
<p>Für einen besonderen Abend kombinieren Sie es mit frecher <a href="https://www.divasboudoir.com/de/freche-herrenunterwasche/"><strong>Herrenunterwäsche</strong></a> für unvergessliche Paarspiele. Dieses Stück kann auch unter einem engen Kleid getragen werden, um beim Ausziehen für einen Überraschungseffekt zu sorgen. Für die Mutigsten: Ergänzen Sie es mit etwas Körperschmuck, der die bestickten Details unterstreicht. Hipster Delilah verwandelt jeden intimen Moment in ein sinnliches Haute-Couture-Spektakel.</p> |
| | summary | | string | <p>Der bestickte Hipster Delilah revolutioniert die Verführung mit seiner transparenten, fein bestickten Spitze und dem gewagten Mehrträger-Design.</p>
<p>Ohne Schritt und Rücken bricht dieses außergewöhnliche Stück mit raffinierter Eleganz alle Codes.</p> |
| | title | | string | Hipster Delilah Bestickt - Grenzenlose Eleganz und Kühnheit |
| | usageinstructions | | string | <p>Um Ihren Hipster Delilah anzuziehen, stellen Sie zunächst die Träger mit den verstellbaren Schiebern auf Ihre Körperform ein. Das <strong>Multiträger-Design</strong> ermöglicht eine individuelle Anpassung, die einen perfekten Sitz garantiert. Die zwickelfreie Konstruktion bietet absolute Freiheit, während das Kreuzband im Rücken einen spektakulären visuellen Effekt erzeugt.</p>
<p>Dieses Stück lässt sich ideal für besondere intime Momente tragen, in denen Sie für eine atemberaubende Überraschung sorgen möchten. Die <strong>zarten Träger</strong> erfordern eine sanfte Handhabung, um ihre Schönheit zu bewahren.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Πλύνετε στο χέρι με κρύο νερό για να διατηρήσετε την κεντημένη δαντέλα</li>
<li>Χρησιμοποιήστε ήπιο απορρυπαντικό χωρίς λευκαντικούς παράγοντες</li>
<li>Μη χλωριούχο λευκαντικό μόνο εάν είναι απαραίτητο</li>
<li>Στεγνώστε σε κρεμάστρα για να διατηρήσετε το σχήμα σας</li>
<li>Μην σιδερώνετε για να μην καταστραφεί το κέντημα</li>
<li>Να χειρίζεστε απαλά τις τιράντες κατά το πλύσιμο</li>
</ul> |
| | description | | string | <p>Το κεντημένο hipster Delilah ενσαρκώνει τέλεια την τέχνη του να παραβιάζεις τους κανόνες, διατηρώντας ταυτόχρονα μια εκλεπτυσμένη κομψότητα. Η <strong>λεπτότατα κεντημένη διάφανη δαντέλα</strong> του δημιουργεί ένα υπολογισμένο παιχνίδι διαφάνειας που αποκαλύπτει με λεπτότητα.</p>
<p>Ο σχεδιασμός με τις πολλαπλές ζώνες με ρυθμιζόμενα ρυθμιστικά <strong>προσαρμόζεται τέλεια σε όλα τα σχήματα σώματος</strong>, προσφέροντας εξατομικευμένη εφαρμογή και βέλτιστη άνεση. Η κατασκευή χωρίς καβάλο, χωρίς πλάτη, μετατρέπει αυτό το κομμάτι σε ένα έργο σαγηνευτικής τέχνης, ενώ η σταυρωτή πλάτη προσθέτει μια εντυπωσιακή οπτική διάσταση που <strong>αναδεικνύει τις γενναιόδωρες καμπύλες</strong>.</p>
<p>Το hipster Delilah επαναπροσδιορίζει τους κώδικες των σέξι εσωρούχων με μια μοντέρνα, εκλεπτυσμένη προσέγγιση.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/anoichta-eswroycha-mayro/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Διαφανής κεντημένη δαντέλα</strong> για εκλεπτυσμένη κομψότητα</li>
<li><strong>Σχεδιασμός πολλαπλών λουριών</strong> με ρυθμιζόμενα ρυθμιστικά</li>
<li><strong>Χωρίς καβάλο και χωρίς πλάτη</strong> για απόλυτη αποπλάνηση</li>
<li><strong>Η σταυρωτή πλάτη</strong> αποκαλύπτει διακριτικά τις καμπύλες</li>
<li><strong>Η λεπτή κατασκευή</strong> ενισχύει τη σιλουέτα</li>
<li><strong>Ρυθμιζόμενοι ιμάντες</strong> για εξατομικευμένη άνεση</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah μεγάλο μέγεθος με κεντημένη δαντέλα, πολλαπλών ιμάντων χωρίς καβάλο. Τολμηρό σχέδιο με σταυρό στην πλάτη. Δωρεάν παράδοση από €59 στο Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Κεντημένο Multi-Straps Large | Diva's Boudoir |
|
| | seotitle | | string | Hipster μεγάλη κεντημένη δαντέλα multi-bra crotchless |
| | seouri | | string | anoichta-eswroycha-mayro |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> 100% πολυεστέρας (με αποκλειστική επένδυση και λάστιχο)</li>
<li><strong>Στυλ:</strong> Χιπστερ χωρίς καβάλο με πολλαπλούς ιμάντες</li>
<li><strong>Λεπτομέρειες</strong>: Διαφανής κεντημένη δαντέλα, σχέδιο με σταυρό στην πλάτη</li>
<li><strong>Λουράκια :</strong> Ρυθμιζόμενα με ρυθμιστές</li>
<li><strong>Κατασκευή:</strong> Χωρίς καβάλο, χωρίς πλάτη</li>
<li><strong>Τελειώματα: :</strong> Λεπτό κέντημα, λεπτομέρειες με σταυρό χιαστί</li>
</ul> |
| | stylingtips | | string | <p>Το hipster Delilah ταιριάζει τέλεια με <a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/"><strong>διχτυωτές κάλτσες</strong></a> για να τονίσει την τολμηρή πλευρά του, ή με ασορτί <strong>τιράντες σουτιέν</strong> για να δημιουργήσει ένα εκλεπτυσμένο σύνολο.</p>
<p>Για μια ξεχωριστή βραδινή έξοδο, συνδυάστε το με άτακτα <a href="https://www.divasboudoir.com/el/atakta-andrika-eswroycha/"><strong>ανδρικά εσώρουχα</strong></a> για αξέχαστα παιχνίδια ζευγαριού. Αυτό το κομμάτι μπορεί επίσης να φορεθεί κάτω από ένα στενό φόρεμα για να δημιουργήσει ένα εφέ έκπληξης κατά το γδύσιμο. Για τις πιο τολμηρές, ολοκληρώστε την εμφάνιση με μερικά κοσμήματα σώματος για να αναδείξετε τις κεντημένες λεπτομέρειες. Το hipster Delilah μετατρέπει κάθε προσωπική στιγμή σε μια αισθησιακή επίδειξη υψηλής ραπτικής.</p> |
| | summary | | string | <p>Το κεντημένο hipster Delilah φέρνει επανάσταση στην αποπλάνηση με τη λεπτότατα κεντημένη διαφανή δαντέλα και το τολμηρό σχέδιο με τις πολλαπλές λουρίδες.</p>
<p>Χωρίς καβάλο και χωρίς πλάτη, αυτό το εξαιρετικό κομμάτι σπάει όλους τους κώδικες με εκλεπτυσμένη κομψότητα.</p> |
| | title | | string | Hipster Delilah Brodé - Απεριόριστη κομψότητα και τόλμη |
| | usageinstructions | | string | <p>Για να φορέσετε το Delilah hipster σας, προσαρμόστε πρώτα τους ιμάντες στο σχήμα του σώματός σας χρησιμοποιώντας τα ρυθμιζόμενα ρυθμιστικά. Ο <strong>σχεδιασμός με πολλαπλούς ιμάντες</strong> επιτρέπει μια εξατομικευμένη εφαρμογή που εγγυάται τέλεια στήριξη. Η κατασκευή χωρίς καβάλο προσφέρει απόλυτη ελευθερία, ενώ η σταυρωτή πλάτη δημιουργεί ένα εντυπωσιακό οπτικό αποτέλεσμα.</p>
<p>Αυτό το κομμάτι είναι ιδανικό για τις ιδιαίτερες προσωπικές στιγμές που θέλετε να δημιουργήσετε μια εντυπωσιακή έκπληξη. Οι <strong>ευαίσθητοι ιμάντες</strong> απαιτούν απαλό χειρισμό για να διατηρήσουν την ομορφιά τους.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Hand wash in cold water to preserve embroidered lace</li>
<li>Use a mild detergent without bleaching agents</li>
<li>Non-chlorine bleach only if necessary</li>
<li>Dry on a hanger to maintain shape</li>
<li>Do not iron to avoid damaging embroidery</li>
<li>Handle straps with care when washing</li>
</ul> |
| | description | | string | <p>The embroidered Delilah hipster perfectly embodies the art of breaking the rules while maintaining sophisticated elegance. Its <strong>finely embroidered transparent lace</strong> creates a calculated play of transparency that reveals with subtlety.</p>
<p>The multi-strap design with adjustable sliders <strong>adapts perfectly to all morphologies</strong>, offering a personalized fit and optimal comfort. The crotchless, backless construction transforms this piece into a true work of seductive art, while the cross-back adds a striking visual dimension that <strong>sublimates generous curves</strong>.</p>
<p>The hipster Delilah redefines the codes of sexy lingerie with a modern, sophisticated approach.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/open-panties-black/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Sheer embroidered lace</strong> for refined elegance</li>
<li><strong>Multi-strap design</strong> with adjustable sliders</li>
<li><strong>Crotchless and backless</strong> for ultimate seduction</li>
<li><strong>Cross-over back</strong> subtly reveals curves</li>
<li><strong>Delicate construction</strong> enhances the silhouette</li>
<li><strong>Adjustable straps</strong> for personalized comfort</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah plus size sheer embroidered lace, multi-strap crotchless. Bold cross-back design. Free delivery from 59€ at Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Embroidered Multi-Straps Plus Size | Diva's Boudoir |
|
| | seotitle | | string | Hipster plus size lace embroidered multi-strap crotchless |
| | seouri | | | specifications | | string | <ul>
<li><strong>Material:</strong> 100% Polyester (exclusive trim and elastic)</li>
<li><strong>Style:</strong> Crotchless multi-strap hipster</li>
<li><strong>Details:</strong> Sheer embroidered lace, cross-back design</li>
<li><strong>Straps:</strong> Adjustable with sliders</li>
<li><strong>Construction:</strong> Crotchless, backless</li>
<li><strong>Finishes:</strong> Delicate embroidery, criss-cross details</li>
</ul> |
| | stylingtips | | string | <p>The Delilah hipster pairs perfectly with <a href="https://www.divasboudoir.com/en/socks-large-size/"><strong>fishnet stockings</strong></a> to accentuate the daring side, or with matching <strong>bra straps</strong> to create a sophisticated ensemble.</p>
<p>For a special evening, pair it with naughty <a href="https://www.divasboudoir.com/en/naughty-mens-lingerie/"><strong>men's lingerie</strong></a> for unforgettable couple's games. This piece can also be worn under a tight dress to create a surprise effect when undressing. For the more daring, complete the look with some body jewelry to highlight the embroidered details. The hipster Delilah transforms every intimate moment into a sensual haute couture spectacle.</p> |
| | summary | | string | <p>The embroidered Delilah hipster revolutionizes seduction with its finely embroidered sheer lace and bold multi-strap design.</p>
<p>Crotchless and backless, this exceptional piece breaks all codes with sophisticated elegance.</p> |
| | title | | string | Hipster Delilah Brodé - Boundless elegance and boldness |
| | usageinstructions | | string | <p>To put on your Delilah hipster, first adjust the straps to your body shape with the adjustable sliders. The <strong>multi-strap design</strong> enables a personalized fit that guarantees perfect support. The crotchless construction offers total freedom, while the cross-back creates a spectacular visual effect.</p>
<p>This piece is ideal for those special intimate moments when you want to create a striking surprise. The <strong>delicate straps</strong> require gentle handling to preserve their beauty.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar a mano en agua fría para preservar el encaje bordado</li>
<li>Utilice un detergente suave sin blanqueantes</li>
<li>Blanqueador sin cloro sólo si es necesario</li>
<li>Secar en una percha para mantener la forma</li>
<li>No planchar para no dañar el bordado</li>
<li>Manipule los tirantes con cuidado al lavarlos</li>
</ul> |
| | description | | string | <p>El hipster Delilah bordado encarna a la perfección el arte de romper las reglas conservando una sofisticada elegancia. Su <strong>fino encaje bordado</strong> crea un calculado juego de transparencias que revela con sutileza.</p>
<p>El diseño de tirantes múltiples con deslizadores ajustables <strong>se adapta perfectamente a todas las formas del cuerpo</strong>, ofreciendo un ajuste personalizado y una comodidad óptima. La construcción sin entrepierna y sin espalda convierte esta pieza en una obra de arte seductora, mientras que la espalda entrecruzada añade una llamativa dimensión visual que <strong>realza las curvas generosas</strong>.</p>
<p>El hipster Delilah redefine los códigos de la lencería sexy con un enfoque moderno y sofisticado.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/bragas-abiertas-negro/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Encaje bordado transparente</strong> para una elegancia refinada</li>
<li><strong>Diseño de tirantes múltiples</strong> con deslizadores ajustables</li>
<li><strong>Sin entrepierna ni espalda</strong> para la máxima seducción</li>
<li><strong>La espalda entrecruzada</strong> revela sutilmente las curvas</li>
<li><strong>Su delicada confección</strong> realza la silueta</li>
<li><strong>Tirantes ajustables</strong> para un confort personalizado</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah talla grande de encaje bordado transparente, sin entrepierna con múltiples tiras. Atrevido diseño cruzado en la espalda. Envío gratuito a partir de 59 € en Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah bordado talla grande | Diva's Boudoir |
|
| | seotitle | | string | Hipster talla grande multibra de encaje bordado sin entrepierna |
| | seouri | | string | bragas-abiertas-negro |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 100% poliéster (ribete y elástico exclusivos)</li>
<li><strong>Estilo:</strong> Hipster de tirantes múltiples sin entrepierna</li>
<li><strong>Detalles:</strong> Encaje bordado transparente, diseño cruzado en la espalda</li>
<li><strong>Tirantes:</strong> Ajustables con deslizadores</li>
<li><strong>Construcción:</strong> Sin entrepierna, sin espalda</li>
<li><strong>Acabados :</strong> Delicados bordados, detalles entrecruzados</li>
</ul> |
| | stylingtips | | string | <p>El hipster Delilah es perfecto con <a href="https://www.divasboudoir.com/es/medias-grandes/"><strong>medias de rejilla</strong></a> para un look más atrevido, o con <strong>tirantes de sujetador</strong> a juego para crear un conjunto sofisticado.</p>
<p>Para una salida nocturna especial, combínalo con <a href="https://www.divasboudoir.com/es/lenceria-masculina-atrevida/"><strong>lencería masculina</strong></a> traviesa para unos juegos de pareja inolvidables. Esta pieza también puede llevarse bajo un vestido ajustado para crear un efecto sorpresa al desvestirse. Para las más atrevidas, completa el look con alguna joya corporal para resaltar los detalles bordados. El hipster Delilah transforma cada momento íntimo en un sensual espectáculo de alta costura.</p> |
| | summary | | string | <p>El hipster Delilah bordado revoluciona la seducción con su encaje transparente finamente bordado y su atrevido diseño multitiras.</p>
<p>Sin entrepierna y sin espalda, esta pieza excepcional rompe todos los códigos con una elegancia sofisticada.</p> |
| | title | | string | Hipster Delilah Brodé - Elegancia y atrevimiento sin límites |
| | usageinstructions | | string | <p>Para ponerte la braguita Delilah, primero ajusta los tirantes a la forma de tu cuerpo utilizando los deslizadores ajustables. El <strong>diseño de tirantes múltiples</strong> permite un ajuste personalizado que garantiza una sujeción perfecta. La construcción sin entrepierna ofrece una libertad total, mientras que la espalda entrecruzada crea un efecto visual espectacular.</p>
<p>Esta pieza es ideal para esos momentos íntimos especiales en los que desea crear una impactante sorpresa. <strong>Los delicados tirantes</strong> requieren una manipulación suave para preservar su belleza.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage à la main à l'eau froide pour préserver la dentelle brodée</li>
<li>Utiliser une lessive douce sans agents blanchissants</li>
<li>Javel non chlorée uniquement si nécessaire</li>
<li>Séchage sur cintre pour maintenir la forme</li>
<li>Ne pas repasser pour éviter d'endommager les broderies</li>
<li>Manipuler délicatement les bretelles lors du lavage</li>
</ul> |
| | description | | string | <p>L'hipster Delilah brodé incarne parfaitement l'art de briser les règles tout en conservant une élégance sophistiquée. Sa <strong>dentelle transparente finement brodée</strong> crée un jeu de transparence calculé qui révèle avec subtilité.</p>
<p>Le design multi-bretelles avec curseurs réglables <strong>s'adapte parfaitement à toutes les morphologies</strong>, offrant un ajustement personnalisé et un confort optimal. La construction sans entrejambe et sans dos transforme cette pièce en véritable œuvre d'art de la séduction, tandis que le croisé dans le dos ajoute une dimension visuelle saisissante qui <strong>sublime les courbes généreuses</strong>. </p>
<p>Le hipster Delilah redéfinit les codes de la lingerie sexy avec une approche moderne et sophistiquée.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/hipster-dentelle-brodee-multi-bretelles-grande-taille/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Dentelle brodée transparente</strong> pour une élégance raffinée</li>
<li><strong>Design multi-bretelles</strong> avec curseurs réglables</li>
<li><strong>Sans entrejambe et sans dos</strong> pour une séduction ultime</li>
<li><strong>Croisé dans le dos</strong> qui révèle subtilement les courbes</li>
<li><strong>Construction délicate</strong> qui sublime la silhouette</li>
<li><strong>Bretelles ajustables</strong> pour un confort personnalisé</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah grande taille dentelle brodée transparente, multi-bretelles sans entrejambe. Design croisé dos audacieux. Livraison gratuite dès 59€ chez Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Brodé Multi-Bretelles Grande Taille | Diva's Boudoir |
|
| | seotitle | | string | Hipster grande taille dentelle brodée multi-bretelles sans entrejambe |
| | seouri | | string | hipster-dentelle-brodee-multi-bretelles-grande-taille |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> 100% Polyester (exclusif des garnitures et élastiques)</li>
<li><strong>Style :</strong> Hipster multi-bretelles sans entrejambe</li>
<li><strong>Détails :</strong> Dentelle brodée transparente, design croisé dos</li>
<li><strong>Bretelles :</strong> Réglables avec curseurs</li>
<li><strong>Construction :</strong> Sans entrejambe, sans dos</li>
<li><strong>Finitions :</strong> Broderies délicates, détails croisés</li>
</ul> |
| | stylingtips | | string | <p>L'hipster Delilah se marie parfaitement avec des <a href="https://www.divasboudoir.com/fr/bas-grande-taille/"><strong>bas résille</strong></a> pour accentuer le côté audacieux, ou avec des <strong>redresse-seins</strong> assortis pour créer un ensemble sophistiqué.</p>
<p>Pour une soirée spéciale, associez-le à une <a href="https://www.divasboudoir.com/fr/lingerie-homme-coquine/"><strong>lingerie pour homme</strong></a> coquine pour des jeux de couple inoubliables. Cette pièce peut aussi se porter sous une robe moulante pour créer un effet de surprise lors du déshabillage. Pour les plus audacieuses, complétez avec quelques bijoux de corps qui souligneront les détails brodés. L'hipster Delilah transforme chaque moment intime en spectacle de haute couture sensuelle.</p> |
| | summary | | string | <p>L'hipster Delilah brodé révolutionne la séduction avec sa dentelle transparente finement brodée et son design multi-bretelles audacieux.</p>
<p>Sans entrejambe et sans dos, cette pièce d'exception brise tous les codes avec une élégance sophistiquée.</p> |
| | title | | string | Hipster Delilah Brodé - Élégance et audace sans limites |
| | usageinstructions | | string | <p>Pour enfiler votre hipster Delilah, ajustez d'abord les bretelles selon votre morphologie grâce aux curseurs réglables. Le <strong>design multi-bretelles</strong> permet un ajustement personnalisé qui garantit un maintien parfait. La construction sans entrejambe offre une liberté totale, tandis que le croisé dans le dos crée un effet visuel spectaculaire.</p>
<p>Cette pièce se porte idéalement pour des moments intimes spéciaux où vous souhaitez créer une surprise saisissante. Les <strong>bretelles délicates</strong> nécessitent une manipulation douce pour préserver leur beauté.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavare a mano in acqua fredda per preservare il pizzo ricamato</li>
<li>Utilizzare un detersivo delicato senza agenti sbiancanti</li>
<li>Candeggiare senza cloro solo se necessario</li>
<li>Asciugare su una gruccia per mantenere la forma</li>
<li>Non stirare per evitare di danneggiare i ricami</li>
<li>Maneggiare delicatamente le bretelle durante il lavaggio</li>
</ul> |
| | description | | string | <p>L'hipster ricamato Delilah incarna perfettamente l'arte di infrangere le regole mantenendo un'eleganza sofisticata. Il <strong>pizzo velato finemente ricamato</strong> crea un calcolato gioco di trasparenze che rivela con delicatezza.</p>
<p>Il design multi-strap con cursori regolabili <strong>si adatta perfettamente a tutte le forme del corpo</strong>, offrendo una vestibilità personalizzata e un comfort ottimale. La costruzione crotchless e senza schienale trasforma questo capo in un'opera d'arte seducente, mentre la schiena incrociata aggiunge una dimensione visiva sorprendente che <strong>esalta le curve generose</strong>.</p>
<p>L'hipster Delilah ridefinisce i codici della lingerie sexy con un approccio moderno e sofisticato.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/mutandine-aperte-nero/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Pizzo ricamato trasparente</strong> per un'eleganza raffinata</li>
<li><strong>Design multistrato</strong> con cursori regolabili</li>
<li><strong>Senza cavallo e senza schienale</strong> per la massima seduzione</li>
<li>La<strong>schiena incrociata</strong> rivela le curve in modo discreto</li>
<li><strong>La struttura delicata</strong> esalta la silhouette</li>
<li><strong>Cinghie regolabili</strong> per un comfort personalizzato</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah di grande taglia in pizzo velato ricamato, multi strap crotchless. Audace design incrociato sulla schiena. Consegna gratuita a partire da 59 € su Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah ricamato Taglia grande | Diva's Boudoir |
|
| | seotitle | | string | Hipster taglia grande in pizzo ricamato multi-bra crotchless |
| | seouri | | string | mutandine-aperte-nero |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> 100% poliestere (esclusi i bordi e l'elastico)</li>
<li><strong>Stile:</strong> Hipster crotchless multi-strap</li>
<li><strong>Dettagli:</strong> pizzo ricamato trasparente, design incrociato sulla schiena</li>
<li><strong>Spalline:</strong> regolabili con cursori</li>
<li><strong>Costruzione:</strong> senza cavallo, senza schienale</li>
<li><strong>Finiture :</strong> Ricamo delicato, dettagli criss-cross</li>
</ul> |
| | stylingtips | | string | <p>L'hipster Delilah è perfetto con le <a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/"><strong>calze a rete</strong></a> per un look più audace, o con le <strong>spalline</strong> del <strong>reggiseno</strong> abbinate per creare un insieme sofisticato.</p>
<p>Per una serata speciale, abbinatelo a <a href="https://www.divasboudoir.com/it/lingerie-da-uomo-birichina/"><strong>lingerie maschile</strong></a> maliziosa per giochi di coppia indimenticabili. Questo capo può essere indossato anche sotto un abito attillato per creare un effetto sorpresa quando ci si spoglia. Per i più audaci, completate il look con dei gioielli per il corpo che mettano in risalto i dettagli ricamati. L'hipster Delilah trasforma ogni momento di intimità in un sensuale spettacolo di alta moda.</p> |
| | summary | | string | <p>L'hipster ricamato Delilah rivoluziona la seduzione con il suo pizzo trasparente finemente ricamato e l'audace design a più cinturini.</p>
<p>Senza cavallo e senza schienale, questo pezzo eccezionale rompe tutti i codici con un'eleganza sofisticata.</p> |
| | title | | string | Hipster Delilah Brodé - Eleganza e audacia senza limiti |
| | usageinstructions | | string | <p>Per indossare il vostro Delilah hipster, regolate prima le spalline in base alla vostra forma del corpo utilizzando i cursori regolabili. Il <strong>design a più spalline</strong> consente una vestibilità personalizzata che garantisce un sostegno perfetto. La costruzione crotchless offre una libertà totale, mentre la schiena criss-cross crea un effetto visivo spettacolare.</p>
<p>Questo pezzo è ideale per quei momenti di intimità speciali in cui si vuole creare una sorpresa eclatante. Le <strong>delicate spalline</strong> devono essere trattate con delicatezza per preservarne la bellezza.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Handwas in koud water om het geborduurde kant te behouden</li>
<li>Gebruik een mild wasmiddel zonder bleekmiddelen</li>
<li>Niet-chloorbleekmiddel alleen indien nodig</li>
<li>Drogen op een kleerhanger om de vorm te behouden</li>
<li>Niet strijken om beschadiging van het borduurwerk te voorkomen</li>
<li>Beugels voorzichtig behandelen tijdens het wassen</li>
</ul> |
| | description | | string | <p>De geborduurde Delilah hipster belichaamt perfect de kunst om de regels te breken en toch een verfijnde elegantie te behouden. Het <strong>fijn geborduurde transparante kant</strong> creëert een berekend spel van transparantie dat subtiel onthult.</p>
<p>Het ontwerp met meerdere bandjes en verstelbare schuifjes <strong>past zich perfect aan alle lichaamsvormen</strong> aan en biedt een persoonlijke pasvorm en optimaal comfort. De kruisloze, rugloze constructie maakt van dit stuk een verleidelijk kunstwerk, terwijl de gekruiste achterkant een opvallende visuele dimensie toevoegt die <strong>royale rondingen benadrukt</strong>.</p>
<p>De Delilah hipster herdefinieert de codes van sexy lingerie met een moderne, geraffineerde benadering.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/open-slipjes-zwart/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Geborduurd kant</strong> voor verfijnde elegantie</li>
<li><strong>Ontwerp met meerdere bandjes</strong> en verstelbare schuivers</li>
<li><strong>Kruisloos en rugloos</strong> voor ultieme verleiding</li>
<li><strong>De kriskras rug</strong> onthult subtiel rondingen</li>
<li><strong>Delicate constructie</strong> verbetert het silhouet</li>
<li><strong>Verstelbare bandjes</strong> voor persoonlijk comfort</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah grote maat van geborduurd kant, kruisloos met meerdere bandjes. Gedurfd kriskras rugontwerp. Gratis bezorging vanaf €59 bij Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Geborduurde Grote Maat | Diva's Boudoir |
|
| | seotitle | | string | Hipster grote maat geborduurde kanten multibh kruisloos |
| | seouri | | | specifications | | string | <ul>
<li><strong>Materiaal:</strong> 100% Polyester (exclusief bies en elastiek)</li>
<li><strong>Stijl:</strong> Kruisloze hipster met meerdere bandjes</li>
<li><strong>Details :</strong> geborduurd kant, kriskras rugontwerp</li>
<li><strong>Bandjes :</strong> Verstelbaar met schuifjes</li>
<li><strong>Constructie:</strong> kruisloos, rugloos</li>
<li><strong>Afwerkingen :</strong> Delicaat borduurwerk, kriskras details</li>
</ul> |
| | stylingtips | | string | <p>De Delilah hipster is perfect met <a href="https://www.divasboudoir.com/nl/grote-maat-kousen/"><strong>netkousen</strong></a> voor een gewaagdere look, of met bijpassende <strong>bh-bandjes</strong> voor een geraffineerd ensemble.</p>
<p>Voor een speciaal avondje uit combineer je het met ondeugende <a href="https://www.divasboudoir.com/nl/ondeugende-mannenlingerie/"><strong>mannenlingerie</strong></a> voor onvergetelijke stoeipartijtjes. Dit stuk kan ook onder een strakke jurk gedragen worden voor een verrassingseffect bij het uitkleden. Als je meer lef hebt, maak je de look af met wat lichaamssieraden om de geborduurde details te benadrukken. De hipster Delilah verandert elk intiem moment in een sensuele show van haute couture.</p> |
| | summary | | string | <p>De geborduurde Delilah hipster zorgt voor een revolutie in de verleiding met zijn fijn geborduurde transparante kant en gedurfde ontwerp met meerdere bandjes.</p>
<p>Zonder kruis en zonder rug breekt dit uitzonderlijke stuk alle codes met geraffineerde elegantie.</p> |
| | title | | string | Hipster Delilah Brodé - Onbeperkte elegantie en brutaliteit |
| | usageinstructions | | string | <p>Om je Delilah hipster aan te trekken, pas je eerst de bandjes aan je lichaamsvorm aan met de verstelbare schuifjes. Het <strong>ontwerp met meerdere bandjes</strong> zorgt voor een persoonlijke pasvorm die perfecte ondersteuning garandeert. De kruisloze constructie biedt totale vrijheid, terwijl de kriskras achterkant een spectaculair visueel effect creëert.</p>
<p>Dit stuk is ideaal voor die speciale intieme momenten wanneer je voor een opvallende verrassing wilt zorgen. De <strong>delicate bandjes</strong> moeten voorzichtig worden behandeld om hun schoonheid te behouden.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar à mão em água fria para preservar a renda bordada</li>
<li>Utilizar um detergente suave sem agentes branqueadores</li>
<li>Lixívia sem cloro apenas se necessário</li>
<li>Secar num cabide para manter a forma</li>
<li>Não passar a ferro para não danificar o bordado</li>
<li>Manusear os suspensórios com cuidado durante a lavagem</li>
</ul> |
| | description | | string | <p>O hipster Delilah bordado encarna na perfeição a arte de quebrar as regras, mantendo uma elegância sofisticada. A sua <strong>renda pura finamente bordada</strong> cria um jogo calculado de transparência que revela com subtileza.</p>
<p>O design de várias tiras com corrediças ajustáveis <strong>adapta-se perfeitamente a todas as formas do corpo</strong>, oferecendo um ajuste personalizado e um conforto ótimo. A construção sem virilhas e sem costas transforma esta peça numa obra de arte sedutora, enquanto as costas cruzadas acrescentam uma dimensão visual marcante que <strong>realça as curvas generosas</strong>.</p>
<p>O hipster Delilah redefine os códigos da lingerie sexy com uma abordagem moderna e sofisticada.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/calcinhas-abertas-preto/sbga7932.htm |
| | highlights | | string | <ul>
<li><strong>Renda bordada transparente</strong> para uma elegância requintada</li>
<li><strong>Design</strong> com<strong>várias tiras</strong> e corrediças ajustáveis</li>
<li><strong>Sem entrepernas e sem costas</strong> para a máxima sedução</li>
<li><strong>As costas cruzadas</strong> revelam subtilmente as curvas</li>
<li><strong>A construção delicada</strong> realça a silhueta</li>
<li><strong>Alças ajustáveis</strong> para um conforto personalizado</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Hipster Delilah tamanho grande em renda bordada, com várias alças e sem pernas. Design ousado e cruzado nas costas. Entrega gratuita a partir de 59 € na Diva's Boudoir. |
| | keywords | | | title | | string | Hipster Delilah Bordado Multi-Straps Grande | Diva's Boudoir |
|
| | seotitle | | string | Hipster grande de renda bordada multi-sutiã sem alças |
| | seouri | | string | calcinhas-abertas-preto |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 100% poliéster (exclusivamente guarnição e elástico)</li>
<li><strong>Estilo:</strong> Crotchless multi-strap hipster</li>
<li><strong>Detalhes :</strong> Renda bordada transparente, design cruzado nas costas</li>
<li><strong>Alças:</strong> Ajustáveis com corrediças</li>
<li><strong>Construção:</strong> Sem entrepernas, sem costas</li>
<li><strong>Acabamentos :</strong> Bordados delicados, pormenores cruzados</li>
</ul> |
| | stylingtips | | string | <p>O hipster Delilah combina perfeitamente com <a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/"><strong>meias de rede</strong></a> para acentuar o lado ousado, ou com <strong>alças de sutiã</strong> a condizer para criar um conjunto sofisticado.</p>
<p>Para uma saída nocturna especial, combine-o com <a href="https://www.divasboudoir.com/pt/lingerie-masculina-atrevida/"><strong>lingerie masculina</strong></a> atrevida para jogos de casal inesquecíveis. Esta peça também pode ser usada por baixo de um vestido justo para criar um efeito surpresa ao despir-se. Para as mais ousadas, completar o look com algumas jóias de corpo para realçar os detalhes bordados. A Delilah hipster transforma cada momento íntimo num espetáculo sensual de alta costura.</p> |
| | summary | | string | <p>O hipster Delilah bordado revoluciona a sedução com a sua renda transparente finamente bordada e o seu design ousado com várias alças.</p>
<p>Sem entrepernas e sem costas, esta peça excecional quebra todos os códigos com uma elegância sofisticada.</p> |
| | title | | string | Hipster Delilah Brodé - Elegância e ousadia sem limites |
| | usageinstructions | | string | <p>Para vestir o seu hipster Delilah, comece por ajustar as alças à forma do seu corpo utilizando as corrediças ajustáveis. O <strong>design com várias alças</strong> permite um ajuste personalizado que garante um apoio perfeito. A construção sem entrepernas oferece total liberdade, enquanto as costas cruzadas criam um efeito visual espetacular.</p>
<p>Esta peça é ideal para aqueles momentos íntimos especiais em que se pretende criar uma surpresa marcante. As <strong>alças delicadas</strong> requerem um manuseamento suave para preservar a sua beleza.</p> |
|
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 7D140D94-3A6F-4DAE-A8BFAC87D635B499 |
|
| promountil | |
| rating | |
| recorduid | | string | 7D140D94-3A6F-4DAE-A8BFAC87D635B499 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.38 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype, product_variations.color, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED )) , SUBSTRING_INDEX(intlsize,'-',1) ) as param1, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)), MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize)) ) , SUBSTRING_INDEX(intlsize,'-',-1) ) as param2, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, 999999, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as groupavailable, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight from product_sizes left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_sizes.id_size,'2074,2067,2073') > 0 and product_variations.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and intlsize <> 'na' and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_sizes.id_size, product_variations.color order by FIELD(product_sizes.gender,'w','m'), product_sizes.sizegroup, FIELD(intlsize,'XS','S','S/M','S-M','M','M/L','M-L','L','L-XL','L/XL','XL','0X','0XL','lXL','1X','1X-2X','1X/2X','XL/2XL','XL-2XL','1XL-2XL','2XL','2X','XXL','2X-3X','2X/3X','2XL-3XL','2XL/3XL','XXXL','3XL','3X','3X-4X','3X/4X','3XL-4XL','3XL/4XL','4XL','5XL','5X','5X-6X','5X/6X','5XL-6XL','5XL/6XL','6XL','6X','7XL','7X','8XL','8X'), cast(intlsize as SIGNED ), groupavailable desc, stock desc
| | recorduid | size | sizetype | color | param1 | param2 | available | groupavailable | stock | gender | sizerange | sizegroup | suppliersize | intlsize | inches | eusize | ussize | uksize | frsize | essize | desize | itsize | ptsize | elsize | bust | waist | hip | underbust | cup | thigh | legheight | bodyheight | bodyweight | | 1 | 2074 | 1X/2X- | intlsize | black | 1X/2X | | 1 | 1 | 1 | w | plus | lingerie | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | 104-110 | 86-91 | 112-120 | | | | | | | | 2 | 2067 | 1X/2X | intlsize | black | 1X/2X | 1X/2X | 1 | 1 | 1 | w | plus | lingerie | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 112-118 | 92-96 | 122-128 | | | | | | | | 3 | 2073 | 3X/4X | intlsize | black | 3X/4X | 3X/4X | 1 | 1 | 1 | w | plus | lingerie | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 120-128 | 98-102 | 128-132 | | | | | | |
|
| 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: 4.32 ms Record Count: 2 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2074 and FIND_IN_SET(product_sizes.sizerange,"all,plus") and product_stocks.stockuid = 'STOCK01' GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid UNION select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2067 and FIND_IN_SET(product_sizes.sizerange,"all,plus") and product_stocks.stockuid = 'STOCK01' GROUP BY product_stocks.productuid, product_stocks.variationuid, product_stocks.stockuid UNION select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2073 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 | 7D140D94-3A6F-4DAE-A8BFAC87D635B499 | B6282B0E-1EB3-4EC5-802A907FDD0C4EA0 | 2074 | black | #000000 | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 840312895075 | 1 | 1 | all | | | 2 | 7D140D94-3A6F-4DAE-A8BFAC87D635B499 | AFA66653-9E2E-430A-BF6D48BDF9F6E2AE | 2073 | black | #000000 | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 840312895082 | 1 | 1 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 5.87 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2074 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid UNION select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2067 and FIND_IN_SET(product_sizes.sizerange,"all,plus") group by product_variations.variationuid UNION select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' 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 = '7D140D94-3A6F-4DAE-A8BFAC87D635B499' and product_variations.isactive = 1 and product_sizes.id_size = 2073 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 | B6282B0E-1EB3-4EC5-802A907FDD0C4EA0 | 2074 | black | #000000 | 1X/2X | 1X/2X- | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 46-48 | 44-46 | 42-44 | w | lingerie | | 1X/2X- | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 840312895075 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 33.2917 | all | | | 2 | B6282B0E-1EB3-4EC5-802A907FDD0C4EA0 | 2067 | black | #000000 | 1X/2X | 1X/2X | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 1X/2X | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 840312895075 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 33.2917 | all | | | 3 | AFA66653-9E2E-430A-BF6D48BDF9F6E2AE | 2073 | black | #000000 | 3X/4X | 3X/4X | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 3X/4X | intlsize | 33.2917 | 0 | | STOCK01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 840312895082 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 33.2917 | all | |
|
| vatrate | |
| warehouse | |