Struct Entries: 108 |
| actions | |
| available | |
| brand | |
| brandcode | |
| branding | | string | divasboudoir,legsboudoir |
|
| 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.hoisery.stocking |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/hoisery/stockings.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.946 ms Record Count: 1 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black') > 0 and product_variations.productuid = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 | 2 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2024-10-07 10:04:01'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-05-30 12:30:14'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.795 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select cart_actions.* from cart_actions where cart_actions.branding IN ('all','divasboudoir') and cart_actions.language IN ('all','it') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('6bcf32ba-0872-461a-b189cd544cb925a7',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: 3.24 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','it') and product_categories.language in ('all','it') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '299E11FF-F497-4405-8B82AAC73469E15C' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'SLST0376' 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 | | string | 299E11FF-F497-4405-8B82AAC73469E15C |
|
| materials | |
| mediadatas | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/gjjm/slst0376/50136_noir60_bk01-scaled.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/gjjm/slst0376/50136_noir60_bk_left_01-scaled.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/gjjm/slst0376/50136_noir60_bk_right_02-scaled_1.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/gjjm/slst0376/50136_noir60_bk_left_02-scaled.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><span>Diese blickdichten Strümpfe 60 Den aus hochwertigen Materialien bieten unvergleichlichen Komfort und optimalen Halt, während sie Ihre natürlichen Kurven elegant betonen. </span></p>
<p><span>sie sind zu jeder Jahreszeit elegant und eignen sich besonders gut für den Winter. </span></p>
<p><span>Dank der seidigen Textur und der engen Passform sehen Sie schick und modisch aus und sind gleichzeitig vor Kälte geschützt. </span></p>
<p><span>Kombinieren Sie sie mit einem Strapsgürtel, um einen noch raffinierteren Look zu erzielen und Ihre Beine noch mehr zu betonen. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/de/blickdichte-strumpfe-in-grossen-grossen-schwarz/slst0376.htm |
| | highlights | | string | <ul>
<li>Hochwertige Materialien für dauerhafte Raffinesse</li>
<li><strong>blickdichte 60 Denier</strong> für optimale Weichheit und Wärme</li>
<li>Seidige Textur umschmeichelt sanft Ihre Beine</li>
<li>Perfekte Passform, die natürliche Formen betont</li>
<li>Ideal für alle Jahreszeiten mit erhöhtem Winterschutz</li>
<li>Optimaler BH, der sich an die <strong>Kurven</strong> anschmiegt</li>
<li>Unübertroffener Komfort für anspruchsvolle Damengarderobe</li>
<li>Unverzichtbar, um schick und trendy zu bleiben</li>
</ul> |
| | keypoint | | | keywords | | string | blickdichte Strümpfe, 60 Denier, elegant, Komfort, thermisch, Winter, seidig, Unterstützung, Diva's Boudoir, Dessous, Weiblichkeit, große Größe |
| | metas | | Struct | | description | | string | Entdecken Sie unsere schwarzen60 Strümpfe aus blickdichter Mikrofaser mit Stretchanteil. Erschwinglicher Luxus für große und kurvige Frauen. Schick das ganze Jahr über, perfekt für den Winter. Strapsgürtel erforderlich. |
| | keywords | | string | blickdichte Strümpfe, 60 Denier, elegant, Komfort, thermisch, Winter, seidig, Unterstützung, Diva's Boudoir, Dessous, Weiblichkeit, große Größe |
| | title | | string | Diva's Boudoir: Luxuriöse schwarze Strümpfe60 für runde Frauen |
|
| | seotitle | | string | Blickdichte Strümpfe in großen Größen |
| | seouri | | string | blickdichte-strumpfe-in-grossen-grossen-schwarz |
| | specifications | | string | <ul>
<li>Stil: Blickdichte Strümpfe winterliche Raffinesse</li>
<li>Denier: 60 Denier optimale Wärme und Schutz</li>
<li>Material: Hohe Qualität für Premium-Haltbarkeit</li>
<li>Textur: Seidig für unvergleichliche Weichheit</li>
<li>Passform: Perfekt für großzügige Kurven</li>
<li>Jahreszeiten: Ideal für alle Jahreszeiten, besonders für den Winter</li>
<li>BH: Optimal für unvergleichlichen Komfort</li>
<li>Pflege: Feinwäsche empfohlen</li>
</ul> |
| | stylingtips | | string | <p>Diese <strong>blickdichten Strümpfe</strong> passen dank ihrer zeitlosen Raffinesse perfekt zu all Ihren Winterlooks. Ihre seidige Textur lässt sich elegant mit hohen Stiefeln kombinieren, um eine schicke Silhouette zu kreieren, oder mit Pumps, um ihre blickdichte Schönheit zu enthüllen. Ideal unter kurzen Kleidern oder Röcken, bieten sie diesen Wärmeschutz und betonen gleichzeitig Ihre natürlichen Formen.</p>
<p>Ihre perfekte Passform macht sie zu einem unverzichtbaren Bestandteil Ihrer Damengarderobe, mit dem Sie auch bei kaltem Wetter modisch aussehen können und der Ihre Fähigkeit offenbart, Wärmekomfort und moderne Raffinesse mit selbstbewusster Kultiviertheit zu verbinden.</p> |
| | summary | | string | Ein seltenes Stück, vor allem in so schönen Größen, das Sie die ganze Saison über lieben werden. |
| | title | | string | Strümpfe 60 Den Opake |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Κατασκευασμένες από υλικά υψηλής ποιότητας, αυτές οι αδιαφανείς κάλτσες 60 Den προσφέρουν απαράμιλλη άνεση και βέλτιστη στήριξη, ενώ παράλληλα τονίζουν κομψά τις φυσικές σας καμπύλες. </span></p>
<p><span>κομψές σε κάθε εποχή, είναι ιδιαίτερα κατάλληλες για τις κακουχίες του χειμώνα. </span></p>
<p><span>Η μεταξένια υφή τους και η λεπτή τους εφαρμογή θα σας κρατήσουν κομψή και μοντέρνα, ενώ παράλληλα θα σας προστατεύουν από το κρύο. </span></p>
<p><span>Συνδυάστε τα με μια ζώνη καλτσοδέτας για μια ακόμη πιο εκλεπτυσμένη εμφάνιση που θα αναδείξει ακόμη περισσότερο τα πόδια σας. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/el/kaltses-megaloy-megethoys-adiafaneis-mayro/slst0376.htm |
| | highlights | | string | <ul>
<li>Υλικά υψηλής ποιότητας για διαρκή εκλέπτυνση</li>
<li><strong>αδιαφανές</strong> ύφασμα<strong>60 denier</strong> για βέλτιστη απαλότητα και ζεστασιά</li>
<li>Η μεταξένια υφή χαϊδεύει απαλά τα πόδια σας</li>
<li>Η τέλεια εφαρμογή ενισχύει το φυσικό σας σχήμα</li>
<li>Ιδανικό για όλες τις εποχές με επιπλέον προστασία το χειμώνα</li>
<li>Βέλτιστη στήριξη για <strong>γενναιόδωρες καμπύλες</strong></li>
<li>Ασυναγώνιστη άνεση για εκλεπτυσμένες γυναικείες γκαρνταρόμπες</li>
<li>Απαραίτητη για να παραμείνετε κομψοί και μοντέρνοι</li>
</ul> |
| | keypoint | | | keywords | | string | αδιαφανείς κάλτσες, 60 denier, κομψές, άνεση, θερμικές, χειμώνα, μεταξένιες, υποστήριξη, Diva's Boudoir, εσώρουχα, θηλυκότητα, μεγάλο μέγεθος |
| | metas | | Struct | | description | | string | Ανακαλύψτε τις κάλτσες μας black60 από αδιαφανή, ελαστική μικροΐνα. Προσιτή πολυτέλεια για ψηλές, καμπυλωτές γυναίκες. Κομψές όλο το χρόνο, ιδανικές για το χειμώνα. Απαιτείται ζώνη καλτσοδέτας. |
| | keywords | | string | αδιαφανείς κάλτσες, 60 denier, κομψές, άνεση, θερμικές, χειμώνα, μεταξένιες, υποστήριξη, Diva's Boudoir, εσώρουχα, θηλυκότητα, μεγάλο μέγεθος |
| | title | | string | Μπουντουάρ της Ντίβας : Luxurious60 Μαύρες κάλτσες για στρογγυλές γυναίκες |
|
| | seotitle | | string | Κάλτσες μεγάλου μεγέθους αδιαφανείς |
| | seouri | | string | kaltses-megaloy-megethoys-adiafaneis-mayro |
| | specifications | | string | <ul>
<li>Στυλ : Αδιαφανείς κάλτσες για χειμερινή φινέτσα</li>
<li>Denier: 60 denier για βέλτιστη ζεστασιά και προστασία</li>
<li>Υλικά : Υψηλής ποιότητας για κορυφαία ανθεκτικότητα</li>
<li>Υφή : Μεταξένια για απαράμιλλη απαλότητα</li>
<li>Εφαρμογή : Ιδανική για γενναιόδωρες καμπύλες</li>
<li>Εποχές : Ιδανικό για όλες τις εποχές, ειδικά το χειμώνα</li>
<li>Στήριξη: Βέλτιστη για αξεπέραστη άνεση</li>
<li>Φροντίδα : Συνιστάται απαλό πλύσιμο</li>
</ul> |
| | stylingtips | | string | <p>Αυτές οι <strong>αδιαφανείς κάλτσες</strong> ταιριάζουν απόλυτα με όλες τις χειμερινές σας εμφανίσεις, χάρη στη διαχρονική τους φινέτσα. Η μεταξένια υφή τους συνδυάζεται κομψά με ψηλές μπότες για να δημιουργήσει μια κομψή σιλουέτα, ή με γόβες για να αποκαλύψει την αδιαφανή ομορφιά τους. Ιδανικά κάτω από φορέματα ή κοντές φούστες, παρέχουν αυτή τη θερμική προστασία, ενώ παράλληλα αναδεικνύουν τις φυσικές σας καμπύλες.</p>
<p>Η τέλεια εφαρμογή τους τα καθιστά απαραίτητα για τη γυναικεία σας γκαρνταρόμπα, διατηρώντας σας στην τάση ακόμη και στις πιο κρύες καιρικές συνθήκες, αποκαλύπτοντας την ικανότητά σας να συνδυάζετε τη θερμική άνεση με τη σύγχρονη εκλέπτυνση.</p> |
| | summary | | string | Ένα σπάνιο κομμάτι, ειδικά σε τόσο όμορφα μεγέθη, που θα αγαπήσετε όλη τη σεζόν. |
| | title | | string | Κάλτσες 60 Den Opaques |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Made from high-quality materials, these opaque 60 Den stockings offer unrivalled comfort and optimum support, while elegantly accentuating your natural curves. </span></p>
<p><span>elegant in any season, they're particularly well-suited to the rigors of winter. </span></p>
<p><span>Their silky texture and slim fit will keep you chic and on-trend, while protecting you from the cold. </span></p>
<p><span>Pair them with a garter belt for an even more sophisticated look that enhances your legs. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/en/opaque-plus-size-stockings-black/slst0376.htm |
| | highlights | | string | <ul>
<li>High-quality materials for lasting sophistication</li>
<li><strong>60-denier opaque</strong> fabric for optimum softness and warmth</li>
<li>Silky texture gently caresses your legs</li>
<li>Perfect fit enhances natural shape</li>
<li>Ideal for all seasons with reinforced winter protection</li>
<li>Optimal bra for <strong>generous curves</strong></li>
<li>Unbeatable comfort for refined feminine wardrobes</li>
<li>Indispensable for staying chic and trendy</li>
</ul> |
| | keypoint | | | keywords | | string | opaque stockings, 60 denier, elegant, comfort, thermal, winter, silky, bra, Diva's Boudoir, lingerie, femininity, plus size |
| | metas | | Struct | | description | | string | Discover our black60 stockings in opaque, stretch microfiber. Affordable luxury for tall, curvy women. Year-round chic, perfect for winter. Garter belt required. |
| | keywords | | string | opaque stockings, 60 denier, elegant, comfort, thermal, winter, silky, bra, Diva's Boudoir, lingerie, femininity, plus size |
| | title | | string | Diva's Boudoir : Luxurious60 Black Stockings for Round Women |
|
| | seotitle | | string | Opaque plus size stockings |
| | seouri | | string | opaque-plus-size-stockings-black |
| | specifications | | string | <ul>
<li>Style: Opaque stockings for winter sophistication</li>
<li>Denier: 60 denier for optimum warmth and protection</li>
<li>Materials: High quality for premium durability</li>
<li>Texture: Silky for incomparable softness</li>
<li>Fit : Perfect for generous curves</li>
<li>Seasons: Ideal for all seasons, especially winter</li>
<li>Bra: Optimal bra for unsurpassed comfort</li>
<li>Care: Delicate wash recommended</li>
</ul> |
| | stylingtips | | string | <p>These <strong>opaque stockings</strong> are the perfect match for all your winter looks, thanks to their timeless sophistication. Their silky texture pairs elegantly with tall boots to create a chic silhouette, or with pumps to reveal their opaque beauty. Ideal under dresses or short skirts, they provide that thermal protection while enhancing your natural curves.</p>
<p>Their perfect fit makes them a must-have in your women's wardrobe, keeping you on trend even in cold weather, revealing your ability to combine thermal comfort and modern refinement with assumed sophistication.</p> |
| | summary | | string | A rare piece, especially in such beautiful sizes, that you'll love all season long. |
| | title | | string | Stockings 60 Den Opaques |
| | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Fabricadas con materiales de alta calidad, estas medias opacas 60 Den ofrecen un confort inigualable y una sujeción óptima, al tiempo que acentúan con elegancia sus curvas naturales. </span></p>
<p><span>elegantes en cualquier estación, son especialmente adecuadas para los rigores del invierno. </span></p>
<p><span>Su textura sedosa y su corte entallado te mantendrán elegante y a la moda, al tiempo que te protegen del frío. </span></p>
<p><span>Combínalos con un liguero para un look aún más sofisticado que realzará aún más tus piernas. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/es/medias-opacas-de-talla-grande-negro/slst0376.htm |
| | highlights | | string | <ul>
<li>Materiales de alta calidad para una sofisticación duradera</li>
<li>tejido<strong>opaco de 60 deniers</strong> para una suavidad y calidez óptimas</li>
<li>Textura sedosa que acaricia suavemente las piernas</li>
<li>El ajuste perfecto realza su forma natural</li>
<li>Ideal para todas las estaciones con protección extra para el invierno</li>
<li>Sujeción óptima para <strong>curvas generosas</strong></li>
<li>Comodidad insuperable para un vestuario femenino refinado</li>
<li>Indispensable para ir a la moda y a la moda</li>
</ul> |
| | keypoint | | | keywords | | string | medias opacas, 60 deniers, elegantes, comodidad, térmicas, invierno, sedosas, sujetador, Diva's Boudoir, lencería, feminidad, talla grande |
| | metas | | Struct | | description | | string | Descubra nuestras medias negras60 de microfibra opaca y elástica. Lujo asequible para mujeres altas y con curvas. Elegantes todo el año, perfectas para el invierno. Requiere liguero. |
| | keywords | | string | medias opacas, 60 deniers, elegantes, comodidad, térmicas, invierno, sedosas, sujetador, Diva's Boudoir, lencería, feminidad, talla grande |
| | title | | string | Diva's Boudoir : Lujosas60 Medias Negras para Mujeres Redondas |
|
| | seotitle | | string | Medias opacas de talla grande |
| | seouri | | string | medias-opacas-de-talla-grande-negro |
| | specifications | | string | <ul>
<li>Estilo : Medias opacas para la sofisticación invernal</li>
<li>Denier: 60 deniers para una calidez y protección óptimas</li>
<li>Materiales : Alta calidad para una durabilidad superior</li>
<li>Textura : Sedosa para una suavidad incomparable</li>
<li>Ajuste : Perfecto para curvas generosas</li>
<li>Temporadas : Ideal para todas las estaciones, especialmente el invierno</li>
<li>Sujeción : Óptima para un confort insuperable</li>
<li>Cuidados : Se recomienda un lavado delicado</li>
</ul> |
| | stylingtips | | string | <p>Estas <strong>medias opacas</strong> son el complemento perfecto para todos tus looks de invierno, gracias a su sofisticación atemporal. Su textura sedosa combina con elegancia con botas altas para crear una silueta chic, o con zapatos de salón para revelar su belleza opaca. Ideales bajo vestidos o faldas cortas, proporcionan protección térmica y realzan tus curvas naturales.</p>
<p>Su ajuste perfecto los convierte en un imprescindible de su armario femenino, manteniéndole a la moda incluso en las épocas más frías, revelando su capacidad para combinar el confort térmico con la sofisticación moderna.</p> |
| | summary | | string | Una pieza rara, especialmente en tallas tan bonitas, que te encantará durante toda la temporada. |
| | title | | string | Medias 60 Den Opacas |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p class="text-base">Ces bas opaques <strong>60 deniers</strong> incarnent l'art de la sophistication hivernale moderne. Confectionnés avec des matériaux de haute qualité, ils répondent parfaitement aux attentes de douceur et d'élégance pour révéler votre allure raffinée tout en vous protégeant des rigueurs du froid.<br><br><strong>Les matériaux de haute qualité</strong> constituent l'innovation technique majeure de ces bas, créant cette sensation de douceur incomparable qui caresse délicatement vos jambes. Cette conception premium garantit une durabilité exceptionnelle qui vous accompagne avec sophistication dans toutes vos activités.<br><br>La densité <strong>60 deniers</strong> offre cette opacité parfaite qui procure chaleur et protection tout en révélant l'élégance de vos jambes. Cette épaisseur idéalement étudiée crée un équilibre harmonieux entre confort thermique et esthétique raffinée, sublimant naturellement vos courbes généreuses.<br><br>La texture soyeuse révolutionne l'expérience tactile en apportant cette douceur luxueuse qui transforme chaque mouvement en moment de bien-être. Cette finition délicate épouse parfaitement les formes, créant cette harmonie entre confort et sophistication qui vous définit.<br><br>L'ajustement parfait témoigne de l'attention portée aux <strong>morphologies généreuses</strong>. Ces bas mettent en valeur vos formes naturelles avec élégance, révélant la beauté unique de vos courbes avec une sophistication moderne qui transcende les saisons.<br><br><strong>Idéaux pour toutes les saisons,</strong> ils sont particulièrement adaptés pour affronter les rigueurs de l'hiver. Cette polyvalence saisonnière vous permet de maintenir votre style raffiné tout au long de l'année, en apportant cette protection thermique supplémentaire lors des périodes froides.<br><br>Le soutien optimal qu'ils procurent épouse délicatement vos courbes généreuses, offrant ce confort inégalable qui vous accompagne du matin au soir. Cette technologie de maintien révèle votre beauté naturelle sans contrainte, créant cette confiance en soi incomparable.<br><br>Un indispensable pour une garde-robe féminine et raffinée qui vous permet de rester chic et tendance en toutes circonstances, révélant votre goût pour la qualité authentique et votre capacité à allier confort et sophistication moderne.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/bas-opaques-grande-taille-60-deniers-hiver-materiaux-haute-qualite/slst0376.htm |
| | highlights | | string | <ul>
<li>Matériaux de haute qualité pour sophistication durable</li>
<li><strong>60 deniers opaques</strong> procurant douceur et chaleur optimales</li>
<li>Texture soyeuse caressant délicatement vos jambes</li>
<li>Ajustement parfait mettant en valeur formes naturelles</li>
<li>Idéaux toutes saisons avec protection hivernale renforcée</li>
<li>Soutien optimal épousant <strong>courbes généreuses</strong></li>
<li>Confort inégalable pour garde-robe féminine raffinée</li>
<li>Indispensable pour rester chic et tendance</li>
</ul> |
| | keypoint | | | keywords | | string | bas opaques, 60 deniers, élégant, confort, thermique, hiver, soyeux, soutien, Diva's Boudoir, lingerie, féminité, grande taille |
| | metas | | Struct | | description | | string | Bas opaques grande taille 60 deniers, matériaux haute qualité, texture soyeuse, ajustement parfait courbes généreuses. Protection hiver chic. Diva's Boudoir. |
| | keywords | | string | bas opaques, 60 deniers, élégant, confort, thermique, hiver, soyeux, soutien, Diva's Boudoir, lingerie, féminité, grande taille |
| | title | | string | Bas Opaques Grande Taille 60 Deniers | Douceur Soyeuse | Diva's Boudoir |
|
| | seotitle | | string | Bas Opaques Grande Taille 60 Deniers Hiver - Matériaux Haute Qualité |
| | seouri | | string | bas-opaques-grande-taille-60-deniers-hiver-materiaux-haute-qualite |
| | specifications | | string | <ul>
<li>Style : Bas opaques sophistication hivernale</li>
<li>Deniers : 60 deniers chaleur et protection optimales</li>
<li>Matériaux : Haute qualité pour durabilité premium</li>
<li>Texture : Soyeuse pour douceur incomparable</li>
<li>Ajustement : Parfait pour courbes généreuses</li>
<li>Saisons : Idéaux toutes saisons, spécialement hiver</li>
<li>Soutien : Optimal pour confort inégalable</li>
<li>Entretien : Lavage délicat recommandé</li>
</ul> |
| | stylingtips | | string | <p>Ces <strong>bas opaques</strong> s'harmonisent parfaitement avec tous vos looks hivernaux grâce à leur sophistication intemporelle. Leur texture soyeuse se marie élégamment avec des bottes hautes pour créer une silhouette chic, ou avec des escarpins pour révéler leur beauté opaque. Idéaux sous des robes ou jupes courtes, ils apportent cette protection thermique tout en mettant en valeur vos formes naturelles.</p>
<p>Leur ajustement parfait en fait l'indispensable de votre garde-robe féminine, vous permettant de rester tendance même par temps froid, révélant votre capacité à allier confort thermique et raffinement moderne avec sophistication assumée.</p> |
| | summary | | string | <p>Rehaussez votre allure avec ces bas opaques <strong>60 deniers</strong> confectionnés avec des matériaux de haute qualité qui procurent sensation de douceur et chaleur.</p>
<p>Leur texture soyeuse et <strong>ajustement parfait</strong> mettent en valeur vos formes naturelles avec sophistication, idéaux pour toutes saisons et particulièrement adaptés aux rigueurs hivernales.</p> |
| | title | | string | Bas Opaques 60 Deniers Hiver - Douceur Soyeuse et Chaleur Sophistiquée |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Realizzate con materiali di alta qualità, queste calze coprenti 60 Den offrono un comfort ineguagliabile e un sostegno ottimale, accentuando con eleganza le vostre curve naturali. </span></p>
<p><span>eleganti in ogni stagione, sono particolarmente adatte ai rigori dell'inverno. </span></p>
<p><span>La loro consistenza setosa e la vestibilità slim vi renderanno chic e alla moda, proteggendovi al tempo stesso dal freddo. </span></p>
<p><span>Abbinateli a un reggicalze per un look ancora più sofisticato che valorizzerà ancora di più le vostre gambe. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/it/calze-coprenti-di-grande-taglia-nero/slst0376.htm |
| | highlights | | string | <ul>
<li>Materiali di alta qualità per una raffinatezza duratura</li>
<li>tessuto<strong>opaco da 60 denari</strong> per una morbidezza e un calore ottimali</li>
<li>La texture setosa accarezza delicatamente le gambe</li>
<li>La perfetta vestibilità esalta le vostre forme naturali</li>
<li>Ideale per tutte le stagioni con una protezione invernale extra</li>
<li>Calze ottimale per <strong>curve generose</strong></li>
<li>Comfort imbattibile per un guardaroba femminile raffinato</li>
<li>Indispensabile per essere sempre chic e alla moda</li>
</ul> |
| | keypoint | | | keywords | | string | calze coprenti, 60 denari, eleganti, comfort, termiche, invernali, setose, calze, Diva's Boudoir, lingerie, femminilità, taglia grande |
| | metas | | Struct | | description | | string | Scoprite le nostre calze Black60 in microfibra opaca ed elasticizzata. Un lusso accessibile per donne alte e formose. Chic tutto l'anno, perfette per l'inverno. È richiesto il reggicalze. |
| | keywords | | string | calze coprenti, 60 denari, eleganti, comfort, termiche, invernali, setose, calze, Diva's Boudoir, lingerie, femminilità, taglia grande |
| | title | | string | Diva's Boudoir : Calze nere Luxurious60 per donne rotonde |
|
| | seotitle | | string | Calze coprenti di grande taglia |
| | seouri | | string | calze-coprenti-di-grande-taglia-nero |
| | specifications | | string | <ul>
<li>Stile: calze coprenti per una raffinatezza invernale</li>
<li>Denari: 60 denari per un calore e una protezione ottimali</li>
<li>Materiali : Alta qualità per una durata superiore</li>
<li>Texture : setosa per una morbidezza incomparabile</li>
<li>Vestibilità : Perfetta per le curve generose: Perfetta per le curve generose</li>
<li>Stagioni : Ideale per tutte le stagioni, soprattutto per l'inverno</li>
<li>Calze : Ottimale per un comfort insuperabile</li>
<li>Cura : Si consiglia un lavaggio delicato</li>
</ul> |
| | stylingtips | | string | <p>Queste <strong>calze coprenti</strong> sono l'abbinamento perfetto per tutti i vostri look invernali, grazie alla loro raffinatezza senza tempo. La loro consistenza setosa si abbina elegantemente agli stivali alti per creare una silhouette chic, o alle décolleté per rivelare la loro bellezza opaca. Ideali sotto abiti o gonne corte, offrono una protezione termica e mettono in risalto le vostre curve naturali.</p>
<p>La loro perfetta vestibilità li rende un must-have del vostro guardaroba femminile, per essere sempre alla moda anche nelle stagioni più fredde, rivelando la vostra capacità di combinare il comfort termico con la raffinatezza moderna.</p> |
| | summary | | string | Un pezzo raro, soprattutto in dimensioni così belle, che amerete per tutta la stagione. |
| | title | | string | Calze 60 Den Opache |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Deze ondoorzichtige 60 Den kousen zijn gemaakt van hoogwaardige materialen en bieden ongeëvenaard comfort en optimale ondersteuning, terwijl ze je natuurlijke rondingen elegant accentueren. </span></p>
<p><span>ze zijn elegant in elk seizoen en bijzonder geschikt voor de strenge winter. </span></p>
<p><span>De zijdeachtige textuur en slanke pasvorm houden je chic en trendy, terwijl ze je beschermen tegen de kou. </span></p>
<p><span>Combineer ze met een jarretelgordel voor een nog geraffineerdere look die je benen nog meer tot hun recht laat komen. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/nl/grote-maat-ondoorzichtige-kousen-zwart/slst0376.htm |
| | highlights | | string | <ul>
<li>Hoogwaardige materialen voor blijvend raffinement</li>
<li><strong>60 denier ondoorzichtige</strong> stof voor optimale zachtheid en warmte</li>
<li>Zijdeachtige textuur streelt zachtjes je benen</li>
<li>Perfecte pasvorm verbetert je natuurlijke vorm</li>
<li>Ideaal voor alle seizoenen met extra winterbescherming</li>
<li>Optimale <strong>bh</strong> voor <strong>royale rondingen</strong></li>
<li>Onovertroffen comfort voor verfijnde damesgarderobes</li>
<li>Onmisbaar om chic en trendy te blijven</li>
</ul> |
| | keypoint | | | keywords | | string | ondoorzichtige kousen, 60 denier, elegant, comfort, thermisch, winter, zijdeachtig, bh, Diva's Boudoir, lingerie, vrouwelijkheid, grote maat |
| | metas | | Struct | | description | | string | Ontdek onze black60 kousen van ondoorzichtige, elastische microvezel. Betaalbare luxe voor lange, ronde vrouwen. Chic het hele jaar door, perfect voor de winter. Jarretelgordel vereist. |
| | keywords | | string | ondoorzichtige kousen, 60 denier, elegant, comfort, thermisch, winter, zijdeachtig, bh, Diva's Boudoir, lingerie, vrouwelijkheid, grote maat |
| | title | | string | Diva's Boudoir : Luxe60 zwarte kousen voor ronde vrouwen |
|
| | seotitle | | string | Grote maat ondoorzichtige kousen |
| | seouri | | string | grote-maat-ondoorzichtige-kousen-zwart |
| | specifications | | string | <ul>
<li>Stijl: Ondoorzichtige kousen voor winterse verfijning</li>
<li>Denier: 60 denier voor optimale warmte en bescherming</li>
<li>Materialen : Hoge kwaliteit voor duurzaamheid</li>
<li>Textuur : Zijdeachtig voor onvergelijkbare zachtheid</li>
<li>Pasvorm : Perfect voor royale rondingen</li>
<li>Seizoenen : Ideaal voor alle seizoenen, vooral de winter</li>
<li>Bh: Optimaal voor onovertroffen comfort</li>
<li>Onderhoud: Fijne was aanbevolen</li>
</ul> |
| | stylingtips | | string | <p>Deze <strong>ondoorzichtige kousen</strong> passen perfect bij al je winterse looks dankzij hun tijdloze verfijning. Hun zijdeachtige textuur combineert elegant met hoge laarzen om een chique silhouet te creëren, of met pumps om hun ondoorzichtige schoonheid te onthullen. Ze zijn ideaal voor onder jurken of korte rokjes en bieden die thermische bescherming terwijl ze je natuurlijke rondingen accentueren.</p>
<p>Door hun perfecte pasvorm zijn ze een must-have voor je damesgarderobe. Ze houden je zelfs bij het koudste weer trendy en laten zien dat je thermisch comfort kunt combineren met moderne verfijning.</p> |
| | summary | | string | Een zeldzaam stuk, vooral in zulke mooie maten, waar je het hele seizoen van zult houden. |
| | title | | string | Kousen 60 Den Opaak |
| | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p><span>Fabricadas com materiais de alta qualidade, estas meias opacas 60 Den oferecem um conforto inigualável e um apoio ótimo, acentuando elegantemente as suas curvas naturais. </span></p>
<p><span>elegantes em qualquer estação, são particularmente adequadas para o rigor do inverno. </span></p>
<p><span>A sua textura sedosa e o seu ajuste fino vão mantê-la chique e na moda, enquanto a protegem do frio. </span></p>
<p><span>Combine-as com um cinto de ligas para um look ainda mais sofisticado que irá realçar ainda mais as suas pernas. </span></p> |
| | guid | | string | https://dev.divasboudoir.com/pt/meias-opacas-de-tamanho-grande-preto/slst0376.htm |
| | highlights | | string | <ul>
<li>Materiais de alta qualidade para uma sofisticação duradoura</li>
<li>tecido<strong>opaco de 60 deniers</strong> para uma suavidade e um calor óptimos</li>
<li>A textura sedosa acaricia suavemente as suas pernas</li>
<li>O ajuste perfeito realça a sua forma natural</li>
<li>Ideal para todas as estações com proteção extra no inverno</li>
<li>Apoio ótimo para <strong>curvas generosas</strong></li>
<li>Conforto imbatível para um guarda-roupa de mulher requintado</li>
<li>Indispensável para se manter chique e na moda</li>
</ul> |
| | keypoint | | | keywords | | string | meias opacas, 60 denier, elegante, conforto, térmicas, inverno, sedosas, suporte, Diva's Boudoir, lingerie, feminilidade, tamanho grande |
| | metas | | Struct | | description | | string | Descubra as nossas meias black60 em microfibra opaca e elástica. Um luxo económico para as mulheres altas e com curvas. Chiques durante todo o ano, perfeitas para o inverno. Necessário cinto de ligas. |
| | keywords | | string | meias opacas, 60 denier, elegante, conforto, térmicas, inverno, sedosas, suporte, Diva's Boudoir, lingerie, feminilidade, tamanho grande |
| | title | | string | Boudoir de Diva : Meias de ligas pretas Luxurious60 para mulheres redondas |
|
| | seotitle | | string | Meias opacas de tamanho grande |
| | seouri | | string | meias-opacas-de-tamanho-grande-preto |
| | specifications | | string | <ul>
<li>Estilo : Meias opacas para uma sofisticação invernal</li>
<li>Denier: 60 denier para um calor e uma proteção óptimos</li>
<li>Materiais : De alta qualidade para uma durabilidade de primeira qualidade</li>
<li>Textura : Sedosa para uma suavidade incomparável</li>
<li>Ajuste : Perfeito para curvas generosas: Perfeito para curvas generosas</li>
<li>Estações : Ideal para todas as estações, especialmente o inverno</li>
<li>Apoio: Ótimo para um conforto inigualável</li>
<li>Cuidados : Recomenda-se uma lavagem delicada</li>
</ul> |
| | stylingtips | | string | <p>Estas <strong>meias opacas</strong> são a combinação perfeita para todos os seus looks de inverno, graças à sua sofisticação intemporal. A sua textura sedosa combina elegantemente com botas altas para criar uma silhueta chique, ou com sapatos de salto alto para revelar a sua beleza opaca. Ideais por baixo de vestidos ou saias curtas, proporcionam essa proteção térmica ao mesmo tempo que realçam as suas curvas naturais.</p>
<p>O seu ajuste perfeito torna-as imprescindíveis no seu guarda-roupa de mulher, mantendo-a na moda mesmo no tempo mais frio, revelando a sua capacidade de combinar conforto térmico com sofisticação moderna.</p> |
| | summary | | string | Uma peça rara, especialmente em tamanhos tão bonitos, que vai adorar durante toda a estação. |
| | title | | string | Meias 60 Den Opaques |
| | usageinstructions | |
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Diese blickdichten 60 Den Strümpfe sind aus hochwertigen Materialien gefertigt und bieten außergewöhnlichen Tragekomfort und optimalen BH, während sie Ihre natürlichen Formen elegant betonen.</p>
<p>Sie sind das ganze Jahr über elegant und besonders geeignet, um den harten Winter zu überstehen.</p>
<p>Ihre seidige Textur und die perfekte Passform sorgen dafür, dass Sie schick und modisch aussehen und sich gleichzeitig vor der Kälte schützen.</p> |
| | highlights | | string | <ul>
<li>eleganz und optimaler Komfort für das tägliche Wohlbefinden</li>
<li><strong>Hochwertige Materialien</strong> garantieren außergewöhnliche Haltbarkeit</li>
<li>blickdichte<strong>60 Denier</strong> für Schutz und zeitlosen Stil</li>
<li>Unvergleichliches Wohlgefühl den ganzen Tag lang</li>
<li>Seidige Textur umschmeichelt sanft Ihre Beine</li>
<li>Perfekte Passform, die <strong>natürliche Formen</strong> hervorhebt</li>
<li>Perfekt für alle Jahreszeiten mit erhöhtem Winterschutz</li>
<li>Optimaler BH für jede Körperform</li>
</ul> |
| | keypoint | | | keywords | | string | blickdichte Strümpfe, große Größe, 60 Denier, Komfort, Winter, Unterstützung, elegant, seidig, Leg's Boudoir, geformte Beine, alle Größen |
| | metas | | Struct | | description | | string | Entdecken Sie unsere blickdichten Strümpfe 60 Den: außergewöhnlicher Komfort und zeitlose Eleganz. Hochwertige Materialien für optimalen BH. Perfekt im Winter und im Sommer. Chic garantiert! |
| | keywords | | string | blickdichte Strümpfe, große Größe, 60 Denier, Komfort, Winter, Unterstützung, elegant, seidig, Leg's Boudoir, geformte Beine, alle Größen |
| | title | | string | Opake Strümpfe 60 Den - Kostenlose Express-Lieferung |
|
| | seotitle | | string | Strümpfe große Größe blickdicht 60 Den |
| | seouri | | string | strumpfe-grosse-grosse-blickdicht-60-den-schwarz |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Diese blickdichten Strümpfe passen dank ihrer <strong> zeitlosen Eleganz</strong> perfekt zu all Ihren Looks. Ihre seidige Textur lässt sich elegant mit hohen Stiefeln kombinieren, um eine schicke Silhouette zu kreieren, oder mit Pumps, um ihre blickdichte Schönheit zu enthüllen.</p>
<p><strong>Ideal unter Kleidern oder Röcken</strong>, bieten sie diesen Wärmeschutz und betonen gleichzeitig Ihre natürlichen Formen auf stilvolle Weise. Ihre perfekte Passform macht sie zu einem unverzichtbaren Bestandteil Ihrer Garderobe, mit dem Sie auch bei kaltem Wetter modisch aussehen und Ihre Fähigkeit unter Beweis stellen, Wärmekomfort und moderne Raffinesse mit Eleganz zu verbinden, die für alle Körperformen zugänglich ist.</p> |
| | summary | | string | Ein seltenes Stück, vor allem in so schönen Größen, das Sie gerne zu all Ihren Outfits tragen werden. |
| | title | | string | Opake Strümpfe 60 Denier |
| | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Αυτές οι αδιαφανείς κάλτσες 60 Den είναι κατασκευασμένες από υλικά υψηλής ποιότητας, προσφέροντας εξαιρετική άνεση και βέλτιστη στήριξη, ενώ παράλληλα ενισχύουν κομψά το φυσικό σας σχήμα.</p>
<p>Φαίνονται υπέροχες όλο το χρόνο και είναι ιδιαίτερα κατάλληλες για τις δύσκολες συνθήκες του χειμώνα.</p>
<p>Η μεταξένια υφή τους και η τέλεια εφαρμογή τους θα σας διατηρήσουν κομψή και μοντέρνα, ενώ παράλληλα θα σας προστατεύουν από το κρύο.</p> |
| | highlights | | string | <ul>
<li>κομψότητα και βέλτιστη άνεση για καθημερινή ευεξία</li>
<li><strong>Υλικά υψηλής ποιότητας</strong> για εξαιρετική ανθεκτικότητα</li>
<li>αδιαφανή<strong>60 denier</strong> για προστασία και διαχρονικό στυλ</li>
<li>Ασυναγώνιστη αίσθηση ευεξίας όλη την ημέρα</li>
<li>Μεταξένια υφή που χαϊδεύει απαλά τα πόδια σας</li>
<li>Η τέλεια εφαρμογή ενισχύει <strong>το φυσικό σας σχήμα</strong></li>
<li>Ιδανικό για όλες τις εποχές με επιπλέον προστασία το χειμώνα</li>
<li>Βέλτιστη στήριξη για όλα τα σχήματα σώματος</li>
</ul> |
| | keypoint | | | keywords | | string | αδιαφανείς κάλτσες, μεγάλες, 60 denier, άνεση, χειμώνας, υποστήριξη, κομψές, μεταξένιες, Leg's Boudoir, καλλίγραμμα πόδια, όλα τα μεγέθη |
| | metas | | Struct | | description | | string | Ανακαλύψτε τις αδιαφανείς κάλτσες 60 Den: εξαιρετική άνεση και διαχρονική κομψότητα. Υλικά υψηλής ποιότητας για βέλτιστη στήριξη. Ιδανικές για χειμώνα και καλοκαίρι. Εγγυημένη κομψότητα! |
| | keywords | | string | αδιαφανείς κάλτσες, μεγάλες, 60 denier, άνεση, χειμώνας, υποστήριξη, κομψές, μεταξένιες, Leg's Boudoir, καλλίγραμμα πόδια, όλα τα μεγέθη |
| | title | | string | 60 Den αδιαφανείς κάλτσες - Δωρεάν υπηρεσία express delivery |
|
| | seotitle | | string | Μεγάλο μέγεθος αδιαφανείς κάλτσες 60 Den |
| | seouri | | string | megalo-megethos-adiafaneis-kaltses-60-den-mayro |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Αυτές οι αδιαφανείς κάλτσες είναι μια <strong> διαχρονικά κομψή</strong> προσθήκη σε κάθε εμφάνιση. Η μεταξένια υφή τους συνδυάζεται κομψά με ψηλές μπότες για να δημιουργήσει μια κομψή σιλουέτα ή με γόβες για να αποκαλύψει την αδιαφανή ομορφιά τους.</p>
<p><strong>Ιδανικές κάτω από φορέματα ή φούστες</strong>, παρέχουν θερμική προστασία ενώ αναδεικνύουν τις φυσικές σας καμπύλες με στυλ. Η τέλεια εφαρμογή τους τα καθιστά απαραίτητα για την γκαρνταρόμπα σας, επιτρέποντάς σας να παραμείνετε στην τάση ακόμη και με κρύο καιρό, αποκαλύπτοντας την ικανότητά σας να συνδυάζετε τη θερμική άνεση και τη σύγχρονη φινέτσα με κομψότητα προσιτή σε όλους τους σωματότυπους.</p> |
| | summary | | string | Ένα σπάνιο κομμάτι, ειδικά σε τόσο όμορφα μεγέθη, που θα σας αρέσει να φοράτε με όλα σας τα ρούχα. |
| | title | | string | 60 Denier αδιαφανείς κάλτσες |
| | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>These 60 Den opaque stockings are made from high-quality materials, offering exceptional comfort and optimum bra, while elegantly enhancing your natural curves.</p>
<p>They're elegant all year round, especially suited to face the rigors of winter.</p>
<p>Their silky texture and perfect fit will keep you chic and fashionable, while protecting you from the cold.</p> |
| | highlights | | string | <ul>
<li>elegance and optimum comfort for everyday well-being</li>
<li><strong>High-quality materials</strong> for exceptional durability</li>
<li><strong>60 denier</strong> opaques for protection and timeless style</li>
<li>Unbeatable feeling of well-being all day long</li>
<li>Silky texture gently caresses your legs</li>
<li>Perfect fit enhances <strong>your natural shape</strong></li>
<li>All-season perfection with reinforced winter protection</li>
<li>Optimum bra for every body type</li>
</ul> |
| | keypoint | | | keywords | | string | opaque stockings, plus size, 60 denier, comfort, winter, bra, elegant, silky, Leg's Boudoir, shapely legs, all sizes |
| | metas | | Struct | | description | | string | Discover our 60 Den opaque stockings: exceptional comfort and timeless elegance. High-quality materials for optimum bra. Perfect for winter and summer. Chic guaranteed! |
| | keywords | | string | opaque stockings, plus size, 60 denier, comfort, winter, bra, elegant, silky, Leg's Boudoir, shapely legs, all sizes |
| | title | | string | 60 Den opaque stockings - Free express delivery |
|
| | seotitle | | string | Opaque plus size stockings 60 Den |
| | seouri | | string | opaque-plus-size-stockings-60-den-black |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>These opaque stockings blend perfectly with all your looks thanks to their <strong> timeless elegance</strong>. Their silky texture pairs elegantly with tall boots to create a chic silhouette, or with pumps to reveal their opaque beauty.</p>
<p><strong>Ideal under dresses or skirts</strong>, they provide that thermal protection while enhancing your natural curves with style. Their perfect fit makes them a wardrobe essential, allowing you to stay on trend even in cold weather, revealing your ability to combine thermal comfort and modern refinement with elegance accessible to all body types.</p> |
| | summary | | string | A rare piece, especially in such beautiful sizes, that you'll love wearing with all your outfits. |
| | title | | string | 60 Denier Opaque Stockings |
| | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Estas medias opacas 60 Den están confeccionadas con materiales de alta calidad y ofrecen una comodidad excepcional y un sujetador óptimo, al tiempo que realzan con elegancia su silueta natural.</p>
<p>Perfectas para todo el año, son especialmente adecuadas para los rigores del invierno.</p>
<p>Su textura sedosa y su ajuste perfecto le permitirán estar a la moda y protegida del frío.</p> |
| | highlights | | string | <ul>
<li>elegancia y comodidad óptimas para el bienestar diario</li>
<li><strong>Materiales de alta calidad</strong> para una durabilidad excepcional</li>
<li>opacos<strong>de 60 deniers</strong> para una protección y un estilo atemporales</li>
<li>Inmejorable sensación de bienestar durante todo el día</li>
<li>Textura sedosa que acaricia suavemente las piernas</li>
<li>El ajuste perfecto realza <strong>su forma natural</strong></li>
<li>Perfecto para todas las estaciones con protección extra en invierno</li>
<li>Sujeción óptima para todas las formas del cuerpo</li>
</ul> |
| | keypoint | | | keywords | | string | medias opacas, talla grande, 60 deniers, comodidad, invierno, sujetador, elegante, sedoso, Leg's Boudoir, piernas torneadas, todas las tallas |
| | metas | | Struct | | description | | string | Descubra nuestras medias opacas 60 Den: comodidad excepcional y elegancia atemporal. Materiales de alta calidad para un sujetador óptimo. Perfectas tanto en invierno como en verano. ¡Chic garantizado! |
| | keywords | | string | medias opacas, talla grande, 60 deniers, comodidad, invierno, sujetador, elegante, sedoso, Leg's Boudoir, piernas torneadas, todas las tallas |
| | title | | string | 60 Den medias opacas - Envío exprés gratuito |
|
| | seotitle | | string | Medias opacas de talla grande 60 Den |
| | seouri | | string | medias-opacas-de-talla-grande-60-den-negro |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Estas medias opacas son un complemento <strong> elegante y atemporal</strong> para cualquier look. Su textura sedosa combina con elegancia con botas altas para crear una silueta chic, o con zapatos de salón para revelar su belleza opaca.</p>
<p><strong>Ideales para llevar debajo de vestidos o faldas</strong>, ofrecen protección térmica y permiten lucir con estilo las curvas naturales. Su ajuste perfecto las convierte en un básico de vestuario, que le permitirá seguir a la moda incluso cuando haga frío, revelando su capacidad para combinar el confort térmico y el refinamiento moderno con una elegancia accesible a todos los tipos de cuerpo.</p> |
| | summary | | string | Una pieza rara, sobre todo en tallas tan bonitas, que te encantará llevar con todos tus conjuntos. |
| | title | | string | Medias opacas de 60 deniers |
| | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p class="text-base">Ces <strong>bas opaques 60 deniers</strong> incarnent l'art de l'élégance moderne alliée au confort optimal. Fabriqués avec des matériaux de haute qualité, ils répondent parfaitement aux attentes de style et de bien-être pour révéler votre beauté naturelle tout en vous protégeant efficacement du froid.<br><br>L'élégance et le confort constituent l'essence même de ces bas, créant cette harmonie parfaite entre esthétique raffinée et sensation de bien-être inégalable. Cette philosophie du style accessible vous accompagne avec sophistication dans toutes vos activités quotidiennes.<br><br>Les <strong>matériaux de haute qualité</strong> témoignent de l'engagement pour l'excellence technique. Cette conception premium garantit une durabilité exceptionnelle qui résiste aux lavages répétés tout en conservant cette douceur incomparable qui caractérise le véritable confort.<br><br>La <strong>densité 60 deniers</strong> offre cette opacité parfaite qui procure protection thermique et style intemporel. Cette épaisseur idéalement étudiée crée un équilibre harmonieux entre confort hivernal et esthétique raffinée, sublimant naturellement la beauté de vos jambes.<br><br>La texture soyeuse révolutionne l'expérience tactile en apportant cette douceur luxueuse qui transforme chaque mouvement en moment de bien-être. Cette finition délicate épouse parfaitement toutes les morphologies, créant cette sensation agréable qui vous accompagne du matin au soir.<br><br>L'ajustement parfait témoigne de l'attention portée à la <strong>diversité des silhouettes</strong>. Ces bas mettent en valeur vos <strong>formes naturelles</strong> avec style, révélant la beauté unique de chaque morphologie avec une élégance moderne qui transcende les standards.<br><br><strong>Parfaits pour toutes les saisons</strong>, ils sont particulièrement adaptés pour affronter les rigueurs de l'hiver. Cette polyvalence saisonnière vous permet de maintenir votre style chic et tendance tout au long de l'année, en apportant cette protection thermique supplémentaire lors des périodes froides.<br><br>Conçus pour un confort optimal, ils offrent ce soutien tout au long de la journée qui s'adapte harmonieusement à toutes les morphologies. Cette technologie de maintien révèle votre confiance naturelle sans contrainte, créant cette assurance qui vous définit.<br><br>Spécialement pensés pour s'adapter à toutes les silhouettes, ils subliment vos jambes et vous font sentir belle et confiante, révélant votre goût pour la qualité authentique et votre capacité à allier confort et élégance moderne.</p> |
| | highlights | | string | <ul>
<li>Élégance et confort optimal pour bien-être quotidien</li>
<li><strong>Matériaux de haute qualité</strong> garantissant durabilité exceptionnelle</li>
<li><strong>60 deniers</strong> opaques pour protection et style intemporel</li>
<li>Sensation de bien-être inégalable tout au long de la journée</li>
<li>Texture soyeuse caressant délicatement vos jambes</li>
<li>Ajustement parfait mettant en valeur <strong>formes naturelles</strong></li>
<li>Parfaits toutes saisons avec protection hivernale renforcée</li>
<li>Soutien optimal s'adaptant à toutes les morphologies</li>
</ul> |
| | keypoint | | | keywords | | string | bas opaques, grande taille, 60 deniers, confort, hiver, soutien, élégant, soyeux, Leg's Boudoir, jambes galbées, toutes tailles |
| | metas | | Struct | | description | | string | Bas opaques 60 deniers élégance, matériaux haute qualité, texture soyeuse, ajustement parfait toutes morphologies. Confort optimal hiver. Leg's Boudoir. |
| | keywords | | string | bas opaques, grande taille, 60 deniers, confort, hiver, soutien, élégant, soyeux, Leg's Boudoir, jambes galbées, toutes tailles |
| | title | | string | Bas Opaques 60 Deniers Élégance | Confort Optimal Hiver | Leg's Boudoir |
|
| | seotitle | | string | Bas Opaques 60 Deniers Élégance Hiver - Matériaux Haute Qualité Confort |
| | seouri | | string | bas-opaques-60-deniers-elegance-hiver-materiaux-haute-qualite-confort |
| | specifications | | string | <div style="text-align: justify;">
<ul>
<li>Style : Bas opaques élégance intemporelle</li>
<li>Deniers : 60 deniers protection et confort optimal</li>
<li>Matériaux : Haute qualité pour durabilité premium</li>
<li>Texture : Soyeuse pour bien-être inégalable</li>
<li>Ajustement : Parfait pour toutes les morphologies</li>
<li>Saisons : Idéaux toutes saisons, spécialement hiver</li>
<li>Soutien : Optimal pour confort quotidien</li>
<li>Entretien : Lavage délicat recommandé</li>
</ul>
</div> |
| | stylingtips | | string | <p>Ces bas opaques s'harmonisent parfaitement avec tous vos looks grâce à leur <strong>élégance intemporelle</strong>. Leur texture soyeuse se marie élégamment avec des bottes hautes pour créer une silhouette chic, ou avec des escarpins pour révéler leur beauté opaque.</p>
<p><strong>Idéaux sous des robes ou jupes</strong>, ils apportent cette protection thermique tout en mettant en valeur vos formes naturelles avec style. Leur ajustement parfait en fait l'indispensable de votre garde-robe, vous permettant de rester tendance même par temps froid, révélant votre capacité à allier confort thermique et raffinement moderne avec élégance accessible à toutes les morphologies.</p> |
| | summary | | string | <p>Optez pour l'élégance et le confort avec ces bas opaques <strong>60 deniers </strong>fabriqués avec des matériaux de haute qualité.</p>
<p>Ils offrent une sensation de bien-être inégalable tout en <strong>mettant en valeur vos formes naturelles avec style.</strong></p>
<p>Parfaits pour toutes saisons et spécialement adaptés aux rigueurs hivernales, leur texture soyeuse et ajustement parfait vous permettent de rester chic et tendance.</p> |
| | title | | string | Bas Opaques 60 Deniers Élégance - Confort Optimal et Style Intemporel |
| | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Queste calze coprenti 60 Den sono realizzate con materiali di alta qualità e offrono un comfort eccezionale e un calze ottimale, valorizzando con eleganza la vostra forma naturale.</p>
<p>Sono belle tutto l'anno e particolarmente adatte ai rigori dell'inverno.</p>
<p>La loro consistenza setosa e la perfetta vestibilità vi renderanno chic e alla moda, proteggendovi al tempo stesso dal freddo.</p> |
| | highlights | | string | <ul>
<li>eleganza e comfort ottimale per il benessere quotidiano</li>
<li><strong>Materiali di alta qualità</strong> per una durata eccezionale</li>
<li>opachi<strong>da 60 denari</strong> per una protezione e uno stile senza tempo</li>
<li>Sensazione di benessere imbattibile per tutto il giorno</li>
<li>La texture setosa accarezza delicatamente le gambe</li>
<li>La perfetta vestibilità esalta <strong>le vostre forme naturali</strong></li>
<li>Perfetti per tutte le stagioni con una protezione invernale extra</li>
<li>Calze ottimale per tutte le forme del corpo</li>
</ul> |
| | keypoint | | | keywords | | string | calze coprenti, taglia grande, 60 denari, comfort, inverno, calze, eleganti, setose, Leg's Boudoir, gambe formose, tutte le taglie |
| | metas | | Struct | | description | | string | Scoprite le nostre calze coprenti 60 Den: comfort eccezionale ed eleganza senza tempo. Materiali di alta qualità per un calze ottimale. Perfette in inverno e in estate. Chic garantito! |
| | keywords | | string | calze coprenti, taglia grande, 60 denari, comfort, inverno, calze, eleganti, setose, Leg's Boudoir, gambe formose, tutte le taglie |
| | title | | string | 60 Den calze coprenti - Consegna rapida gratuita |
|
| | seotitle | | string | Calze coprenti di grande taglia 60 Den |
| | seouri | | string | calze-coprenti-di-grande-taglia-60-den-nero |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Queste calze coprenti sono un'aggiunta <strong> elegante e senza tempo</strong> a qualsiasi look. La loro consistenza setosa si abbina elegantemente agli stivali alti per creare una silhouette chic, o alle décolleté per rivelare la loro bellezza opaca.</p>
<p><strong>Ideali sotto abiti o gonne</strong>, offrono protezione termica e al tempo stesso mettono in mostra le vostre curve naturali con stile. La loro perfetta vestibilità li rende un capo essenziale del guardaroba, che vi permette di essere sempre alla moda anche nella stagione fredda, rivelando la vostra capacità di combinare comfort termico e raffinatezza moderna con un'eleganza accessibile a tutti i tipi di corpo.</p> |
| | summary | | string | Un pezzo raro, soprattutto in dimensioni così belle, che vi piacerà indossare con tutti i vostri outfit. |
| | title | | string | Calze coprenti 60 denari |
| | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Deze 60 Den ondoorzichtige kousen zijn gemaakt van hoogwaardige materialen en bieden uitzonderlijk comfort en optimale bh, terwijl ze je natuurlijke vorm elegant accentueren.</p>
<p>Ze zien er het hele jaar door geweldig uit en zijn bijzonder geschikt voor de strenge winter.</p>
<p>De zijdeachtige textuur en perfecte pasvorm houden je chic en modieus, terwijl ze je beschermen tegen de kou.</p> |
| | highlights | | string | <ul>
<li>elegantie en optimaal comfort voor dagelijks welzijn</li>
<li><strong>Hoogwaardige materialen</strong> voor uitzonderlijke duurzaamheid</li>
<li><strong>60 denier</strong> opaak voor bescherming en tijdloze stijl</li>
<li>De hele dag door een onovertroffen gevoel van welzijn</li>
<li>Zijdezachte textuur streelt zacht je benen</li>
<li>Perfecte pasvorm verbetert <strong>je natuurlijke vorm</strong></li>
<li>Perfect voor alle seizoenen met extra winterbescherming</li>
<li>Optimale bh voor alle lichaamsvormen</li>
</ul> |
| | keypoint | | | keywords | | string | ondoorzichtige kousen, grote maat, 60 denier, comfort, winter, bh, elegant, zijdeachtig, Leg's Boudoir, mooie benen, alle maten |
| | metas | | Struct | | description | | string | Ontdek onze 60 Den ondoorzichtige kousen: uitzonderlijk comfort en tijdloze elegantie. Hoogwaardige materialen voor optimale bh. Perfect in winter en zomer. Chic gegarandeerd! |
| | keywords | | string | ondoorzichtige kousen, grote maat, 60 denier, comfort, winter, bh, elegant, zijdeachtig, Leg's Boudoir, mooie benen, alle maten |
| | title | | string | 60 Den ondoorzichtige kousen - Gratis expreslevering |
|
| | seotitle | | string | Grote maat ondoorzichtige kousen 60 Den |
| | seouri | | string | grote-maat-ondoorzichtige-kousen-60-den-zwart |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Deze ondoorzichtige kousen zijn een <strong> tijdloos elegante</strong> toevoeging aan elke look. Hun zijdeachtige textuur combineert elegant met hoge laarzen om een chique silhouet te creëren, of met pumps om hun ondoorzichtige schoonheid te onthullen.</p>
<p>Ze zijn<strong>ideaal voor onder jurken of rokken</strong> en bieden thermische bescherming terwijl ze je natuurlijke rondingen in stijl laten zien. Door hun perfecte pasvorm zijn ze onmisbaar in je garderobe, zodat je zelfs bij koud weer trendy blijft en je thermisch comfort en moderne verfijning kunt combineren met elegantie die voor elk lichaamstype toegankelijk is.</p> |
| | summary | | string | Een zeldzaam stuk, vooral in zulke mooie maten, dat je graag bij al je outfits zult dragen. |
| | title | | string | 60 Denier Opaque Kousen |
| | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Estas meias opacas 60 Den são fabricadas com materiais de alta qualidade, oferecendo um conforto excecional e um apoio ótimo, ao mesmo tempo que realçam elegantemente a sua forma natural.</p>
<p>São óptimas durante todo o ano e particularmente adaptadas aos rigores do inverno.</p>
<p>A sua textura sedosa e o seu ajuste perfeito vão mantê-la chique e na moda, ao mesmo tempo que a protegem do frio.</p> |
| | highlights | | string | <ul>
<li>elegância e conforto ideal para o bem-estar quotidiano</li>
<li><strong>Materiais de alta qualidade</strong> para uma durabilidade excecional</li>
<li>opacos<strong>de 60 denier</strong> para uma proteção e um estilo intemporal</li>
<li>Sensação imbatível de bem-estar durante todo o dia</li>
<li>A textura sedosa acaricia suavemente as suas pernas</li>
<li>O ajuste perfeito realça <strong>a sua forma natural</strong></li>
<li>Perfeita para todas as estações com proteção extra no inverno</li>
<li>Suporte ótimo para todas as formas do corpo</li>
</ul> |
| | keypoint | | | keywords | | string | meias opacas, grandes, 60 denier, conforto, inverno, suporte, elegantes, sedosas, Leg's Boudoir, pernas torneadas, todos os tamanhos |
| | metas | | Struct | | description | | string | Descubra as nossas meias opacas 60 Den: conforto excecional e elegância intemporal. Materiais de alta qualidade para um apoio ótimo. Perfeitas no inverno e no verão. Chique garantido! |
| | keywords | | string | meias opacas, grandes, 60 denier, conforto, inverno, suporte, elegantes, sedosas, Leg's Boudoir, pernas torneadas, todos os tamanhos |
| | title | | string | 60 meias opacas Den - Entrega expressa gratuita |
|
| | seotitle | | string | Meias opacas de tamanho grande 60 Den |
| | seouri | | string | meias-opacas-de-tamanho-grande-60-den-preto |
| | specifications | | string | <div style="text-align: justify;"></div> |
| | stylingtips | | string | <p>Estas meias opacas são uma adição <strong> elegante e intemporal</strong> a qualquer visual. A sua textura sedosa combina elegantemente com botas altas para criar uma silhueta chique, ou com sapatos de salto alto para revelar a sua beleza opaca.</p>
<p><strong>Ideais para usar por baixo de vestidos ou saias</strong>, proporcionam proteção térmica enquanto mostram as suas curvas naturais com estilo. O seu ajuste perfeito torna-as essenciais no guarda-roupa, permitindo-lhe manter-se na moda mesmo com tempo frio, revelando a sua capacidade de combinar o conforto térmico e o requinte moderno com uma elegância acessível a todos os tipos de corpo.</p> |
| | summary | | string | Uma peça rara, sobretudo em tamanhos tão bonitos, que vai adorar usar com todos os seus conjuntos. |
| | title | | string | Meias opacas de 60 denier |
| | usageinstructions | |
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | 6BCF32BA-0872-461A-B189CD544CB925A7 |
|
| promountil | |
| rating | |
| recorduid | | string | 6BCF32BA-0872-461A-B189CD544CB925A7 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.83 ms Record Count: 7 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,'1039,1040,1041,1042,1043,1044,1150') > 0 and product_variations.productuid = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 | 1039 | 4 | intlsize | black | 4 | 4 | -1 | 999999 | 0 | w | plus | stocking | 4-M | 4 | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | | | | | | 49-55 | | | | | 2 | 1040 | 5 | intlsize | black | 5 | 5 | -1 | 999999 | 1 | w | plus | stocking | 5-L | 5 | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | | | | | | 56-62 | | | | | 3 | 1041 | 6 | intlsize | black | 6 | 6 | -1 | 999999 | 1 | w | plus | stocking | 6-XL | 6 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | | | | | | 62-69 | | | | | 4 | 1042 | 7 | intlsize | black | 7 | 7 | -1 | 999999 | 1 | w | plus | stocking | 7-2XL | 7 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | | | | | | 69-76 | | | | | 5 | 1043 | 8 | intlsize | black | 8 | 8 | -1 | 999999 | 0 | w | plus | stocking | 8-3XL | 8 | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | | | | | | 76-83 | | | | | 6 | 1044 | 9 | intlsize | black | 9 | 9 | -1 | 999999 | 0 | w | plus | stocking | 9-4XL | 9 | | 52-54 | 22-24 | 26-28 | 54-56 | 54-56 | 52-54 | 58-60 | 54-56 | 52-54 | | | | | | 83-89 | | | | | 7 | 1150 | 10 | intlsize | black | 10 | 10 | -1 | 999999 | 0 | w | plus | stocking | 9-4XL | 10 | | 54-56 | 24-26 | 28-30 | 56-58 | 56-58 | 54-56 | 60-62 | 54-58 | 54-56 | | | | | | 89-96 | | | |
|
| sizeranges | |
| sizes | | string | 1039,1040,1041,1042,1043,1044,1150 |
|
| 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: 10.5 ms Record Count: 6 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1039 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1040 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1041 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1042 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1043 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1044 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1150 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 | 6BCF32BA-0872-461A-B189CD544CB925A7 | F870AB31-A083-476E-AB033C19B41A34B5 | 1039 | black | #000000 | 4-M | 4 | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | stocking | | 4 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 50136 | | -1 | 0 | all | | | 2 | 6BCF32BA-0872-461A-B189CD544CB925A7 | 88E1C271-C3D9-4C42-8BB20E2F47FFD393 | 1040 | black | #000000 | 5-L | 5 | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | stocking | | 5 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132903 | 1 | 1 | all | | | 3 | 6BCF32BA-0872-461A-B189CD544CB925A7 | 88D65C8C-9ED5-4BA5-AD63DC60C7355763 | 1041 | black | #000000 | 6-XL | 6 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | stocking | | 6 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132910 | 1 | 1 | all | | | 4 | 6BCF32BA-0872-461A-B189CD544CB925A7 | 202E5B87-D3BF-4A40-9AC0178518821416 | 1042 | black | #000000 | 7-2XL | 7 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | stocking | | 7 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132927 | 1 | 1 | all | | | 5 | 6BCF32BA-0872-461A-B189CD544CB925A7 | 80731322-8F41-4DAD-85D0949DFF18DFDA | 1043 | black | #000000 | 8-3XL | 8 | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | stocking | | 8 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277134709 | -1 | 0 | all | | | 6 | 6BCF32BA-0872-461A-B189CD544CB925A7 | 78BA2246-8C15-4D3E-93C8DDF873909E89 | 1044 | black | #000000 | 9-4XL | 9 | | 52-54 | 22-24 | 26-28 | 54-56 | 54-56 | 52-54 | 58-60 | 54-56 | 52-54 | w | stocking | | 9 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 3 | 0 | 0 | 50136 | 4260277134716 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 22.4 ms Record Count: 7 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1039 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1040 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1041 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1042 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1043 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1044 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' 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 = '6BCF32BA-0872-461A-B189CD544CB925A7' and product_variations.isactive = 1 and product_sizes.id_size = 1150 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 | F870AB31-A083-476E-AB033C19B41A34B5 | 1039 | black | #000000 | 4-M | 4 | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | stocking | | 4 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 50136 | | -1 | 0 | -1 | 0 | -1 | 2 | 0 | 20.7917 | all | | | 2 | 88E1C271-C3D9-4C42-8BB20E2F47FFD393 | 1040 | black | #000000 | 5-L | 5 | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | stocking | | 5 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132903 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 20.7917 | all | | | 3 | 88D65C8C-9ED5-4BA5-AD63DC60C7355763 | 1041 | black | #000000 | 6-XL | 6 | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | stocking | | 6 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132910 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 20.7917 | all | | | 4 | 202E5B87-D3BF-4A40-9AC0178518821416 | 1042 | black | #000000 | 7-2XL | 7 | | 48-50 | 18-20 | 22-24 | 50-52 | 50-52 | 48-50 | 54-56 | 50-52 | 48-50 | w | stocking | | 7 | intlsize | 20.7917 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277132927 | 1 | 1 | -1 | 1 | -1 | 2 | 0 | 20.7917 | all | | | 5 | 80731322-8F41-4DAD-85D0949DFF18DFDA | 1043 | black | #000000 | 8-3XL | 8 | | 50-52 | 20-22 | 24-26 | 52-54 | 52-54 | 50-52 | 56-58 | 52-54 | 50-52 | w | stocking | | 8 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | 50136 | 4260277134709 | -1 | 0 | -1 | 0 | -1 | 2 | 0 | 20.7917 | all | | | 6 | 78BA2246-8C15-4D3E-93C8DDF873909E89 | 1044 | black | #000000 | 9-4XL | 9 | | 52-54 | 22-24 | 26-28 | 54-56 | 54-56 | 52-54 | 58-60 | 54-56 | 52-54 | w | stocking | | 9 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 3 | 0 | 0 | 50136 | 4260277134716 | -1 | 0 | -1 | 0 | -1 | 2 | 0 | 20.7917 | all | | | 7 | 78BA2246-8C15-4D3E-93C8DDF873909E89 | 1150 | black | #000000 | 9-4XL | 10 | | 54-56 | 24-26 | 28-30 | 56-58 | 56-58 | 54-56 | 60-62 | 54-58 | 54-56 | w | stocking | | 10 | intlsize | 20.7917 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 1 | 3 | 0 | 0 | 50136 | 4260277134716 | -1 | 0 | -1 | 0 | -1 | 2 | 0 | 20.7917 | all | |
|
| vatrate | |
| warehouse | |