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.briefs.thong |
|
| category | |
| categorygender | |
| categorymediadatas | | Struct | | adult | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/categories/divasboudoir/lingerie/sexylingerie/thong.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: 1.37 ms Record Count: 3 Cached: No Datasource: divasboudoir_sitedatas Lazy: No SQL: select product_colors.color as recorduid, product_colors.type, product_colors.code, product_colors.color, product_colors.range, product_colors.hexvalue, (if( (select count(distinct CASE WHEN product_variations.supplier < 0 THEN product_variations.variationuid END) ) > 0, -1, if( sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved) >= 0, sum(if(product_variations.supplier >= 0,product_variations.supplier,0))+sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved), 0 ) )) as available, IF((sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved))>=0,sum(product_stocks.warehouse)+sum(product_stocks.packaging)-sum(product_stocks.reserved),0) as stock from product_colors left outer join product_variations on product_colors.color = product_variations.color and product_variations.isactive = 1 left outer join product_stocks on product_stocks.productuid = product_variations.productuid and product_stocks.variationuid = product_variations.variationuid and product_stocks.stockuid = 'STOCK01' where FIND_IN_SET(product_colors.color,'black,red,white') > 0 and product_variations.productuid = 'A5EB2811-35A4-44F1-82955DA99B9128ED' group by product_colors.range,product_colors.color order by product_colors.range,product_colors.color
| | recorduid | type | code | color | range | hexvalue | available | stock | | 1 | black | color | blak | black | black | #000000 | -1 | 0 | | 2 | red | color | red | red | red | #F50000 | -1 | 0 | | 3 | white | color | whit | white | white | #FFFFFF | -1 | 1 |
|
| 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 '2022-09-06 09:27:48'} |
|
| defect | |
| dimensions | Struct Entries: 14 | | acrylicbones | | | backsideheight | | | diameter | | | flatsteelbones | | | frontsideheight | | | fullheight | | | length | | | modestysize | | | panels | | | sides | | | spiralsteelbones | | | totallength | | | unit | | | wiresize | |
|
| display | |
| displayfrom | |
| displayto | |
| grossweight | |
| hasbrandinfos | |
| hascareinstructions | |
| hascolorinfos | |
| hascompositions | |
| hasdescription | |
| hasdimensions | |
| hasmaterials | |
| hasotherspecifications | |
| haspromo | |
| hasshortdescription | |
| hassizeinfos | |
| hasspecifications | |
| hasstockinfos | |
| hasstylingtips | |
| hasusageinstructions | |
| hasvariations | |
| import | |
| inpromo | |
| instockvariations | |
| isactive | |
| iscustommade | |
| isdivasize | |
| isfirstprice | |
| isfixedprice | |
| ishot | |
| isnew | |
| isonline | |
| isoutletprice | |
| itemprice | |
| itempromo | |
| key | |
| language | |
| lastupdated | | Date Time (Europe/Paris) | | {ts '2025-09-11 10:17:57'} |
|
| linkedactions | Query Template: /system/api/cart/actions.cfc:12 Execution Time: 0.957 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','pt') 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('a5eb2811-35a4-44f1-82955da99b9128ed',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.67 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','pt') and product_categories.language in ('all','pt') 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 <> 'SBGA4825' group by products.reference order by products.ishot desc, products.isnew desc, orderidx asc, products.lastupdated desc
| | productuid | reference | type | key | language | name | linkuid | colors | vatrate | metadatas | dimensions | mediadatas | tags | themes | isdivasize | totalvariations | variationlist | inpromo | haspromo | itempromo | itemprice | unitprice | prices | promountil | isfixedprice | ishot | isnew | orderidx | available | stock | instockvariations | brand | brandname | showbrand | display | sizetype | intlsize | sizes | sizerange | categorymediadatas | categorysizerange | section | category | subcategory |
|
| linkuid | |
| materials | |
| mediadatas | | Struct | | alt | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijou_blanc.jpg |
| | type | | | width | |
| | back | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijou.jpg |
| | type | | | width | |
| | default | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijoub_blanc.jpg |
| | type | | | width | |
| | variations | | Struct | | colors | | Struct | | black | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijou.jpg |
| | type | | | width | |
| | red | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijou_rouge.jpg |
| | type | | | width | |
| | white | | Struct | | height | | | isprivate | | | rating | | | src | | string | /photobank/products/puun/sbga4825/string_grande_taille_bijoub_blanc.jpg |
| | type | | | width | |
|
|
| | video | | Struct | | embedsrc | | | height | | | id | | | isprivate | | | rating | | | src | | | thumb | | Struct | | default | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | high | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | maxres | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | medium | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
| | standard | | Struct | | height | | | isprivate | | | rating | | | src | | | type | | | width | |
|
| | type | | | width | |
|
|
| mediagallery | |
| metadatas | | Struct | | darkboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -schwarz-rot-ou-weiss |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -mayro-kokkino-ou-leyko |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -black-red-ou-white |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -negro-rojo-ou-blanco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -noir-rouge-ou-blanc |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -nero-rosso-ou-bianco |
| | 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 | | string | -preto-vermelho-ou-branco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | divasboudoir | | Struct | | de | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Feinwäsche mit der Hand</li>
<li>Lauwarmes Wasser (maximal 30°C)</li>
<li>Feinwaschmittel</li>
<li>Flach trocknen</li>
<li>Vorsichtig mit den Kettchen umgehen</li>
</ul> |
| | description | | string | <p>Der Juwelen-String explodiert vor Sinnlichkeit mit seinen <strong>Kristallketten</strong>, die bei jeder Ihrer Bewegungen tanzen. Seine <strong>zarten Stickereien</strong> auf dem oberen Schambereich offenbaren eine subtile Provokation, während die <strong>kleinen Brillanten</strong> jeden Blick in eine Einladung verwandeln.</p>
<p>Ein String, der Ihren Körper nicht nur kleidet, sondern ihn mit einer <strong>rohen, selbstbewussten Sinnlichkeit</strong> sublimiert.</p>
<p>Jedes Detail wurde durchdacht, um einen Moment purer Verführung zu schaffen: die gleitenden Ketten, die funkelnden Kristalle, ein Design, das Ihre Kühnheit schreit.</p> |
| | guid | | string | https://dev.divasboudoir.com/de/string-grosse-grosse-joyas-verstellbar-schwarz-rot-ou-weiss/sbga4825.htm |
| | highlights | | string | <ul>
<li>Ultraprovokante<strong>, mit Kristallen verzierte Ketten</strong></li>
<li><strong>Zarte Stickereien</strong> auf dem oberen Schambereich</li>
<li><strong>Kleine Glitzersteine</strong>, die das Licht fangen</li>
<li><strong>Verstellbarer String</strong> für optimalen Tragekomfort</li>
<li><strong>Drei Farben</strong>: Schwarz, Rot, Weiß</li>
<li><strong>Minimalistisches Design</strong>, aber furchtbar sexy</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Großer Schmuckstring mit Kristallkettchen. Zarte Stickereien in drei Farben. Ultra sexy, provokant. Schnelle Lieferung. Diva's Boudoir. |
| | keywords | | | title | | string | Sexy Schmuckstring Große Größe | Diva's Boudoir |
|
| | seotitle | | string | String große Größe Juwel mit Ketten und Kristallen |
| | seouri | | string | string-grosse-grosse-joyas-verstellbar-schwarz-rot-ou-weiss |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Spitze und Kristallketten</li>
<li><strong>Farben:</strong> Schwarz, Rot, Weiß</li>
<li><strong>Stil:</strong> Ultra-sexy Juwelen-String</li>
<li><strong>Details:</strong> Ketten, Kristalle, Stickereien</li>
<li><strong>Passform:</strong> Verstellbare Träger</li>
</ul> |
| | stylingtips | | string | <p>Wagen Sie die totale Provokation! Vervollständigen Sie Ihren Look mit unseren <a href="https://www.divasboudoir.com/de/sexy-kleider-in-grossen-grossen/">Sexy Kleidern</a> oder <a href="https://www.divasboudoir.com/de/neglige-in-grosse-grossen/">Negligés</a> für eine grenzenlose Verführung.</p> |
| | summary | | string | <p>Entdecken Sie den <strong>ultra-sexy Schmuck-String</strong>, der jeden Moment in eine Einladung zur Verführung verwandelt.</p>
<p><strong>zarte Stickereien</strong>, <strong>Kristallketten</strong> und <strong>kleine Brillanten</strong> sorgen für einen String, der niemanden gleichgültig lässt.</p> |
| | title | | string | Juwelen-String: Provokation und sinnliche Kristalle |
| | usageinstructions | | string | <p>Dieser Juwelen-String ist für Momente gemacht, in denen Sie <strong>Ihre Sinnlichkeit explodieren lassen</strong> wollen <strong>.</strong> Seine Kristallketten sorgen für eine hypnotische Bewegung, die niemanden kalt lassen wird.</p> |
|
| | el | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Απαλό πλύσιμο στο χέρι</li>
<li>Ζεστό νερό (30°C το πολύ)</li>
<li>Ήπιο απορρυπαντικό</li>
<li>Στεγνώστε σε επίπεδη επιφάνεια</li>
<li>Να χειρίζεστε τις αλυσίδες με προσοχή</li>
</ul> |
| | description | | string | <p>Το στρινγκ με κοσμήματα εκρήγνυται με αισθησιασμό, με τις <strong>κρυστάλλινες αλυσίδες</strong> του να χορεύουν με κάθε σας κίνηση. Το <strong>λεπτεπίλεπτο κέντημά</strong> του στην κορυφή του εφηβαίου αποκαλύπτει μια διακριτική πρόκληση, ενώ οι <strong>μικρές λάμψεις</strong> μετατρέπουν κάθε ματιά σε πρόσκληση.</p>
<p>Ένα στρινγκ που δεν ντύνει απλώς το σώμα σας, αλλά το υποβόσκει με <strong>ωμό, γεμάτο αυτοπεποίθηση αισθησιασμό.</strong></p>
<p>Κάθε λεπτομέρεια έχει σχεδιαστεί για να δημιουργήσει μια στιγμή καθαρής αποπλάνησης: συρόμενες αλυσίδες, αστραφτερά κρύσταλλα, ένα σχέδιο που φωνάζει τόλμη.</p> |
| | guid | | string | https://dev.divasboudoir.com/el/joyas-megalo-rythmizomeno-stringk-mayro-kokkino-ou-leyko/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Αλυσίδες στολισμένες με</strong> εξαιρετικά προκλητικά<strong>κρύσταλλα</strong></li>
<li><strong>Λεπτό κέντημα</strong> στην κορυφή του εφηβαίου</li>
<li><strong>Μικρές λάμψεις</strong> που πιάνουν το φως</li>
<li><strong>Ρυθμιζόμενο στρινγκ</strong> για βέλτιστη άνεση</li>
<li><strong>Τρία χρώματα</strong>: μαύρο, κόκκινο, λευκό</li>
<li><strong>Μινιμαλιστικός</strong> αλλά σέξι<strong>σχεδιασμός</strong></li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Μεγάλο κορδόνι με κοσμήματα και κρυστάλλινες αλυσίδες. Λεπτό κέντημα σε τρία χρώματα. Εξαιρετικά σέξι, προκλητικό. Γρήγορη παράδοση. Μπουντουάρ της Ντίβας. |
| | keywords | | | title | | string | Στρινγκ Bijou Grande Taille Sexy | Diva's Boudoir |
|
| | seotitle | | string | Μεγάλο στρινγκ με κοσμήματα, αλυσίδες και κρύσταλλα |
| | seouri | | string | joyas-megalo-rythmizomeno-stringk-mayro-kokkino-ou-leyko |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Δαντέλα και κρυστάλλινες αλυσίδες</li>
<li><strong>Χρώματα:</strong> Μαύρο, Κόκκινο, Λευκό</li>
<li><strong>Στυλ :</strong> Πολύ σέξι στρινγκ με κοσμήματα</li>
<li><strong>Λεπτομέρειες</strong>: Αλυσίδες, κρύσταλλα, κεντήματα</li>
<li><strong>Εφαρμογή :</strong> Ρυθμιζόμενες τιράντες</li>
</ul> |
| | stylingtips | | string | <p>Τολμήστε να είστε εντελώς προκλητικοί! Ολοκληρώστε την εμφάνισή σας με τα <a href="https://www.divasboudoir.com/el/sexi-foremata-syn-megethos/">σέξι φορέματα</a> ή <a href="https://www.divasboudoir.com/el/negklize-megaloy-megethoys/">τα νεγκλιζέ</a> μας για απεριόριστη αποπλάνηση.</p> |
| | summary | | string | <p>Ανακαλύψτε το <strong>εξαιρετικά σέξι στρινγκ με κοσμήματα</strong> που μετατρέπει κάθε στιγμή σε πρόσκληση για αποπλάνηση.</p>
<p><strong>λεπτά κεντήματα</strong>, <strong>αλυσίδες από κρύσταλλα</strong> και <strong>μικρές λάμψεις</strong> για ένα στρινγκ που δεν αφήνει κανέναν αδιάφορο.</p> |
| | title | | string | Bijou G-string: Πρόκληση και αισθησιακοί κρύσταλλοι |
| | usageinstructions | | string | <p>Αυτό το στρινγκ με κοσμήματα είναι φτιαγμένο για εκείνες τις στιγμές που θέλετε να <strong>αφήσετε τον αισθησιασμό σας να εκραγεί.</strong> Οι κρυστάλλινες αλυσίδες του δημιουργούν μια υπνωτική κίνηση που δεν θα αφήσει κανέναν άφωνο.</p> |
|
| | en | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Delicate hand wash</li>
<li>Warm water (30°C maximum)</li>
<li>Mild detergent</li>
<li>Dry flat</li>
<li>Handle chains with care</li>
</ul> |
| | description | | string | <p>The jewel thong explodes with sensuality, its <strong>crystal chains</strong> dancing with your every move. Its <strong>delicate embroidery</strong> on the top of the pubis reveals a subtle provocation, while the <strong>tiny sparkles</strong> turn every glance into an invitation.</p>
<p>A thong that doesn't just dress your body, but sublimates it with <strong>raw, assumed sensuality.</strong></p>
<p>Every detail has been designed to create a moment of pure seduction: sliding chains, sparkling crystals, a design that screams boldness.</p> |
| | guid | | string | https://dev.divasboudoir.com/en/string-jewel-plus-size-chains-crystals/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Chains adorned with</strong> ultra-provocative<strong>crystals</strong></li>
<li><strong>Delicate embroidery</strong> on the top of the pubis</li>
<li>Light-catching <strong>sparkles</strong></li>
<li><strong>Adjustable thong</strong> for optimum comfort</li>
<li><strong>Three colors</strong>: black, red, white</li>
<li><strong>Minimalist</strong> yet terribly sexy<strong>design</strong></li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Plus size jewel thong with crystal chains. Delicate embroidery in three colors. Ultra sexy, provocative. Fast delivery. Diva's Boudoir. |
| | keywords | | | title | | string | Thong Bijou Plus Size Sexy | Diva's Boudoir |
|
| | seotitle | | string | Jewel thong plus size with chains and crystals |
| | seouri | | string | string-jewel-plus-size-chains-crystals |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Lace and crystal chains</li>
<li><strong>Colors:</strong> Black, Red, White</li>
<li><strong>Style:</strong> Ultra sexy jewel thong</li>
<li><strong>Details:</strong> Chains, crystals, embroidery</li>
<li><strong>Fitting :</strong> Adjustable straps</li>
</ul> |
| | stylingtips | | string | <p>Dare to be totally provocative! Complete your look with our <a href="https://www.divasboudoir.com/en/sexys-plus-size-dresses/">sexy dresses</a> or <a href="https://www.divasboudoir.com/en/plus-size-robes/">negligees</a> for unlimited seduction.</p> |
| | summary | | string | <p>Discover the <strong>ultra-sexy jewel thong</strong> that transforms every moment into an invitation to seduction.</p>
<p><strong>delicate embroidery</strong>, <strong>crystal chains</strong> and <strong>tiny sparkles</strong> for a thong that leaves no one indifferent.</p> |
| | title | | string | Bijou G-string: Provocation and Sensual Crystals |
| | usageinstructions | | string | <p>This jewel thong is made for those moments when you want to <strong>explode your sensuality.</strong> Its crystal chains create a hypnotic movement that will leave no one speechless.</p> |
|
| | es | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavado suave a mano</li>
<li>Agua tibia (30°C máximo)</li>
<li>Detergente suave</li>
<li>Secar en plano</li>
<li>Manipular las cadenas con cuidado</li>
</ul> |
| | description | | string | <p>El tanga joya explota de sensualidad, sus <strong>cadenas de cristal</strong> bailan con cada uno de tus movimientos. Su <strong>delicado bordado</strong> en la parte superior del pubis revela una sutil provocación, mientras que los <strong>pequeños destellos</strong> convierten cada mirada en una invitación.</p>
<p>Un tanga que no sólo viste tu cuerpo, sino que lo sublima con <strong>una sensualidad cruda y segura.</strong></p>
<p>Cada detalle ha sido diseñado para crear un momento de pura seducción: cadenas deslizantes, cristales brillantes, un diseño que grita audacia.</p> |
| | guid | | string | https://dev.divasboudoir.com/es/tanga-joya-talla-grande-cadenas-cristales/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Cadenas adornadas con cristales</strong> ultraprovocadores</li>
<li><strong>Delicados bordados</strong> en la parte superior del pubis</li>
<li><strong>Pequeños destellos</strong> que captan la luz</li>
<li><strong>Tanga ajustable</strong> para un confort óptimo</li>
<li><strong>Tres colores</strong>: negro, rojo y blanco</li>
<li><strong>Diseño minimalista</strong> pero sexy</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Tanga joya grande con cadenas de cristal. Delicado bordado en tres colores. Ultra sexy y provocativo. Entrega rápida. Diva's Boudoir. |
| | keywords | | | title | | string | Tanga Bijou Talla grande Sexy | Diva's Boudoir |
|
| | seotitle | | string | Tanga joya grande con cadenas y cristales |
| | seouri | | string | tanga-joya-talla-grande-cadenas-cristales |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Encaje y cadenas de cristal</li>
<li><strong>Colores:</strong> negro, rojo y blanco</li>
<li><strong>Estilo :</strong> Tanga joya ultra sexy</li>
<li><strong>Detalles :</strong> Cadenas, cristales, bordados</li>
<li><strong>Ajuste :</strong> Tirantes ajustables</li>
</ul> |
| | stylingtips | | string | <p>¡Atrévete a ser totalmente provocativa! Completa tu look con nuestros <a href="https://www.divasboudoir.com/es/sexys-vestidos-talla-grande/">vestidos sexys</a> o <a href="https://www.divasboudoir.com/es/picardias-talla-grande/">picardías</a> para una seducción sin límites.</p> |
| | summary | | string | <p>Descubre el tanga <strong>joya ultra sexy</strong> que convierte cada momento en una invitación a la seducción.</p>
<p><strong>delicados bordados</strong>, <strong>cadenas de cristales</strong> y <strong>pequeños destellos</strong> para un tanga que no deja indiferente a nadie.</p> |
| | title | | string | Tanga Bijou: provocación y cristales sensuales |
| | usageinstructions | | string | <p>Este tanga joya está hecho para esos momentos en los que quieres <strong>dejar que explote tu sensualidad.</strong> Sus cadenas de cristal crean un movimiento hipnótico que no dejará a nadie boquiabierto.</p> |
|
| | fr | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage délicat à la main</li>
<li>Eau tiède (30°C maximum)</li>
<li>Lessive douce</li>
<li>Séchage à plat</li>
<li>Manipuler avec précaution les chaînettes</li>
</ul> |
| | description | | string | <p>Le string bijou explose de sensualité avec ses <strong>chaînettes de cristaux</strong> qui dansent à chacun de vos mouvements. Ses <strong>broderies délicates</strong> sur le haut du pubis révèlent une provocation subtile, tandis que les <strong>petits brillants</strong> transforment chaque regard en invitation.</p>
<p>Un string qui ne se contente pas d'habiller votre corps, mais qui le sublime avec une <strong>sensualité crue et assumée</strong>.</p>
<p>Chaque détail a été pensé pour créer un moment de pure séduction : les chaînettes qui glissent, les cristaux qui scintillent, un design qui crie votre audace.</p> |
| | guid | | string | https://dev.divasboudoir.com/fr/string-bijou-grande-taille-chaines-cristaux/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Chaînettes ornées de cristaux</strong> ultra provocantes</li>
<li><strong>Broderies délicates</strong> sur le haut du pubis</li>
<li><strong>Petits brillants</strong> qui accrochent la lumière</li>
<li><strong>String ajustable</strong> pour un confort optimal</li>
<li><strong>Trois couleurs</strong> : noir, rouge, blanc</li>
<li><strong>Design minimal</strong> mais terriblement sexy</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | String bijou grande taille avec chaînettes de cristaux. Broderies délicates, trois couleurs. Ultra sexy, provocant. Livraison rapide. Diva's Boudoir. |
| | keywords | | | title | | string | String Bijou Grande Taille Sexy | Diva's Boudoir |
|
| | seotitle | | string | String grande taille bijou avec chaînettes et cristaux |
| | seouri | | string | string-bijou-grande-taille-chaines-cristaux |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Dentelle et chaînettes de cristaux</li>
<li><strong>Couleurs :</strong> Noir, Rouge, Blanc</li>
<li><strong>Style :</strong> String bijou ultra sexy</li>
<li><strong>Détails :</strong> Chaînettes, cristaux, broderies</li>
<li><strong>Ajustement :</strong> Bretelles réglables</li>
</ul> |
| | stylingtips | | string | <p>Osez la provocation totale ! Complétez votre look avec nos <a href="https://www.divasboudoir.com/fr/robes-sexys-grande-taille/">Robes Sexys</a> ou nos <a href="https://www.divasboudoir.com/fr/deshabille-grande-taille/">déshabillés</a> pour une séduction sans limite.</p> |
| | summary | | string | <p>Découvrez le <strong>string bijou ultra sexy</strong> qui transforme chaque moment en invitation à la séduction.</p>
<p> <strong>Broderies délicates</strong>, <strong>chaînettes de cristaux</strong> et <strong>petits brillants</strong> pour un string qui ne laisse personne indifférent.</p> |
| | title | | string | String Bijou : Provocation et Cristaux Sensuels |
| | usageinstructions | | string | <p>Ce string bijou est fait pour les moments où vous voulez <strong>faire exploser votre sensualité</strong>. Ses chaînettes de cristaux créent un mouvement hypnotique qui ne laissera personne de marbre.</p> |
|
| | it | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavaggio a mano delicato</li>
<li>Acqua calda (massimo 30°C)</li>
<li>Detersivo delicato</li>
<li>Asciugare in piano</li>
<li>Maneggiare le catene con cura</li>
</ul> |
| | description | | string | <p>Il perizoma gioiello esplode di sensualità, con le sue <strong>catene di cristalli</strong> che danzano ad ogni vostro movimento. Il suo <strong>delicato ricamo</strong> sulla parte superiore del pube rivela una sottile provocazione, mentre i <strong>piccoli scintillii</strong> trasformano ogni sguardo in un invito.</p>
<p>Un perizoma che non si limita a vestire il corpo, ma lo sublima con una <strong>sensualità cruda e sicura.</strong></p>
<p>Ogni dettaglio è stato studiato per creare un momento di pura seduzione: catene scorrevoli, cristalli scintillanti, un design che grida audacia.</p> |
| | guid | | string | https://dev.divasboudoir.com/it/perizoma-gioiello-taglia-grande-catene-cristalli/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Catene ornate di cristalli</strong> ultra-provocanti</li>
<li><strong>Delicati ricami</strong> sulla parte superiore del pube</li>
<li><strong>Piccoli scintillii</strong> che catturano la luce</li>
<li><strong>Perizoma regolabile</strong> per un comfort ottimale</li>
<li><strong>Tre colori</strong>: nero, rosso, bianco</li>
<li><strong>Design minimalista</strong> ma sexy</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Un tanga di taglia grande delicatamente ricamato e ornato di gioielli. |
| | keywords | | | title | | string | Perizoma Joyas di taglia grande e regolabile |
|
| | seotitle | | string | Perizoma gioiello di taglia grande con catene e cristalli |
| | seouri | | string | perizoma-gioiello-taglia-grande-catene-cristalli |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> pizzo e catene di cristallo</li>
<li><strong>Colori:</strong> Nero, Rosso, Bianco</li>
<li><strong>Stile :</strong> Perizoma gioiello ultra sexy</li>
<li><strong>Dettagli :</strong> Catene, cristalli, ricamo</li>
<li><strong>Vestibilità :</strong> Spalline regolabili</li>
</ul> |
| | stylingtips | | string | <p>Osate essere totalmente provocanti! Completate il vostro look con i nostri <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">abiti</a> o <a href="https://www.divasboudoir.com/it/vestaglia-taglia-grande/">vestaglie</a> <a href="https://www.divasboudoir.com/it/abiti-sexys-taglia-grande/">sexy</a> per una seduzione senza limiti.</p> |
| | summary | | string | <p>Scoprite il <strong>perizoma gioiello ultra sexy</strong> che trasforma ogni momento in un invito alla seduzione.</p>
<p><strong>ricami delicati</strong>, <strong>catene di cristalli</strong> e <strong>piccoli scintillii</strong> per un tanga che non lascia indifferenti.</p> |
| | title | | string | Bijou perizoma: provocazione e cristalli sensuali |
| | usageinstructions | | string | <p>Questo perizoma gioiello è fatto per quei momenti in cui volete <strong>far esplodere la vostra sensualità.</strong> Le sue catene di cristalli creano un movimento ipnotico che non lascerà nessuno a bocca aperta.</p> |
|
| | nl | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Zacht met de hand wassen</li>
<li>Warm water (maximaal 30°C)</li>
<li>Mild wasmiddel</li>
<li>Plat drogen</li>
<li>Kettingen voorzichtig behandelen</li>
</ul> |
| | description | | string | <p>De juwelenstring barst van de sensualiteit, de <strong>kristallen kettingen</strong> dansen met elke beweging. Het <strong>delicate borduursel</strong> op de bovenkant van het schaambeen onthult een subtiele provocatie, terwijl de <strong>kleine glittertjes</strong> elke blik in een uitnodiging veranderen.</p>
<p>Een string die je lichaam niet alleen aankleedt, maar het sublimeert met <strong>rauwe, zelfverzekerde sensualiteit.</strong></p>
<p>Elk detail is ontworpen om een moment van pure verleiding te creëren: glijdende kettingen, fonkelende kristallen, een ontwerp dat durf schreeuwt.</p> |
| | guid | | string | https://dev.divasboudoir.com/nl/string-sieraad-grote-maat-kettingen-kristallen/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Kettingen versierd met</strong> ultra-provocerende<strong>kristallen</strong></li>
<li><strong>Delicaat borduurwerk</strong> bovenaan het schaambeen</li>
<li><strong>Kleine fonkelingen</strong> die het licht vangen</li>
<li><strong>Verstelbare string</strong> voor optimaal comfort</li>
<li><strong>Drie kleuren</strong>: zwart, rood, wit</li>
<li><strong>Minimalistisch</strong> maar sexy<strong>ontwerp</strong></li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Grote maat juwelenstring met kristallen kettingen. Delicaat borduurwerk in drie kleuren. Ultrasexy, uitdagend. Snelle levering. Diva's Boudoir. |
| | keywords | | | title | | string | String Bijou Grote Maat Sexy | Diva's Boudoir |
|
| | seotitle | | string | Grote maat juwelenstring met kettingen en kristallen |
| | seouri | | string | string-sieraad-grote-maat-kettingen-kristallen |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Kant en kristallen kettingen</li>
<li><strong>Kleuren:</strong> Zwart, Rood, Wit</li>
<li><strong>Stijl :</strong> Ultra sexy juwelen string</li>
<li><strong>Details :</strong> Kettingen, kristallen, borduursel</li>
<li><strong>Pasvorm :</strong> Verstelbare bandjes</li>
</ul> |
| | stylingtips | | string | <p>Durf je helemaal uit te sloven! Maak je look compleet met onze <a href="https://www.divasboudoir.com/nl/sexys-jurken-grote-maat/">sexy jurkjes</a> of <a href="https://www.divasboudoir.com/nl/grote-maat-neglige/">negligés</a> voor onbeperkte verleiding.</p> |
| | summary | | string | <p>Ontdek de <strong>ultra sexy juwelenstring</strong> die van elk moment een uitnodiging tot verleiding maakt.</p>
<p><strong>delicaat borduurwerk</strong>, <strong>kettingen van kristallen</strong> en <strong>kleine glittertjes</strong> voor een string die niemand onverschillig laat.</p> |
| | title | | string | Bijou G-string: provocatie en sensuele kristallen |
| | usageinstructions | | string | <p>Deze juwelenstring is gemaakt voor die momenten waarop je <strong>je sensualiteit wilt laten exploderen.</strong> De kristallen kettingen creëren een hypnotiserende beweging die niemand sprakeloos zal laten.</p> |
|
| | pt | Struct Entries: 15 | | abstract | | | careinstructions | | string | <ul>
<li>Lavagem suave à mão</li>
<li>Água morna (30°C no máximo)</li>
<li>Detergente suave</li>
<li>Secar na horizontal</li>
<li>Manusear as correntes com cuidado</li>
</ul> |
| | description | | string | <p>A tanga jewel explode de sensualidade, as suas <strong>correntes de cristal</strong> dançam com todos os seus movimentos. O seu <strong>delicado bordado</strong> na parte superior do púbis revela uma subtil provocação, enquanto os <strong>pequenos brilhos</strong> transformam cada olhar num convite.</p>
<p>Uma tanga que não se limita a vestir o seu corpo, mas que o sublima com uma <strong>sensualidade crua e confiante.</strong></p>
<p>Cada pormenor foi concebido para criar um momento de pura sedução: correntes deslizantes, cristais cintilantes, um design que grita ousadia.</p> |
| | guid | | string | https://dev.divasboudoir.com/pt/fio-dental-joia-tamanho-grande-correntes-cristais/sbga4825.htm |
| | highlights | | string | <ul>
<li><strong>Correntes adornadas com cristais</strong> ultra-provocantes</li>
<li><strong>Bordado delicado</strong> na parte superior do púbis</li>
<li><strong>Pequenos brilhos</strong> que captam a luz</li>
<li><strong>Tanga ajustável</strong> para um conforto ótimo</li>
<li><strong>Três cores</strong>: preto, vermelho, branco</li>
<li><strong>Design minimalista</strong> mas sexy</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Tanga grande com jóias e correntes de cristal. Bordados delicados em três cores. Ultra sexy, provocante. Entrega rápida. Diva's Boudoir. |
| | keywords | | | title | | string | Tanga Bijou Grande Taille Sexy | Diva's Boudoir |
|
| | seotitle | | string | Tanga grande com jóias, correntes e cristais |
| | seouri | | string | fio-dental-joia-tamanho-grande-correntes-cristais |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Renda e correntes de cristal</li>
<li><strong>Cores:</strong> Preto, Vermelho, Branco</li>
<li><strong>Estilo :</strong> Tanga ultra sexy com jóias</li>
<li><strong>Detalhes :</strong> Correntes, cristais, bordados</li>
<li><strong>Ajuste :</strong> Alças ajustáveis</li>
</ul> |
| | stylingtips | | string | <p>Atreva-se a ser totalmente provocante! Completa o teu look com os nossos <a href="https://www.divasboudoir.com/pt/vestidos-sexys-plus-size/">vestidos sensuais</a> ou com os nossos <a href="https://www.divasboudoir.com/pt/batotas-plus-size/">negligees</a> para uma sedução sem limites.</p> |
| | summary | | string | <p>Descubra a <strong>tanga joia ultra sexy</strong> que transforma cada momento num convite à sedução.</p>
<p><strong>bordados delicados</strong>, <strong>correntes de cristais</strong> e <strong>pequenos brilhos</strong> para uma tanga que não deixa ninguém indiferente.</p> |
| | title | | string | Bijou G-string: Provocação e cristais sensuais |
| | usageinstructions | | string | <p>Esta tanga de jóias é feita para aqueles momentos em que quer <strong>deixar a sua sensualidade explodir.</strong> As suas correntes de cristal criam um movimento hipnótico que não deixará ninguém sem palavras.</p> |
|
|
| | fetishboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -schwarz-rot-ou-weiss |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -mayro-kokkino-ou-leyko |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -black-red-ou-white |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -negro-rojo-ou-blanco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -noir-rouge-ou-blanc |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -nero-rosso-ou-bianco |
| | 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 | | string | -preto-vermelho-ou-branco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | latexboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -schwarz-rot-ou-weiss |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -mayro-kokkino-ou-leyko |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -black-red-ou-white |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -negro-rojo-ou-blanco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -noir-rouge-ou-blanc |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -nero-rosso-ou-bianco |
| | 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 | | string | -preto-vermelho-ou-branco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | legsboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Feinwäsche per Hand in lauwarmem Wasser (maximal 30°C), um die Kristalle zu erhalten</li>
<li>Verwenden Sie ein mildes Waschmittel speziell für feine Dessous</li>
<li>Gehen Sie vorsichtig mit den Kettchen und Kristallen um</li>
<li>Flach liegend vor direktem Licht geschützt trocknen</li>
<li>Sorgfältig aufbewahren, um die Schmuckdetails zu erhalten</li>
</ul> |
| | description | | string | <p>Der Juwelen-String verkörpert die Kunst der raffinierten Lingerie mit seinen <strong>zarten Stickereien</strong>, die den oberen Teil des Schambereichs harmonisch verzieren.</p>
<p>Die <strong>Kristallketten</strong> erzeugen eine anmutige Bewegung, die Ihre Bewegungen natürlich begleitet, während die <strong>kleinen</strong> eingearbeiteten <strong>Brillanten</strong> dieses Stück in ein wahres Dessous-Schmuckstück verwandeln. Diese Kreation ist eine perfekte Kombination aus <strong>Komfort und Ästhetik</strong>, da sich das verstellbare Design sanft an jede Körperform anpasst.</p>
<p>Die <strong>sorgfältige Verarbeitung</strong> verrät die Aufmerksamkeit, die jedem Detail gewidmet wurde, und schafft ein Stück, das Sie elegant begleitet. Erhältlich in <strong>drei zeitlosen Farben</strong> - geheimnisvolles Schwarz, leidenschaftliches Rot und reines Weiß - offenbart jede Version eine andere Facette Ihrer Persönlichkeit.</p>
<p>Dieses einzigartige Stück verwandelt jeden Moment in eine Gelegenheit, bei der Sie sich natürlich selbstbewusst und raffiniert fühlen.</p> |
| | highlights | | string | <ul>
<li><strong>Zarte Stickereien</strong> auf dem oberen Schambereich mit raffinierten Mustern</li>
<li><strong>Mit Kristallen verzierte Ketten</strong>, die das Licht sanft auffangen</li>
<li>Eingearbeitete<strong>kleine Brillanten</strong> für einen raffinierten Schmuckeffekt.</li>
<li><strong>Verstellbarer String</strong>, der sich an jede Körperform anpasst</li>
<li><strong>Drei Farben</strong>: Schwarz, Rot, Weiß</li>
<li><strong>Sorgfältige Verarbeitung</strong> wie bei einem Dessous-Schmuckstück</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Schmuckstring in großen Größen mit zarten Stickereien und Kristallketten. Drei raffinierte Farben, sorgfältige Verarbeitung. Eleganz und Komfort bei Leg's Boudoir. |
| | keywords | | | title | | string | Juwelen-String Große Größe Kristalle | Leg's Boudoir |
|
| | seotitle | | string | String große Größe Juwelen Stickerei Ketten Kristalle |
| | seouri | | string | juwelen-string-grosse-grosse-stickerei-kristalle |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Zarte Stickereien und Kristallketten (92% Viskose, 8% Elasthan)</li>
<li><strong>Farben:</strong> Schwarz, Rot, Weiß</li>
<li><strong>Stil:</strong> Schmuck-String mit Stickereien und Kristallsteinen</li>
<li><strong>Details:</strong> Bewegliche Ketten, kleine eingearbeitete Brillanten</li>
<li><strong>Passform:</strong> Verstellbare Träger für optimalen Tragekomfort</li>
<li><strong>Verarbeitung:</strong> Sorgfältig mit Liebe zum Detail</li>
</ul> |
| | stylingtips | | string | <p>Der Schmuckstring zeichnet sich durch seine <strong>kristallklaren Details</strong> aus, die einen raffinierten Stil kreieren. Für eine perfekte Harmonie kombinieren Sie ihn mit Teilen, die seine Eleganz verlängern. Vervollständigen Sie Ihren Look mit unseren <a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse/">selbstfixierenden Strümpfen</a> in <a href="https://www.legsboudoir.com/de/selbstfixierende-strumpfe-grosse-grosse/">großen Größen</a> für absolute Raffinesse, oder entdecken Sie unsere <a href="https://www.legsboudoir.com/de/selbstbindende-strumpfe/">selbstfixierenden Strümpfe</a> in allen Größen, um Ihre Beine mit der gleichen Liebe zum Detail zu betonen.</p> |
| | summary | | string | <p>Entdecken Sie den Schmuckstring, bei dem <strong>zarte Stickereien</strong> auf <strong>Kristallketten</strong> treffen, um ein Stück von außergewöhnlicher Eleganz zu schaffen.</p>
<p>Eine Kreation, die Ihre Silhouette auf natürliche Weise raffiniert hervorhebt.</p> |
| | title | | string | Juwelen-String: Eleganz und kristalline Raffinesse |
| | usageinstructions | | string | <p>Der Juwelen-String wurde für Momente entworfen, in denen Sie <strong>Komfort und Raffinesse</strong> miteinander verbinden möchten. Seine <strong>Kristallketten</strong> erzeugen eine zarte Bewegung, die Ihre Bewegungen natürlich begleitet. Passen Sie die Träger an Ihre Körperform an, um einen optimalen Tragekomfort zu gewährleisten.</p>
<p>Die <strong>zarten Stickereien</strong> und <strong>kleinen Brillanten</strong> erzeugen einen subtilen Effekt, der Ihre Vorliebe für raffinierte Details offenbart.</p> |
|
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Πλύνετε απαλά στο χέρι με χλιαρό νερό (30°C το πολύ) για να διατηρήσετε τους κρυστάλλους</li>
<li>Χρησιμοποιήστε ένα ήπιο απορρυπαντικό για λεπτά εσώρουχα</li>
<li>Να χειρίζεστε τις αλυσίδες και τα κρύσταλλα με προσοχή</li>
<li>Στεγνώστε σε επίπεδη επιφάνεια μακριά από το άμεσο φως</li>
<li>Αποθηκεύστε προσεκτικά για να διατηρήσετε τις λεπτομέρειες των κοσμημάτων</li>
</ul> |
| | description | | string | <p>Το στρινγκ κόσμημα ενσαρκώνει την τέχνη των εκλεπτυσμένων εσωρούχων, με <strong>λεπτεπίλεπτο κέντημα</strong> που κοσμεί αρμονικά την κορυφή του εφηβαίου.</p>
<p>Οι <strong>κρυστάλλινες αλυσίδες</strong> δημιουργούν μια χαριτωμένη κίνηση που συνοδεύει φυσικά τις κινήσεις σας, ενώ οι ενσωματωμένες <strong>λάμψεις</strong> μετατρέπουν αυτό το κομμάτι σε ένα πραγματικό κόσμημα εσωρούχων. Αυτή η δημιουργία συνδυάζει τέλεια <strong>την άνεση και την αισθητική</strong>, χάρη στον ρυθμιζόμενο σχεδιασμό της που προσαρμόζεται απαλά σε όλα τα σχήματα του σώματος.</p>
<p>Το <strong>σχολαστικό φινίρισμα</strong> αποκαλύπτει την προσοχή που έχει δοθεί σε κάθε λεπτομέρεια, δημιουργώντας ένα κομμάτι που σας συνοδεύει με κομψότητα. Διαθέσιμο σε <strong>τρία διαχρονικά χρώματα</strong> - το μυστηριώδες μαύρο, το παθιασμένο κόκκινο και το καθαρό λευκό - κάθε έκδοση αποκαλύπτει μια διαφορετική πτυχή της προσωπικότητάς σας.</p>
<p>Αυτό το μοναδικό κομμάτι μετατρέπει κάθε στιγμή σε μια ευκαιρία να νιώσετε φυσικά σίγουροι και εκλεπτυσμένοι.</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 | Μεγάλο στρινγκ με κοσμήματα, λεπτό κέντημα και κρυστάλλινες αλυσίδες. Τρία εκλεπτυσμένα χρώματα, με προσεγμένο φινίρισμα. Κομψότητα και άνεση στο Leg's Boudoir. |
| | keywords | | | title | | string | Στρινγκ κόσμημα μεγάλο μέγεθος κρύσταλλα | Μπουντουάρ του ποδιού |
|
| | seotitle | | string | G-string μεγάλο μέγεθος κοσμήματα κέντημα αλυσίδες κρύσταλλα |
| | seouri | | string | megalo-megethos-stringk-me-kosmhmata-kai-krystallina-kenthmata |
| | specifications | | string | <ul>
<li><strong>Υλικό:</strong> Λεπτά κεντήματα και κρυστάλλινες αλυσίδες (92% βισκόζη, 8% ελαστάν)</li>
<li><strong>Χρώματα:</strong> Μαύρο, Κόκκινο, Λευκό</li>
<li><strong>Στυλ:</strong> Στρινγκ με κοσμήματα, κεντήματα και κρύσταλλα</li>
<li><strong>Λεπτομέρειες:</strong> Κινητές αλυσίδες, ενσωματωμένες λάμψεις</li>
<li><strong>Εφαρμογή:</strong> Ρυθμιζόμενοι ιμάντες για βέλτιστη άνεση</li>
<li><strong>Τελειώματα:</strong> Προσεγμένη προσοχή στη λεπτομέρεια</li>
</ul> |
| | stylingtips | | string | <p>Το στρινγκ με κοσμήματα διακρίνεται για τις <strong>κρυστάλλινες λεπτομέρειες</strong> που δημιουργούν ένα εκλεπτυσμένο στυλ. Για τέλεια αρμονία, συνδυάστε το με κομμάτια που επεκτείνουν την κομψότητά του. Ολοκληρώστε την εμφάνισή σας με <a href="https://www.legsboudoir.com/el/hold-ups-large/">τα μεγάλα μεγέθη</a> μας για απόλυτη εκλέπτυνση ή ανακαλύψτε <a href="https://www.legsboudoir.com/el/kaltses-stay-up/">τα μαγιό</a> μας σε όλα τα μεγέθη για να αναδείξετε τα πόδια σας με την ίδια προσοχή στη λεπτομέρεια.</p> |
| | summary | | string | <p>Ανακαλύψτε το στρινγκ κόσμημα, όπου <strong>το λεπτό κέντημα</strong> συναντά <strong>τις κρυστάλλινες αλυσίδες</strong> για να δημιουργήσει ένα κομμάτι εξαιρετικής κομψότητας.</p>
<p>Μια δημιουργία που ενισχύει φυσικά τη σιλουέτα σας με φινέτσα.</p> |
| | title | | string | String Bijou : Κομψότητα και κρυστάλλινη φινέτσα |
| | usageinstructions | | string | <p>Το στρινγκ κόσμημα έχει σχεδιαστεί για τις στιγμές εκείνες που θέλετε να συνδυάσετε <strong>άνεση και φινέτσα</strong>. <strong>Οι κρυστάλλινες αλυσίδες</strong> του δημιουργούν μια λεπτή κίνηση που συνοδεύει φυσικά τις κινήσεις σας. Προσαρμόστε τα λουράκια στο σχήμα του σώματός σας για βέλτιστη άνεση.</p>
<p>Το <strong>λεπτό κέντημα</strong> και οι <strong>μικροσκοπικές λάμψεις</strong> δημιουργούν ένα διακριτικό αποτέλεσμα που αποκαλύπτει το γούστο σας για εκλεπτυσμένες λεπτομέρειες.</p> |
|
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Hand-wash gently in lukewarm water (30°C maximum) to preserve crystals</li>
<li>Use a mild detergent for fine lingerie</li>
<li>Handle chains and crystals with care</li>
<li>Dry flat away from direct light</li>
<li>Store with care to preserve jewelry details</li>
</ul> |
| | description | | string | <p>The jewel thong embodies the art of refined lingerie, with its <strong>delicate embroidery</strong> harmoniously adorning the top of the pubis.</p>
<p><strong>Crystal chains</strong> create a graceful movement that naturally accompanies your gestures, while integrated <strong>sparkles</strong> transform this piece into a veritable jewel of lingerie. This creation perfectly combines <strong>comfort and aesthetics</strong>, thanks to its adjustable design that gently adapts to all morphologies.</p>
<p>The <strong>meticulous finishing</strong> reveals the attention paid to every detail, creating a piece that accompanies you with elegance. Available in <strong>three timeless colors</strong> - mysterious black, passionate red and pure white - each version reveals a different facet of your personality.</p>
<p>This unique piece transforms every moment into an opportunity to feel naturally confident and refined.</p> |
| | highlights | | string | <ul>
<li><strong>Delicate embroidery</strong> on the top of the pubis with sophisticated motifs</li>
<li><strong>Chains adorned with crystals</strong> that delicately catch the light</li>
<li>Integrated<strong>sparkles</strong> for a refined jewel effect</li>
<li><strong>Adjustable thong</strong> to suit all body shapes</li>
<li><strong>Three colors</strong>: black, red, white</li>
<li><strong>Finishes</strong> worthy of a lingerie jewel</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Plus size jewel thong with delicate embroidery and crystal chains. Three refined colors, meticulously finished. Elegance and comfort at Leg's Boudoir. |
| | keywords | | | title | | string | Thong Jewel Plus Size Crystals | Leg's Boudoir |
|
| | seotitle | | string | G-string plus size jewel embroidery chains crystals |
| | seouri | | string | jewel-thong-plus-size-crystal-embroidery |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Delicate embroidery and crystal chains (92% viscose, 8% elastane)</li>
<li><strong>Colors:</strong> Black, Red, White</li>
<li><strong>Style:</strong> Jewel thong with embroidery and crystals</li>
<li><strong>Details:</strong> Movable chains, small integrated sparkles</li>
<li><strong>Fit :</strong> Adjustable straps for optimum comfort</li>
<li><strong>Finishes:</strong> Careful attention to detail</li>
</ul> |
| | stylingtips | | string | <p>Jewel thongs feature <strong>crystalline details</strong> that create a sophisticated look. For perfect harmony, pair it with pieces that will extend its elegance. Complete your look with our <a href="https://www.legsboudoir.com/en/hold-ups-plus-size/">plus size hold-ups</a> for total sophistication, or discover our <a href="https://www.legsboudoir.com/en/stay-up-stockings/">hold-ups</a> in all sizes to sublimate your legs with the same attention to detail.</p> |
| | summary | | string | <p>Discover the jewel thong, where <strong>delicate embroidery</strong> meets <strong>crystal chains</strong> to create a piece of exceptional elegance.</p>
<p>A creation that naturally enhances your silhouette with refinement.</p> |
| | title | | string | String Bijou: Crystal elegance and refinement |
| | usageinstructions | | string | <p>The jewel thong is designed for those moments when you want to combine <strong>comfort and refinement</strong>. Its <strong>crystal chains</strong> create a delicate movement that naturally accompanies your movements. Adjust the straps to your body shape for optimum comfort.</p>
<p><strong>Delicate embroidery</strong> and <strong>small sparkles</strong> create a subtle effect that reveals your taste for refined details.</p> |
|
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar a mano suavemente en agua tibia (30°C como máximo) para preservar los cristales</li>
<li>Utilice un detergente suave para lencería fina</li>
<li>Manipule las cadenas y los cristales con cuidado</li>
<li>Secar en plano, lejos de la luz directa</li>
<li>Guardar con cuidado para conservar los detalles de las joyas</li>
</ul> |
| | description | | string | <p>El tanga joya encarna el arte de la lencería refinada, con <strong>delicados bordados</strong> que adornan armoniosamente la parte superior del pubis.</p>
<p>Las <strong>cadenas de cristal</strong> crean un movimiento grácil que acompaña con naturalidad tus movimientos, mientras que los <strong>destellos</strong> integrados convierten esta pieza en una auténtica joya de la lencería. Esta creación combina a la perfección <strong>comodidad y estética</strong>, gracias a su diseño ajustable que se adapta suavemente a todas las formas del cuerpo.</p>
<p>El <strong>meticuloso acabado</strong> revela la atención prestada a cada detalle, creando una pieza que te acompaña con elegancia. Disponible en <strong>tres colores atemporales</strong> -negro misterioso, rojo pasión y blanco puro-, cada versión revela una faceta diferente de tu personalidad.</p>
<p>Esta pieza única transforma cada momento en una oportunidad para sentirse naturalmente segura y refinada.</p> |
| | highlights | | string | <ul>
<li><strong>Delicado bordado</strong> en la parte superior del pubis con sofisticados motivos</li>
<li><strong>Cadenas adornadas con cristales</strong> que captan suavemente la luz</li>
<li><strong>Destellos</strong> integrados para un refinado efecto joya</li>
<li><strong>Tanga ajustable</strong> para adaptarse a todas las formas del cuerpo</li>
<li><strong>Tres colores</strong>: negro, rojo y blanco</li>
<li><strong>Acabado con el esmero</strong> de una joya de lencería</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Tanga joya de talla grande con delicados bordados y cadenas de cristal. Tres refinados colores, meticulosamente acabados. Elegancia y comodidad en Leg's Boudoir. |
| | keywords | | | title | | string | Tanga Joya Talla grande Cristales | Leg's Boudoir |
|
| | seotitle | | string | Tanga talla grande joya bordado cadenas cristales |
| | seouri | | string | tanga-joya-talla-grande-con-bordado-de-cristales |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Delicados bordados y cadenas de cristal (92% viscosa, 8% elastán)</li>
<li><strong>Colores:</strong> negro, rojo y blanco</li>
<li><strong>Estilo:</strong> Tanga joya con bordados y cristales</li>
<li><strong>Detalles:</strong> Cadenas móviles, brillos integrados</li>
<li><strong>Ajuste :</strong> Tirantes ajustables para un confort óptimo</li>
<li><strong>Acabados</strong>: Cuidada atención al detalle</li>
</ul> |
| | stylingtips | | string | <p>El tanga joya presenta <strong>detalles cristalinos</strong> que crean un estilo sofisticado. Para una armonía perfecta, combínalo con piezas que amplíen su elegancia. Completa tu look con nuestras <a href="https://www.legsboudoir.com/es/medias-autoportantes/">medias</a> <a href="https://www.legsboudoir.com/es/medias-talla-grande/">de talla grande</a> para una sofisticación total, o descubre nuestras <a href="https://www.legsboudoir.com/es/medias-autoportantes/">medias</a> de todas las tallas para realzar tus piernas con la misma atención al detalle.</p> |
| | summary | | string | <p>Descubra el tanga joya, donde el <strong>delicado bordado</strong> se une a <strong>las cadenas de cristal</strong> para crear una pieza de elegancia excepcional.</p>
<p>Una creación que realza naturalmente tu figura con refinamiento.</p> |
| | title | | string | String Bijou : Elegancia y refinamiento cristalino |
| | usageinstructions | | string | <p>El tanga joya está pensado para esos momentos en los que desea combinar <strong>comodidad y refinamiento</strong>. Sus <strong>cadenas de cristal</strong> crean un delicado movimiento que acompaña con naturalidad tus movimientos. Ajusta los tirantes a la forma de tu cuerpo para un confort óptimo.</p>
<p>El <strong>delicado bordado</strong> y los <strong>diminutos destellos</strong> crean un sutil efecto que revela su gusto por los detalles refinados.</p> |
|
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Lavage délicat à la main à l'eau tiède (30°C maximum) pour préserver les cristaux</li>
<li>Utiliser une lessive douce spéciale lingerie fine</li>
<li>Manipuler avec précaution les chaînettes et cristaux</li>
<li>Séchage à plat à l'abri de la lumière directe</li>
<li>Ranger avec soin pour préserver les détails bijoux</li>
</ul> |
| | description | | string | <p>Le string bijou incarne l'art de la lingerie raffinée avec ses <strong>broderies délicates</strong> qui ornent harmonieusement le haut du pubis.</p>
<p>Les <strong>chaînettes de cristaux</strong> créent un mouvement gracieux qui accompagne naturellement vos gestes, tandis que les <strong>petits brillants</strong> intégrés transforment cette pièce en véritable bijou de lingerie. Cette création allie parfaitement <strong>confort et esthétisme</strong> grâce à sa conception ajustable qui s'adapte délicatement à toutes les morphologies.</p>
<p>Les <strong>finitions soignées</strong> révèlent l'attention portée à chaque détail, créant une pièce qui vous accompagne avec élégance. Disponible en <strong>trois coloris intemporels</strong> - noir mystérieux, rouge passion et blanc pur - chaque version révèle une facette différente de votre personnalité.</p>
<p>Cette pièce unique transforme chaque moment en occasion de vous sentir naturellement confiante et raffinée.</p> |
| | highlights | | string | <ul>
<li><strong>Broderies délicates</strong> sur le haut du pubis avec motifs sophistiqués</li>
<li><strong>Chaînettes ornées de cristaux</strong> qui accrochent délicatement la lumière</li>
<li><strong>Petits brillants</strong> intégrés pour un effet bijou raffiné</li>
<li><strong>String ajustable</strong> qui s'adapte à toutes les morphologies</li>
<li><strong>Trois coloris</strong> : noir, rouge, blanc</li>
<li><strong>Finitions soignées</strong> dignes d'un bijou de lingerie</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | String bijou grande taille avec broderies délicates et chaînettes de cristaux. Trois coloris raffinés, finitions soignées. Élégance et confort chez Leg's Boudoir. |
| | keywords | | | title | | string | String Bijou Grande Taille Cristaux | Leg's Boudoir |
|
| | seotitle | | string | String grande taille bijou broderies chaînettes cristaux |
| | seouri | | string | string-bijou-grande-taille-broderies-cristaux |
| | specifications | | string | <ul>
<li><strong>Matière :</strong> Broderies délicates et chaînettes de cristaux (92% viscose, 8% élasthanne)</li>
<li><strong>Couleurs :</strong> Noir, Rouge, Blanc</li>
<li><strong>Style :</strong> String bijou avec broderies et cristaux</li>
<li><strong>Détails :</strong> Chaînettes mobiles, petits brillants intégrés</li>
<li><strong>Ajustement :</strong> Bretelles réglables pour un confort optimal</li>
<li><strong>Finitions :</strong> Soignées avec attention aux détails</li>
</ul> |
| | stylingtips | | string | <p>Le string bijou se distingue par ses <strong>détails cristallins</strong> qui créent un style sophistiqué. Pour une harmonie parfaite, associez-le à des pièces qui prolongeront son élégance. Complétez votre look avec nos <a href="https://www.legsboudoir.com/fr/bas-autofixants-grande-taille/">bas autofixants grande taille</a> pour une sophistication totale, ou découvrez nos <a href="https://www.legsboudoir.com/fr/bas-autofixants/">bas autofixants</a> dans toutes les tailles pour sublimer vos jambes avec la même attention aux détails.</p> |
| | summary | | string | <p>Découvrez le string bijou, où les <strong>broderies délicates</strong> rencontrent des <strong>chaînettes de cristaux</strong> pour créer une pièce d'une élégance exceptionnelle.</p>
<p>Une création qui sublime naturellement votre silhouette avec raffinement.</p> |
| | title | | string | String Bijou : Élégance et Raffinement Cristallin |
| | usageinstructions | | string | <p>Le string bijou est conçu pour les moments où vous souhaitez allier <strong>confort et raffinement</strong>. Ses <strong>chaînettes de cristaux</strong> créent un mouvement délicat qui accompagne naturellement vos gestes. Ajustez les bretelles selon votre morphologie pour un confort optimal.</p>
<p>Les <strong>broderies délicates</strong> et les <strong>petits brillants</strong> créent un effet subtil qui révèle votre goût pour les détails raffinés.</p> |
|
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Lavare delicatamente a mano in acqua tiepida (massimo 30°C) per preservare i cristalli</li>
<li>Utilizzare un detersivo delicato per la lingerie fine</li>
<li>Maneggiare con cura catene e cristalli</li>
<li>Asciugare in piano lontano dalla luce diretta</li>
<li>Conservare con cura per preservare i dettagli dei gioielli</li>
</ul> |
| | description | | string | <p>Il perizoma gioiello incarna l'arte della lingerie raffinata, con un <strong>delicato ricamo</strong> che adorna armoniosamente la parte superiore del pube.</p>
<p>Le <strong>catene di cristallo</strong> creano un movimento aggraziato che accompagna naturalmente i vostri movimenti, mentre i <strong>brillantini</strong> integrati trasformano questo pezzo in un vero e proprio gioiello di lingerie. Questa creazione combina perfettamente <strong>comfort ed estetica</strong>, grazie al suo design regolabile che si adatta delicatamente a tutte le forme del corpo.</p>
<p>La <strong>finitura meticolosa</strong> rivela l'attenzione prestata a ogni dettaglio, creando un capo che vi accompagna con eleganza. Disponibile in <strong>tre colori senza tempo</strong> - nero misterioso, rosso passionale e bianco puro - ogni versione rivela una sfaccettatura diversa della vostra personalità.</p>
<p>Questo pezzo unico trasforma ogni momento in un'occasione per sentirsi naturalmente sicuri e raffinati.</p> |
| | highlights | | string | <ul>
<li><strong>Delicato ricamo</strong> sulla parte superiore del pube con motivi sofisticati</li>
<li><strong>Catene ornate di cristalli</strong> che catturano delicatamente la luce</li>
<li><strong>Scintille</strong> integrate per un raffinato effetto gioiello</li>
<li><strong>Perizoma regolabile</strong> per adattarsi a tutte le forme del corpo</li>
<li><strong>Tre colori</strong>: nero, rosso, bianco</li>
<li><strong>Rifinito con la cura</strong> di un gioiello di lingerie</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Perizoma gioiello di grande taglia con delicati ricami e catene di cristalli. Tre colori raffinati, minuziosamente rifiniti. Eleganza e comfort da Leg's Boudoir. |
| | keywords | | | title | | string | Perizoma Gioiello Taglia Grande Cristalli | Gamba Boudoir |
|
| | seotitle | | string | Perizoma di taglia grande ricamo gioiello catene cristalli |
| | seouri | | string | perizoma-gioiello-di-taglia-grande-con-ricamo-in-cristallo |
| | specifications | | string | <ul>
<li><strong>Materiale:</strong> Delicati ricami e catene di cristalli (92% viscosa, 8% elastan)</li>
<li><strong>Colori:</strong> nero, rosso, bianco</li>
<li><strong>Stile:</strong> Perizoma gioiello con ricami e cristalli</li>
<li><strong>Dettagli:</strong> Catene mobili, scintille integrate</li>
<li><strong>Vestibilità :</strong> Spalline regolabili per un comfort ottimale</li>
<li><strong>Finiture:</strong> Cura dei dettagli</li>
</ul> |
| | stylingtips | | string | <p>Il tanga gioiello si distingue per i suoi <strong>dettagli cristallini</strong> che creano uno stile sofisticato. Per un'armonia perfetta, abbinatelo a capi che ne esaltino l'eleganza. Completate il vostro look con le nostre <a href="https://www.legsboudoir.com/it/Calze autoreggenti di taglia grande/">autoreggenti di taglia grande</a> per una raffinatezza totale, oppure scoprite le nostre <a href="https://www.legsboudoir.com/it/calze-autoreggenti/">autoreggenti</a> di tutte le taglie per valorizzare le vostre gambe con la stessa attenzione ai dettagli.</p> |
| | summary | | string | <p>Scoprite il perizoma gioiello, dove i <strong>ricami delicati</strong> incontrano le <strong>catene di cristalli</strong> per creare un pezzo di eccezionale eleganza.</p>
<p>Una creazione che valorizza naturalmente la vostra figura con raffinatezza.</p> |
| | title | | string | String Bijou: eleganza e raffinatezza dei cristalli |
| | usageinstructions | | string | <p>Il perizoma gioiello è pensato per i momenti in cui si desidera combinare <strong>comfort e raffinatezza</strong>. Le sue <strong>catene di cristalli</strong> creano un movimento delicato che accompagna naturalmente i vostri movimenti. Regolate le spalline in base alla forma del vostro corpo per un comfort ottimale.</p>
<p>I <strong>ricami delicati</strong> e i <strong>piccoli scintillii</strong> creano un effetto discreto che rivela il vostro gusto per i dettagli raffinati.</p> |
|
| | nl | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Voorzichtig met de hand wassen in lauwwarm water (maximaal 30°C) om de kristallen te behouden</li>
<li>Gebruik een mild wasmiddel voor fijne lingerie</li>
<li>Wees voorzichtig met kettingen en kristallen</li>
<li>Droog plat en uit de buurt van direct licht</li>
<li>Voorzichtig opbergen om de details van de sieraden te behouden</li>
</ul> |
| | description | | string | <p>De juwelenstring belichaamt de kunst van verfijnde lingerie, met <strong>delicaat borduurwerk</strong> dat harmonieus de bovenkant van het schaambeen siert.</p>
<p>De <strong>kristallen kettingen</strong> creëren een sierlijke beweging die je bewegingen op natuurlijke wijze begeleidt, terwijl de geïntegreerde <strong>glitters</strong> van dit stuk een echt lingeriejuweel maken. Deze creatie combineert perfect <strong>comfort en esthetiek</strong>, dankzij het verstelbare ontwerp dat zich zachtjes aanpast aan alle lichaamsvormen.</p>
<p>De <strong>zorgvuldige afwerking</strong> onthult de aandacht die is besteed aan elk detail, waardoor een stuk is ontstaan dat je elegant begeleidt. Verkrijgbaar in <strong>drie tijdloze kleuren</strong> - mysterieus zwart, gepassioneerd rood en puur wit - onthult elke versie een ander facet van je persoonlijkheid.</p>
<p>Dit unieke stuk verandert elk moment in een kans om je natuurlijk zelfverzekerd en verfijnd te voelen.</p> |
| | highlights | | string | <ul>
<li><strong>Delicaat borduurwerk</strong> op de bovenkant van het schaambeen met verfijnde motieven</li>
<li><strong>Kettingen versierd met kristallen</strong> die zachtjes het licht vangen</li>
<li>Geïntegreerde<strong>glitters</strong> voor een verfijnd juweleneffect</li>
<li><strong>Verstelbare string</strong> voor alle lichaamsvormen</li>
<li><strong>Drie kleuren</strong>: zwart, rood, wit</li>
<li><strong>Afgewerkt met de zorg</strong> van een lingeriejuweel</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Grote maat juwelenstring met delicaat borduurwerk en kristallen kettingen. Drie verfijnde kleuren, zorgvuldig afgewerkt. Elegantie en comfort bij Leg's Boudoir. |
| | keywords | | | title | | string | String Jewel Grote Maat Kristallen | Leg's Boudoir |
|
| | seotitle | | string | G-string grote maat juweel borduurwerk kettingen kristallen |
| | seouri | | string | grote-maat-juwelenstring-met-kristallen-borduursel |
| | specifications | | string | <ul>
<li><strong>Materiaal:</strong> Delicaat borduurwerk en kristallen kettingen (92% viscose, 8% elastaan)</li>
<li><strong>Kleuren:</strong> Zwart, Rood, Wit</li>
<li><strong>Stijl:</strong> Juwelenstring met borduursel en kristallen</li>
<li><strong>Details:</strong> beweegbare kettingen, geïntegreerde glitters</li>
<li><strong>Pasvorm :</strong> Verstelbare bandjes voor optimaal comfort</li>
<li><strong>Afwerking:</strong> Zorgvuldige aandacht voor detail</li>
</ul> |
| | stylingtips | | string | <p>De juwelenstring valt op door de <strong>kristallen details</strong> die een verfijnde stijl creëren. Voor een perfecte harmonie combineer je hem met stukken die zijn elegantie verlengen. Maak je look compleet met onze <a href="https://www.legsboudoir.com/nl/hold-ups-grote-maten/">grote hold ups</a> voor totale verfijning, of ontdek onze <a href="https://www.legsboudoir.com/nl/ophoudende-kousen/">hold ups</a> in alle maten om je benen te verbeteren met dezelfde aandacht voor detail.</p> |
| | summary | | string | <p>Ontdek de juwelenstring, waar <strong>delicaat borduurwerk</strong> samenkomt met <strong>kristallen kettingen</strong> om een stuk van uitzonderlijke elegantie te creëren.</p>
<p>Een creatie die je figuur op natuurlijke en geraffineerde wijze benadrukt.</p> |
| | title | | string | String Bijou : Elegantie en kristalverfijning |
| | usageinstructions | | string | <p>De juwelenstring is ontworpen voor momenten waarop je <strong>comfort en verfijning</strong> wilt combineren. De <strong>kristallen kettingen</strong> creëren een delicate beweging die je bewegingen op natuurlijke wijze begeleidt. Pas de bandjes aan je lichaamsvorm aan voor optimaal comfort.</p>
<p>Het <strong>delicate borduursel</strong> en <strong>de kleine glittertjes</strong> creëren een subtiel effect dat je smaak voor verfijnde details onthult.</p> |
|
| | pt | Struct Entries: 14 | | abstract | | | careinstructions | | string | <ul>
<li>Lavar suavemente à mão em água morna (30°C no máximo) para preservar os cristais</li>
<li>Utilizar um detergente suave para lingerie fina</li>
<li>Manusear as correntes e os cristais com cuidado</li>
<li>Secar ao abrigo da luz direta</li>
<li>Guardar cuidadosamente para preservar os pormenores das jóias</li>
</ul> |
| | description | | string | <p>A tanga jewel encarna a arte da lingerie requintada, com <strong>bordados delicados</strong> que adornam harmoniosamente a parte superior do púbis.</p>
<p>As <strong>correntes de cristal</strong> criam um movimento gracioso que acompanha naturalmente os seus movimentos, enquanto os <strong>brilhos</strong> integrados transformam esta peça numa verdadeira joia de lingerie. Esta criação combina perfeitamente <strong>conforto e estética</strong>, graças ao seu design ajustável que se adapta suavemente a todas as formas do corpo.</p>
<p>O <strong>acabamento meticuloso</strong> revela a atenção dada a cada detalhe, criando uma peça que a acompanha com elegância. Disponível em <strong>três cores intemporais</strong> - preto misterioso, vermelho apaixonado e branco puro - cada versão revela uma faceta diferente da sua personalidade.</p>
<p>Esta peça única transforma cada momento numa oportunidade para se sentir naturalmente confiante e refinada.</p> |
| | highlights | | string | <ul>
<li><strong>Bordado delicado</strong> na parte superior do púbis com motivos sofisticados</li>
<li><strong>Correntes adornadas com cristais</strong> que captam suavemente a luz</li>
<li><strong>Brilhos</strong> integrados para um efeito de joalharia requintada</li>
<li><strong>Tanga ajustável</strong> para se adaptar a todas as formas do corpo</li>
<li><strong>Três cores</strong>: preto, vermelho e branco</li>
<li><strong>Acabamento com o cuidado</strong> de uma joia de lingerie</li>
</ul> |
| | keypoint | | | keywords | | | metas | | Struct | | description | | string | Tanga grande com jóias, bordados delicados e correntes de cristais. Três cores refinadas, meticulosamente acabadas. Elegância e conforto em Leg's Boudoir. |
| | keywords | | | title | | string | Tanga Joia Tamanho Grande Cristais | Leg's Boudoir |
|
| | seotitle | | string | Tanga de tamanho grande com bordados de jóias e correntes de cristais |
| | seouri | | string | tanga-de-joias-de-tamanho-grande-com-bordado-de-cristais |
| | specifications | | string | <ul>
<li><strong>Material:</strong> Bordados delicados e correntes de cristais (92% viscose, 8% elastano)</li>
<li><strong>Cores:</strong> Preto, Vermelho, Branco</li>
<li><strong>Estilo:</strong> Tanga de jóias com bordados e cristais</li>
<li><strong>Detalhes:</strong> Correntes móveis, brilhantes integrados</li>
<li><strong>Ajuste :</strong> Alças ajustáveis para um conforto ótimo</li>
<li><strong>Acabamentos:</strong> Atenção cuidada aos pormenores</li>
</ul> |
| | stylingtips | | string | <p>A tanga jewel distingue-se pelos seus <strong>detalhes cristalinos</strong> que criam um estilo sofisticado. Para uma harmonia perfeita, combine-a com peças que aumentem a sua elegância. Complete o seu look com as nossas cuecas <a href="https://www.legsboudoir.com/pt/Meias de liga tamanho grande/">de tamanho grande</a> para uma sofisticação total, ou descubra as nossas <a href="https://www.legsboudoir.com/pt/meias-de-ligas/">cuecas</a> de todos os tamanhos para realçar as suas pernas com a mesma atenção aos detalhes.</p> |
| | summary | | string | <p>Descubra a tanga jewel, onde <strong>os bordados delicados</strong> se juntam às <strong>correntes de cristal</strong> para criar uma peça de elegância excecional.</p>
<p>Uma criação que realça naturalmente a sua figura com requinte.</p> |
| | title | | string | String Bijou : Elegância e requinte do cristal |
| | usageinstructions | | string | <p>A tanga jewel foi concebida para aqueles momentos em que se pretende aliar <strong>conforto e requinte</strong>. As suas <strong>correntes de cristais</strong> criam um movimento delicado que acompanha naturalmente os seus movimentos. Ajuste as tiras à forma do seu corpo para um conforto ideal.</p>
<p>Os <strong>bordados delicados</strong> e <strong>os pequenos brilhos</strong> criam um efeito subtil que revela o seu gosto pelos detalhes refinados.</p> |
|
|
| | lustboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -schwarz-rot-ou-weiss |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -mayro-kokkino-ou-leyko |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -black-red-ou-white |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -negro-rojo-ou-blanco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -noir-rouge-ou-blanc |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -nero-rosso-ou-bianco |
| | 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 | | string | -preto-vermelho-ou-branco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
| | smboudoir | | Struct | | de | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -schwarz-rot-ou-weiss |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | el | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -mayro-kokkino-ou-leyko |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | en | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -black-red-ou-white |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | es | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -negro-rojo-ou-blanco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | fr | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -noir-rouge-ou-blanc |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
| | it | Struct Entries: 14 | | abstract | | | careinstructions | | | description | | | highlights | | | keypoint | | | keywords | | | metas | | Struct | | description | | | keywords | | | title | |
| | seotitle | | | seouri | | string | -nero-rosso-ou-bianco |
| | 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 | | string | -preto-vermelho-ou-branco |
| | specifications | | | stylingtips | | | summary | | | title | | | usageinstructions | |
|
|
|
| name | |
| netweight | |
| nextshipment | |
| ordered | |
| orderidx | |
| origin | |
| originalsize | |
| packaging | |
| productshipment | |
| productuid | | string | A5EB2811-35A4-44F1-82955DA99B9128ED |
|
| promountil | |
| rating | |
| recorduid | | string | A5EB2811-35A4-44F1-82955DA99B9128ED |
|
| reference | |
| related | |
| reserved | |
| returned | |
| returnsallowed | |
| section | |
| shipment | |
| showbrand | |
| sizeinfos | Query Template: /system/api/product/sizes.cfc:20 Execution Time: 2.99 ms Record Count: 12 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,'2382,2383,2384,2385,2380,2381') > 0 and product_variations.productuid = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 | 2382 | L | intlsize | black | L | L | -1 | 999999 | 0 | w | plus | lingerie | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | | | 102-107 | | | | | | | | 2 | 2382 | L | intlsize | white | L | L | -1 | 999999 | 0 | w | plus | lingerie | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | | | 102-107 | | | | | | | | 3 | 2382 | L | intlsize | red | L | L | -1 | 999999 | 0 | w | plus | lingerie | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | | | 102-107 | | | | | | | | 4 | 2383 | XL | intlsize | black | XL | XL | -1 | 999999 | 0 | w | plus | lingerie | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | | | 107-112 | | | | | | | | 5 | 2383 | XL | intlsize | white | XL | XL | -1 | 999999 | 0 | w | plus | lingerie | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | | | 107-112 | | | | | | | | 6 | 2383 | XL | intlsize | red | XL | XL | -1 | 999999 | 0 | w | plus | lingerie | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | | | 107-112 | | | | | | | | 7 | 2384 | 2XL | intlsize | white | 2XL | 2XL | -1 | 999999 | 1 | w | plus | lingerie | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | | | 112-117 | | | | | | | | 8 | 2384 | 2XL | intlsize | red | 2XL | 2XL | -1 | 999999 | 0 | w | plus | lingerie | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | | | 112-117 | | | | | | | | 9 | 2384 | 2XL | intlsize | black | 2XL | 2XL | -1 | 999999 | 0 | w | plus | lingerie | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | | | 112-117 | | | | | | | | 10 | 2385 | 3XL | intlsize | white | 3XL | 3XL | -1 | 999999 | 0 | w | plus | lingerie | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | | | 117-123 | | | | | | | | 11 | 2385 | 3XL | intlsize | red | 3XL | 3XL | -1 | 999999 | 0 | w | plus | lingerie | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | | | 117-123 | | | | | | | | 12 | 2385 | 3XL | intlsize | black | 3XL | 3XL | -1 | 999999 | 0 | w | plus | lingerie | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | | | 117-123 | | | | | | |
|
| sizeranges | |
| sizes | | string | 2382,2383,2384,2385,2380,2381 |
|
| 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: 11.5 ms Record Count: 12 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2382 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2383 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2384 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2385 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2380 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2381 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 | A5EB2811-35A4-44F1-82955DA99B9128ED | 950AFE77-F569-4404-83053A632DEF04FD | 2382 | black | #000000 | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5109-1 | | -1 | 0 | all | | | 2 | A5EB2811-35A4-44F1-82955DA99B9128ED | 679F0EFF-C819-4E9B-BC0603E56820647F | 2382 | red | #F50000 | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 3 | A5EB2811-35A4-44F1-82955DA99B9128ED | FB66BF5F-CD71-4A90-82E6860AA7DF744B | 2382 | white | #FFFFFF | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 4 | A5EB2811-35A4-44F1-82955DA99B9128ED | E589E193-5C72-4D63-ADE533BE72CA38F9 | 2383 | black | #000000 | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | P5109-1 | P5109-11116 | -1 | 0 | all | | | 5 | A5EB2811-35A4-44F1-82955DA99B9128ED | 71B8C588-2DA1-46E4-95E7F356078654C7 | 2383 | red | #F50000 | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 6 | A5EB2811-35A4-44F1-82955DA99B9128ED | 443C7A9C-6DC8-44B4-905AE6BC8D801E9D | 2383 | white | #FFFFFF | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 7 | A5EB2811-35A4-44F1-82955DA99B9128ED | 4DA51E68-3D9A-41CE-A4E78C25B78A2F20 | 2384 | black | #000000 | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5109-1 | P5109-1P1117 | -1 | 0 | all | | | 8 | A5EB2811-35A4-44F1-82955DA99B9128ED | 653E04FD-5B8C-4EBC-A14D49844EC355DD | 2384 | red | #F50000 | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 9 | A5EB2811-35A4-44F1-82955DA99B9128ED | 379543B0-B226-498D-B6209CCB79CA40CB | 2384 | white | #FFFFFF | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | 1 | 1 | all | | | 10 | A5EB2811-35A4-44F1-82955DA99B9128ED | 6634A640-9490-492B-ADEC6C01278D31E7 | 2385 | black | #000000 | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 1 | -1 | 1 | 4 | 0 | 0 | P5109-1 | P5109-1P1117 | -1 | 0 | all | | | 11 | A5EB2811-35A4-44F1-82955DA99B9128ED | AC2A3B1E-EFD9-4682-B880AE2CBD1D7EFE | 2385 | red | #F50000 | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | | | 12 | A5EB2811-35A4-44F1-82955DA99B9128ED | 4776C899-B013-46D5-99F218E68B3F70E9 | 2385 | white | #FFFFFF | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | all | |
|
| subcategory | |
| supplier | |
| supplierreference | |
| tags | |
| themes | |
| totalvariations | |
| type | |
| unitprice | |
| usageinstructions | |
| variations | Query Template: /system/api/product/variations.cfc:171 Execution Time: 20 ms Record Count: 12 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2382 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2383 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2384 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2385 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2380 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' 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 = 'A5EB2811-35A4-44F1-82955DA99B9128ED' and product_variations.isactive = 1 and product_sizes.id_size = 2381 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 | 950AFE77-F569-4404-83053A632DEF04FD | 2382 | black | #000000 | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5109-1 | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 2 | 679F0EFF-C819-4E9B-BC0603E56820647F | 2382 | red | #F50000 | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 3 | FB66BF5F-CD71-4A90-82E6860AA7DF744B | 2382 | white | #FFFFFF | L | L | | 40-42 | 10-12 | 14-16 | 42-44 | 42-44 | 40-42 | 46-48 | 42-44 | 40-42 | w | lingerie | | L | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 1 | 0 | 14.125 | all | | | 4 | E589E193-5C72-4D63-ADE533BE72CA38F9 | 2383 | black | #000000 | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 2 | 0 | 0 | P5109-1 | P5109-11116 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 5 | 71B8C588-2DA1-46E4-95E7F356078654C7 | 2383 | red | #F50000 | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 6 | 443C7A9C-6DC8-44B4-905AE6BC8D801E9D | 2383 | white | #FFFFFF | XL | XL | | 42-44 | 12-14 | 16-18 | 44-46 | 44-46 | 42-44 | 48-50 | 44-46 | 42-44 | w | lingerie | | XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 1 | 0 | 14.125 | all | | | 7 | 4DA51E68-3D9A-41CE-A4E78C25B78A2F20 | 2384 | black | #000000 | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | P5109-1 | P5109-1P1117 | -1 | 0 | -1 | 1 | -1 | 0 | 0 | 14.125 | all | | | 8 | 653E04FD-5B8C-4EBC-A14D49844EC355DD | 2384 | red | #F50000 | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 1 | -1 | 0 | 0 | 14.125 | all | | | 9 | 379543B0-B226-498D-B6209CCB79CA40CB | 2384 | white | #FFFFFF | 2XL | 2XL | | 44-46 | 14-16 | 18-20 | 46-48 | 46-48 | 44-46 | 50-52 | 46-48 | 44-46 | w | lingerie | | 2XL | intlsize | 14.125 | 0 | | STOCK01 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | 1 | 1 | -1 | 1 | -1 | 1 | 0 | 14.125 | all | | | 10 | 6634A640-9490-492B-ADEC6C01278D31E7 | 2385 | black | #000000 | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 1 | -1 | 1 | 4 | 0 | 0 | P5109-1 | P5109-1P1117 | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 11 | AC2A3B1E-EFD9-4682-B880AE2CBD1D7EFE | 2385 | red | #F50000 | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 0 | 0 | 14.125 | all | | | 12 | 4776C899-B013-46D5-99F218E68B3F70E9 | 2385 | white | #FFFFFF | 3XL | 3XL | | 46-48 | 16-18 | 20-22 | 48-50 | 48-50 | 46-48 | 52-54 | 48-50 | 46-48 | w | lingerie | | 3XL | intlsize | 14.125 | 0 | | STOCK01 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | | | -1 | 0 | -1 | 0 | -1 | 1 | 0 | 14.125 | all | |
|
| vatrate | |
| warehouse | |