SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    37513, 
    37514, 
    37515, 
    37516, 
    37520, 
    37521, 
    37522, 
    37523, 
    37524, 
    37525, 
    37526, 
    37527, 
    37528, 
    37529, 
    37530, 
    37531, 
    37532, 
    37533, 
    37534, 
    37535, 
    37536, 
    37537, 
    37538, 
    37539, 
    37540, 
    37541, 
    37542, 
    37543, 
    37544, 
    37545, 
    37546, 
    37547, 
    37548, 
    37549, 
    37550, 
    37551, 
    37552, 
    37553, 
    37554, 
    37555, 
    37557, 
    37558, 
    37559, 
    37560, 
    37561, 
    37562, 
    37563, 
    37820, 
    37821, 
    37822, 
    37823, 
    37824, 
    37825, 
    37826, 
    37827, 
    37828, 
    37829, 
    37830, 
    37831, 
    37832, 
    37833, 
    37834, 
    37835, 
    37836, 
    37837, 
    37838, 
    37839, 
    37840, 
    37841, 
    37842, 
    37843, 
    37844, 
    37845, 
    37846, 
    37847, 
    37848, 
    37849, 
    37850, 
    37851, 
    37852, 
    37853, 
    37854, 
    37855, 
    37856, 
    37858, 
    37859, 
    37860, 
    37861, 
    37862, 
    37863, 
    37864, 
    37865, 
    37866, 
    37867, 
    37868, 
    37869, 
    37870, 
    37871, 
    37872, 
    37873, 
    37874, 
    37875, 
    37877, 
    37878, 
    37879, 
    37880, 
    37881, 
    37882, 
    37883, 
    37884, 
    37885, 
    37886, 
    37887, 
    37888, 
    37889, 
    37890, 
    37891, 
    37892, 
    37893, 
    37894, 
    37895, 
    37896, 
    37897, 
    38150, 
    38151, 
    38152, 
    38155, 
    38156
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00171

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "307.21"
    },
    "table": {
      "table_name": "q_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 128,
      "rows_produced_per_join": 128,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (37513,37514,37515,37516,37520,37521,37522,37523,37524,37525,37526,37527,37528,37529,37530,37531,37532,37533,37534,37535,37536,37537,37538,37539,37540,37541,37542,37543,37544,37545,37546,37547,37548,37549,37550,37551,37552,37553,37554,37555,37557,37558,37559,37560,37561,37562,37563,37820,37821,37822,37823,37824,37825,37826,37827,37828,37829,37830,37831,37832,37833,37834,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,38150,38151,38152,38155,38156)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "281.61",
        "eval_cost": "25.60",
        "prefix_cost": "307.21",
        "data_read_per_join": "488K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
37513 <ul><li>360 Perry Ellis (M) Edt 30Ml+Red Edt 30Ml+Reserve Edt 30Ml Set</li> </ul>
37514 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> </div> </div> </div> <ul style="list-style-type:circle;"><li class="ng-binding">360 Perry Ellis (W) Edt 100Ml+118Ml B.Mist+57G H.Cream+10Ml Set. Imported from UAE.</li> </ul>
37515 <ul><li>brand:Perry Ellis</li> <li>Gender Women </li> </ul>
37516 <ul><li>Brand : Legend Forty </li> <li>Gender:Unisex</li> </ul>
37520
37521 <ul><li>Unit Components CAs the most valuable fragrance of the world, Amouage has roots in the Oman Sultanate. Their perfume production is never fast, but it is about years of patience and painstaking work. Gold ornaments on beautiful bottles were handmade. Amouage uses original ingredients from Omana - silver incense, lemon and bush. Today, as in ancient times, valuable powders from the tamarisk tree manually collect the burial of selected shepherds. Amouage uses the essence of an extremely rare flower (an omelet bore), which grows and blooms in a short period of time every year on the remote Oman Mountains.ount 1</li> </ul>
37522 <ul><li>Brand:Antonio Banderas</li> <li>Blue Seduction </li> <li>Men</li> </ul>
37523 <ul><li>Brand:Antonio Banderas  </li> <li>Women</li> </ul>
37524 <ul><li>Brand:Antonio Banderas </li> <li>Gender:Men</li> </ul>
37525 <ul><li><span>An elegant, sensual fragrance inspired by the power of attraction, for a woman who’s sophisticated, feminine and full of personality.</span></li> </ul>
37526 <ul><li><span>Aramis Miniature Gift Set for Men - 4 Piece - Aramis Eau De Toilette 7 Ml - Aftershave 7 Ml - Black Eau De Toilette 7 Ml - Voyager Eau De Toilette 7 Ml</span></li> </ul>
37527 <ul><li><span>Receive a FREE personalized 30 mL travel spray with the purchase of a Cologne Absolue 200 mL. Engrave your 30 mL travel spray refill with a personalized monogram and a leather case of your choice. </span></li> </ul>
37528 <ul><li>Brand Azzaro</li> <li>Item Azzaro Pour Homme Gift Set EDT 100Ml With Deodorant Travel 150Ml</li> <li>Quantity 100 Ml & 150Ml</li> <li>Fragrance EDT</li> </ul>
37529 <ul><li><span>Loris Azzaro WANTED Travel Exclusive set.</span></li> <li><span>1x Azzaro Wanted 100ml Eau de Toilette spray</span></li> <li><span>1x Azzaro Wanted 150ml Deodorant spray</span></li> </ul>
37530 <ul><li>Top notes</li> <li>Bergamot, Sea Notes, Nutmeg, Violet Leaf</li> <li>Middle notes</li> <li>Jasmine, Ambergris, Cashmere Wood</li> <li>Base notes</li> <li>Sandalwood, Tonka Bean, Moss, Musk</li> </ul>
37531 <ul><li>Beyonce Heat </li> <li>Gender:Unisex</li> </ul>
37532 <p>Boucheron Iris De Syracuse Edp 125Ml+Santal De Kandy Edp 125Ml+Ambre D'Alexandrie Edp 125Ml Set</p>
37533 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Britney Spears Fantasy (W) Edp 100ml+100ml Bl Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Labdanum: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37534 <ul><li>Brand:Britney Spears </li> <li>Gender:Women </li> </ul>
37535 <ul><li> Brand:Burberry</li> <li>Gender:Women </li> </ul>
37536 <ul><li>Burberry Mr Burberry </li> <li>Gender:Unisex</li> </ul>
37537 <ul><li>Brand: Mr Burberry </li> <li>Gender:Unisex</li> </ul>
37538 <ul><li>Burberry My Burberry </li> <li>Gender:Women</li> </ul>
37539 <ul><li>Brand: My Burberry </li> <li>Gender:Women</li> </ul>
37540 <ul><li>Brand:My Burberry</li> <li>Gender:Women</li> </ul>
37541 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Burberry My Burberry Black (W) Edp 50ml+75ml Bl Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Papyrus: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37542 <ul><li><span>My Burberry Black. A new fragrance joining the My Burberry collection, it follows the same codes of craftsmanship, innovation and appreciation of the iconic Heritage Trench Coat.</span></li> </ul>
37543 <ul><li>Burberry My Burberry Blush </li> <li>Gender:Women</li> </ul>
37544 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Burberry My Burberry Limited Edition Edp 90ml+30ml Body Oil+10G</span></li> <li><span class="a-list-item">Gold Glow Powder Set</span></li> <li><span class="a-list-item">Women Eau De Perfume</span></li> </ul>
37545 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Erwachsene</span></li> <li><span class="a-list-item">Multicolor</span></li> </ul>
37546 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Bvlgari Aqva Divina (W) Edt 65ml+100ml Bl+150G Soap+100ml Sg Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Patchouli: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37547 <ul><li>Bvlgari Aqva Divina (W) Edt 65Ml+40Ml Bl+40Ml Sg+50G Soap+Pouch Set</li> </ul>
37548 <ul><li>Size0.5 oz</li> <li>Fragrance NameAqva Pour Homme</li> <li>FormulationSpray</li> <li>Fragrance TypeEau de Toilette</li> </ul>
37549 <ul><li>Bvlgari Blv </li> <li>Men</li> <li> 100Ml+75Ml Asb+75Ml Sg+Pouch Set</li> </ul>
37550 <ul><li dir="ltr"><span>A dreamy fragrance that the use of emotions everyday.</span></li> <li dir="ltr"><span>Fragrance for Women.</span></li> <li dir="ltr"><span>High quality.</span></li> <li dir="ltr"><span>Aromatic Notes: Flowers, Sweets & Biuky.</span></li> </ul>
37551 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Bvlgari</span></li> <li><span class="a-list-item">Fragrance Type: Eau de Parfum</span></li> <li><span class="a-list-item">Targeted Group: Women</span></li> <li><span class="a-list-item">Fragrance Family: Aromatic</span></li> <li><span class="a-list-item">Number of Pieces: 2</span></li> </ul>
37552 <div class="a-column a-span4"> <div class="a-section a-text-left visualRpdColumnSmall firstColumn"> <div class="a-fixed-left-grid"> <div class="a-fixed-left-grid-inner"> <ul><li class="a-fixed-left-grid-col a-col-right"><span class="a-size-small a-color-base visualRpdText">Bvlgari goldea the roman night set (edp75ml+edp15ml+beauty mirror)</span></li> </ul></div> </div> </div> </div> <div class="a-column a-span4"> </div>
37553 <ul><li>Bvlgari Goldea The Roman Night 75ml Eau de Parfum Gift Set</li> <li>Bulgari Goldea The Roman Night Eau de Parfum evokes the ebullient energy emanating from a festive and starry night in the Eternal City: Rome.</li> <li>The Master Perfumer Alberto Morillas reinvents Chypre and fills his Roman night with hypnotic nocturnal flowers: night-blooming Jasmine and Tuberose blossoms. Caressed by the delicious kiss of luscious Mulberries and black Peony, they trigger desire.</li> </ul>
37554 <ul><li>Bvlgari Man Black Cologne Edt 100Ml+75Ml Asb+75Ml Sg+Pouch Set</li> </ul>
37555 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">It’s crafted with citrus tones mixed with warm woody fragrances</li> <li class="jsx-1889249662">Ideal gift set</li> <li class="jsx-1889249662">Travel friendly</li> </ul>
37557 <ul><li>Brand:Bvlgari</li> <li>Gender:Unisex </li> </ul>
37558 <ul><li>Bvlgari Man In Black Edp 15Ml+Man Extreme 15Ml+Man Black Cologne 15Ml Mni Set</li> </ul>
37559 <p> </p> <div class="std"> <ul><li><span>Eau De Parfum 60 ml</span></li> <li><span>After Shave Balsam 40 ml</span></li> <li><span>Duschgel 40 ml</span></li> <li>Bvlgari Man In Black </li> <li><span>Eau De Parfum Geschenkset</span><span> enthält</span></li> </ul></div>
37560 Bvlgari Omnia Amethyste (W) Edt 65Ml+15Ml Mini Set
37561 <ul><li>Bvlgari Omnia Amethyste  </li> <li><span>Eau De Parfum</span></li> <li><span>Women</span></li> </ul>
37562 <ul><li>Bvlgari Omnia Coral </li> <li>Women </li> <li><span>Eau De Parfum</span></li> </ul>
37563 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Bvlgari Omnia Paraiba (W) Edt 65ml+15ml Mini Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Opoponax: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37820 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Launched by the design house of guess</span></li> <li><span class="a-list-item">This deodorant spray has a blend of violet leaves, bergamot, olibanum oil, cedar wood, virginia orpur, oak moss, grey amber, lychee scent trek, orpur, etc.</span></li> <li><span class="a-list-item">100 percent genuine product</span></li> </ul>
37821 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Launched by the design house of Guess</span></li> <li><span class="a-list-item">This woody fragrance has a blend of hot pepper, grapefruit, elemi, cedar, vetiver, geranium, patchouli, labdanum, and black vanilla</span></li> <li><span class="a-list-item">Provides long lasting results</span></li> </ul>
37822 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Top notes are sweet & white floral</span></li> <li><span class="a-list-item">Middle notes are woody & fruity</span></li> <li><span class="a-list-item">Base notes are powdery & floral</span></li> </ul>
37823 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Top notes are floral & woody</span></li> <li><span class="a-list-item">Middle notes are powdery</span></li> <li><span class="a-list-item">Base notes are fruity & fresh</span></li> </ul>
37824 <ul><li>Guess Pink</li> <li>Women</li> <li> 250Ml Body Mist</li> </ul>
37825 <ul><li>Guess Seductive (M) Body Spray 226Ml</li> </ul>
37826 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Top notes are white floral & woody</span></li> <li><span class="a-list-item">Middle notes are fruity & vanilla</span></li> <li><span class="a-list-item">Base notes are sweet & citrus</span></li> </ul>
37827 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Guess Seductive Blue (M) Body Spray 170G</span></li> <li><span class="a-list-item">Men Perfume</span></li> <li><span class="a-list-item">French labdanum: Rate only the most important ingredients you sense in this fragrance.</span></li> </ul>
37828 <ul><li>Fogg Happiness 250 ml Deodorant for Men</li></ul>
37829 <span>Eau Des Merveilles Perfume by Hermes, Launched in 2004, eau de merveilles by hermes is a warm, feminine scent for any woman. This feminine scent possesses a blend of vetiver, oak, cedar for the top notes. The heart of this fragrance is a lovely amber, finishing off with lemon, orange, pink pepper and elemi.</span>
37830 <div class="descriptionProductCode"> <p class="productCode">Product code: 776428</p> </div> <div class="hidden-xs infoTabs infoTabs-2tabs"> <div class="RadTabStrip RadTabStrip_Vista RadTabStripTop_Vista"> <div class="multiPage"> <div class="infoPage featurestext col-xs-12 sdtabBody"> <div class="infoTabPageContainer"> <div class="infoTabPage"><span>HERMÈS Eau des Merveilles Fragranced Soap 100g.<br /><br />"The perfume of enchantment. An amber wood for women, surprising and magical." Jean-Claude Ellena<br /><br />From surprises to magic and from magic to enchantment, Eau des Merveilles leads us by the nose into a cloud of fantasies. Based on an amber woody accord which resonates right through to the head notes, this fragrance, which was created by Ralph Schwieger and Nathalie Feisthauer in 2004, succeeds in the challenge of achieving sparkling femininity apparently without flowers. Since then its amber woody accord has revealed other facets of itself, from Eau Claire des Merveilles to L`Ambre des Merveilles, interpreted by Jean-Claude Ellena.</span> <p>Cleanses and delicately scents the skin without drying it.</p> </div> </div> </div> </div> </div> </div>
37831 <span>Hermès Voyage d'Hermès After-Shave Balm provides hydration and comfort to the skin. Its light, fluid formula is easily absorbed and soothes razor burn. The skin is nourished and delicately perfumed. Non-greasy texture.</span><br /><span>Another way to wear fragrance Voyage d'Hermès.</span><br /><br />An invitation to discover, meet and share. Jean-Claude Ellena<br /><br /><span>A novel that feeds on the imagination, Voyage d’Hermès expresses the long-standing and unusual relationship between the house and travel. An interplay of paradoxes, complements and unexpected alliances support the premise of woody notes that are fresh yet musky, familiar yet surprising, hovering between impulsive and comforting, equally at ease with men as with women. Hermès designer Philippe Mouquet created a travel object bottle for Voyage d’Hermès, designed for journeys and symbolic of movement.</span>
37832 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Irresistible fragrance</span></li> <li><span class="a-list-item">Anti-bacterial properties</span></li> <li><span class="a-list-item">Long lasting fragrance</span></li> <li><span class="a-list-item">8 hours freshness with freshness lock technology</span></li> <li><span class="a-list-item">Keeps body odour away</span></li> </ul>
37833 <p style="font-weight:400;"><span style="font-style:inherit;font-weight:inherit;">Musk is a testament of the beauty and depth of its base note, White Musk. A balancing, warm and sensual fragrance, it starts with the elegant citrusy scent of Bergamot; complex and aromatic, it combines together with the lively, spicy, green heart note of Basil, leaving a fresh and balanced feeling.<span> </span></span>This fragrance combines with the deep, balancing scent of Agarwood completes the concentrated oil.</p> <p style="font-weight:400;">The finest scents to remember the most sensational moments… Hind Al Oud Concentrated Oils remind us of our deepest and purest memories, the ones that we treasure and hold close.</p>
37834 <p> A 75ml BOSS Bottled Unlimited deodorant stick. BOSS Bottled Unlimited – invigorating freshness, enduring energy and aromatic masculinity. Your motivating energy boost for personal success beyond limits. Keep fresh on your busiest days with this refreshing scent.</p>
37835 <ul><li><span>Hugo Boss Bottled Unlimited (M) Deodorant 150Ml</span></li> </ul>
37836 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Hugo Boss Bottled Unlimited (M) Shower Gel 150 ml</span></li> <li><span class="a-list-item">Men Perfume</span></li> <li><span class="a-list-item">A feast for the nose indeed and all in the bright brilliant opening. </span></li> </ul>
37837 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Hugo Boss</span></li> <li><span class="a-list-item">Category Type: Body</span></li> <li><span class="a-list-item">Product Factor: Gel</span></li> <li><span class="a-list-item">Size: 200 ml</span></li> <li><span class="a-list-item">Scent: Mixed</span></li> <li><span class="a-list-item">EAN-13: 8005610262123</span></li> <li><span class="a-list-item">Details: The revitalising head notes of iced mint leaves stimulate the senses, while the scent of wild tea awakens the mind and spirit</span></li> </ul>
37838 <p class="a-size-large a-spacing-none"><span class="a-size-large">Hugo Boss Hugo Woman Bath & Shower Gel 200ml/6.7oz</span></p>
37839 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Hugo Boss The Scent (W) Shower Gel 200 ml</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> </ul>
37840 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Hugo Boss The Scent (W) Body Lotion 200 ml</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">leather, oak moss and vetiver.</span></li> </ul>
37841 <span>A 150ml tube of shower gel for all-over freshness. HUGO BOSS introduces BOSS The Scent, its new seductive perfume for men. An irresistible and unforgettable fragrance, it releases refined notes of ginger, exotic maninka fruit and leather over time, enticing the senses. Get your day off to the best start by lathering up with this signature, masculine fragrance.</span>
37842
37843 <ul><li><span>All about Eve by Joop! for Women Shower Gel 5 oz. New in Box</span></li> </ul>
37844 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Launched by the design house of joop</span></li> <li><span class="a-list-item">This mild deodorant spray has a blend of cinnamon, jasmine, honey, tobacco, and vetiver</span></li> <li><span class="a-list-item">Ideal for daily use</span></li> </ul>
37845 <ul><li>Brand: Joop</li> <li>Category Type: Body</li> <li>Product Factor: Gel</li> <li>Size: 150 ml</li> <li>Scent: Woody</li> <li>Targeted Group: Men</li> <li>Country of Origin: France</li> <li>EAN-13: 3607345849782</li> </ul>
37846
37847 <ul><li><span>Korloff Paris Royal Oud Deodorant 150Ml</span></li> </ul>
37848 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Men's Deodorant Stick</span></li> <li><span class="a-list-item">Scent: woody</span></li> </ul>
37849 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Lacoste Pour Femme Shower Gel</span></li> <li><span class="a-list-item">Size: 150 ml</span></li> </ul>
37850 <ul><li>luxurious scented body cream</li> <li>Fragrance Notes: Vanilla, Blackcurrant, Floral Bouquet, Musk, Blackberry</li> <li>Enriched in vegetable glycerine, apricot stones and vitamin E</li> </ul>
37851 <p class="short-desc">Lalique LALBLW006 Amethyst Eclat (W) Body Cream 200ml</p>
37852 <ul><li>Brand: Lalique</li> <li>Category Type: Body</li> <li>Suitable Skin Type: All Skin Type</li> <li>Size: 200 ml</li> <li>Type: Moisturizers</li> <li>Texture: Cream</li> <li>Recommended Use: Moisturiser</li> <li>Country of Origin: France</li> <li>EAN-13: 7640111500629</li> <li>Top Notes: Rose Buds, Bergamot And Neroli</li> <li>Heart Notes: Gardenia, Tuberose And Jasmine</li> <li>Base Notes: Musks, Cedar Wood And Sandalwood</li> </ul>
37853 <span>A rich perfumed moisturizing body cream Formulated with conditioning ingredients that hydrate & shield body skin Quickly dissolves into skin to deliver long-lasting comfort Infused with a subtle sensuous fragrance Body skin appears softer, smoother, fresher & more soothed</span>
37854 <span>This nourishing fragranced body lotion is made with the most precious natural ingredients for a modern interpretation of an oriental fragrance with a twist of gourmand. It entwines the elegance of iris with the strength of patchouli and the sweetness of a gourmand blend for an incredible scent with depth and complexity. </span><br /><br /><span>La Vie Est Belle, French for "life is beautiful", represents a choice—the choice to create your own path to happiness. Made with the most precious natural ingredients, the fragrance entwines the elegance of iris with the strength of patchouli and the sweetness of praline. Floral notes of sambac, jasmine and Tunisian orange blossom are added in the form of sublime absolutes. </span><br /><br /><span>La Vie Est Belle is the fragrance of joyful femininity that makes life more beautiful. It is for the woman who lives in the present, who is filled with honesty, truth, and gratitude, and who is free of social constraint, to emblazon her own unique path. </span>
37855 <p class="visually-hidden"><span style="font-size:14px;">DESCRIPTION</span></p> <div class="tabs"> <div class="tab active"><span class="tab1-desc tab-desc tab-content show-drop">Lancome La Vie Est Belle Eau de Parfum is Lancome’s bestselling feminine fragrance that is a sweet and elegant perfume capturing the essence of Magnolia Extract. Inspired by the idea of natural and simple beauty and taking pleasure in the small things in life. Opening with top notes of iris, a key ingredient of this beautiful floral fragrance, flowing into a heart of patchouli accords which is all finally rounded off with a smooth base of gourmand. Lancome La Vie Est Belle Shower Gel is lightly fragrances and enriched with moisturising and softening properties which smooth and revitalise your skin.</span></div> </div>
37856 <ul><li>Removes dead skin cells</li> <li>Skin feels smooth, comfortable and supple</li> <li>Gives skin even-looking texture</li> <li>Suitable for sensitive skin</li> </ul>
37858 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <div class="jsx-1003258361 jsx-3349621030" style="margin-bottom:0px;padding:0px;border-width:0px;font-size:12px;line-height:inherit;font-family:'Proxima Nova', 'Helvetica Neue', Arial, sans-serif;vertical-align:baseline;color:rgb(64,69,83);background-color:rgb(255,255,255);"><div class="jsx-1889249662 overviewSection" style="margin-bottom:0px;padding:0px;border-width:0px;font:inherit;vertical-align:baseline;"><ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">This perfume contains top notes of Freesia, Ruby Red Grapefruit, Water Hyacinth</li><li class="jsx-1889249662">The heart of the perfume contains Peony, Jasmine, Blue Poppy</li><li class="jsx-1889249662">The notes that stay the longest, mixing with the middle notes, have Amber Milk, Creamy Sandalwood, Musk.</li></ul></div></div></div> </div> </div> </div><div> </div>
37859 <ul><li>Miu Miu (W) Body Cream 150Ml</li> </ul>
37860 A sensual Body Lotion with a milky texture of that leaves skin feeling supple and soft, and lightly scented—the perfect finishing touch to your beauty ritual.<br /><br />Fragrance Family:<br />Fresh<br /><br />Scent Type:<br />Fresh Florals<br /><br />Key Notes:<br />Lily of the Valley
37861 <ul class="a-unordered-list a-vertical a-spacing-none"><li class="showHiddenFeatureBullets"><span class="a-list-item">Energizing and refreshing shower gel</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Features a lightweight and fast-absorbing texture</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Own or to complement the eau de parfum.</span></li> </ul>
37862 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Fragrance from the designer house of Mont Blanc</span></li> <li><span class="a-list-item">An aftershave for men</span></li> <li><span class="a-list-item">Sweet and aromatic scent</span></li> <li><span class="a-list-item">Base notes of aromatic, fruity, sweet, fresh spicy, citrus, woody</span></li> <li><span class="a-list-item">100ml bottle</span></li> </ul>
37863 <ul><li>Mont Blanc Legend (M) Shaving Foam 100Ml</li> </ul>
37864 <p>Prolong the scent of montblanc legend with this super-sized all-over shower gel</p>
37865 <ul><li>Mont Blanc Legend Night</li> <li>Men</li> <li>After Shave Balm 100Ml</li> </ul>
37866 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Montblanc Legend</span></li> <li><span class="a-list-item">Spirit After Shave</span></li> <li><span class="a-list-item">After Shave Balm</span></li> </ul>
37867 <ul><li>Montale Paris</li> <li>Powder Flowers</li> <li>100Ml Hair Mist</li> </ul>
37868 <ul><li>Luxurious and sensual, Rose Elixir Hair Mist, sublimates the hair with a brilliant and silky veil and leaves an intense scented sillage.</li> <li>"The magnetic Rose attracts the composition of Citrus, Strawberry Leaves, Jasmine, Orange Blossom to hatch in Amber, Musk and Vanilla. A dancing fragrance for an intense feminine sillage."</li> </ul>
37869 <ul><li>Intimate and chic, White Musk Hair Mist, sublimates the hair with a brilliant and silky veil and leaves an intense scented sillage.</li> <li>"On a starting point of Violet Leaves and Ylang-Ylang oil, the sublime fragrance of a very pure and feminine high quality White Musk."</li> </ul>
37870 <ul><li>Collections: Fragrances - Man, Gifts under £150, Limited Edition Writing Instruments</li> <li>Category: After Shave Balm, Fragrances, Fragrances-Man</li> <li>Type: Fragrances</li> </ul>
37871 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">A fragrance for modern women who are aware of her sexuality.</span></li> <li><span class="a-list-item">They are open to the world but also intimate and sensual.</span></li> <li><span class="a-list-item">Fragrance Family: Floral, Fruity.</span></li> <li><span class="a-list-item">Top Notes: Bergamot, Orange blossom, Osmanthus.</span></li> <li><span class="a-list-item">Heart Notes: Amber, Musk. Base Notes: Vanilla, Vetiver.</span></li> </ul>
37872 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">30ml/1oz</span></li> <li><span class="a-list-item">Narciso Rodriguez For Her</span></li> </ul>
37873 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <p>To reinvent and embellish reality, Nina Ricci tells a modern fairy tale, seductive and captivating, with a magical fragrance, a promise of charm, enchantment and emotion. A sparkling sweet floral fragrance with a hint of toffee apple to lend a femininity caressed by seduction, for a modern girl living between dream and reality. For more than 80 years, Nina Ricci captures the very essence of women. House of couture as well as “Couturier du Parfum”, this internationally renowned brand, established in 1932 in Paris, is synonymous with ultra-femininity, timeless chic, Parisian flair and poetic vision.</p> </div> </div> </div> </div> <div> </div>
37874 <ul><li><span>Hair mist by Nina Ricci. Taif rose accord, spiced at the top with black and pink pepper, before being wrapped in a creamy woody nuance of Atlas cedar</span></li> </ul>
37875
37877 <ul><li>Orchid Noir</li> <li>Men</li> <li>250 Ml Deo.</li> </ul>
37878 <ul><li><span>1 Million is the expresion of every man's fantasies. </span></li> <li><span>A taste for money, sparkling cars, games and pretty girls.</span></li> <li><span> It embodies the return of flamboyant masculinity. </span></li> <li><span>The 1 Million man is a seducer. He is flamboyant, self-confident, daring and irresistable... </span></li> <li><span>Shop the Paco Rabanne 1 Million Shower Gel today and enhance the million scent!</span></li> <li><span>A delicately perfumed cleanser for body</span></li> </ul>
37879 <ul><li>Specifications</li> <li>Brand:Paco Rabanne</li> <li>Size:100ml</li> <li>Targeted Group:Men</li> <li>Oil Free</li> </ul>
37880 <ul><li>Brand :Paco Rabanne</li> <li>Model Name : Black Xs L'exces</li> <li>Ideal : For Men</li> <li>Fragrance Classification : Deodorant Spray</li> <li>Quantity :250 ml</li> </ul>
37881 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">For Him</span></li> <li><span class="a-list-item">Content Quantity: 100ml</span></li> <li><span class="a-list-item">Product Type: Aftershave</span></li> <li><span class="a-list-item">Designer / Manufacturer: Paco Rabanne</span></li> <li><span class="a-list-item">Fragrance Line: Paco Rabanne Pour Homme</span></li> </ul>
37882 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Invictus by Paco Rabanne for Men 5.1 oz Deodorant Spray: Buy Paco Rabanne Deodorants - Invictus by Paco Rabanne for Men 5.1 oz Deodorant Spray</span></li> <li><span class="a-list-item">Item Condition: 100% authentic, new and unused. Invictus by Paco Rabanne for Men 5.1 oz Deodorant Spray.</span></li> <li><span class="a-list-item">Type: Deodorant</span></li> </ul>
37883 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">The flowery body lotion pampers your senses and brings an absolutely perfect wellbeing.</span></li> <li><span class="a-list-item">Wrap yourself in the pleasant scent of Olympea.</span></li> <li><span class="a-list-item">For an indescribable feeling on the skin.</span></li> <li><span class="a-list-item">Enjoy this indescribably beautiful spa moment.</span></li> </ul>
37884 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">300 ml liquid soap</span></li> <li><span class="a-list-item">Head notes: basil, canella and black pepper</span></li> <li><span class="a-list-item">Heart notes: lavender, clary sage and lily of the valley</span></li> <li><span class="a-list-item">Base notes: tonka bean, musk, vanilla and amber</span></li> <li><span class="a-list-item">In Penhaligon's signature dispenser</span></li> </ul>
37885 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">150 ml hand and body cream</span></li> <li><span class="a-list-item">Head notes: bergamot, lemon and geranium</span></li> <li><span class="a-list-item">Heart notes: lily of the valley, rose, ylang ylang and jasmine</span></li> <li><span class="a-list-item">Base notes: oakmoss and sandalwood</span></li> <li><span class="a-list-item">In Penhaligon's signature box</span></li> </ul>
37886 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Reliable freshness throughout the day and an irresistible scent</span></li> <li><span class="a-list-item">It provides protection against unpleasant odours</span></li> <li><span class="a-list-item">The carrier the unique scent of palladium fragrance</span></li> <li><span class="a-list-item">Give the clear top notes in the Palladium refreshes immediately</span></li> <li><span class="a-list-item">A rich blend of the fruity mandarin</span></li> </ul>
37887 <ul><li><span>Top notes are grapefruit, bergamot and rosemary; middle notes are neroli, sea notes and violet leaf; base notes are cedar, patchouli and amber</span></li> </ul>
37888 <ul><li><span>ml size perfect for travelling</span></li> </ul>
37889 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Deodorant Stick Alcohol Free 2.7 Oz</span></li> <li><span class="a-list-item">Fragrance Notes: Juniper, Arctical, Siberian Pine, Patchouli, Pine Balm, Incense, Myrtle, Russian Coriander Leaves, Black Pepper</span></li> <li><span class="a-list-item">Year Introduced: 2008</span></li> </ul>
37890 <ul><li>Prada Milano</li> <li>La Femme Shower Cream</li> <li>200Ml</li> </ul>
37891 <p>This daily interlude transforms your shower routine into a ritual. The soft shower cream envelops your body in luxurious, scented foam that leaves skin feeling clean, smooth and supple. After use, the L’Homme Prada fragrance laces the skin with notes of neroli, iris and amber.</p> <p>The L’Homme Prada Tonic Shower Cream is the perfect start to your L’Homme Prada routine. Follow with the L’Homme Prada Eau de Toilette for intense, long-lasting fragrance.</p>
37892 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Prada</span></li> <li><span class="a-list-item">Type: After Shave Balm</span></li> <li> Size: 50 ml</li> <li><span class="a-list-item">Targeted Group: Men</span></li> <li><span class="a-list-item">Top Notes: Iris, Amber</span></li> <li><span class="a-list-item">Middle Notes: Neroli</span></li> </ul>
37893 <ul><li>Roberto Cavalli Paradiso Azzurro Shower Gel 150Ml</li> </ul>
37894 Sean John Unforgivable 236Ml Body Mist
37895 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Launched by the design house of Sofia Vergara in the year 2014</span></li> <li><span class="a-list-item">It is recommended for daily use</span></li> <li><span class="a-list-item">This body mist has a blend of blackberry, currant buds, plum, rose, orchid, violet, woody notes, sandalwood, and vanilla</span></li> </ul>
37896
37897 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <ul><li>MUGLER Alien Man Deodorant Spray 150 ml A refreshing deodorant spray scented with the woody, leathery and aromatic notes of Alien Man which leaves the skin feeling fresh and invigorated.</li> </ul></div> </div> </div> </div> <div class="feature"> </div> <div> </div> <div class="feature"> </div>
38150
38151
38152
38155
38156 <ul><li>L'Artisan Perfumeur Explosions D'Emotions Rappelle (W) Edp 1.5Ml Vails</li> <li> <p>This is an Eau de Parfum with an expansive and extroverted personality, where a generous floral peony note meets with the unexpected fruitiness of pomegranate.</p> </li> <li> <p>Top:Fruity and metallic note of pomegranate and black pepper;</p> </li> <li> <p>Sample</p> </li> <li> <p>Travel Size</p> </li> </ul>