SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    62434, 62433, 62435, 62436, 64866, 65459
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00056

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (62434,62433,62435,62436,64866,65459) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
62433 <p>Reflecting the utilitarian detail found in classic industrial factory pendant lights, the Wilcox Uplight Stem Mount Pendant features our hand-spun, deep bowl shade complete with a durable stem mount. American made from commercial grade materials, this industrial uplight pendant is available in four shade sizes, each featuring an opening at the top of the shade to allow light to escape. </p> <p>With focused down lighting plus fashionable up lighting, this factory pendant is perfect for dining rooms and kitchens or for commercial lighting needs in restaurants, offices, and retail settings. Customize with finish color and mounting options to complement any space!</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality pendant is a lasting stem mount option.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Wilcox Uplight Stem Mount Pendant over on our <a href="https://www.barnlight.com/inspiration/featured-customer-industrial-pendants-lend-chic-touch-to-miami-office-space/" target="_blank">blog</a>!</li> </ul> industrial uplight, pendant lighting, deep bowl pendant light, uplight pendant Reflecting the utilitarian detail in industrial factory pendant lights, the Wilcox Uplight features our hand-spun deep bowl shade and heavy duty stem mount. Wesco Uplight Stem Mount Pendant, BLE-S-ULW-PC, deep bowl pendant, uplight, industrial, up light, up-light, stem pendant, wesco, deep bowl uplight, uplight stem mount, up light stem, Wilcox Uplight, Wilcox Uplights, Wilcox Uplight Stem Mount Pendant, Wilcox Uplight Stem Mount Pendants, Wilcox Uplight Pendant, Wilcox Uplight Pendants, BLE-S-ULW16, BLE-S-ULW18, BLE-S-ULW18, BLE-S-ULW12, BLE-S-ULW14, Wilcox Up Light Stem Mount, SPS-0323, SPS 0323, SPS0323, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, H-16312, H-16314, H-16316, uplight deep bowl shade, uplight deep bowl shade stem mount,
62434 <p>We've given the Wilcox a slight redesign, providing a stylish new addition to our line of traditional warehouse lighting. Slightly separating the RLM Shade from the neck, the Wilcox Cord Hung Pendant now provides a hint of uplighting. The deep bowl warehouse shade is connected to the neck with small metal arms. The result is a stylish new ceiling light, capable of infusing a new sense of style into both commercial and residential spaces.</p> <p>Based on classic lighting designs, the Wilcox pendant light matches both the style and durability possessed by those original fixtures. We accomplish this by constructing only high quality commercial grade materials. This helps the Wilcox withstand the numerous challenges it faces throughout its lifetime of service. Discover a powdercoat finish color suiting your space and give your home or business the unique style of industrial ceiling lights!</p> <p>|break|</p> <ul> <li>Hands-on craftsmanship and high-quality materials establish a durable ceiling-mounted pendant design.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Wilcox Uplight Cord Hung Pendant on our<span> </span><a href="https://www.barnlight.com/inspiration/american-made-lighting-highlights-new-canadian-restaurant/" target="_blank">blog</a>!</li> </ul> industrial pendant, warehouse uplight pendant, deep bowl pendant light, industrial ceiling light Imbue your space with warehouse style up-lighting with our Wilcox Uplight pendant. This industrial ceiling light features our deep bowl warehouse shade with custom finish and cord options. Wesco Industrial Uplight Pendant, BLE-C-ULW-PC, deep bowl pendant, cord hung uplight, industrial, up light, up-light, cord hung pendant, wesco, deep bowl uplight, wesco uplight, wilcox uplight, BLE-C-ULW, ULW, ULW shade, deep bowl, uplight, wilcox, wilcox cord pendant, wilcox pendant, wilcox uplight, wilcox uplights, Wilcox Uplight Cord Hung Pendant, Wilcox Uplight Cord Hung Pendants, Wilcox Uplight Pendant, Wilcox Uplight Pendants, Wilcox Uplight Cord Mount Pendant, Wilcox Uplight Cord mount Pendant light, BLE-C-ULW18, BLE-C-ULW16, BLE-C-ULW20, BLE-C-ULW12, BLE-C-ULW14, SPS-0323, SPS 0323, SPS0323, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, H-16312, H-16314, H-16316, uplight deep bowl shade, uplight deep bowl shade cord-hung,
62435 <p>A classic industrial swag lamp hand-crafted to reflect hanging warehouse fixtures that were popular in the Industrial Age. The Wilcox Uplight features our deep bowl shade for a focused down light along with an opening at the top of the shade to provide an uplighting feature as well. </p> <p>American made with commercial grade materials, this industrial ceiling light is available in four shade sizes and can be customized with finish color and mounting options. Consider this fashionable pendant light for kitchen islands, dining spaces, or family rooms. Rugged enough for commercial lighting needs too!</p> <p>|break|</p> <ul> <li>An industrial chain mount fixture, this pendant’s RLM-style shade was meticulously manufactured by hand.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> industrial swag lamp, chain hung warehouse shade, industrial ceiling light, hanging warehouse shade Shopping for industrial swag lamps? Crafted after hanging warehouse fixtures popular in the Industrial Age, the Wilcox Uplight features our deep bowl shade and chain mount. BLE-C-ULW-PC-CN36, Wesco Uplight Chain Hung Pendant, deep bowl pendant, chain mount, chain hung pendant, chain hung uplight, industrial, up light, up-light, swag light, industrial swag light, wesco, deep bowl uplight, wilcox uplight, wilcox uplights, Wilcox Uplight Chain Hung Pendant, Wilcox Uplight Chain Hung Pendants, Wilcox Uplight Pendant, Wilcox Uplight Pendants, Wilcox Uplight Chain Hung Pendant Light, Wilcox Uplight Pendant Light, Wilcox uplight, wilcox uplights, BLE-CN-ULW16, BLE-CN-ULW18, BLE-CN-ULW20, BLE-CN-ULW12, BLE-CN-ULW14, SPS-0323, SPS 0323, SPS0323, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, H-16312, H-16314, H-16316, uplight deep bowl shade,
62436 <p>Custom industrial wall light solutions with the Wilcox Uplight Gooseneck! This hand-crafted warehouse light features our deep bowl shade mounted to a classic gooseneck arm wall mount. Choose from four shade sizes and a variety of gooseneck arm styles to suit your space requirements. </p> <p>American made from commercial grade materials, this industrial warehouse light should be considered for covered entryways, porches or as task lighting in a kitchen, garage or workshop. Rugged enough for commercial applications too!</p> <p>|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW109022452 BCX0"><span class="NormalTextRun SCXW109022452 BCX0">A rugged, handcrafted</span><span class="NormalTextRun SCXW109022452 BCX0"><span> </span></span><span class="NormalTextRun SCXW109022452 BCX0">gooseneck wall light, this industrial fixture is<span> </span></span><span class="NormalTextRun SCXW109022452 BCX0">a long-</span><span class="NormalTextRun SCXW109022452 BCX0">lasting</span><span class="NormalTextRun SCXW109022452 BCX0"><span> RLM </span></span><span class="NormalTextRun SCXW109022452 BCX0">lighting option. </span></span><span class="EOP SCXW109022452 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Read more about the Wilcox Uplight Gooseneck on our <a href="https://www.barnlight.com/inspiration/american-made-lighting-highlights-new-canadian-restaurant/" target="_blank">blog</a>!</li> </ul> <br /> <p> </p> industrial wall light, industrial gooseneck light, warehouse light, industrial uplight gooseneck Find your custom industrial wall light with the Wilcox Uplight Gooseneck. This hand-crafted warehouse light features our deep bowl shade mounted to a curvy gooseneck wall mount. Wesco Uplight Gooseneck Light, BLE-G-ULW-PC, uplight gooseneck, industrial wall light, wesco, wesco deep bowl, deep bowl gooseneck, gooseneck, industrial gooseneck, industrial uplight gooseneck , wilcox uplight, wilcox uplights, BLE-G-ULW16, BLE-G-ULW18, BLE-G-ULW20, BLE-G-ULW12, BLE-G-ULW14, Goose neck interior, Gooseneck interior, Goose neck light interior, Gooseneck light interior, interior goose neck, interior gooseneck light, interior goose neck light, SPS-0323, SPS 0323, SPS0323, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, Wilcox up light gooseneck, Wilcox uplight gooseneck, Wilcox up-light gooseneck, Wilcox up light goosenecks, Wilcox uplight goosenecks, Wilcox up-light goosenecks, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, H-16312, H-16314, H-16316, uplight deep bowl shade, uplight deep bowl shade gooseneck,
64866 <p>Wood and metal each possess their own unique properties and decorative characteristics. By incorporating both, the Wilcox Pendant offers an elevated appearance and iconic design. Made from solid metal, the deep bowl shade is inherently strong and reliable. With its universal appeal, the wood’s grain and knots give the pendant a natural warmth. Together, these materials help this fixture feel refined, stylish, and truly one-of-a-kind.<br /> <br />Both the wooden top and metal shade are entirely handcrafted by talented artisans ensuring an unmatched level of quality and attention to detail. Contemporary yet classic, the Wilcox can become the defining focal point of any home or business.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Part of our exclusive <a title="Learn more about our Timber &amp; Ore Collection" href="/timber-ore-collection/">Timber &amp; Ore Collection</a></li> <li>All wood is sourced from North American suppliers who are committed to sustainable felling and regrowth practices.</li> <li><span>Every p</span><span>iece of wood is unique with slight, natural variations such as knots and grain differences due to natural growth patterns. Therefore, no two pieces will be exactly alike!</span></li> <li><span><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></span></li> </ul> Contemporary yet timeless, this uplight pendant incorporates a wooden top into its design. Handcrafted by talented artisans in the USA and fully customizable! Wilcox Uplight Wooden Top Pendant, Wilcox Uplight Wooden Top Pendant light, Wilcox Wooden Top Pendant, Wilcox Wooden Top Pendant light, Wilcox Uplight Wooden Pendant, Wilcox Uplight Wooden Pendant light, Wilcox Wooden Pendant, Wilcox Wooden Pendant Light, Wilcox Up light Wooden Top Pendant, Wilcox Up light Wooden Top Pendant light, Wilcox Up light Wooden Pendant, Wilcox Up light Wooden Pendant light, Wooden Uplight pendant, Wooden Up Light Pendant, Wooden Uplight Pendant Light, Wooden Up Light Pendant light, Wilcox wooden pendant, wilcox wooden pendant light, wooden top pendant, wooden top pendant light, wooden pendant, wooden pendant light, Wilcox, Wilcox Uplight, Wilcox wooden uplight, Wilcox Up Light, Wilcox wooden up light, wood, Wilcox Uplight Wood Top Pendant, Wilcox Uplight Wood Top Pendant light, Wilcox Wood Top Pendant, Wilcox Wood Top Pendant light, Wilcox Uplight Wood Pendant, Wilcox Uplight Wood Pendant light, Wilcox Wood Pendant, Wilcox Wood Pendant Light, Wilcox Up light Wood Top Pendant, Wilcox Up light Wood Top Pendant light, Wilcox Up light Wood Pendant, Wilcox Up light Wood Pendant light, Wood Uplight pendant, Wood Up Light Pendant, Wood Uplight Pendant Light, Wood Up Light Pendant light, Wilcox wood pendant, wilcox wood pendant light, wood top pendant, wood top pendant light, wood pendant, wood pendant light, Wilcox, Wilcox Uplight, Wilcox wood uplight, Wilcox Up Light, Wilcox wood up light, wooden, BLE-C-WULW, timber, ore, timber and ore, timber & ore, wilcox cord hung pendant, wilcox cord hung pendant light, wilcox cord hung, wilcox cord, BLE-C-WULW20, BLE-C-WULW18, BLE-C-WULW20, Light with wooden top, light with wood top, light with wooden fixture, light with wood fixture, light with wood top, light with wooden top, light with wood, light with wood socket, light with wooden socket, light with wooden sockets, light with wood sockets, wood socket, wooden sockets, wood socket light, wooden socket lights, Pendant with wooden top, pendant with wood top, Pendant with wooden fixture, pendant with wood fixture, pendant with wood top, pendant with wooden top, pendant with wood, pendant with wood socket, pendant with wooden socket, pendant with wooden sockets, pendant with wood sockets, Pendants with wooden top, pendants with wood top, Pendants with wooden fixture, pendants with wood fixture, pendants with wood top, pendants with wooden top, pendants with wood, pendants with wood socket, pendants with wooden socket, pendants with wooden sockets, pendants with wood sockets, BLE-C-WULW14, BLE-C-WULW16, BLE-C-WULW18, BLE-C-WULW20, Wilcox uplight series, wilcox uplight collection, wilcox up light series, wilcox up light collection, wilcox up-light series, wilcox up-light collection, The Wilcox uplight series, the wilcox uplight collection, the wilcox up light series, the wilcox up light collection, the wilcox up-light series, the wilcox up-light collection, SPS-0501, SPS 0501, SPS0501, wooden wesco, wood wesco, wooden wilcox, wood wilcox, wood fixtures, wood fixture, wooden fixtures, wooden fixture, wooden hanging light, wooden hanging lights, wooden hanging lighting, wood hanging light, wood hanging lights, wood hanging lighting, timber ore wilcox, wooden top barn light, wood lights, wood and metal lights, wilcox uplight wooden top pendent, timber ore,
65459 <p><span data-contrast="auto"><span>The Wilcox brings an eye-catching look to any space — no matter what style! A timeless design, the slight separation between the shade and mounting allows a touch of illumination to escape as </span></span><span data-contrast="auto"><span>uplighting</span></span><span data-contrast="auto"><span>. Functional and decorative, the Wilcox functions as either an accent piece or focal point in residential and commercial locations.  </span></span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></p> <p><span data-contrast="auto"><span>A diverse array of customizing options lets the Wilcox assume the perfect look for every space. Bright, playful colors help this flush mount pendant stand out while dark or neutral finishes help the Wilcox blend in with existing designs. </span></span></p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting stem mount option.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> A timeless design, the Wilcox Uplight Flush Mount Pendant Light offers style and illumination to residential and commercial settings! American made, handcrafted, and fully customizable! Wilcox Flush Mount Light, Wilcox Flush Mount, Wilcox Flush Mount Pendant, Wilcox Pendant, Wilcox Pendant Light, Wilcox ceiling light, Wilcox flush mount ceiling pendant, Wilcox flush, Flush Wilcox, The Wilcox Flush Mount Light, The Wilcox Flush Mount, The Wilcox Flush Mount Pendant, The Wilcox Pendant, The Wilcox Pendant Light, The Wilcox ceiling light, The Wilcox flush mount ceiling pendant, The Wilcox flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Wilcox Uplight Flush Mount Light, Wilcox Uplight Flush Mount, The Wilcox Uplight Flush Mount Light, The Wilcox Uplight Flush Mount, H-16312, H-16314, H-16316, uplight deep bowl shade,