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.656 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,'fluorose') > 0 and product_variations.productuid = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 | fluorose | color | fpin | fluorose | pink | #FA22A0 | -1 | 0 |
|
| colorrange | |
| colors | |
| colortype | |
| comments | |
| compositions | Struct Entries: 13 | | coton | | | elastane | | | free | | | leather | | | lycra | | | metal | | | nylon | | | polyamide | | | polyester | | | polyurethane | | | silk | | | spandex | | | viscose | |
|
| datecreated | | Date Time (Europe/Paris) | | {ts '2023-10-17 18:49:34'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-10-22 18:45:34'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.651 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select cart_actions.* from cart_actions where cart_actions.branding IN ('all','divasboudoir') and cart_actions.language IN ('all','el') and (cart_actions.quotas = -1 or (cart_actions.usedCount < cart_actions.quotas)) and cart_actions.isactive = 1 and (date(cart_actions.activeFrom) <= '2025-11-24' OR cart_actions.activeFrom is null) and (date(cart_actions.activeTo) >= '2025-11-24' OR cart_actions.activeTo is null) and ( FIND_IN_SET('48d69b15-6ff6-4ea2-b5241e6595879204',lcase(cart_actions.linkedproducts)) > 0 and cart_actions.linkedproducts is not null )
| | id_action | branding | language | name | code | type | minimumOrder | maximumOrder | minimumItems | maximumItems | maximumUse | allowedItems | quotas | usedCount | linkedproducts | linkedthemes | linkedbrands | linkeditem | params | activeFrom | activeTo | isActive |
|
| linkedproducts | Query Template: /system/api/products.cfc:1305 Execution Time: 1.31 ms Record Count: 0 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select products.productuid as productuid, products.reference, 'default' as type, products.key, products.language, products.name, product_links.linkuid, products.colors, products.vatrate, products.metadatas, products.dimensions, products.mediadatas, products.tags, products.themes, products.isdivasize, count(distinct product_variations.variationuid) as totalvariations, group_concat(distinct product_variations.variationuid) as variationlist, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END) as inpromo, if(count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.variationuid END)>0,1,0) as haspromo, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0) END)) as itempromo, IFNULL(min(product_variations.itemprice),0) as itemprice, (select IF (products.isfixedprice = 0 and sum(product_variations.itempromo) > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null), IFNULL(min(NULLIF(product_variations.itempromo, 0)), 0), IFNULL(min(NULLIF(product_variations.itemprice, 0)), 0) )) as unitprice, count(distinct CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN product_variations.itempromo ELSE product_variations.itemprice END) as prices, (select (CASE WHEN products.isfixedprice = 0 and product_variations.itempromo > 0 and (product_variations.promoUntil > now() or product_variations.promoUntil is null) THEN min(NULLIF(product_variations.promountil, 0)) END)) as promountil, products.isfixedprice, products.ishot, products.isnew, if(products.orderidx > 0, products.orderidx, 999999999) as orderidx, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, count(distinct CASE WHEN ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) > 0 OR ((product_stocks.warehouse+product_stocks.packaging-product_stocks.reserved) <= 0 AND product_variations.supplier = 0)) THEN product_variations.variationuid END) as instockvariations, products.brand, brands.name as brandname, IFNULL(brands.ispublic, 0) as showbrand, brands.display, product_categories.sizetype,GROUP_CONCAT(DISTINCT product_sizes.suppliersize) as intlsize,products.sizes,product_sizes.sizerange,product_categories.mediadatas as categorymediadatas, product_categories.sizerange as categorysizerange, product_categorymap.section, product_categorymap.category, product_categorymap.key as subcategory from products left outer join product_categorymap on products.productuid = product_categorymap.productuid left outer join product_categories on (product_categories.branding = product_categorymap.branding and product_categories.section = product_categorymap.section and product_categories.category = product_categorymap.category and product_categories.key = product_categorymap.key) left outer join product_sizes on product_sizes.id_size IN (products.sizes) left outer join brands on products.brand = brands.brand left outer join product_variations on product_variations.productuid = products.productuid and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' left outer join product_links on product_links.reference = products.reference where products.isactive = 1 and products.isdeleted = 0 and brands.isactive = 1 and brands.isdeleted = 0 and product_categories.isactive = 1 and product_categories.isdeleted = 0 and product_variations.isactive = 1 and FIND_IN_SET('divasboudoir',products.branding) and product_categories.branding IN ('all','divasboudoir') and product_categorymap.branding IN ('all','divasboudoir') and FIND_IN_SET(product_sizes.sizerange,"all,plus") and products.language in ('all','el') and product_categories.language in ('all','el') and (products.displayFrom <= DATE(NOW()) or products.displayFrom is null) and (products.displayTo >= DATE(NOW()) or products.displayTo IS null) and product_links.linkuid = '' and product_links.linkuid is not null and product_links.linkuid <> '' and products.reference <> 'SLST6393' group by products.reference order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
| | productuid | reference | type | key | language | name | linkuid | colors | vatrate | metadatas | dimensions | mediadatas | tags | themes | isdivasize | totalvariations | variationlist | inpromo | haspromo | itempromo | itemprice | unitprice | prices | promountil | isfixedprice | ishot | isnew | orderidx | available | stock | instockvariations | brand | brandname | showbrand | display | sizetype | intlsize | sizes | sizerange | categorymediadatas | categorysizerange | section | category | subcategory |
|
| linkuid | |
| materials | |
| mediadatas | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille_dos1.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | fluorose | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/ddru/slst6393/bas_autofixants_rose_fluo_grande_taille.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 | Unfixierte Strümpfe in Neonpink.<br /><br />Intensive Farbe, Silikonband unter der Spitze für einen guten Halt. |
| | guid | | string | https://dev.divasboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse-neonpink-neonpink/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bekennen Sie Farbe mit unseren Strümpfen in Übergröße in Neonpink. Entdecken Sie unsere große Auswahl an Strümpfen in Übergröße für jeden Anlass. Schneller und diskreter Versand |
| | keywords | | | title | | string | Selbstfixierende Strümpfe in großen Größen in Neonpink. Schneller Versand |
|
| | seotitle | | string | Selbstfixierende Strümpfe große Größe neonpink |
| | seouri | | string | selbstfixierende-strumpfe-grosse-grosse-neonpink-neonpink |
| | specifications | | | stylingtips | | | summary | | string | Wagen Sie es, Farbe zu bekennen und überraschen Sie Ihre Mitmenschen mit diesen Strümpfen in strahlendem Pink. |
| | title | | string | Unfixierte Strümpfe in Neonpink |
| | usageinstructions | |
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Φθορίζοντα ροζ hold-ups.<br /><br />Έντονο χρώμα, ζώνη σιλικόνης κάτω από τη δαντέλα για καλή στήριξη. |
| | guid | | string | https://dev.divasboudoir.com/el/fthorizonta-roz-hold-ups,-megalo-megethos-roz-neon/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Τολμήστε να γίνετε πολύχρωμοι με τις φθορίζουσες ροζ κάλτσες plus size. Ελάτε να ανακαλύψετε τη μεγάλη γκάμα μας σε κάλτσες plus size για όλες τις περιστάσεις. Γρήγορη, διακριτική παράδοση |
| | keywords | | | title | | string | Φθορίζοντα ροζ hold ups, μεγάλο μέγεθος |
|
| | seotitle | | string | Φθορίζοντα ροζ hold ups, μεγάλο μέγεθος |
| | seouri | | string | fthorizonta-roz-hold-ups,-megalo-megethos-roz-neon |
| | specifications | | | stylingtips | | | summary | | string | Τολμήστε να είστε πολύχρωμοι και εκπλήξτε τους φίλους και την οικογένειά σας με αυτές τις φωτεινές ροζ κάλτσες. |
| | title | | string | Φθορίζοντα ροζ hold-ups |
| | usageinstructions | |
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Fluorescent pink hold-ups.<br /><br />Intense color, silicone band under the lace for good support. |
| | guid | | string | https://dev.divasboudoir.com/en/fluorescent-pink-hold-ups,-large-size-fluo-rose/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Dare to be colorful with our fluorescent pink plus size stockings. Come and discover our wide choice of plus size stockings for all occasions. Fast, discreet shipping |
| | keywords | | | title | | string | Fluorescent pink hold-ups, large size. Fast shipping |
|
| | seotitle | | string | Fluorescent pink hold-ups, large size |
| | seouri | | string | fluorescent-pink-hold-ups,-large-size-fluo-rose |
| | specifications | | | stylingtips | | | summary | | string | Dare to be colorful and surprise your friends and family with these bright pink stockings. |
| | title | | string | Fluorescent pink pantyhose |
| | usageinstructions | |
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Medias de color rosa fluorescente.<br /><br />Color intenso, banda de silicona bajo el encaje para una buena sujeción. |
| | guid | | string | https://dev.divasboudoir.com/es/medias-rosa-fluorescente,-talla-grande-rosa-neon/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Atrévete con el colorido de nuestras medias de talla grande rosa fluorescente. Ven y descubre nuestra amplia gama de medias de talla grande para todas las ocasiones. Entrega rápida y discreta |
| | keywords | | | title | | string | Medias rosa fluorescente, talla grande. Envío rápido |
|
| | seotitle | | string | Medias rosa fluorescente, talla grande |
| | seouri | | string | medias-rosa-fluorescente,-talla-grande-rosa-neon |
| | specifications | | | stylingtips | | | summary | | string | Atrévete con los colores y sorprende a tus amigos y familiares con estas medias de color rosa brillante. |
| | title | | string | Medias rosa fluorescente |
| | usageinstructions | |
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | <p>Bas aufofixants rose fluo.<br><br>Couleur intense, bande de silicone sous la dentelle pour un bon maintien.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/bas-autofixants-grande-taille-rose-fluo-rose-fluo/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Osez la couleur avec nos bas grande taille rose fluo. Venez découvrir notre large choix de bas grande taille pour toutes les occasions. Envoi rapide et discret |
| | keywords | | | title | | string | Bas autofixants grande taille rose fluo. Envoi rapide |
|
| | seotitle | | string | Bas autofixants grande taille rose fluo |
| | seouri | | string | bas-autofixants-grande-taille-rose-fluo-rose-fluo |
| | specifications | | | stylingtips | | | summary | | string | <p>Osez la couleur et surprenez votre entourage avec ces bas d'un rose éclantant.</p> |
| | title | | string | Bas aufofixants rose fluo |
| | usageinstructions | |
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Autoreggenti rosa fluorescenti.<br /><br />Colore intenso, fascia in silicone sotto il pizzo per un buon sostegno. |
| | guid | | string | https://dev.divasboudoir.com/it/autoreggenti-rosa-fluorescenti,-taglia-grande-rosa-neon/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Osate essere colorati con le nostre calze rosa fluo taglia grande. Venite a scoprire la nostra ampia gamma di calze taglia grande per tutte le occasioni. Consegna rapida e discreta |
| | keywords | | | title | | string | Autoreggenti rosa fluorescenti, taglia grande |
|
| | seotitle | | string | Autoreggenti rosa fluorescenti, taglia grande |
| | seouri | | string | autoreggenti-rosa-fluorescenti,-taglia-grande-rosa-neon |
| | specifications | | | stylingtips | | | summary | | string | Osate essere colorati e sorprendete i vostri amici e familiari con queste calze rosa acceso. |
| | title | | string | Autoreggenti rosa fluorescenti |
| | usageinstructions | |
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Fluorescerend roze hold-ups.<br /><br />Intense kleur, siliconen band onder de veter voor goede ondersteuning. |
| | guid | | string | https://dev.divasboudoir.com/nl/fluorescerend-roze-hold-ups,-groote-maat-neonroze/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Durf kleurrijk te zijn met onze fluorescerend roze kousen voor groote maten. Kom en ontdek ons brede assortiment groote maten kousen voor alle gelegenheden. Snelle, discrete levering |
| | keywords | | | title | | string | Fluorescerend roze hold-ups, groote maat |
|
| | seotitle | | string | Fluorescerend roze hold-ups, groote maat |
| | seouri | | string | fluorescerend-roze-hold-ups,-groote-maat-neonroze |
| | specifications | | | stylingtips | | | summary | | string | Durf kleurrijk te zijn en verras je vrienden en familie met deze felroze kousen. |
| | title | | string | Fluorescerend roze hold-ups |
| | usageinstructions | |
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | | description | | string | Meias em rosa fluorescente.<br /><br />Cor intensa, banda de silicone por baixo da renda para uma boa sustentação. |
| | guid | | string | https://dev.divasboudoir.com/pt/pegas-cor-de-rosa-fluorescente,-tamanho-grande-rosa-neon/slst6393.htm |
| | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | string | Atreva-se a ser colorida com as nossas meias de tamanho grande cor-de-rosa fluorescente. Venha descobrir a nossa vasta gama de meias plus size para todas as ocasiões. Entrega rápida e discreta |
| | keywords | | | title | | string | Pegas cor-de-rosa fluorescente, tamanho grande |
|
| | seotitle | | string | Pegas cor-de-rosa fluorescente, tamanho grande |
| | seouri | | string | pegas-cor-de-rosa-fluorescente,-tamanho-grande-rosa-neon |
| | specifications | | | stylingtips | | | summary | | string | Atreva-se a ser colorido e surpreenda os seus amigos e familiares com estas meias cor-de-rosa brilhantes. |
| | title | | string | Meias cor-de-rosa fluorescente |
| | 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 <strong>selbstfixierenden Strümpfe in Neonpink</strong> verkörpern Kühnheit und moderne Weiblichkeit. Ihre <strong>strahlende rosa Farbe</strong> verleiht Ihrer Garderobe einen auffallend originellen Touch, während das <strong>leicht blickdichte Finish</strong> eine natürliche Bedeckung bietet, die die Haut sublimiert.</p>
<p>Die <strong>Zusammensetzung aus 85% Nylon und 15% Elasthan</strong> garantiert eine <strong>perfekte Dehnbarkeit</strong>, die sich harmonisch an die Kurven jeder Körperform anpasst. Diese Kombination edler Materialien sorgt für einen <strong>außergewöhnlichen Tragekomfort</strong> und eine optimale Widerstandsfähigkeit bei langem Tragen.</p>
<p>Das <strong>unter der Spitze angebrachte Silikonband</strong> sorgt <strong>den ganzen Tag über</strong> für <strong>perfekten Halt</strong>, ohne zu drücken oder die Haut zu markieren. Diese Technologie ermöglicht <strong>absolute Bewegungsfreiheit</strong> und stellt gleichzeitig sicher, dass Ihre Strümpfe perfekt an ihrem Platz bleiben.</p>
<p>Die <strong>hübschen, passenden rosafarbenen Strumpfbänder</strong> sind das Detail, das den Unterschied ausmacht. Diese sorgfältige Verarbeitung verwandelt einen einfachen Strumpf in ein echtes Modeaccessoire, das eine <strong>schlanke Silhouette</strong> und eine <strong>prächtige Rund</strong> ung schafft, die die Schönheit jeder Figur auf natürliche Weise hervorhebt.</p> |
| | highlights | | string | <ul>
<li><strong>Leuchtendes Neonpink</strong> für einen gewagten Stil</li>
<li><strong>Hochwertiges, dünnes Nylon</strong> für ein seidiges Gefühl</li>
<li><strong>Silikonband unter der Spitze</strong> für optimalen Halt</li>
<li><strong>Leicht blickdicht</strong> für einen eleganten, natürlichen Effekt</li>
<li><strong>Passende rosafarbene Strumpfbänder</strong> für ein raffiniertes Finish</li>
<li><strong>Perfekte Kur</strong> venform, die die Silhouette aufwertet</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Selbstfixierende Strümpfe in Neonpink in großen Größen mit Silikonband und passenden Strumpfhaltern. Knallige Farbe und üppige Kurven bei Leg's Boudoir. |
| | keywords | | | title | | string | Selbstfixierende Strümpfe Fluo Pink Große Größe | Leg's Boudoir |
|
| | seotitle | | string | Selbstfixierende Strümpfe Fluo-Pink Große Größe |
| | seouri | | string | selbstfixierende-strumpfe-in-neonpink,-grosse-grosse |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 85% Nylon, 15% Elasthan</li>
<li><strong>Farbe:</strong> Neonpink</li>
<li><strong>Opazität:</strong> Leicht undurchsichtig</li>
<li><strong>Art :</strong> Selbstfixierend mit Silikonband</li>
<li>Veredelung<strong>:</strong> Passende rosa Strumpfbänder</li>
<li><strong>Größen:</strong> Standard und mehrere Größen erhältlich</li>
</ul> |
| | stylingtips | | string | <p>Das <strong>leuchtende Neonpink</strong> dieser Strümpfe macht sie zu perfekten Statement-Pieces, mit denen Sie überraschen und gewagte Looks kreieren können. Kombinieren Sie sie mit schwarzen oder weißen Kleidungsstücken, um ihre leuchtende Farbe zu betonen, oder wagen Sie einen farbenfrohen Total-Look für einen selbstbewussten Stil. Die <strong>passenden Strumpfbänder</strong> sorgen für einen femininen Touch, der sich perfekt mit ausgefallenen oder raffinierten Outfits kombinieren lässt.</p>
<p>Vervollständigen Sie Ihren Look mit unseren <a href="https://www.legsboudoir.com/de/bodystocking-und-catsuits/">Bodystockings</a> und entdecken Sie unsere Auswahl an <a href="https://www.legsboudoir.com/de/bodystockings-grosse-grossen/">Bodystockings in großen Größen,</a> um perfekt aufeinander abgestimmte Outfits zu kreieren.</p> |
| | summary | | string | <p>Bekennen Sie<strong>Farbe mit unseren selbstfixierenden Strümpfen in Neonpink</strong>, die Sie mit ihrer <strong>leuchtenden Farbe</strong> überraschen werden.</p>
<p>Diese feinen Nylonstrümpfe bieten eine <strong>prächtige Form</strong> und <strong>perfekten Halt</strong> dank des Silikonbandes unter der Spitze.</p> |
| | title | | string | Selbstfixierende Strümpfe in Neonpink - Intensive Farbe und üppige Kurven |
| | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Αυτά τα <strong>neon ροζ hold-ups</strong> είναι η επιτομή της τολμηρής, μοντέρνας θηλυκότητας. Το <strong>έντονο ροζ χρώμα</strong> τους προσθέτει μια εντυπωσιακή πινελιά πρωτοτυπίας στην γκαρνταρόμπα σας, ενώ το <strong>ελαφρώς αδιαφανές φινίρισμα</strong> προσφέρει φυσική κάλυψη που αναδεικνύει το δέρμα.</p>
<p>Η <strong>σύνθεση από 85% νάιλον και 15% ελαστάν</strong> εγγυάται <strong>τέλειο τέντωμα</strong> που προσαρμόζεται αρμονικά στις καμπύλες κάθε σωματότυπου. Αυτός ο συνδυασμός ευγενών υλικών παρέχει <strong>εξαιρετική άνεση</strong> και βέλτιστη αντοχή για παρατεταμένη χρήση.</p>
<p>Η <strong>ζώνη σιλικόνης κάτω από τη δαντέλα</strong> εξασφαλίζει <strong>τέλεια στήριξη όλη την ημέρα</strong> χωρίς να συμπιέζει ή να σημαδεύει το δέρμα. Αυτή η τεχνολογία επιτρέπει την <strong>απόλυτη ελευθερία κινήσεων</strong>, ενώ παράλληλα διασφαλίζει ότι οι κάλτσες σας παραμένουν τέλεια στη θέση τους.</p>
<p>Οι <strong>όμορφες ταιριαστές ροζ καλτσοδέτες</strong> είναι η λεπτομέρεια που κάνει όλη τη διαφορά. Αυτό το σχολαστικό φινίρισμα μετατρέπει μια απλή κάλτσα σε πραγματικό αξεσουάρ μόδας, δημιουργώντας μια <strong>λεπτή σιλουέτα</strong> και μια <strong>πλούσια καμπύλη</strong> που ενισχύει φυσικά την ομορφιά κάθε σιλουέτας.</p> |
| | highlights | | string | <ul>
<li><strong>Φωτεινό ροζ νέον</strong> για έντονο στυλ</li>
<li><strong>Υψηλής ποιότητας λεπτό νάιλον</strong> για μεταξένια αίσθηση</li>
<li><strong>Ζώνη σιλικόνης κάτω από τη δαντέλα</strong> για βέλτιστη στήριξη</li>
<li><strong>Ελαφρώς αδιαφανές</strong> για ένα κομψό φυσικό αποτέλεσμα</li>
<li><strong>Ασορτί ροζ καλτσοδέτες</strong> για εκλεπτυσμένο φινίρισμα</li>
<li><strong>Τέλειο σχήμα</strong> για να ενισχύσει τη σιλουέτα</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Φθορίζοντα ροζ hold ups με ζώνη σιλικόνης και ασορτί καλτσοδέτες. Ζωηρό χρώμα και πλούσιες καμπύλες στο Leg's Boudoir. |
| | keywords | | | title | | string | Φθορίζον ροζ καλσόν μεγάλο | Μπουντουάρ του ποδιού |
|
| | seotitle | | string | Φθορίζον ροζ hold ups Large |
| | seouri | | string | fthorizon-roz-hold-ups-megalo-megethos |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> 85% νάιλον, 15% ελαστάν</li>
<li><strong>Χρώμα:</strong> Φθορίζον ροζ</li>
<li><strong>Αδιαφάνεια:</strong> Ελαφρώς αδιαφανές</li>
<li><strong>Τύπος:</strong> Αυτοκόλλητος με ζώνη σιλικόνης</li>
<li><strong>Φινίρισμα :</strong> Ασορτί ροζ καλτσοδέτες</li>
<li><strong>Μεγέθη</strong>: Διατίθενται κανονικά και διάφορα μεγέθη</li>
</ul> |
| | stylingtips | | string | <p>Το <strong>έντονο νέον ροζ</strong> χρώμα αυτών των καλτσών τις καθιστά τα τέλεια statement κομμάτια για να εκπλήξετε και να δημιουργήσετε τολμηρές εμφανίσεις. Συνδυάστε τες με μαύρα ή λευκά κομμάτια για να αναδείξετε το έντονο χρώμα τους ή επιλέξτε μια εντελώς χρωματική εμφάνιση για μια τολμηρή δήλωση στυλ. <strong>Οι ασορτί καλτσοδέτες</strong> προσθέτουν μια θηλυκή πινελιά που ταιριάζει απόλυτα με εκκεντρικά ή εκλεπτυσμένα σύνολα.</p>
<p>Ολοκληρώστε την εμφάνισή σας με τις <a href="https://www.legsboudoir.com/el/bodystocking-kai-catsuits/">κορδόνια</a> μας και ανακαλύψτε την επιλογή μας σε <a href="https://www.legsboudoir.com/el/syn-megethos-bodystockings/">κορδόνια plus-size</a> για να δημιουργήσετε τέλεια συντονισμένα σύνολα.</p> |
| | summary | | string | <p><strong>Τολμήστε να γίνετε πολύχρωμοι με τα neon ροζ hold-ups μας</strong>, σχεδιασμένα για να εκπλήσσουν τους πάντες γύρω σας με την <strong>έντονη απόχρωσή</strong> τους.</p>
<p>Αυτές οι λεπτές νάιλον κάλτσες προσφέρουν μια <strong>πλούσια καμπύλη</strong> και <strong>τέλεια στήριξη</strong> χάρη στη ζώνη σιλικόνης κάτω από το κορδόνι τους.</p> |
| | title | | string | Φθορίζον ροζ hold ups - Έντονο χρώμα και πλούσια καμπύλη |
| | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>These <strong>neon pink hold-ups</strong> are the epitome of bold, modern femininity. Their <strong>bright pink color</strong> adds a striking touch of originality to your wardrobe, while the <strong>slightly opaque finish</strong> offers natural coverage that sublimates the skin.</p>
<p>The <strong>85% nylon and 15% elastane composition</strong> guarantees <strong>perfect stretch</strong> that adapts harmoniously to the curves of every morphology. This alliance of noble materials provides <strong>exceptional comfort</strong> and optimum resistance for prolonged wear.</p>
<p>The <strong>silicone band under the lace</strong> ensures <strong>perfect support all day long</strong>, without compressing or marking the skin. This technology allows <strong>total freedom of movement</strong> while ensuring that your stockings stay perfectly in place.</p>
<p><strong>Matching pink garters</strong> are the detail that makes all the difference. This meticulous finish transforms a simple stocking into a true fashion accessory, creating a <strong>slender silhouette</strong> and a <strong>sumptuous curve</strong> that naturally enhances the beauty of every figure.</p> |
| | highlights | | string | <ul>
<li><strong>Bright neon pink</strong> for bold style</li>
<li><strong>High-quality fine nylon</strong> for a silky feel</li>
<li><strong>Silicone band under lace</strong> for optimal support</li>
<li><strong>Slightly opaque</strong> for a natural, elegant effect</li>
<li><strong>Matching pink garters</strong> for a refined finish</li>
<li><strong>Perfect curve</strong> to enhance the silhouette</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Fluorescent pink plus size hold-ups with silicone band and matching garters. Vibrant color and sumptuous curves at Leg's Boudoir. |
| | keywords | | | title | | string | Fluorescent Pink Hosiery Plus Size | Leg's Boudoir |
|
| | seotitle | | string | Fluorescent Pink Hosiery Plus Size |
| | seouri | | string | fluorescent-pink-hold-ups-plus-size |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 85% Nylon, 15% Elastane</li>
<li><strong>Color:</strong> Fluorescent pink</li>
<li><strong>Opacity:</strong> Slightly opaque</li>
<li><strong>Type :</strong> Garters with silicone band</li>
<li><strong>Finish:</strong> Matching pink garters</li>
<li><strong>Sizes</strong>: Standard and several sizes available</li>
</ul> |
| | stylingtips | | string | <p>The <strong>bright fluorescent pink</strong> of these stockings makes them the perfect statement pieces to surprise and create bold looks. Pair them with black or white pieces to bring out their vibrant color, or dare the colorful total look for an assertive style. <strong>Matching garters</strong> add a feminine touch that goes perfectly with offbeat or sophisticated outfits.</p>
<p>Complete your look with our <a href="https://www.legsboudoir.com/en/bodystocking-and-catsuits/">bodystockings</a> and discover our selection of <a href="https://www.legsboudoir.com/en/plus-size-bodystockings/">plus size bodystockings</a> to create perfectly coordinated outfits.</p> |
| | summary | | string | <p><strong>Dare to be colorful with our neon pink hold-ups</strong>, designed to surprise those around you with their <strong>dazzling hue</strong>.</p>
<p>These fine nylon stockings offer <strong>sumptuous curves</strong> and <strong>perfect support</strong> thanks to their silicone band under lace.</p> |
| | title | | string | Fluorescent pink hold ups - Intense color and sumptuous curve |
| | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p><strong>Estos medias rosa neón</strong> son el epítome de la feminidad atrevida y moderna. Su <strong>brillante color rosa</strong> añade un llamativo toque de originalidad a tu vestuario, mientras que el <strong>acabado ligeramente opaco</strong> ofrece una cobertura natural que realza la piel.</p>
<p>La <strong>composición de 85% de nailon y 15% de elastano</strong> garantiza <strong>una elasticidad perfecta</strong> que se adapta armoniosamente a las curvas de cada tipo de cuerpo. Esta combinación de materiales nobles proporciona <strong>un confort excepcional</strong> y una resistencia óptima para un uso prolongado.</p>
<p>La <strong>banda de silicona situada bajo el encaje</strong> garantiza <strong>una sujeción perfecta durante todo el día</strong> sin comprimir ni marcar la piel. Esta tecnología permite <strong>una total libertad de movimientos</strong>, al tiempo que garantiza que las medias permanezcan perfectamente en su sitio.</p>
<p>Los <strong>bonitos ligueros rosas a juego</strong> son el detalle que marca la diferencia. Este minucioso acabado transforma una simple media en un verdadero accesorio de moda, creando una <strong>silueta esbelta</strong> y una <strong>suntuosa curva</strong> que realza naturalmente la belleza de cada figura.</p> |
| | highlights | | string | <ul>
<li><strong>Brillante rosa neón</strong> para un estilo atrevido</li>
<li><strong>Nylon fino de alta calidad</strong> para un tacto sedoso</li>
<li><strong>Banda de silicona bajo el encaje</strong> para una sujeción óptima</li>
<li><strong>Ligeramente opaco</strong> para un elegante efecto natural</li>
<li><strong>Liguero rosa a juego</strong> para un acabado refinado</li>
<li><strong>Forma perfecta</strong> para realzar la silueta</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Medias rosa fluorescente con banda de silicona y ligueros a juego. Color vibrante y curvas suntuosas en Leg's Boudoir. |
| | keywords | | | title | | string | Medias rosa fluorescente talla grande | Leg's Boudoir |
|
| | seotitle | | string | Medias rosa fluorescente Talla grande |
| | seouri | | string | medias-rosa-fluorescente-talla-grande |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 85% nailon, 15% elastán</li>
<li><strong>Color:</strong> rosa fluorescente</li>
<li><strong>Opacidad</strong>: Ligeramente opaco</li>
<li><strong>Tipo :</strong> Autocierre con banda de silicona</li>
<li><strong>Acabado</strong>: Liguero rosa a juego</li>
<li><strong>Tallas</strong>: Estándar y varias disponibles</li>
</ul> |
| | stylingtips | | string | <p>El <strong>rosa neón brillante</strong> de estas medias las convierte en las piezas perfectas para sorprender y crear looks atrevidos. Combínalas con prendas blancas o negras para resaltar su vibrante color, o apuesta por un look total color para una declaración de estilo atrevida. <strong>Los ligueros a juego</strong> añaden un toque femenino que combina a la perfección con conjuntos desenfadados o sofisticados.</p>
<p>Completa tu look con nuestros <a href="https://www.legsboudoir.com/es/bodystockings-y-catsuits/">bodystockings</a> y descubre nuestra selección de <a href="https://www.legsboudoir.com/es/bodys-de-talla-grande/">bodystockings de talla grande</a> para crear conjuntos perfectamente coordinados.</p> |
| | summary | | string | <p><strong>Atrévete con nuestras medias de color rosa neón</strong>, diseñadas para sorprender a todos los que te rodean con su <strong>brillante tonalidad</strong>.</p>
<p>Estas finas medias de nailon ofrecen una <strong>suntuosa curva</strong> y <strong>una sujeción perfecta</strong> gracias a su banda de silicona bajo encaje.</p> |
| | title | | string | Medias rosa fluorescente - Color intenso y curva suntuosa |
| | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Ces <strong>bas autofixants rose fluo</strong> incarnent l'audace et la féminité moderne. Leur <strong>couleur rose éclatante</strong> apporte une touche d'originalité saisissante à votre garde-robe, tandis que la <strong>finition légèrement opaque</strong> offre une couverture naturelle qui sublime la peau.</p>
<p>La <strong>composition 85% nylon et 15% élasthanne</strong> garantit une <strong>extensibilité parfaite</strong> qui s'adapte harmonieusement aux courbes de chaque morphologie. Cette alliance de matières nobles procure un <strong>confort exceptionnel</strong> et une résistance optimale pour un port prolongé.</p>
<p>La <strong>bande de silicone placée sous la dentelle</strong> assure un <strong>maintien parfait toute la journée</strong> sans comprimer ni marquer la peau. Cette technologie permet une <strong>liberté de mouvement totale</strong> tout en garantissant que vos bas restent parfaitement en place.</p>
<p>Les <strong>jolies jarretières roses assorties</strong> constituent le détail qui fait toute la différence. Cette finition soignée transforme un simple bas en véritable accessoire de mode, créant une <strong>silhouette élancée</strong> et un <strong>galbe somptueux</strong> qui valorise naturellement la beauté de chaque silhouette.</p> |
| | highlights | | string | <ul>
<li><strong>Rose fluo éclatant</strong> pour un style audacieux</li>
<li><strong>Nylon fin haute qualité</strong> pour un toucher soyeux</li>
<li><strong>Bande de silicone sous dentelle</strong> pour un maintien optimal</li>
<li><strong>Légèrement opaque</strong> pour un effet naturel élégant</li>
<li><strong>Jarretières roses assorties</strong> pour une finition raffinée</li>
<li><strong>Galbe parfait</strong> qui valorise la silhouette</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Bas autofixants rose fluo grande taille avec bande silicone et jarretières assorties. Couleur éclatante et galbe somptueux chez Leg's Boudoir. |
| | keywords | | | title | | string | Bas Autofixants Rose Fluo Grande Taille | Leg's Boudoir |
|
| | seotitle | | string | Bas Autofixants Rose Fluo Grande Taille |
| | seouri | | string | bas-autofixants-rose-fluo-grande-taille |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> 85% Nylon, 15% Élasthanne</li>
<li><strong>Couleur :</strong> Rose fluo</li>
<li><strong>Opacité :</strong> Légèrement opaque</li>
<li><strong>Type :</strong> Autofixants avec bande silicone</li>
<li><strong>Finition :</strong> Jarretières roses assorties</li>
<li><strong>Tailles :</strong> Standard et plusieurs tailles disponibles</li>
</ul> |
| | stylingtips | | string | <p>Le <strong>rose fluo éclatant</strong> de ces bas en fait des pièces statement parfaites pour surprendre et créer des looks audacieux. Associez-les à des pièces noires ou blanches pour faire ressortir leur couleur vibrante, ou osez le total look coloré pour un style assumé. Les <strong>jarretières assorties</strong> apportent une touche de féminité qui se marie parfaitement avec des tenues décalées ou sophistiquées.</p>
<p>Complétez votre look avec nos <a href="https://www.legsboudoir.com/fr/bodystocking-et-catsuits/">bodystockings</a> et découvrez notre sélection de <a href="https://www.legsboudoir.com/fr/bodystockings-grande-taille/">bodystockings grande taille</a> pour créer des tenues parfaitement coordonnées.</p> |
| | summary | | string | <p><strong>Osez la couleur avec nos bas autofixants rose fluo</strong>, conçus pour surprendre votre entourage avec leur <strong>teinte éclatante</strong>.</p>
<p>Ces bas fins nylon offrent un <strong>galbe somptueux</strong> et un <strong>maintien parfait</strong> grâce à leur bande de silicone sous dentelle.</p> |
| | title | | string | Bas Autofixants Rose Fluo - Couleur Intense et Galbe Somptueux |
| | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Queste <strong>autoreggenti rosa neon</strong> sono l'emblema di una femminilità audace e moderna. Il loro <strong>colore rosa acceso</strong> aggiunge un tocco di originalità al vostro guardaroba, mentre la <strong>finitura leggermente opaca</strong> offre una copertura naturale che valorizza la pelle.</p>
<p>La <strong>composizione di 85% nylon e 15% elastan</strong> garantisce una <strong>perfetta elasticità</strong> che si adatta armoniosamente alle curve di ogni tipo di corpo. Questa combinazione di materiali nobili offre un <strong>comfort eccezionale</strong> e una resistenza ottimale per un uso prolungato.</p>
<p>La <strong>fascia in silicone sotto il pizzo</strong> assicura un <strong>sostegno perfetto per tutto il giorno</strong> senza comprimere o segnare la pelle. Questa tecnologia consente <strong>una totale libertà di movimento</strong> e garantisce che le calze rimangano perfettamente al loro posto.</p>
<p>Il <strong>grazioso reggicalze rosa coordinato</strong> è il dettaglio che fa la differenza. Questa finitura meticolosa trasforma una semplice calza in un vero e proprio accessorio di moda, creando una <strong>silhouette sottile</strong> e una <strong>curva sontuosa</strong> che esalta naturalmente la bellezza di ogni figura.</p> |
| | highlights | | string | <ul>
<li><strong>Rosa neon brillante</strong> per uno stile deciso</li>
<li><strong>Nylon pregiato di alta qualità</strong> per una sensazione setosa al tatto</li>
<li><strong>Fascia in silicone sotto il pizzo</strong> per un sostegno ottimale</li>
<li><strong>Leggermente opaco</strong> per un elegante effetto naturale</li>
<li><strong>Giarrettiere rosa abbinate</strong> per una finitura raffinata</li>
<li><strong>Forma perfetta</strong> per esaltare la silhouette</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Autoreggenti rosa fluo con fascia in silicone e reggicalze coordinati. Colori vivaci e curve sontuose da Leg's Boudoir. |
| | keywords | | | title | | string | Calze rosa fluorescenti di taglia grande | Leg's Boudoir |
|
| | seotitle | | string | Rosa fluorescente Taglia grande |
| | seouri | | string | hold-up-rosa-fluorescente-taglia-grande |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> 85% nylon, 15% elastan</li>
<li><strong>Colore:</strong> rosa fluorescente</li>
<li><strong>Opacità:</strong> Leggermente coprente</li>
<li><strong>Tipo :</strong> Autoaderente con fascia in silicone</li>
<li><strong>Finitura :</strong> Giarrettiere rosa abbinate</li>
<li><strong>Taglie</strong>: Standard e diverse taglie disponibili</li>
</ul> |
| | stylingtips | | string | <p>Il <strong>rosa neon brillante</strong> di queste calze le rende perfette per sorprendere e creare look audaci. Abbinatele a capi bianchi o neri per far risaltare il loro colore vibrante, oppure optate per un look total color per una dichiarazione di stile audace. <strong>I reggicalze abbinati</strong> aggiungono un tocco femminile che si abbina perfettamente ad outfit anticonformisti o sofisticati.</p>
<p>Completate il vostro look con i nostri <a href="https://www.legsboudoir.com/it/bodystocking-e-tute/">bodystockings</a> e scoprite la nostra selezione di <a href="https://www.legsboudoir.com/it/bodystockings-di-taglia-grande/">bodystockings taglia grande</a> per creare outfit perfettamente coordinati.</p> |
| | summary | | string | <p><strong>Osate essere colorate con le nostre calze autoreggenti rosa neon</strong>, progettate per sorprendere tutti coloro che vi circondano con la loro <strong>tonalità brillante</strong>.</p>
<p>Queste calze in nylon pregiato offrono una <strong>curva sontuosa</strong> e un <strong>sostegno perfetto</strong> grazie alla fascia in silicone sotto il pizzo.</p> |
| | title | | string | Rosa fluorescente - Colore intenso e curva sontuosa |
| | usageinstructions | |
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Deze <strong>neonroze hold-ups</strong> zijn het toppunt van gedurfde, moderne vrouwelijkheid. Hun <strong>felroze kleur</strong> voegt een opvallend vleugje originaliteit toe aan je garderobe, terwijl de <strong>licht ondoorzichtige afwerking</strong> een natuurlijke dekking biedt die de huid mooier maakt.</p>
<p>De <strong>samenstelling van 85% nylon en 15% elastaan</strong> garandeert een <strong>perfecte stretch</strong> die zich harmonieus aanpast aan de rondingen van elk lichaamstype. Deze combinatie van edele materialen biedt <strong>uitzonderlijk comfort</strong> en optimale weerstand voor langdurig dragen.</p>
<p>De <strong>siliconenband onder de veter</strong> zorgt <strong>de hele dag</strong> voor <strong>een perfecte ondersteuning</strong> zonder de huid samen te drukken of te beschadigen. Deze technologie zorgt voor <strong>totale bewegingsvrijheid</strong> terwijl je kousen perfect op hun plaats blijven zitten.</p>
<p>De <strong>mooie bijpassende roze kousenbanden</strong> zijn het detail dat het verschil maakt. Deze zorgvuldige afwerking verandert een eenvoudige kous in een echt mode-accessoire en creëert een <strong>slank silhouet</strong> en een <strong>weelderige ronding</strong> die de schoonheid van elk figuur op natuurlijke wijze benadrukt.</p> |
| | highlights | | string | <ul>
<li><strong>Helder neonroze</strong> voor een gedurfde stijl</li>
<li><strong>Hoogwaardig fijn nylon</strong> voor een zijdezacht gevoel</li>
<li><strong>Siliconen band onder kant</strong> voor optimale ondersteuning</li>
<li><strong>Licht ondoorschijnend</strong> voor een elegant natuurlijk effect</li>
<li><strong>Bijpassende roze kousenband</strong> voor een verfijnde afwerking</li>
<li><strong>Perfecte vorm</strong> om het silhouet te verbeteren</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Fluorescerend roze hold-ups met siliconen band en bijpassende kousenbanden. Levendige kleuren en weelderige rondingen bij Leg's Boudoir. |
| | keywords | | | title | | string | Fluorescerend Roze Kousen Grote Maat | Leg's Boudoir |
|
| | seotitle | | string | Fluorescerend roze hold ups Grote maat |
| | seouri | | string | fluorescerend-roze-hold-ups-grote-maat |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> 85% nylon, 15% elastaan</li>
<li><strong>Kleur:</strong> Fluorescerend roze</li>
<li><strong>Opaciteit:</strong> Licht ondoorschijnend</li>
<li><strong>Type :</strong> Zelfsluitend met siliconenband</li>
<li><strong>Afwerking :</strong> Bijpassende roze kousenband</li>
<li><strong>Maten</strong>: Standaard en verschillende maten beschikbaar</li>
</ul> |
| | stylingtips | | string | <p>Het <strong>felle neonroze</strong> van deze kousen maakt ze tot de perfecte statement pieces om te verrassen en gewaagde looks te creëren. Combineer ze met zwarte of witte stukken om hun levendige kleur naar voren te laten komen, of ga voor een totale kleurenlook voor een gedurfd stijlstatement. <strong>Bijpassende kousenbanden</strong> voegen een vrouwelijke touch toe die perfect past bij onconventionele of geraffineerde outfits.</p>
<p>Maak je look compleet met onze <a href="https://www.legsboudoir.com/nl/bodystocking-en-catsuits/">bodystockings</a> en ontdek onze selectie <a href="https://www.legsboudoir.com/nl/bodystockings-grote-maten/">bodystockings in grote maten</a> om perfect gecoördineerde outfits te creëren.</p> |
| | summary | | string | <p><strong>Durf kleurrijk te zijn met onze neonroze hold-ups</strong>, ontworpen om iedereen om je heen te verrassen met hun <strong>felle tint</strong>.</p>
<p>Deze fijne nylonkousen bieden een <strong>weelderige ronding</strong> en <strong>perfecte ondersteuning</strong> dankzij de siliconen band onder het kant.</p> |
| | title | | string | Fluorescerend roze hold-ups - Intense kleur en weelderige curve |
| | usageinstructions | |
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | string | <p>Estas <strong>cuecas rosa néon</strong> são o epítome da feminilidade arrojada e moderna. A sua <strong>cor rosa vivo</strong> confere um toque de originalidade marcante ao seu guarda-roupa, enquanto o <strong>acabamento ligeiramente opaco</strong> oferece uma cobertura natural que realça a pele.</p>
<p>A <strong>composição de 85% de nylon e 15% de elastano</strong> garante <strong>uma elasticidade perfeita</strong> que se adapta harmoniosamente às curvas de cada tipo de corpo. Esta combinação de materiais nobres proporciona <strong>um conforto excecional</strong> e uma resistência óptima para uma utilização prolongada.</p>
<p>A <strong>banda de silicone sob a renda</strong> garante <strong>um suporte perfeito durante todo o dia</strong>, sem comprimir nem marcar a pele. Esta tecnologia permite <strong>uma total liberdade de movimentos</strong>, garantindo ao mesmo tempo que as meias se mantêm perfeitamente no sítio.</p>
<p>As <strong>bonitas ligas cor-de-rosa a condizer</strong> são o pormenor que faz toda a diferença. Este acabamento minucioso transforma uma simples meia num verdadeiro acessório de moda, criando uma <strong>silhueta esguia</strong> e uma <strong>curva sumptuosa</strong> que realça naturalmente a beleza de cada figura.</p> |
| | highlights | | string | <ul>
<li><strong>Rosa néon brilhante</strong> para um estilo arrojado</li>
<li><strong>Nylon fino de alta qualidade</strong> para um toque sedoso</li>
<li><strong>Faixa de silicone sob a renda</strong> para um suporte ótimo</li>
<li><strong>Ligeiramente opaco</strong> para um elegante efeito natural</li>
<li><strong>Ligeiras ligas cor-de-rosa a condizer</strong> para um acabamento requintado</li>
<li><strong>Forma perfeita</strong> para realçar a silhueta</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Sutiãs rosa fluorescente com banda de silicone e ligas a condizer. Cores vibrantes e curvas sumptuosas na Leg's Boudoir. |
| | keywords | | | title | | string | Meias-calças cor-de-rosa fluorescente Grande | Leg's Boudoir |
|
| | seotitle | | string | Meias cor-de-rosa fluorescente Grande |
| | seouri | | string | meias-rosa-fluorescente-tamanho-grande |
| | specifications | | string | <ul>
<li><strong>Material:</strong> 85% nylon, 15% elastano</li>
<li><strong>Cor:</strong> Rosa fluorescente</li>
<li><strong>Opacidade:</strong> Ligeiramente opaco</li>
<li><strong>Tipo :</strong> Auto-fixação com banda de silicone</li>
<li><strong>Acabamento:</strong> Ligas cor-de-rosa a condizer</li>
<li><strong>Tamanhos</strong>: Normal e vários tamanhos disponíveis</li>
</ul> |
| | stylingtips | | string | <p>O <strong>rosa néon brilhante</strong> destas meias torna-as nas peças de afirmação perfeitas para surpreender e criar looks ousados. Combine-as com peças pretas ou brancas para realçar a sua cor vibrante, ou opte por um look totalmente colorido para uma afirmação de estilo arrojada. <strong>As ligas a condizer</strong> acrescentam um toque feminino que combina na perfeição com conjuntos fora do comum ou sofisticados.</p>
<p>Complete o seu look com os nossos <a href="https://www.legsboudoir.com/pt/bodystocking-e-catsuits/">bodystockings</a> e descubra a nossa seleção de <a href="https://www.legsboudoir.com/pt/bodystockings-plus-size/">bodystockings plus size</a> para criar conjuntos perfeitamente coordenados.</p> |
| | summary | | string | <p>Atreva-se<strong>a ser colorida com as nossas meias de ligas rosa néon</strong>, concebidas para surpreender todos à sua volta com a sua <strong>tonalidade brilhante</strong>.</p>
<p>Estas meias de nylon fino oferecem uma <strong>curva sumptuosa</strong> e um <strong>suporte perfeito</strong> graças à sua banda de silicone sob o laço.</p> |
| | title | | string | Meias rosa fluorescente - Cor intensa e curva sumptuosa |
| | 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 | 48D69B15-6FF6-4EA2-B5241E6595879204 |
|
| promountil | |
| rating | |
| recorduid | | string | 48D69B15-6FF6-4EA2-B5241E6595879204 |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 1.23 ms Record Count: 2 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_sizes.id_size as recorduid, if(intlsize <> '',intlsize,eusize) as size, if(intlsize <> '','intlsize','eusize') as sizetype, product_variations.color, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', cast(intlsize as SIGNED ), cast(eusize as SIGNED )) , SUBSTRING_INDEX(intlsize,'-',1) ) as param1, if(product_sizes.sizegroup = 'bra', if(intlsize <> '', MID(intlsize,length(cast(intlsize as SIGNED ))+1,length(intlsize)), MID(eusize,length(cast(eusize as SIGNED ))+1,length(eusize)) ) , SUBSTRING_INDEX(intlsize,'-',-1) ) as param2, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, 999999, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as groupavailable, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, product_sizes.gender, product_sizes.sizerange, product_sizes.sizegroup, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.bust, product_sizes.waist, product_sizes.hip, product_sizes.underbust, product_sizes.cup, product_sizes.thigh, product_sizes.legheight, product_sizes.bodyheight, product_sizes.bodyweight from product_sizes left outer join product_variations on product_sizes.suppliersize = product_variations.size and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_sizes.id_size,'1816,1112') > 0 and product_variations.productuid = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 | 1816 | 2-4 | intlsize | fluorose | 2 | 4 | -1 | 999999 | 0 | w | plus | stocking | One | 2-4 | | 34-40 | 4-10 | 8-12 | 36-42 | 36-42 | 34-40 | 40-46 | 36-42 | 34-40 | | | | | | | | | | | 2 | 1112 | 5-6 | intlsize | fluorose | 5 | 6 | -1 | 999999 | 0 | w | plus | stocking | Queen | 5-6 | | 42-48 | 12-18 | 16-22 | 44-50 | 44-50 | 42-48 | 48-52 | 44-50 | 42-48 | | | | | | | | | |
|
| sizeranges | |
| sizes | |
| sizetype | |
| specifications | Struct Entries: 23 | | belly | | | bones | | | bra | | | breasts | | | bust | | | closing | | | crochtless | | | cups | | | cut | | | garter | | | halter | | | lacing | | | lining | | | modestypanel | | | panty | | | sheathing | | | sleeves | | | stocking | | | straps | | | stretch | | | suspenders | | | transparency | | | underwires | |
|
| stock | |
| stocks | Query Template: /system/api/product/stocks.cfc:25 Execution Time: 3.33 ms Record Count: 2 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select * from ( select product_stocks.productuid, product_stocks.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, 'all' as display, product_variations.comments from product_stocks left outer join product_variations on product_variations.productuid = product_stocks.productuid and product_variations.variationuid = product_stocks.variationuid left outer join product_sizes on product_variations.size = product_sizes.suppliersize left outer join product_colors on product_variations.color = product_colors.color where product_stocks.productuid = '48D69B15-6FF6-4EA2-B5241E6595879204' and product_variations.isactive = 1 and product_sizes.id_size = 1816 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' and product_variations.isactive = 1 and product_sizes.id_size = 1112 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 | 48D69B15-6FF6-4EA2-B5241E6595879204 | 6680DBE2-D54C-4AA5-9C3684B3048EBA04 | 1816 | fluorose | #FA22A0 | One | 2-4 | | 34-40 | 4-10 | 8-12 | 36-42 | 36-42 | 34-40 | 40-46 | 36-42 | 34-40 | w | stocking | | 2-4 | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 2 | 48D69B15-6FF6-4EA2-B5241E6595879204 | 9129796D-BC77-4EC4-91D8CF47BAD2CCE9 | 1112 | fluorose | #FA22A0 | Queen | 5-6 | | 42-48 | 12-18 | 16-22 | 44-50 | 44-50 | 42-48 | 48-52 | 44-50 | 42-48 | w | stocking | | 5-6 | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 3 | 0 | 0 | | 888368050819 | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | | string | lollipop,readyforvalentine |
|
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 4.01 ms Record Count: 2 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_variations.variationuid, product_sizes.id_size as recorduid, product_variations.color, product_colors.hexvalue, product_sizes.suppliersize, product_sizes.intlsize, product_sizes.inches, product_sizes.eusize, product_sizes.ussize, product_sizes.uksize, product_sizes.frsize, product_sizes.essize, product_sizes.desize, product_sizes.itsize, product_sizes.ptsize, product_sizes.elsize, product_sizes.gender, product_sizes.sizegroup, product_sizes.cup, if(intlsize <> '',intlsize,product_sizes.intlsize) as size, if(intlsize <> '','intlsize','intlsize') as sizetype, product_variations.itemprice, product_variations.itempromo, product_variations.promoUntil, product_stocks.stockuid, product_stocks.warehouse, product_stocks.ontour, product_stocks.packaging, product_variations.supplier, product_stocks.reserved, product_variations.ordered, product_variations.returned, product_variations.defect, product_variations.reference as manufacturerreference, product_variations.ean, (if( (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)) > 0, (sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved)), if((select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 )) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock, (if( (select count(distinct b.variationuid) from product_variations b where b.isactive = 1 and b.productuid = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' and product_variations.isactive = 1 and product_sizes.id_size = 1816 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' 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 = '48D69B15-6FF6-4EA2-B5241E6595879204' and product_variations.isactive = 1 and product_sizes.id_size = 1112 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 | 6680DBE2-D54C-4AA5-9C3684B3048EBA04 | 1816 | fluorose | #FA22A0 | One | 2-4 | | 34-40 | 4-10 | 8-12 | 36-42 | 36-42 | 34-40 | 40-46 | 36-42 | 34-40 | w | stocking | | 2-4 | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 2 | 9129796D-BC77-4EC4-91D8CF47BAD2CCE9 | 1112 | fluorose | #FA22A0 | Queen | 5-6 | | 42-48 | 12-18 | 16-22 | 44-50 | 44-50 | 42-48 | 48-52 | 44-50 | 42-48 | w | stocking | | 5-6 | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 3 | 0 | 0 | | 888368050819 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | |
|
| vatrate | |
| warehouse | |