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.sexypanty |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/sexylingerie/sexypanty.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.808 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black,red,white') > 0 and product_variations.productuid = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 | | 2 | red | color | red | red | red | #F50000 | -1 | 0 | | 3 | white | color | whit | white | white | #FFFFFF | -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 '2020-02-10 17:15:36'} |
|
| 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 | black-plus-size-sexy-high-waist-floral-lace-strappy-panty-p5124-1p |
|
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-10-22 18:46:54'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.65 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','el') 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('952f4d3d-c960-4c3a-b0293edd79b2b08a',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.3 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','el') and product_categories.language in ('all','el') 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 <> 'SBGA8281' 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/sbga8281/culotte_grande_taille_lacage_blanc.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga8281/culotte_grande_taille_lacage_rouge.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga8281/culotte_grande_taille_lacage_noir.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga8281/culotte_grande_taille_lacage_noir_editorial.jpg |
| | type | | | width | |
| | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga8281/culotte_grande_taille_lacage_rouge.jpg |
| | type | | | width | |
| | white | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga8281/culotte_grande_taille_lacage_blanc.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 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 Criss Cross Slip hat alles, was man sich wünschen kann, mit seinem Design, das so konzipiert ist, dass es niemals beult. Die <strong>schönen Taillen</strong> passen sich perfekt an Ihre üppigen Kurven an und schaffen eine wohlgeformte Silhouette ohne Einschränkungen.</p>
<p>Die <strong>Schnürung an den Hüften</strong> verwandelt jede Bewegung in eine Einladung zur Verführung, während der <strong>brasilianische Schnitt</strong> Ihren Po enthüllt und wunderschön betont. Dieser <strong>bauchfreie</strong> Slip bietet optimalen Halt, ohne dabei an Sexyness zu verlieren.</p>
<p>Die <strong>hochwertige Spitze</strong> schmiegt sich sanft an Ihre Haut und sorgt für absoluten Komfort, der Sie den ganzen Tag über begleitet. Erhältlich in drei unverzichtbaren Farben - geheimnisvolles Schwarz, leidenschaftliches Rot und provokatives Weiß - zeigt jede Version eine andere Facette Ihrer Sinnlichkeit. Diese Kreation ist die perfekte Kombination aus <strong>Komfort und Provokation</strong> und verwandelt jeden Tag in eine Gelegenheit, sich unwiderstehlich sexy und selbstbewusst zu fühlen.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/criss-cross-slip,-grosse-grossen-schwarz-schwarz/sbga8281.htm |
| | highlights | | string | <ul>
<li>Dank der schönen Taillen<strong>absolut nicht beult</strong> </li>
<li><strong>Sexy Schnürung</strong> an den Hüften ultra provokativ</li>
<li><strong>Brasilianischer Schnitt</strong>, der den Po betont</li>
<li>Rutscht<strong>am Bauch hoch</strong> für einen perfekten Sitz</li>
<li><strong>Hochwertige Spitze, die</strong> den ganzen Tag über bequem ist</li>
<li><strong>Drei Farben</strong>: Schwarz, Rot und Weiß</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Criss Cross Slip in großen Größen aus Spitze mit Hüftschnürung. Nicht bauschen, brasilianischer Schnitt. 3 sexy Farben. Diva's Boudoir Lingerie. |
| | keywords | | | title | | string | Criss Cross Slip große Größe mit Schnürung | Diva's Boudoir |
|
| | seotitle | | string | Slip große Größen Criss Cross Spitze Schnürung Hüften |
| | seouri | | string | criss-cross-slip,-grosse-grossen-schwarz-schwarz |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Stretchige Spitze (92% Polyamid, 8% Elasthan)</li>
<li><strong>Farben:</strong> Schwarz, Rot, Weiß</li>
<li><strong>Stil:</strong> Höschen mit Hüftschnürung und brasilianischem Schnitt</li>
<li><strong>Schnitt:</strong> Brasilianisch am Gesäß, steigt am Bauch an</li>
<li><strong>Pflege:</strong> Schonende Handwäsche empfohlen</li>
</ul> |
| | stylingtips | | string | <p>Der Criss Cross Slip mit seiner <strong>aufreizenden Schnürung</strong> ist schon für sich allein genommen ein unglaublich sexy Look.</p>
<p>Um den verführerischen Effekt noch zu verstärken, kombinieren Sie es mit Teilen, die seine Präsenz subtil offenbaren. <strong>Schwarz</strong> verleiht zeitlose Sinnlichkeit, <strong>Rot</strong> steht für feurige Leidenschaft und <strong>Weiß</strong> für provokative Unschuld.</p>
<p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/string-in-ubergrosse/">sexy Strings, um</a>das Vergnügen zu variieren, oder fügen Sie einen <a href="https://www.divasboudoir.com/de/kimonos-in-grossen-grossen/">Kimono</a> für eine schrittweise Verführung hinzu, die mit der Entdeckung dieses schrecklich aufregenden Slips ihren Höhepunkt erreicht.</p> |
| | summary | | string | <p>Entdecken Sie den <strong>bequemen und sexy</strong> Criss Cross Slip, der dank seiner <strong>schönen Taillen</strong> absolut nicht beult.</p>
<p>Die <strong>Schnürung an den Hüften</strong> und der <strong>brasilianische Schnitt</strong> sorgen für eine perfekt geformte Silhouette.</p> |
| | title | | string | Criss Cross Slip: Sexy Schnürung und absoluter Komfort |
| | usageinstructions | | string | <p>Der Criss Cross Slip ist perfekt für alle Gelegenheiten, bei denen Sie <strong>absoluten Komfort und Verführung</strong> miteinander verbinden möchten. Das nicht beulende Design garantiert den ganzen Tag über ein angenehmes Tragegefühl ohne jegliche Beschwerden.</p>
<p>Die <strong>Schnürung an den Hüften</strong> ermöglicht eine individuelle Passform und sorgt gleichzeitig für einen furchtbar sexy optischen Effekt. Tragen Sie es selbstbewusst, denn Sie wissen, dass die perfekte Passform Ihre Kurven betont, ohne sie jemals einzuengen.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Το εσώρουχο Criss Cross τα έχει όλα, με ένα σχέδιο που δεν είναι ποτέ ογκώδες. Η <strong>όμορφη ζώνη</strong> του προσαρμόζεται τέλεια στις γενναιόδωρες καμπύλες σας, δημιουργώντας μια σμιλεμένη σιλουέτα χωρίς περιορισμούς.</p>
<p><strong>Τα κορδόνια</strong> του <strong>στο ισχίο</strong> μετατρέπουν κάθε κίνηση σε πρόσκληση για αποπλάνηση, ενώ το <strong>βραζιλιάνικο κόψιμό</strong> του αποκαλύπτει και αναδεικνύει όμορφα τους γλουτούς σας. Αυτά τα εσώρουχα <strong>που αγκαλιάζουν την κοιλιά</strong> σας προσφέρουν βέλτιστη στήριξη, διατηρώντας παράλληλα αυτή την τρομερά σέξι εμφάνιση.</p>
<p>Η <strong>υψηλής ποιότητας δαντέλα</strong> αγκαλιάζει απαλά το δέρμα σας για απόλυτη άνεση που διαρκεί όλη την ημέρα. Διατίθεται σε τρία βασικά χρώματα - το μυστηριώδες μαύρο, το παθιασμένο κόκκινο και το προκλητικό λευκό - κάθε έκδοση αποκαλύπτει μια διαφορετική πτυχή του αισθησιασμού σας. Αυτή η δημιουργία συνδυάζει τέλεια <strong>την άνεση και την πρόκληση</strong>, μετατρέποντας κάθε μέρα σε μια ευκαιρία να νιώσετε ακαταμάχητα σέξι και σίγουροι.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/eswroycha-megaloy-megethoys-criss-cross-mayro-mayro/sbga8281.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 | Μεγάλο δαντελένιο εσώρουχο Criss Cross με κορδόνια στους γοφούς. Μη ογκώδες, βραζιλιάνικο κόψιμο. 3 σέξι χρώματα. Εσώρουχα Diva's Boudoir. |
| | keywords | | | title | | string | Εσώρουχο Criss Cross μεγάλο μέγεθος με κορδόνια | Diva's Boudoir |
|
| | seotitle | | string | Εσώρουχα μεγάλου μεγέθους Criss Cross δαντέλα για το ισχίο |
| | seouri | | string | eswroycha-megaloy-megethoys-criss-cross-mayro-mayro |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Στρετς δαντέλα (92% πολυαμίδιο, 8% ελαστάν)</li>
<li><strong>Χρώματα:</strong> Μαύρο, Κόκκινο, Λευκό</li>
<li><strong>Στυλ</strong>: Εσώρουχα με κορδόνια στους γοφούς και βραζιλιάνικο κόψιμο</li>
<li><strong>Κόψιμο</strong>: Βραζιλιάνικο στους γλουτούς, ανεβαίνει στο στομάχι</li>
<li><strong>Φροντίδα:</strong> Συνιστάται απαλό πλύσιμο στο χέρι</li>
</ul> |
| | stylingtips | | string | <p>Τα εσώρουχα Criss Cross, με τα <strong>προκλητικά κορδόνια</strong> τους, είναι ό,τι χρειάζεστε για να δημιουργήσετε μια απίστευτα σέξι εμφάνιση.</p>
<p>Για επιπλέον αποπλάνηση, συνδυάστε τα με κομμάτια που αποκαλύπτουν διακριτικά την παρουσία τους. <strong>Το μαύρο</strong> φέρνει διαχρονικό αισθησιασμό, το <strong>κόκκινο</strong> αποκαλύπτει φλογερό πάθος, ενώ <strong>το λευκό</strong> παίζει με την προκλητική αθωότητα.</p>
<p>Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/stringk-syn-megethos/">σέξι στρινγκ</a>μας <a href="https://www.divasboudoir.com/el/stringk-syn-megethos/">για</a>ποικιλία, ή προσθέστε ένα <a href="https://www.divasboudoir.com/el/megala-kimono/">κιμονό</a> για μια σταδιακή αποπλάνηση που κορυφώνεται με την ανακάλυψη αυτών των τρομερά συναρπαστικών εσώρουχων.</p> |
| | summary | | string | <p>Ανακαλύψτε το <strong>άνετο, σέξι</strong> εσώρουχο Criss Cross, το οποίο δεν θα κατσουφιάσει καθόλου χάρη στο <strong>όμορφο ζωνάρι</strong> του.</p>
<p>Τα <strong>κορδόνια</strong> του <strong>στους γοφούς</strong> και το <strong>βραζιλιάνικο κόψιμο</strong> δημιουργούν μια τέλεια σμιλεμένη σιλουέτα.</p> |
| | title | | string | Εσώρουχα Criss Cross: Σέξι κορδόνια και απόλυτη άνεση |
| | usageinstructions | | string | <p>Τα εσώρουχα Criss Cross είναι ιδανικά για όλες εκείνες τις περιπτώσεις που θέλετε να συνδυάσετε <strong>την απόλυτη άνεση με την αποπλάνηση</strong>. Ο μη φουσκωτός σχεδιασμός εξασφαλίζει ολοήμερη χρήση χωρίς δυσφορία.</p>
<p>Τα <strong>κορδόνια στους γοφούς</strong> επιτρέπουν την εξατομικευμένη εφαρμογή, ενώ παράλληλα δημιουργούν ένα απίστευτα σέξι οπτικό αποτέλεσμα. Φορέστε το με αυτοπεποίθηση, γνωρίζοντας ότι η τέλεια εφαρμογή του θα αναδείξει τις καμπύλες σας χωρίς ποτέ να τις συμπιέζει.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>The Criss Cross panty has it all, with a design that's never bulging. Its <strong>beautiful waistband</strong> adapts perfectly to your generous curves, creating a sculpted silhouette with no constraints.</p>
<p><strong>Hip lacing</strong> turns every movement into an invitation to seduction, while the <strong>Brazilian cut</strong> reveals and beautifully enhances your buttocks. These <strong>tummy-hugging</strong> panties offer optimum support while retaining that terribly sexy edge.</p>
<p><strong>High-quality lace</strong> gently hugs your skin for absolute comfort that stays with you all day long. Available in three essential colors - mysterious black, passionate red and provocative white - each version reveals a different facet of your sensuality. This creation perfectly combines <strong>comfort and provocation</strong>, turning every day into an opportunity to feel irresistibly sexy and confident.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/plus-size-panties-criss-cross-black-black/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>Absolutely no sagging</strong> thanks to its beautiful waistband</li>
<li><strong>Sexy lacing</strong> on the ultra-provocative hips</li>
<li><strong>Brazilian cut</strong> shows off your buttocks to best advantage</li>
<li><strong>Rises over the tummy</strong> for perfect support</li>
<li><strong>Quality lace</strong> for all-day comfort</li>
<li><strong>Three colors</strong>: black, red and white</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Criss Cross plus size lace panties with hip lacing. Non-shedding, Brazilian cut. 3 sexy colors. Diva's Boudoir Lingerie. |
| | keywords | | | title | | string | Criss Cross plus size lace-up panties | Diva's Boudoir |
|
| | seotitle | | string | Plus size panties Criss Cross lace hip lacing |
| | seouri | | string | plus-size-panties-criss-cross-black-black |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Stretch lace (92% polyamide, 8% elastane)</li>
<li><strong>Colors:</strong> Black, Red, White</li>
<li><strong>Style:</strong> Panties with hip lacing and Brazilian cut</li>
<li><strong>Cut:</strong> Brazilian on the buttocks, rises on the tummy</li>
<li><strong>Care:</strong> Delicate hand wash recommended</li>
</ul> |
| | stylingtips | | string | <p>Criss Cross panties with their <strong>provocative lacing</strong> stand alone to create a terribly sexy look.</p>
<p>To amplify the seductive effect, pair them with pieces that subtly reveal their presence. <strong>Black</strong> brings timeless sensuality, <strong>red</strong> reveals fiery passion, while <strong>white</strong> plays on provocative innocence.</p>
<p>Complete your look with our <a href="https://www.divasboudoir.com/en/thong-plus-size/">sexy thongs for</a>variety, or add a <a href="https://www.divasboudoir.com/en/plus-size-kimonos/">kimono</a> for a gradual seduction that culminates in the discovery of these terribly exciting panties.</p> |
| | summary | | string | <p>Discover <strong>comfortable, sexy</strong> Criss Cross panties that won't sulk at all thanks to their <strong>beautiful waistband</strong>.</p>
<p><strong>Hip lacing</strong> and a <strong>Brazilian cut</strong> create a perfectly sculpted silhouette.</p> |
| | title | | string | Criss Cross panties: Sexy lacing and absolute comfort |
| | usageinstructions | | string | <p>Criss Cross panties are perfect for all occasions when you want to combine <strong>absolute comfort with seduction</strong>. Their no-kink design guarantees all-day wear without any discomfort.</p>
<p>The <strong>lacing on the hips</strong> allows a personalized fit while creating a terribly sexy visual effect. Wear it with confidence, knowing that its perfect fit will sublimate your curves without ever compressing them.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>La braguita Criss Cross lo tiene todo, con un diseño que nunca resulta voluminoso. Su <strong>preciosa cinturilla</strong> se adapta perfectamente a tus generosas curvas, creando una silueta esculpida sin limitaciones.</p>
<p>Su <strong>lazada en la cadera</strong> convierte cada movimiento en una invitación a la seducción, mientras que su <strong>corte brasileño</strong> revela y realza maravillosamente tus glúteos. Estas braguitas <strong>que se ciñen al vientre</strong> ofrecen una sujeción óptima al tiempo que conservan ese aspecto terriblemente sexy.</p>
<p>El <strong>encaje de alta calidad</strong> abraza suavemente tu piel para un confort absoluto que dura todo el día. Disponible en tres colores esenciales -negro misterioso, rojo apasionado y blanco provocativo-, cada versión revela una faceta diferente de tu sensualidad. Esta creación combina a la perfección <strong>comodidad y provocación</strong>, convirtiendo cada día en una oportunidad para sentirse irresistiblemente sexy y segura de sí misma.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/bragas-talla-grande-criss-cross-negro-negro/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>No se descuelga en absoluto</strong> gracias a su bonita cinturilla</li>
<li><strong>Sexy lazada</strong> en las caderas, ultra provocativa</li>
<li><strong>Corte brasileño</strong> para lucir las nalgas</li>
<li><strong>Se eleva sobre el vientre</strong> para una sujeción perfecta</li>
<li><strong>Encaje de calidad</strong> para una mayor comodidad durante todo el día</li>
<li><strong>Tres colores</strong>: negro, rojo y blanco</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Braguita de encaje de talla grande Criss Cross con lazada en la cadera. No voluminosas, corte brasileño. 3 sexys colores. Lencería Diva's Boudoir. |
| | keywords | | | title | | string | Braga Criss Cross talla grande lazada | Diva's Boudoir |
|
| | seotitle | | string | Bragas talla grande Criss Cross de encaje en la cadera |
| | seouri | | string | bragas-talla-grande-criss-cross-negro-negro |
| | specifications | | string | <ul>
<li><strong>Material:</strong> encaje elástico (92% poliamida, 8% elastán)</li>
<li><strong>Colores:</strong> negro, rojo y blanco</li>
<li><strong>Estilo :</strong> Braguita con lazada en la cadera y corte brasileño</li>
<li><strong>Corte :</strong> Brasileño en las nalgas, sube en el vientre</li>
<li><strong>Cuidados:</strong> Se recomienda un lavado a mano delicado</li>
</ul> |
| | stylingtips | | string | <p>Las bragas Criss Cross, con sus <strong>provocativos lazos</strong>, son todo lo que necesitas para crear un look increíblemente sexy.</p>
<p>Para mayor seducción, combínalas con prendas que revelen su presencia sutilmente. <strong>El negro</strong> aporta una sensualidad atemporal, <strong>el rojo</strong> revela una pasión ardiente, mientras que <strong>el blanco</strong> juega con una inocencia provocativa.</p>
<p>Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/tanga-talla-grande/">sexys tangas para</a>variar, o añade un <a href="https://www.divasboudoir.com/es/kimonos-tallas-grandes/">kimono</a> para una seducción gradual que culmine con el descubrimiento de estas bragas terriblemente excitantes.</p> |
| | summary | | string | <p>Descubre las <strong>cómodas y sexys</strong> braguitas Criss Cross, que no se enfurruñan en absoluto gracias a su <strong>bonita cinturilla</strong>.</p>
<p>Su <strong>lazada en las caderas</strong> y su <strong>corte brasileño</strong> crean una silueta perfectamente esculpida.</p> |
| | title | | string | Braguitas Criss Cross: lazada sexy y comodidad absoluta |
| | usageinstructions | | string | <p>Las braguitas Criss Cross son perfectas para todas esas ocasiones en las que quieres combinar <strong>comodidad absoluta con seducción</strong>. Su diseño no abombado garantiza su uso durante todo el día sin molestias.</p>
<p>El <strong>cordón en las caderas</strong> permite un ajuste personalizado a la vez que crea un efecto visual increíblemente sexy. Llévalo con confianza, sabiendo que su ajuste perfecto realzará tus curvas sin comprimirlas en ningún momento.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>La culotte Criss Cross a tout pour plaire avec sa conception pensée pour ne jamais boudiner. Ses <strong>belles tailles</strong> s'adaptent parfaitement à vos courbes généreuses, créant une silhouette sculptée sans aucune contrainte.</p>
<p>Son <strong>laçage sur les hanches</strong> transforme chaque mouvement en invitation à la séduction, tandis que sa <strong>coupe brésilienne</strong> révèle et met magnifiquement en valeur vos fesses. Cette culotte qui <strong>monte sur le ventre</strong> offre un maintien optimal tout en conservant ce côté terriblement sexy.</p>
<p>La <strong>dentelle de qualité</strong> épouse délicatement votre peau pour un confort absolu qui vous accompagne toute la journée. Disponible en trois couleurs incontournables - noir mystérieux, rouge passion et blanc provocant - chaque version révèle une facette différente de votre sensualité. Cette création allie parfaitement <strong>confort et provocation</strong>, transformant chaque jour en occasion de vous sentir irrésistiblement sexy et confiante.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/culotte-criss-cross-grande-taille-dentelle-lacage/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>Ne boudine absolument pas</strong> grâce à ses belles tailles</li>
<li><strong>Laçage sexy</strong> sur les hanches ultra provocant</li>
<li><strong>Coupe brésilienne</strong> qui met les fesses en valeur</li>
<li><strong>Monte sur le ventre</strong> pour un maintien parfait</li>
<li><strong>Dentelle de qualité</strong> confortable toute la journée</li>
<li><strong>Trois couleurs</strong> : noir, rouge et blanc</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Culotte Criss Cross grande taille en dentelle avec laçage hanches. Ne boudine pas, coupe brésilienne. 3 couleurs sexy. Diva's Boudoir Lingerie. |
| | keywords | | | title | | string | Culotte Criss Cross grande taille laçage | Diva's Boudoir |
|
| | seotitle | | string | Culotte grande taille Criss Cross dentelle laçage hanches |
| | seouri | | string | culotte-criss-cross-grande-taille-dentelle-lacage |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Dentelle extensible (92% polyamide, 8% élasthanne)</li>
<li><strong>Couleurs :</strong> Noir, Rouge, Blanc</li>
<li><strong>Style :</strong> Culotte avec laçage hanches et coupe brésilienne</li>
<li><strong>Coupe :</strong> Brésilienne sur les fesses, monte sur le ventre</li>
<li><strong>Entretien :</strong> Lavage délicat à la main recommandé</li>
</ul> |
| | stylingtips | | string | <p>La culotte Criss Cross avec son <strong>laçage provocant</strong> se suffit à elle-même pour créer un look terriblement sexy.</p>
<p>Pour amplifier l'effet de séduction, associez-la à des pièces qui révèlent subtilement sa présence. Le coloris <strong>noir</strong> apporte une sensualité intemporelle, le <strong>rouge</strong> révèle une passion ardente, tandis que le <strong>blanc</strong> joue sur l'innocence provocante.</p>
<p>Complétez votre look avec nos <a href="https://www.divasboudoir.com/fr/string-grande-taille/">strings sexys</a>pour varier les plaisirs, ou ajoutez un <a href="https://www.divasboudoir.com/fr/kimonos-grande-taille/">kimonos</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 Criss Cross, <strong>confortable et sexy</strong> qui ne boudine absolument pas grâce à ses <strong>belles tailles</strong>.</p>
<p>Son <strong>laçage sur les hanches</strong> et sa <strong>coupe brésilienne</strong> créent une silhouette parfaitement sculptée.</p> |
| | title | | string | Culotte Criss Cross : Laçage Sexy et Confort Absolu |
| | usageinstructions | | string | <p>La culotte Criss Cross est parfaite pour toutes les occasions où vous souhaitez allier <strong>confort absolu et séduction</strong>. Sa conception qui ne boudine pas garantit un port agréable toute la journée sans aucune gêne.</p>
<p>Le <strong>laçage sur les hanches</strong> permet un ajustement personnalisé tout en créant un effet visuel terriblement sexy. Portez-la avec assurance, sachant que sa coupe parfaite sublimera vos courbes sans jamais les comprimer.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>La mutandina Criss Cross ha tutto, con un design mai ingombrante. La sua <strong>splendida fascia in vita</strong> si adatta perfettamente alle vostre curve generose, creando una silhouette scolpita senza costrizioni.</p>
<p>L'<strong>allacciatura sui fianchi</strong> trasforma ogni movimento in un invito alla seduzione, mentre il <strong>taglio brasiliano</strong> rivela ed esalta i vostri glutei. Queste mutandine <strong>aderenti alla pancia</strong> offrono un sostegno ottimale pur mantenendo un look terribilmente sexy.</p>
<p>Il <strong>pizzo di alta qualità</strong> abbraccia delicatamente la pelle per un comfort assoluto che dura tutto il giorno. Disponibile in tre colori essenziali - nero misterioso, rosso passionale e bianco provocante - ogni versione rivela una diversa sfaccettatura della vostra sensualità. Questa creazione combina perfettamente <strong>comfort e provocazione</strong>, trasformando ogni giorno in un'occasione per sentirsi irresistibilmente sexy e sicure di sé.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/mutandine-di-taglia-grande-criss-cross-nero-nero/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>Assolutamente nessun cedimento</strong> grazie alla sua bella fascia in vita</li>
<li><strong>Sexy allacciatura</strong> sui fianchi, ultra provocante</li>
<li><strong>Taglio brasiliano</strong> per mettere in mostra il sedere</li>
<li><strong>Si solleva sulla pancia</strong> per un sostegno perfetto</li>
<li><strong>Pizzo di qualità</strong> per un comfort che dura tutto il giorno</li>
<li><strong>Tre colori</strong>: nero, rosso e bianco</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Mutandine in pizzo di grande taglia Criss Cross con allacciatura sui fianchi. Taglio brasiliano non voluminoso. 3 colori sexy. Diva's Boudoir Lingerie. |
| | keywords | | | title | | string | Criss Cross panty taglia grande allacciatura | Diva's Boudoir |
|
| | seotitle | | string | Mutandine di taglia grande con allacciatura Criss Cross sui fianchi |
| | seouri | | string | mutandine-di-taglia-grande-criss-cross-nero-nero |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> pizzo elasticizzato (92% poliammide, 8% elastan)</li>
<li><strong>Colori:</strong> Nero, Rosso, Bianco</li>
<li><strong>Stile :</strong> Mutandina con allacciatura sui fianchi e taglio brasiliano</li>
<li><strong>Taglio :</strong> Brasiliano sui glutei, rialzato sul ventre</li>
<li><strong>Cura:</strong> Si consiglia un lavaggio delicato a mano</li>
</ul> |
| | stylingtips | | string | <p>Le mutandine Criss Cross, con la loro <strong>provocante allacciatura</strong>, sono tutto ciò che serve per creare un look incredibilmente sexy.</p>
<p>Per una maggiore seduzione, abbinatele a capi che rivelino sottilmente la loro presenza. <strong>Il nero</strong> porta con sé una sensualità senza tempo, il <strong>rosso</strong> rivela una passione ardente, mentre il <strong>bianco</strong> gioca con l'innocenza provocante.</p>
<p>Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/perizoma-di-grandi-dimensioni/">tanga sexy per</a>variare, oppure aggiungete un <a href="https://www.divasboudoir.com/it/kimono-taglie-forti/">kimono</a> per una seduzione graduale che culmina con la scoperta di queste mutandine terribilmente eccitanti.</p> |
| | summary | | string | <p>Scoprite le <strong>comode e sexy</strong> mutandine Criss Cross, che non vi faranno sentire in imbarazzo grazie alla loro <strong>splendida fascia in vita</strong>.</p>
<p>L'<strong>allacciatura sui fianchi</strong> e il <strong>taglio brasiliano</strong> creano una silhouette perfettamente scolpita.</p> |
| | title | | string | Mutandine Criss Cross: allacciatura sexy e comfort assoluto |
| | usageinstructions | | string | <p>Le mutandine Criss Cross sono perfette per tutte le occasioni in cui si desidera unire il <strong>comfort assoluto alla seduzione</strong>. Il design non sgambato assicura un'usura che dura tutto il giorno senza alcun disagio.</p>
<p>L'<strong>allacciatura sui fianchi</strong> consente una vestibilità personalizzata e crea un effetto visivo incredibilmente sexy. Indossatelo con fiducia, sapendo che la sua perfetta vestibilità esalterà le vostre curve senza mai comprimerle.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>De Criss Cross panty heeft het allemaal, met een ontwerp dat nooit volumineus is. De <strong>prachtige tailleband</strong> past zich perfect aan je royale rondingen aan en creëert een gebeeldhouwd silhouet zonder beperkingen.</p>
<p>De <strong>heupveter</strong> maakt van elke beweging een uitnodiging tot verleiding, terwijl <strong>de Braziliaanse snit</strong> je billen onthult en prachtig laat uitkomen. Deze <strong>nauwsluitende</strong> slips bieden optimale ondersteuning terwijl ze die vreselijk sexy look behouden.</p>
<p>Het <strong>hoogwaardige kant</strong> omhelst je huid zachtjes voor absoluut comfort dat de hele dag blijft zitten. Verkrijgbaar in drie essentiële kleuren - mysterieus zwart, hartstochtelijk rood en uitdagend wit - onthult elke versie een ander facet van je sensualiteit. Deze creatie combineert perfect <strong>comfort en provocatie</strong>, waardoor elke dag een kans wordt om je onweerstaanbaar sexy en zelfverzekerd te voelen.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/groote-maat-slip-criss-cross-zwart-zwart/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>Absoluut geen afzakken</strong> dankzij de mooie tailleband</li>
<li><strong>Sexy vetersluiting</strong> op de heupen, ultra uitdagend</li>
<li><strong>Braziliaans model</strong> om je billen te showen</li>
<li><strong>Komt omhoog over de buik</strong> voor perfecte ondersteuning</li>
<li><strong>Kwaliteitsveter</strong> voor de hele dag comfort</li>
<li><strong>Drie kleuren</strong>: zwart, rood en wit</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Kriskras grote maat kanten slip met vetersluiting op de heupen. Niet volumineus, Braziliaans model. 3 sexy kleuren. Diva's Boudoir Lingerie. |
| | keywords | | | title | | string | Criss Cross panty grote maat | Diva's Boudoir |
|
| | seotitle | | string | Grote maat slip Criss Cross kant heupveter |
| | seouri | | string | groote-maat-slip-criss-cross-zwart-zwart |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Stretchkant (92% polyamide, 8% elastaan)</li>
<li><strong>Kleuren:</strong> Zwart, Rood, Wit</li>
<li><strong>Stijl :</strong> Slipje met heupveter en Braziliaans model</li>
<li><strong>Snit :</strong> Braziliaans op de billen, oplopend op de buik</li>
<li><strong>Onderhoud:</strong> Fijne handwas aanbevolen</li>
</ul> |
| | stylingtips | | string | <p>Criss Cross slips, met hun <strong>provocerende vetersluiting</strong>, zijn alles wat je nodig hebt om een ongelooflijk sexy look te creëren.</p>
<p>Voor nog meer verleiding combineer je ze met stukken die subtiel hun aanwezigheid onthullen. <strong>Zwart</strong> brengt tijdloze sensualiteit, <strong>rood</strong> onthult vurige passie en <strong>wit</strong> speelt met provocerende onschuld.</p>
<p>Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/string-groote-maat/">sexy strings voor</a>de afwisseling, of voeg een <a href="https://www.divasboudoir.com/nl/plus-size-kimonos/">kimono</a> toe voor een geleidelijke verleiding die culmineert in de ontdekking van deze vreselijk opwindende slipjes.</p> |
| | summary | | string | <p>Ontdek de <strong>comfortabele, sexy</strong> Criss Cross slip, die dankzij de <strong>mooie tailleband</strong> absoluut niet gaat knellen.</p>
<p>De <strong>vetersluiting op de heupen</strong> en <strong>de Braziliaanse snit</strong> zorgen voor een perfect gebeeldhouwd silhouet.</p> |
| | title | | string | Criss Cross slip: Sexy vetersluiting en absoluut comfort |
| | usageinstructions | | string | <p>Criss Cross slips zijn perfect voor alle gelegenheden waarbij je <strong>absoluut comfort</strong> wilt combineren <strong>met verleiding</strong>. Het niet opbollende ontwerp zorgt ervoor dat je het de hele dag zonder ongemak kunt dragen.</p>
<p>De <strong>vetersluiting op de heupen</strong> zorgt voor een persoonlijke pasvorm en een ongelooflijk sexy visueel effect. Draag het met vertrouwen, wetende dat de perfecte pasvorm je rondingen zal verbeteren zonder ze ooit samen te drukken.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>A cueca Criss Cross tem tudo, com um design que nunca é volumoso. A sua <strong>bela cintura</strong> adapta-se perfeitamente às suas curvas generosas, criando uma silhueta esculpida sem constrangimentos.</p>
<p>O seu laço <strong>na anca</strong> transforma cada movimento num convite à sedução, enquanto o seu <strong>corte brasileiro</strong> revela e realça lindamente as suas nádegas. Estas cuecas <strong>que abraçam a barriga</strong> oferecem um suporte ótimo, mantendo aquele aspeto terrivelmente sexy.</p>
<p>A <strong>renda de alta qualidade</strong> envolve suavemente a sua pele para um conforto absoluto que dura todo o dia. Disponível em três cores essenciais - preto misterioso, vermelho apaixonante e branco provocante - cada versão revela uma faceta diferente da sua sensualidade. Esta criação combina na perfeição <strong>conforto e provocação</strong>, transformando cada dia numa oportunidade para se sentir irresistivelmente sexy e confiante.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/cuecas-tamanho-grande-criss-cross-preto-preto/sbga8281.htm |
| | highlights | | string | <ul>
<li><strong>Sem qualquer flacidez</strong> graças à sua bela cintura</li>
<li><strong>Laço sexy</strong> nas ancas, ultra provocante</li>
<li><strong>Corte brasileiro</strong> para mostrar o seu traseiro</li>
<li><strong>Sobe sobre a barriga</strong> para um apoio perfeito</li>
<li><strong>Renda de qualidade</strong> para conforto durante todo o dia</li>
<li><strong>Três cores</strong>: preto, vermelho e branco</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Cuecas de renda grandes Criss Cross com laço na anca. Não volumosas, corte brasileiro. 3 cores sensuais. Lingerie Diva's Boudoir. |
| | keywords | | | title | | string | Calcinha Criss Cross tamanho grande com laço | Diva's Boudoir |
|
| | seotitle | | string | Cuecas de tamanho grande Criss Cross com renda na anca |
| | seouri | | string | cuecas-tamanho-grande-criss-cross-preto-preto |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Renda elástica (92% poliamida, 8% elastano)</li>
<li><strong>Cores:</strong> Preto, Vermelho, Branco</li>
<li><strong>Estilo :</strong> Cuecas com laço na anca e corte brasileiro</li>
<li><strong>Corte:</strong> Brasileiro nas nádegas, sobe na barriga</li>
<li><strong>Cuidados:</strong> Recomenda-se uma lavagem delicada à mão</li>
</ul> |
| | stylingtips | | string | <p>As cuecas Criss Cross, com o seu <strong>laço provocante</strong>, são tudo o que precisa para criar um visual incrivelmente sexy.</p>
<p>Para uma maior sedução, combine-as com peças que revelem subtilmente a sua presença. <strong>O preto</strong> traz uma sensualidade intemporal, <strong>o vermelho</strong> revela uma paixão ardente, enquanto <strong>o branco</strong> joga com uma inocência provocante.</p>
<p>Complete o seu look com as nossas tangas <a href="https://www.divasboudoir.com/pt/fio-dental-tamanho-grande/">sensuais para</a>variar, ou adicione um <a href="https://www.divasboudoir.com/pt/quimonos-de-tamanho-grande/">quimono</a> para uma sedução gradual que culmina com a descoberta destas cuecas terrivelmente excitantes.</p> |
| | summary | | string | <p>Descubra as cuequinhas Criss Cross, <strong>confortáveis e sensuais</strong>, que não fazem qualquer barulho graças à sua <strong>bela cintura</strong>.</p>
<p>O seu laço <strong>nas ancas</strong> e o <strong>corte brasileiro</strong> criam uma silhueta perfeitamente esculpida.</p> |
| | title | | string | Cuecas Criss Cross: laço sexy e conforto absoluto |
| | usageinstructions | | string | <p>As cuecas Criss Cross são perfeitas para todas as ocasiões em que se quer combinar <strong>conforto absoluto com sedução</strong>. O design sem abaulamento garante uma utilização durante todo o dia sem desconforto.</p>
<p>O <strong>laço nas ancas</strong> permite um ajuste personalizado, criando um efeito visual incrivelmente sexy. Use-o com confiança, sabendo que o seu ajuste perfeito irá realçar as suas curvas sem nunca as comprimir.</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 | Black Plus Size Sexy High Waist Floral Lace Strappy Panty P5124-1P |
|
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 952F4D3D-C960-4C3A-B0293EDD79B2B08A |
|
| promountil | |
| rating | |
| recorduid | | string | 952F4D3D-C960-4C3A-B0293EDD79B2B08A |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.57 ms Record Count: 15 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,'1093,1137,1148,1136,1115') > 0 and product_variations.productuid = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 | 1093 | 38-40 | intlsize | red | 38 | 40 | -1 | 999999 | 1 | w | plus | lingerie | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 92-100 | 74-82 | 98-106 | | | | | | | | 2 | 1093 | 38-40 | intlsize | white | 38 | 40 | -1 | 999999 | 0 | w | plus | lingerie | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 92-100 | 74-82 | 98-106 | | | | | | | | 3 | 1093 | 38-40 | intlsize | black | 38 | 40 | -1 | 999999 | 0 | w | plus | lingerie | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | 92-100 | 74-82 | 98-106 | | | | | | | | 4 | 1137 | 44-46 | intlsize | red | 44 | 46 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 102-108 | 86-92 | 108-114 | | | | | | | | 5 | 1137 | 44-46 | intlsize | black | 44 | 46 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 102-108 | 86-92 | 108-114 | | | | | | | | 6 | 1137 | 44-46 | intlsize | white | 44 | 46 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | 102-108 | 86-92 | 108-114 | | | | | | | | 7 | 1148 | 46-48 | intlsize | black | 46 | 48 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 100-110 | 82-96 | 106-116 | | | | | | | | 8 | 1148 | 46-48 | intlsize | white | 46 | 48 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 100-110 | 82-96 | 106-116 | | | | | | | | 9 | 1148 | 46-48 | intlsize | red | 46 | 48 | -1 | 999999 | 0 | w | plus | lingerie | XL-2XL | 46-48 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | 100-110 | 82-96 | 106-116 | | | | | | | | 10 | 1136 | 48-50 | intlsize | red | 48 | 50 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 110-116 | 96-102 | 116-122 | | | | | | | | 11 | 1136 | 48-50 | intlsize | black | 48 | 50 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 110-116 | 96-102 | 116-122 | | | | | | | | 12 | 1136 | 48-50 | intlsize | white | 48 | 50 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | 110-116 | 96-102 | 116-122 | | | | | | | | 13 | 1115 | 50-52 | intlsize | red | 50 | 52 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 116-126 | 102-110 | 122-132 | | | | | | | | 14 | 1115 | 50-52 | intlsize | black | 50 | 52 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 116-126 | 102-110 | 122-132 | | | | | | | | 15 | 1115 | 50-52 | intlsize | white | 50 | 52 | -1 | 999999 | 0 | w | plus | lingerie | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | 116-126 | 102-110 | 122-132 | | | | | | |
|
| sizeranges | |
| sizes | | string | 1093,1137,1148,1136,1115 |
|
| 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: 60.5 ms Record Count: 9 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1093 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1137 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1148 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1136 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1115 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 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | 3CFA6390-EA32-44B5-835AD30581BBDAAD | 1093 | black | #000000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 5 | 0 | 0 | P5124-1P | P5124-1P1115 | -1 | 0 | all | | | 2 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | A4CB2EB3-DE60-4E1F-9B8EFC335308A422 | 1093 | red | #F50000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5124-3 | | 1 | 1 | all | | | 3 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | 9C9EFFD2-2E08-401A-9194E7154B1CC91F | 1093 | white | #FFFFFF | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | P5124-2 | | -1 | 0 | all | | | 4 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | BAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D | 1137 | black | #000000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 1 | 0 | 0 | -1 | 2 | 27 | 0 | 0 | P5124-1P | P5124-1P1117 | -1 | 0 | all | | | 5 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | B9CDA488-7C84-4456-BC8EC4FC1524DD88 | 1137 | red | #F50000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5124-3 | | -1 | 0 | all | | | 6 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | CB13274B-82AC-4BA3-A182BFC5BAACE092 | 1137 | white | #FFFFFF | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | P5124-2 | P5124-21117 | -1 | 0 | all | | | 7 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | DE4AE40E-912E-4422-ABAD6D2247F4A3FC | 1136 | black | #000000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 41 | 0 | 0 | P5124-1P | P5124-1P1119 | -1 | 0 | all | | | 8 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | BB3DBC58-6269-4085-87C19A61E38057C1 | 1136 | red | #F50000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | P5124-3 | P5124-3P1119 | -1 | 0 | all | | | 9 | 952F4D3D-C960-4C3A-B0293EDD79B2B08A | 4F24B3E6-9038-4C5F-8AFB7405236AF15B | 1136 | white | #FFFFFF | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | P5124-2 | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 12.8 ms Record Count: 15 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1093 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1137 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1148 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1136 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' 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 = '952F4D3D-C960-4C3A-B0293EDD79B2B08A' and product_variations.isactive = 1 and product_sizes.id_size = 1115 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 | 3CFA6390-EA32-44B5-835AD30581BBDAAD | 1093 | black | #000000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 5 | 0 | 0 | P5124-1P | P5124-1P1115 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 2 | A4CB2EB3-DE60-4E1F-9B8EFC335308A422 | 1093 | red | #F50000 | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5124-3 | | 1 | 1 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 3 | 9C9EFFD2-2E08-401A-9194E7154B1CC91F | 1093 | white | #FFFFFF | M-L | 38-40 | | 38-40 | 8-10 | 12-14 | 40-42 | 40-42 | 38-40 | 44-46 | 40-42 | 38-40 | w | lingerie | | 38-40 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | P5124-2 | | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 4 | BAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D | 1137 | black | #000000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 1 | 0 | 0 | -1 | 2 | 27 | 0 | 0 | P5124-1P | P5124-1P1117 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 5 | B9CDA488-7C84-4456-BC8EC4FC1524DD88 | 1137 | red | #F50000 | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5124-3 | | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 6 | CB13274B-82AC-4BA3-A182BFC5BAACE092 | 1137 | white | #FFFFFF | XL-2XL | 44-46 | | 44-46 | 14-16 | 18-22 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 44-46 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | P5124-2 | P5124-21117 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 7 | BAA63E9B-B6E2-4BA8-ADD4BE3BDC883B9D | 1148 | black | #000000 | XL-2XL | 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 | 16.625 | 11.625 | | STOCK01 | 1 | 0 | 0 | -1 | 2 | 27 | 0 | 0 | P5124-1P | P5124-1P1117 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 8 | B9CDA488-7C84-4456-BC8EC4FC1524DD88 | 1148 | red | #F50000 | XL-2XL | 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 | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5124-3 | | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 9 | CB13274B-82AC-4BA3-A182BFC5BAACE092 | 1148 | white | #FFFFFF | XL-2XL | 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 | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 1 | 0 | 0 | P5124-2 | P5124-21117 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 10 | DE4AE40E-912E-4422-ABAD6D2247F4A3FC | 1136 | black | #000000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 41 | 0 | 0 | P5124-1P | P5124-1P1119 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 11 | BB3DBC58-6269-4085-87C19A61E38057C1 | 1136 | red | #F50000 | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | P5124-3 | P5124-3P1119 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 12 | 4F24B3E6-9038-4C5F-8AFB7405236AF15B | 1136 | white | #FFFFFF | 3XL-4XL | 48-50 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | lingerie | | 48-50 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | P5124-2 | | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 13 | DE4AE40E-912E-4422-ABAD6D2247F4A3FC | 1115 | black | #000000 | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | 50-52 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 41 | 0 | 0 | P5124-1P | P5124-1P1119 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 14 | BB3DBC58-6269-4085-87C19A61E38057C1 | 1115 | red | #F50000 | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | 50-52 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 1 | 0 | 0 | P5124-3 | P5124-3P1119 | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | | | 15 | 4F24B3E6-9038-4C5F-8AFB7405236AF15B | 1115 | white | #FFFFFF | 3XL-4XL | 50-52 | | 50-52 | 20-22 | 24-28 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | lingerie | | 50-52 | intlsize | 16.625 | 11.625 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | P5124-2 | | -1 | 0 | -1 | 0 | -1 | 0 | 1 | 11.625 | all | |
|
| vatrate | |
| warehouse | |