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.695 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'red') > 0 and product_variations.productuid = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | red | color | red | red | red | #F50000 | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2025-09-06 17:37:34'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | | string | p5091-culotte-ouverte |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-10-22 18:41:25'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.677 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','nl') 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('7e8fb423-5e88-4d19-b5342db1ab0126fd',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.4 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','nl') and product_categories.language in ('all','nl') 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 <> 'SBGA1591' 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/puun/sbga1591/culotte_ouverte_rouge_dos.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga1591/culotte_ouverte_rouge.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga1591/culotte_ouverte_rouge.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | | string | products.parishollywood.sbga1591 |
|
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Der Passion Slip verkörpert die <strong>kühnste</strong> Verführung mit seinem roten Netzstoff, der mit Transparenz spielt, um Ihre Haut subtil zu enthüllen.</p>
<p>Diese überaus <strong>verruchte</strong> Kreation verwandelt dank ihrer strategischen Öffnungen jeden intimen Moment in ein Erlebnis puren Vergnügens. Die<strong>Öffnung im Schritt</strong> bietet einen direkten Zugang, der die Temperatur ansteigen lässt, während die <strong>große Öffnung auf der Rückseite</strong> Ihren Po auf furchtbar erregende Weise enthüllt.</p>
<p>das Netzgewebe mit <strong>geometrischem Rautenmuster</strong> schmiegt sich perfekt an Ihre üppigen Kurven an und sorgt für einen fesselnden visuellen Effekt. Der <strong>elastische Bund</strong> passt sich natürlich jeder Körperform an und sorgt so für optimalen Tragekomfort, selbst bei Ihren intensivsten Momenten.</p>
<p>Die <strong>roten Abschlüsse</strong> an allen Rändern sorgen für den letzten Schliff, der Passion zu einem wirklich unwiderstehlichen Slip macht.</p>
<p>Diese rote Passion-Kreation wurde entwickelt, um Ihre <strong>authentische</strong> Sinnlichkeit zu enthüllen und jeden Moment in einen Moment der puren Verführung zu verwandeln.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/hoschen-leidenschaft-grosse-grosse-netz-rot/sbga1591.htm |
| | highlights | | string | <ul>
<li>Ultra-sinnliches, halbtransparentes<strong>rotes Netzgewebe</strong> </li>
<li><strong>Öffnung im Schritt</strong> für einen direkten, verruchten Zugang</li>
<li><strong>Große hintere Öffnung</strong>, die Ihren Po enthüllt</li>
<li>Sehr sexy<strong>geometrisches Rautenmuster</strong> </li>
<li>Bequemer<strong>elastischer Bund</strong>, der sich perfekt anpasst</li>
<li><strong>Rote Abschlüsse</strong> an allen Rändern für einen perfekten Look</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Passion Slip in großen Größen aus rotem Netzstoff mit frechen Öffnungen. Schritt und Rücken offen. Hypersexy und gewagt. Schnelle Lieferung. |
| | keywords | | | title | | string | Slip Passion große Größe aus rotem Netz | Diva's Boudoir |
|
| | seotitle | | string | Slip, offen, große Größen Passion Netzstoff rot |
| | seouri | | string | hoschen-leidenschaft-grosse-grosse-netz-rot |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Rotes Netz (90% Polyamid, 10% Elasthan)</li>
<li><strong>Farbe:</strong> Passionsrot</li>
<li><strong>Größen:</strong> 42 bis 52</li>
<li><strong>Stil:</strong> Offener Slip mit geometrischem Netz</li>
<li><strong>Öffnungen:</strong> Im Schritt und hinten für vollen Zugriff</li>
<li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li>
</ul> |
| | stylingtips | | string | <p>Der Passion Slip aus rotem Netzstoff ist schon für sich allein genommen ein <strong>sexy</strong> Look. Um den verführerischen Effekt zu verstärken, kombinieren Sie es mit Teilen, die seine freche Präsenz subtil offenbaren. Diese leidenschaftsrote Kreation offenbart Ihre selbstbewusste Kühnheit und Ihre ungezügelte Sinnlichkeit.</p>
<p>Vervollständigen Sie Ihren Look mit unseren <strong><a href="https://www.divasboudoir.com/de/strumpfe-in-grossen-grossen/">selbstfixierenden Strümpfen</a></strong>, um die sinnliche Wirkung auf Ihre Beine zu verlängern, oder fügen Sie ein <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/"><strong>Negligé</strong></a> hinzu für eine schrittweise Verführung, die mit der Entdeckung dieses schrecklich aufregenden Slips ihren Höhepunkt erreicht.</p> |
| | summary | | string | <p>Entdecken Sie den Passion Slip, eine <strong>hyperfreche</strong> Kreation aus rotem Netzstoff, die Ihre <strong>kühnste</strong> Seite offenbart.</p>
<p>Die <strong>strategischen Öffnungen</strong> und das halbtransparente Material sorgen für einen unwiderstehlichen Effekt und sorgen für Momente der puren Lust.</p> |
| | title | | string | Passion Slip: Rotes Netz und freche Öffnungen |
| | usageinstructions | | string | <p>Der Passion Slip wurde für Ihre <strong>frechsten</strong> und gewagtesten Momente entworfen. Seine <strong>strategischen Öffnungen</strong> - im Schritt und auf der Rückseite - bieten einen vollständigen Zugang, der jeden intimen Moment in ein Erlebnis purer Lust verwandelt.</p>
<p>Tragen Sie ihn selbstbewusst, um Ihre <strong>sexieste</strong> und provokanteste Seite zu enthüllen. Das halbtransparente rote Netzgewebe enthüllt subtil Ihre Haut und bewahrt gleichzeitig das Geheimnis, das bei jedem Blick die Temperatur steigen lässt.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Το εσώρουχο Passion ενσαρκώνει την πιο <strong>τολμηρή</strong> αποπλάνηση με το κόκκινο δίχτυ που παίζει με τη διαφάνεια και αποκαλύπτει διακριτικά το δέρμα σας.</p>
<p>Αυτή η <strong>σούπερ άτακτη</strong> δημιουργία μετατρέπει κάθε προσωπική στιγμή σε μια εμπειρία καθαρής απόλαυσης χάρη στα στρατηγικά ανοίγματά της. Το<strong>άνοιγμα στον καβάλο</strong> προσφέρει άμεση πρόσβαση που ανεβάζει τη θερμοκρασία, ενώ το <strong>μεγάλο πίσω άνοιγμα</strong> αποκαλύπτει τα οπίσθιά σας με τρομερά συναρπαστικό τρόπο.</p>
<p>το δίχτυ με το <strong>γεωμετρικό μοτίβο</strong> διαμαντιών αγκαλιάζει τέλεια τις γενναιόδωρες καμπύλες σας, δημιουργώντας ένα σαγηνευτικό οπτικό αποτέλεσμα. Η <strong>ελαστική ζώνη στη μέση</strong> προσαρμόζεται φυσικά σε όλα τα σχήματα του σώματος για βέλτιστη άνεση, ακόμη και στις πιο έντονες στιγμές σας.</p>
<p>Το <strong>κόκκινο τελείωμα</strong> σε όλες τις άκρες προσθέτει την τελική πινελιά που κάνει το Passion ένα πραγματικά ακαταμάχητο εσώρουχο.</p>
<p>Αυτή η δημιουργία σε κόκκινο χρώμα του πάθους έχει σχεδιαστεί για να αποκαλύψει τον πιο <strong>αυθεντικό</strong> σας αισθησιασμό και να μετατρέψει κάθε στιγμή σε μια στιγμή καθαρής αποπλάνησης.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/passion-panties-megalo-megethos-resille-kokkino/sbga1591.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 | Passion plus size εσώρουχο σε κόκκινο δίχτυ με άτακτα ανοίγματα. Ανοιχτό καβάλο και πλάτη. Σούπερ σέξι και τολμηρό. Γρήγορη παράδοση. |
| | keywords | | | title | | string | Εσώρουχα πάθους μεγάλο μέγεθος κόκκινο διχτυωτό | Diva's Boudoir |
|
| | seotitle | | string | Πάθος διχτυωτό κόκκινο μεγάλο ανοιχτό βρακί |
| | seouri | | string | passion-panties-megalo-megethos-resille-kokkino |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Κόκκινο διχτυωτό ύφασμα (90% πολυαμίδιο, 10% ελαστάν)</li>
<li><strong>Χρώμα:</strong> Κόκκινο του πάθους</li>
<li><strong>Μεγέθη:</strong> 42 έως 52</li>
<li><strong>Στυλ:</strong> Ανοιχτό εσώρουχο με γεωμετρικό δίχτυ</li>
<li><strong>Ανοίγματα:</strong> καβάλο και πλάτη για απόλυτη πρόσβαση</li>
<li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li>
</ul> |
| | stylingtips | | string | <p>Το κόκκινο διχτυωτό εσώρουχο Passion στέκεται μόνο του για να δημιουργήσει μια <strong>σούπερ σέξι</strong> εμφάνιση. Για μια πρόσθετη πινελιά αποπλάνησης, συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την άτακτη παρουσία τους. Αυτή η κόκκινη δημιουργία του πάθους αποκαλύπτει την τόλμη και τον αχαλίνωτο αισθησιασμό σας.</p>
<p>Ολοκληρώστε την εμφάνισή σας με τις <strong><a href="https://www.divasboudoir.com/el/kaltses-megaloy-megethoys/">αυτοκόλλητες κάλτσες</a></strong> μας για να παρατείνετε το αισθησιακό αποτέλεσμα στα πόδια σας ή προσθέστε ένα <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/"><strong>νεγκλιζέ</strong></a> για μια σταδιακή αποπλάνηση που θα κορυφωθεί με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p> |
| | summary | | string | <p>Ανακαλύψτε το εσώρουχο Passion, μια <strong>σούπερ άτακτη</strong> δημιουργία από κόκκινο διχτυωτό ύφασμα που αποκαλύπτει την πιο <strong>τολμηρή</strong> πλευρά σας.</p>
<p>Τα <strong>στρατηγικά</strong> του <strong>ανοίγματα</strong> και το ημιδιαφανές ύφασμα δημιουργούν ένα ακαταμάχητο αποτέλεσμα για στιγμές καθαρής απόλαυσης.</p> |
| | title | | string | Εσώρουχα πάθους: Κόκκινο δίχτυ και άτακτα ανοίγματα |
| | usageinstructions | | string | <p>Τα εσώρουχα Passion είναι σχεδιασμένα για τις πιο τολμηρές και <strong>άτακτες</strong> στιγμές σας. Τα <strong>στρατηγικά</strong> του <strong>ανοίγματα</strong> - στον καβάλο και στην πλάτη - προσφέρουν απόλυτη πρόσβαση, μετατρέποντας κάθε προσωπική στιγμή σε μια εμπειρία απόλυτης απόλαυσης.</p>
<p>Φορέστε το με αυτοπεποίθηση για να αποκαλύψετε την <strong>πιο σέξι</strong>, προκλητική πλευρά σας. Το ημιδιαφανές κόκκινο δίχτυ αποκαλύπτει διακριτικά το δέρμα σας, διατηρώντας παράλληλα το μυστήριο που ανεβάζει τη θερμοκρασία με κάθε ματιά.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Passion panties embody the most <strong>daring</strong> seduction with their red fishnet that plays with transparency to subtly reveal your skin.</p>
<p>This <strong>super-naughty</strong> creation transforms every intimate moment into an experience of pure pleasure, thanks to its strategic openings. The<strong>crotch opening</strong> offers direct access that raises the temperature, while the <strong>large rear opening</strong> reveals your buttocks in a terribly exciting way.</p>
<p>the fishnet with its <strong>geometric</strong> diamond <strong>pattern</strong> perfectly hugs your generous curves, creating a captivating visual effect. The <strong>elastic waistband</strong> naturally adapts to all body shapes for optimum comfort, even during your most intense moments.</p>
<p><strong>Red trim on</strong> all edges adds that finishing touch that makes Passion a truly irresistible panty.</p>
<p>This passion red creation is designed to reveal your most <strong>authentic</strong> sensuality and turn every moment into a moment of pure seduction.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/passion-panties-plus-size-resille-red/sbga1591.htm |
| | highlights | | string | <ul>
<li>Ultra-sensual, semi-transparent<strong>red fishnet</strong> </li>
<li><strong>Crotch opening</strong> for direct, naughty access</li>
<li><strong>Large rear opening</strong> reveals your buttocks</li>
<li>Sexy<strong>geometric</strong> diamond<strong>pattern</strong> </li>
<li>Comfortable<strong>elastic waistband</strong> for a perfect fit</li>
<li><strong>Red trim on</strong> all edges for a perfect look</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Plus size Passion panties in red fishnet with naughty openings. Open crotch and back. Super sexy and daring. Fast delivery. |
| | keywords | | | title | | string | Passion panties plus size red fishnet | Diva's Boudoir |
|
| | seotitle | | string | Open panties plus size Passion fishnet red |
| | seouri | | string | passion-panties-plus-size-resille-red |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Red fishnet (90% polyamide, 10% elastane)</li>
<li><strong>Color:</strong> Passion red</li>
<li><strong>Sizes:</strong> 42 to 52</li>
<li><strong>Style:</strong> Open panty with geometric fishnet</li>
<li><strong>Openings:</strong> crotch and back for total access</li>
<li><strong>Care:</strong> Delicate hand wash recommended</li>
</ul> |
| | stylingtips | | string | <p>Passion's red fishnet panties stand on their own to create a <strong>super-sexy</strong> look. To amplify the seductive effect, pair them with pieces that subtly reveal their naughty presence. This passion red creation reveals your boldness and unbridled sensuality.</p>
<p>Complete your look with our <strong><a href="https://www.divasboudoir.com/en/socks-large-size/">self-fastening stockings</a></strong> to prolong the sensual effect on your legs, or add a <a href="https://www.divasboudoir.com/en/plus-size-robes/"><strong>negligee</strong></a> for a gradual seduction that culminates in the discovery of these terribly exciting panties.</p> |
| | summary | | string | <p>Discover Passion panties, a <strong>super-naughty</strong> creation in red fishnet that reveals your most <strong>daring</strong> side.</p>
<p>Their <strong>strategic openings</strong> and semi-transparent fabric create an irresistible effect for moments of pure pleasure.</p> |
| | title | | string | Passion panties: Red fishnet with naughty openings |
| | usageinstructions | | string | <p>Passion panties are designed for your most daring and <strong>naughty</strong> moments. Its <strong>strategic openings</strong> - crotch and back - offer total access that transforms every intimate moment into an experience of pure pleasure.</p>
<p>Wear it with confidence to reveal your <strong>sexiest</strong>, most provocative side. The semi-transparent red fishnet subtly reveals your skin while preserving that mystery that raises the temperature with every glance.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Las braguitas Passion encarnan la seducción más <strong>atrevida</strong> con su rejilla roja que juega con la transparencia para revelar sutilmente tu piel.</p>
<p>Esta creación <strong>súper traviesa</strong> convierte cada momento íntimo en una experiencia de puro placer gracias a sus estratégicas aberturas. La<strong>abertura de la entrepierna</strong> ofrece un acceso directo que eleva la temperatura, mientras que la <strong>gran abertura</strong> trasera revela tus nalgas de una forma terriblemente excitante.</p>
<p>la malla de rejilla, con su <strong>estampado geométrico</strong> de rombos, abraza perfectamente tus generosas curvas, creando un efecto visual cautivador. La <strong>cintura elástica</strong> se adapta con naturalidad a todas las formas del cuerpo para un confort óptimo, incluso en tus momentos más intensos.</p>
<p>El <strong>ribete rojo</strong> en todos los bordes añade ese toque final que hace de Passion una braguita verdaderamente irresistible.</p>
<p>Esta creación en rojo pasión está diseñada para revelar tu sensualidad más <strong>auténtica</strong> y convertir cada momento en un instante de pura seducción.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/bragas-passion-talla-grande-resille-rojo/sbga1591.htm |
| | highlights | | string | <ul>
<li><strong>Red roja</strong> semitransparente ultrasensual</li>
<li>Abertura en<strong>la entrepierna</strong> para un acceso directo y travieso</li>
<li><strong>Gran abertura trasera</strong> que deja al descubierto las nalgas</li>
<li><strong>Estampado geométrico</strong> de rombos muy sexy</li>
<li><strong>Cómoda cintura elástica</strong> que se ajusta perfectamente</li>
<li><strong>Ribete rojo en</strong> todos los bordes para un look perfecto</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bragas talla grande Passion de rejilla roja con traviesas aberturas. Entrepierna y espalda abiertas. Super sexy y atrevida. Entrega rápida. |
| | keywords | | | title | | string | Bragas Passion talla grande red fishnet | Diva's Boudoir |
|
| | seotitle | | string | Passion bragas abiertas talla grande rojas de rejilla |
| | seouri | | string | bragas-passion-talla-grande-resille-rojo |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Red roja (90% poliamida, 10% elastán)</li>
<li><strong>Color:</strong> rojo pasión</li>
<li><strong>Tallas</strong>: de la 42 a la 52</li>
<li><strong>Estilo:</strong> Braguita abierta con rejilla geométrica</li>
<li><strong>Aberturas:</strong> entrepierna y espalda para un acceso total</li>
<li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li>
</ul> |
| | stylingtips | | string | <p>Las braguitas rojas de rejilla Passion se mantienen solas para crear un look <strong>súper sexy</strong>. Combínalas con piezas que revelen sutilmente su traviesa presencia para añadir un toque de seducción. Esta creación rojo pasión revela tu atrevimiento y sensualidad desenfrenada.</p>
<p>Completa tu look con nuestras <strong><a href="https://www.divasboudoir.com/es/medias-grandes/">medias que se atan solas</a></strong> para prolongar el efecto sensual en tus piernas, o añade un <a href="https://www.divasboudoir.com/es/picardias-talla-grande/"><strong>picardías</strong></a> para una seducción gradual que culminará con el descubrimiento de estas bragas terriblemente excitantes.</p> |
| | summary | | string | <p>Descubre las braguitas Passion, una creación <strong>súper traviesa</strong> de rejilla roja que revela tu lado más <strong>atrevido</strong>.</p>
<p>Sus <strong>aberturas estratégicas</strong> y su tejido semitransparente crean un efecto irresistible para momentos de puro placer.</p> |
| | title | | string | Bragas Passion: Red de rejilla roja y aberturas traviesas |
| | usageinstructions | | string | <p>Las braguitas Passion están diseñadas para tus momentos más atrevidos y <strong>traviesos</strong>. Sus <strong>estratégicas aberturas</strong> -entrepierna y espalda- ofrecen un acceso total, convirtiendo cada momento íntimo en una experiencia de puro placer.</p>
<p>Llévalo con confianza para revelar tu lado <strong>más sexy</strong> y provocativo. La rejilla roja semitransparente revela sutilmente tu piel al tiempo que preserva el misterio que sube la temperatura con cada mirada.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>La culotte Passion incarne la séduction la plus <strong>audacieuse</strong> avec sa résille rouge qui joue avec la transparence pour révéler subtilement votre peau.</p>
<p>Cette création <strong>hyper coquine</strong> transforme chaque moment intime en expérience de pur plaisir grâce à ses ouvertures stratégiques. L'<strong>ouverture à l'entrejambe</strong> offre un accès direct qui fait monter la température, tandis que la <strong>grande ouverture arrière</strong> révèle vos fesses de façon terriblement excitante.</p>
<p> La résille aux <strong>motifs géométriques</strong> en losanges épouse parfaitement vos courbes généreuses, créant un effet visuel captivant. Sa <strong>taille élastique</strong> s'adapte naturellement à toutes les morphologies pour un confort optimal, même lors de vos moments les plus intenses.</p>
<p>Les <strong>finitions rouges</strong> sur tous les bords apportent cette touche finale qui fait de Passion une culotte vraiment irrésistible.</p>
<p>Cette création rouge passion est conçue pour révéler votre sensualité la plus <strong>authentique</strong> et transformer chaque instant en moment de pure séduction.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/culotte-passion-grande-taille-resille-rouge/sbga1591.htm |
| | highlights | | string | <ul>
<li><strong>Résille rouge</strong> semi-transparente ultra sensuelle</li>
<li><strong>Ouverture entrejambe</strong> pour un accès direct et coquin</li>
<li><strong>Grande ouverture arrière</strong> qui révèle vos fesses</li>
<li><strong>Motifs géométriques</strong> en losanges très sexy</li>
<li><strong>Taille élastique</strong> confortable qui s'adapte parfaitement</li>
<li><strong>Finitions rouges</strong> sur tous les bords pour un look parfait</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Culotte Passion grande taille en résille rouge avec ouvertures coquines. Entrejambe et dos ouverts. Hyper sexy et audacieuse. Livraison rapide. |
| | keywords | | | title | | string | Culotte Passion grande taille résille rouge | Diva's Boudoir |
|
| | seotitle | | string | Culotte ouverte grande taille Passion résille rouge |
| | seouri | | string | culotte-passion-grande-taille-resille-rouge |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Résille rouge (90% polyamide, 10% élasthanne)</li>
<li><strong>Couleur :</strong> Rouge passion</li>
<li><strong>Tailles :</strong> 42 à 52</li>
<li><strong>Style :</strong> Culotte ouverte avec résille géométrique</li>
<li><strong>Ouvertures :</strong> Entrejambe et arrière pour un accès total</li>
<li><strong>Entretien :</strong> Lavage délicat à la main recommandé</li>
</ul> |
| | stylingtips | | string | <p>La culotte Passion en résille rouge se suffit à elle-même pour créer un look <strong>hyper sexy</strong>. Pour amplifier l'effet de séduction, associez-la à des pièces qui révèlent subtilement sa présence coquine. Cette création rouge passion révèle votre audace assumée et votre sensualité débridée.</p>
<p>Complétez votre look avec nos <strong><a href="https://www.divasboudoir.com/fr/bas-grande-taille/">bas autofixants</a></strong> pour prolonger l'effet sensuel sur vos jambes, ou ajoutez un <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/"><strong>déshabillé</strong></a> pour une séduction progressive qui culminera avec la découverte de cette culotte terriblement excitante.</p> |
| | summary | | string | <p>Découvrez la culotte Passion, une création <strong>hyper coquine</strong> en résille rouge qui révèle votre côté le plus <strong>audacieux</strong>.</p>
<p>Ses <strong>ouvertures stratégiques</strong> et sa matière semi-transparente créent un effet irrésistible pour des moments de pur plaisir.</p> |
| | title | | string | Culotte Passion : Résille Rouge et Ouvertures Coquines |
| | usageinstructions | | string | <p>La culotte Passion est conçue pour vos moments les plus <strong>coquins</strong> et audacieux. Ses <strong>ouvertures stratégiques</strong> - entrejambe et arrière - offrent un accès total qui transforme chaque instant intime en expérience de pur plaisir.</p>
<p>Portez-la avec assurance pour révéler votre côté le plus <strong>sexy</strong> et provocant. La résille rouge semi-transparente révèle subtilement votre peau tout en conservant ce mystère qui fait monter la température à chaque regard.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Le mutandine Passion incarnano la seduzione più <strong>audace</strong> con la loro rete rossa che gioca con le trasparenze per rivelare sottilmente la pelle.</p>
<p>Questa creazione <strong>super birichina</strong> trasforma ogni momento intimo in un'esperienza di puro piacere grazie alle sue aperture strategiche. L'<strong>apertura inguinale</strong> offre un accesso diretto che aumenta la temperatura, mentre l'<strong>ampia apertura posteriore</strong> rivela i vostri glutei in modo terribilmente eccitante.</p>
<p>la rete a rombi <strong>geometrici</strong> abbraccia perfettamente le vostre curve generose, creando un effetto visivo accattivante. L'<strong>elastico in vita</strong> si adatta naturalmente a tutte le forme del corpo per un comfort ottimale, anche nei momenti più intensi.</p>
<p>Le <strong>finiture rosse</strong> su tutti i bordi aggiungono quel tocco finale che rende Passion un panty davvero irresistibile.</p>
<p>Questa creazione rosso passione è pensata per rivelare la vostra sensualità più <strong>autentica</strong> e trasformare ogni momento in un momento di pura seduzione.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/mutandine-passionali-taglia-grande-resille-rosso/sbga1591.htm |
| | highlights | | string | <ul>
<li><strong>Rete rossa</strong> semitrasparente e ultra-sensuale</li>
<li><strong>Apertura all'inguine</strong> per un accesso diretto e malizioso</li>
<li><strong>L'ampia apertura posteriore</strong> rivela i vostri glutei</li>
<li><strong>Motivo geometrico</strong> a rombi molto sexy</li>
<li>Confortevole<strong>fascia elastica in vita</strong> che si adatta perfettamente</li>
<li><strong>Rifiniture rosse su</strong> tutti i bordi per un look perfetto</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Mutandine Passion taglia grande in rete rossa con aperture maliziose. Inguine e schiena aperti. Super sexy e audaci. Consegna rapida. |
| | keywords | | | title | | string | Mutandine Passion taglia grande a rete rossa | Diva's Boudoir |
|
| | seotitle | | string | Passione mutandine a rete rosse di grande taglia aperte |
| | seouri | | string | mutandine-passionali-taglia-grande-resille-rosso |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> rete rossa (90% poliammide, 10% elastan)</li>
<li><strong>Colore:</strong> Rosso passione</li>
<li><strong>Taglie:</strong> dalla 42 alla 52</li>
<li><strong>Stile:</strong> mutandine aperte con rete geometrica</li>
<li><strong>Aperture:</strong> cavallo e schiena per un accesso totale</li>
<li><strong>Cura:</strong> si consiglia un lavaggio delicato a mano</li>
</ul> |
| | stylingtips | | string | <p>Le mutandine a rete rosse di Passion sono perfette da sole per creare un look <strong>super sexy</strong>. Abbinatele a capi che rivelano sottilmente la loro presenza maliziosa per un ulteriore tocco di seduzione. Questa creazione rosso passione rivela la vostra audacia e sensualità sfrenata.</p>
<p>Completate il vostro look con le nostre <strong><a href="https://www.divasboudoir.com/it/calze-di-grandi-dimensioni/">calze autoreggenti</a></strong> per prolungare l'effetto sensuale sulle vostre gambe, oppure aggiungete una <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/"><strong>vestaglia per</strong></a> una seduzione graduale che culminerà con la scoperta di queste mutandine terribilmente eccitanti.</p> |
| | summary | | string | <p>Scoprite le mutandine Passion, una creazione <strong>super-naughty</strong> in rete rossa che rivela il vostro lato più <strong>audace</strong>.</p>
<p>Le sue <strong>aperture strategiche</strong> e il tessuto semitrasparente creano un effetto irresistibile per momenti di puro piacere.</p> |
| | title | | string | Mutandine passionali: rete rossa e aperture birichine |
| | usageinstructions | | string | <p>Le mutandine Passion sono pensate per i vostri momenti più audaci e <strong>maliziosi</strong>. Le sue <strong>aperture strategiche</strong> - inguine e schiena - offrono un accesso totale, trasformando ogni momento di intimità in un'esperienza di puro piacere.</p>
<p>Indossatela con fiducia per rivelare il vostro lato <strong>più sexy</strong> e provocante. La rete rossa semitrasparente rivela sottilmente la vostra pelle, mantenendo il mistero che aumenta la temperatura ad ogni sguardo.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Passion slips belichamen de meest <strong>gedurfde</strong> verleiding met hun rode visnet dat speelt met transparantie om je huid subtiel te onthullen.</p>
<p>Deze <strong>superdeugende</strong> creatie verandert elk intiem moment in een ervaring van puur genot dankzij de strategische openingen. De<strong>opening in het kruis</strong> biedt directe toegang die de temperatuur doet stijgen, terwijl de <strong>grote opening aan de achterkant</strong> je billen op een vreselijk opwindende manier onthult.</p>
<p>het visnet met <strong>geometrisch ruitpatroon</strong> omhelst perfect je royale rondingen en creëert een fascinerend visueel effect. De <strong>elastische tailleband</strong> past zich op natuurlijke wijze aan alle lichaamsvormen aan voor optimaal comfort, zelfs tijdens je meest intense momenten.</p>
<p>De <strong>rode boorden</strong> rond alle randen zorgen voor de finishing touch die van Passion een onweerstaanbare panty maakt.</p>
<p>Deze passierode creatie is ontworpen om je meest <strong>authentieke</strong> sensualiteit te onthullen en van elk moment een moment van pure verleiding te maken.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/passieslip-grote-maat-resille-rood/sbga1591.htm |
| | highlights | | string | <ul>
<li>Ultra-sensueel, semi-transparant<strong>rood visnet</strong></li>
<li><strong>Kruisopening</strong> voor directe, ondeugende toegang</li>
<li><strong>Grote opening aan de achterkant</strong> onthult je billen</li>
<li>Zeer sexy<strong>geometrisch ruitpatroon</strong></li>
<li>Comfortabele<strong>elastische tailleband</strong> die perfect past</li>
<li><strong>Rode rand aan</strong> alle randen voor een perfecte look</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Passion grote maten slip in rood visnet met ondeugende openingen. Open kruis en rug. Super sexy en gedurfd. Snelle levering. |
| | keywords | | | title | | string | Passieslip grote maat rood visnet | Diva's Boudoir |
|
| | seotitle | | string | Passie visnet rood grote maat onderbroek |
| | seouri | | string | passieslip-grote-maat-resille-rood |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Rood visnet (90% polyamide, 10% elastaan)</li>
<li><strong>Kleur:</strong> Passierood</li>
<li><strong>Maten:</strong> 42 tot 52</li>
<li><strong>Stijl:</strong> Open slip met geometrisch visnet</li>
<li><strong>Openingen:</strong> kruis en rug voor volledige toegang</li>
<li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li>
</ul> |
| | stylingtips | | string | <p>De rode visnet slipjes van Passion staan op zichzelf en creëren een <strong>super sexy</strong> look. Voor een extra vleugje verleiding combineer je ze met stukken die subtiel hun ondeugende aanwezigheid onthullen. Deze passionele rode creatie onthult je brutaliteit en ongebreidelde sensualiteit.</p>
<p>Maak je look compleet met onze <strong><a href="https://www.divasboudoir.com/nl/grote-maat-kousen/">zelfbinderkousen</a></strong> om het sensuele effect op je benen te verlengen, of voeg een <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/"><strong>negligé</strong></a> toe voor een geleidelijke verleiding die zal culmineren in de ontdekking van deze vreselijk opwindende slip.</p> |
| | summary | | string | <p>Ontdek de Passion slip, een <strong>superdeugende</strong> creatie van rood visnet die je van je meest <strong>gewaagde</strong> kant laat zien.</p>
<p>De <strong>strategische openingen</strong> en semi-transparante stof creëren een onweerstaanbaar effect voor momenten van puur plezier.</p> |
| | title | | string | Passieslipjes: Rood visnet en ondeugende openingen |
| | usageinstructions | | string | <p>Passion slips zijn ontworpen voor je meest gewaagde en <strong>ondeugende</strong> momenten. De <strong>strategische openingen</strong> - kruis en rug - bieden volledige toegang, waardoor elk intiem moment een ervaring van puur plezier wordt.</p>
<p>Draag het met vertrouwen om je <strong>meest sexy</strong> en uitdagende kant te onthullen. Het semi-transparante rode visnet onthult subtiel je huid terwijl het mysterie behouden blijft dat de temperatuur doet stijgen met elke blik.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>As cuecas Passion encarnam a sedução mais <strong>ousada</strong> com a sua rede vermelha que joga com a transparência para revelar subtilmente a sua pele.</p>
<p>Esta criação <strong>super atrevida</strong> transforma cada momento íntimo numa experiência de puro prazer graças às suas aberturas estratégicas. A<strong>abertura na virilha</strong> oferece um acesso direto que aumenta a temperatura, enquanto a <strong>grande abertura traseira</strong> revela as suas nádegas de uma forma terrivelmente excitante.</p>
<p>a rede de pesca com o seu <strong>padrão geométrico</strong> de diamantes envolve perfeitamente as suas curvas generosas, criando um efeito visual cativante. A <strong>cintura elástica</strong> adapta-se naturalmente a todas as formas do corpo para um conforto ótimo, mesmo durante os seus momentos mais intensos.</p>
<p>O <strong>acabamento vermelho</strong> em todas as extremidades dá o toque final que faz de Passion uma cueca verdadeiramente irresistível.</p>
<p>Esta criação em vermelho paixão foi concebida para revelar a sua sensualidade mais <strong>autêntica</strong> e transformar cada momento num momento de pura sedução.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/cuecas-passion-tamanho-grande-resille-vermelho/sbga1591.htm |
| | highlights | | string | <ul>
<li><strong>Rede vermelha</strong> ultra-sensual e semi-transparente</li>
<li><strong>Abertura nas virilhas</strong> para um acesso direto e atrevido</li>
<li><strong>Grande abertura nas costas</strong> que revela as suas nádegas</li>
<li><strong>Padrão geométrico</strong> de diamantes muito sexy</li>
<li><strong>Cintura elástica</strong> confortável que se ajusta perfeitamente</li>
<li><strong>Acabamento vermelho em</strong> todos os bordos para um look perfeito</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Cuecas Passion plus size em rede vermelha com aberturas atrevidas. Entrepernas e costas abertas. Super sexy e ousada. Entrega rápida. |
| | keywords | | | title | | string | Cuecas Passion tamanho grande rede vermelha | Diva's Boudoir |
|
| | seotitle | | string | Calcinhas de rede vermelhas grandes abertas Passion |
| | seouri | | string | cuecas-passion-tamanho-grande-resille-vermelho |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Rede vermelha (90% poliamida, 10% elastano)</li>
<li><strong>Cor:</strong> Vermelho paixão</li>
<li><strong>Tamanhos:</strong> 42 a 52</li>
<li><strong>Estilo:</strong> Cuecas abertas com rede geométrica</li>
<li><strong>Aberturas:</strong> entrepernas e atrás para acesso total</li>
<li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada à mão</li>
</ul> |
| | stylingtips | | string | <p>As cuecas de rede vermelhas da Passion criam um visual <strong>super sexy</strong>. Combine-as com peças que revelem subtilmente a sua presença atrevida para um toque adicional de sedução. Esta criação vermelha da Passion revela a sua ousadia e sensualidade desenfreada.</p>
<p>Complete o seu look com as nossas <strong><a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">meias</a></strong> de <strong><a href="https://www.divasboudoir.com/pt/meias-de-tamanho-grande/">ligas</a></strong> para prolongar o efeito sensual nas suas pernas, ou adicione um <a href="https://www.divasboudoir.com/pt/batotas-plus-size/"><strong>negligee</strong></a> para uma sedução gradual que culminará na descoberta destas cuecas terrivelmente excitantes.</p> |
| | summary | | string | <p>Descubra as cuecas Passion, uma criação <strong>super atrevida</strong> em rede vermelha que revela o seu lado mais <strong>atrevido</strong>.</p>
<p>As suas <strong>aberturas estratégicas</strong> e o tecido semi-transparente criam um efeito irresistível para momentos de puro prazer.</p> |
| | title | | string | Calcinhas Passion: rede vermelha e aberturas atrevidas |
| | usageinstructions | | string | <p>As cuecas Passion foram concebidas para os seus momentos mais ousados e <strong>atrevidos</strong>. As suas <strong>aberturas estratégicas</strong> - entrepernas e costas - oferecem um acesso total, transformando cada momento íntimo numa experiência de puro prazer.</p>
<p>Use-as com confiança para revelar o seu lado <strong>mais sexy</strong> e provocante. A rede vermelha semi-transparente revela subtilmente a sua pele, preservando o mistério que faz subir a temperatura a cada olhar.</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 | | string | P5091 culotte ouverte |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 7E8FB423-5E88-4D19-B5342DB1AB0126FD |
|
| promountil | |
| rating | |
| recorduid | | string | 7E8FB423-5E88-4D19-B5342DB1AB0126FD |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.36 ms Record Count: 2 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,'1245,1244') > 0 and product_variations.productuid = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 | 1245 | 42-44 | intlsize | red | 42 | 44 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 42-44 | | 42-44 | 16-18 | 20-22 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | 92-100 | 74-82 | 98-106 | | | | | | | | 2 | 1244 | 46-48 | intlsize | red | 46 | 48 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 110-116 | 96-102 | 116-122 | | | | | | |
|
| 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: 3.42 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' and product_variations.isactive = 1 and product_sizes.id_size = 1245 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' and product_variations.isactive = 1 and product_sizes.id_size = 1244 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 | 7E8FB423-5E88-4D19-B5342DB1AB0126FD | 244B7131-4EFC-420C-AB2A78D166624AC5 | 1245 | red | #F50000 | XL-2XL | 42-44 | | 42-44 | 16-18 | 20-22 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | 42-44 | intlsize | 14.9583 | 10.7917 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | P5091-2 | P5091-2P1117 | -1 | 0 | all | | | 2 | 7E8FB423-5E88-4D19-B5342DB1AB0126FD | CC95EC3A-058E-46BE-86E566557D76A5BA | 1244 | red | #F50000 | 3XL-4XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 46-48 | intlsize | 14.9583 | 10.7917 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | P5091-2 | P5091-2P1119 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 4.13 ms Record Count: 2 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' and product_variations.isactive = 1 and product_sizes.id_size = 1245 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' 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 = '7E8FB423-5E88-4D19-B5342DB1AB0126FD' and product_variations.isactive = 1 and product_sizes.id_size = 1244 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 | 244B7131-4EFC-420C-AB2A78D166624AC5 | 1245 | red | #F50000 | XL-2XL | 42-44 | | 42-44 | 16-18 | 20-22 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | 42-44 | intlsize | 14.9583 | 10.7917 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | P5091-2 | P5091-2P1117 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 10.7917 | all | | | 2 | CC95EC3A-058E-46BE-86E566557D76A5BA | 1244 | red | #F50000 | 3XL-4XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 46-48 | intlsize | 14.9583 | 10.7917 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | P5091-2 | P5091-2P1119 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 10.7917 | all | |
|
| vatrate | |
| warehouse | |