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 (
    65688, 65103, 65454, 65694, 65102, 65596, 
    65696, 65519, 65597, 65683, 65613, 
    65702
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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": 12,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65688,65103,65454,65694,65102,65596,65696,65519,65597,65683,65613,65702) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65102 <p><span data-contrast="auto"><span data-wac-het="1">A practical option abundant with decorative appeal, the Sinclair is a favorite for residential and commercial spaces. Classic lighting is central to this fixture’s design. The large-scale shallow bowl shade evokes vintage industrial lights, which gives the Sinclair a timeless feel. At home in contemporary and traditional décors, this pendant offers every setting a grounded, elevated character.  </span></span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}" data-wac-het="1"> </span></p> <p><span data-contrast="auto"><span data-wac-het="1">The Sinclair’s rugged stem mounting protects its wires, allowing installation indoors and out. Commercial-grade materials make this pendant one of the most reliable lighting fixtures available. Fully customizable, numerous powder coat </span></span><span data-contrast="auto"><span data-wac-het="1">finishes</span></span><span data-contrast="auto"><span data-wac-het="1"> and other unique options help the Sinclair stand out in any space.</span></span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}" data-wac-het="1"> </span></p> <p>|break|</p> <ul> <li>Features a 28" oversized shade, hand spun in the USA </li> <li><span>Made-to-order, learn more about the process</span><span> </span><a href="https://www.barnlight.com/video-gallery/">here</a><span>.</span></li> <li><span>LED version coming soon!</span></li> </ul> With its 28” shade and stem mounting, the Sinclair stands out in every home or business. Durably crafted and fully customizable, create the perfect look for your space! BLE-S-SBS28, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Stem Pendant Light, Sinclair 28" Stem Pendant, Sinclair 28" Stem Light, Sinclair 28" Stem, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Stem Pendant Light, Sinclair 28 Stem Pendant, Sinclair 28 Stem Light, Sinclair 28 Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Stem Pendant Light, 28 Sinclair Stem Pendant, 28 Sinclair Stem Light, 28 Sinclair Stem, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Stem Pendant, Sinclair Stem, 28”, Sinclair 28” Stem Mount Pendant Light, Sinclair 28" Stem Mount Pendant, Sinclair 28" Stem Mount, Sinclair 28" Stem Mount Light, Sinclair 28 Stem Mount Pendant Light, Sinclair 28 Stem Mount Pendant, Sinclair 28 Stem Mount, Sinclair 28 Stem Mount Light, 28” Sinclair Stem Mount Pendant Light, 28” Sinclair Stem Mount Pendant, 28” Sinclair Stem Mount, 28” Sinclair Stem Mount Light, 28 Sinclair Stem Mount Pendant Light, 28 Sinclair Stem Mount Pendant, 28 Sinclair Stem Mount, 28 Sinclair Stem Mount Light, 28" sinclair,
65103 <p>In this design, industrial detailing unites with classic lighting styles to create a pendant with near-universal appeal. The Sinclair, while still embracing vintage influences, complements the very latest contemporary looks. To create this timeless appearance, an oversized RLM shade is suspended from a rugged chain mounting. As either an accent piece or focal point, the Sinclair can put the finishing touches on residential and commercial décors.</p> <p>This fixture is made with the skill and integrity associated with American made lighting, offering an unmatched sense of durability and longevity. Finish colors ranging from bold to understated and a variety of cord options let the Sinclair take on the ideal look for every space.</p> <p>|break|</p> <ul> <li>Features a 28" oversized shade, hand spun in the USA </li> <li><span>Made-to-order, learn more about the process</span><span> </span><a href="https://www.barnlight.com/video-gallery/">here</a><span>.</span></li> <li><span>LED version coming soon!</span></li> </ul> Industrial and eye-catching, this chain hung pendant features a large, 28” shade! Meticulously crafted and customizable for truly unique looks! BLE-CN-SBS28, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Chain Pendant Light, Sinclair 28" Chain Pendant, Sinclair 28" Chain Light, Sinclair 28" Chain, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Chain Pendant Light, Sinclair 28 Chain Pendant, Sinclair 28 Chain Light, Sinclair 28 Chain, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Chain Pendant Light, 28” Sinclair Chain Pendant, 28” Sinclair Chain Light, 28” Sinclair Chain, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Chain Pendant Light, 28” Sinclair Chain Pendant, 28” Sinclair Chain Light, 28” Sinclair Chain, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Chain Pendant Light, 28 Sinclair Chain Pendant, 28 Sinclair Chain Light, 28 Sinclair Chain, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Chain Pendant, Sinclair Chain, Sinclair 28" Chain Hung Pendant Light, Sinclair 28" Chain Hung Pendant, Sinclair 28" Chain Mount Pendant Light, Sinclair 28" Chain Mount Pendant, Sinclair 28 Chain Hung Pendant Light, Sinclair 28 Chain Hung Pendant, Sinclair 28 Chain Mount Pendant Light, Sinclair 28 Chain Mount Pendant, 28 Sinclair Chain Hung Pendant Light, 28 Sinclair Chain Hung Pendant, 28 Sinclair Chain Mount Pendant Light, 28 Sinclair Chain Mount Pendant, 28" sinclair,
65454 <p>Modern lighting stands out with its clean, round lines and chic styles, and the Chateau perfects this look! As either an accent piece or focal point, this flush mount pendant’s curved profile functions as subtle hints of character in residential and commercial lighting plans. Customize the Chateau’s appearance with your favorite finish color and other unique options.  </p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process<span> </span></span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/">here</a>!</li> <li>Shade Size:<strong><span> </span></strong>Width 6.5" x Height 9" </li> <li>Read more about our Chateau Flush Mount Light over on the <a href="/inspiration/professionals-corner-modern-pendants-offer-industrial-vibe-to-cafe/" target="_blank">blog</a>!</li> </ul> Flush mount lighting with a modern edge, the Chateau elevates residential and commercial spaces! American made and handcrafted, this fully customizable flush mount light will transform every decor! Chateau Flush Mount Light, Chateau Flush Mount, Chateau Flush Mount Pendant, Chateau Pendant, Chateau Pendant Light, Chateau ceiling light, Chateau flush mount ceiling pendant, Chateau flush, Flush Chateau, The Chateau Flush Mount Light, The Chateau Flush Mount, The Chateau Flush Mount Pendant, The Chateau Pendant, The Chateau Pendant Light, The Chateau ceiling light, The Chateau flush mount ceiling pendant, The Chateau flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-BIS,
65519 <p><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">Swapping out damaged glass in our Glass Ball Pendants has never been<span> </span></span></span><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">simpler</span></span><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">, thanks to these replacement globes. We’ve made all three sizes and both opaque and clear shades available, that way you can easily recreate your pendant’s initial style.</span></span><span class="EOP SCXW45342300 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></p> Change out broken glass shades with these stylish replacements! Available in three sizes and opaque and clear! BLE-GLB-GLASS, replacement glass ball, replacement glass ball shade, replacement glass ball shades, replacement ball, replacement ball shade, replacement ball shades, replacement glass shade, replacement glass shades, Glass ball shade, glass ball shades, ball shade, ball shades, replacement globes, bubble glass, glb, glbcl,
65596 <p>The Double Maven Rope Chandelier boasts all the nautical style of our single Maven Chandelier but with two layers of lighting. Eighteen <span>sockets mounted to two large metal rings are suspended from sturdy ropes. This dramatic fixture will create a head-turning focal point in both residential and commercial spaces.</span></p> <p><span>Featuring a Shipyard Bronze finish, the Double Maven Rope Chandelier brings a classic and dramatic flair with its oversized profile and rugged styling. </span></p> <p>|break|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Shipyard Bronze Finish with Brown Jute Rope</li> <li>18 Sockets - 40W E12 Candelabra Base</li> <li>18 Bulbs Included </li> </ul> Double the style with the Maven Rope Chandelier! Two layers of lighting to add a dramatic focal point to your space! The Maven Chandelier, maven, outerbanks, outer banks chandelier, round chandelier, medieval chandelier, BLE-C-CH012, mavin, mavan, vintage chandelier, maven chandileir, ring chandelier, rope, rope hung, rope mount, rope mount lighting, chain mount chandelier, chandelier, industrial chandelier, rustic chandelier, farmhouse, modern farmhouse, farm house, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, new maven, rope chandelier, maven rope, mavin rope, maven rope chandelier, mavin rope chandelier, maven rope chandeliers, mavin rope chandeliers, outer bank, outer banks, F3128, pike place, troy, wagon wheel chandelier, wagon wheel light, wagon wheel pendant,
65597 <p>Bringing industrial elements into your décor has never been easier with the Copeland Stem Mount Pendant! Starting with a sturdy stem mounting, this fixture features a polished nickel vented cap atop a prismatic clear glass shade. A <span>metal-rimmed, Fresnel lens glass diffuser focuses the illumination for better task lighting and is held in place with knurled thumbscrews adding another beautiful industrial detail. </span></p> <p>|break|</p> <ul> <li>This product is imported by Hudson Valley, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Features a Fresnel Lens Prismatic Glass Diffuser</li> <li>Includes a 3", 6", 12" and (2) 18" stems </li> </ul> This sturdy stem mount pendant oozes industrial style but the prismatic glass shade adds a touch of elegance! 7311, 7311-AGB, 7311-OB, 7311-SN, 7311-PN, 7308, 7308-AGB, 7308-OB, 7308-SN, 7308-PN, 7311, 7315-AGB, 7315-OB, 7315-SN, 7315-PN, haverhill, hudson valley, glass pendant light, diffuser pendant light, light with metal arms, glass and metal light, ribbed glass, ribbed, ribbed glass pendant, glass stem light, glass farmhouse light, ambient glass lighting, glass industrial light,
65613 <p>Create an inviting atmosphere at your front porch or doorway with the Ledford Wall Sconce! Crafted from hand-worked iron and finished in Textured Black, this wet-rated wall sconce offers a taste of nostalgia with its traditional lantern shape and hanging shade. Opal white glass eliminates glare and diffuses the illumination for a welcoming glow. </p> <p>|break|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Textured Black Finish </li> <li>Opal White Glass </li> </ul> Outdoor lighting with a classic profile & rugged construction. White glass provides diffused illumination for less glare. B6351, B6353, B6357, mission beach, troy, lantern, outdoor lantern, glass lantern, rectangle lantern, modern lantern, simple outdoor lantern, cylinder glass lantern, outdoor sconce, wet location sconce, modern outdoor lantern,
65683 <p>With inspiration from an era when candles were the only option for illumination, the Ledford Chain Hung Pendant brings the timeless look of a lantern to the modern age. With its sleek Textured Black frame enclosing an opal glass shade, this lantern lends a classic vibe to kitchens, covered porches, and dining rooms. The rugged chain mounting adds a dash of industrial styling to create an eye-catching fixture!</p> <p>|break|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Textured Black Finish </li> <li>Opal White Glass </li> </ul> Outdoor lighting with a classic profile & rugged construction. White glass provides diffused illumination for less glare. B6351, B6353, B6357, F6357, mission beach, troy, lantern, outdoor lantern, glass lantern, rectangle lantern, modern lantern, simple outdoor lantern, cylinder glass lantern, modern outdoor lantern, ledford, ledford chain, chain hung lantern, front porch lantern, F6357, chain lantern, chain mount lantern,
65688 <p><span>Capture the look you love without breaking the bank! This collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p>Influenced by 1930s-era gas station lighting, the Seaside’s shallow, wavy shade offers excellent light spread. By embracing an inherently playful shape, the Seaside complements eclectic modern décors, urban businesses, and other spaces. Mounted to a rugged gooseneck arm with meticulous craftsmanship, the Seaside commands attention and establishes an enviable curb appeal.</p> <p class="title">|break|</p> <ul> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/wall-lights/gooseneck-lights/seaside-gooseneck-light/">here</a> for our complete listing!</li> </ul> Looking for that perfect balance of coastal charm and industrial durability? Our Barn Light Basics Seaside Gooseneck Light is the affordable option for you! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, discount modern lights, basic modern light, seaside gooseneck, seaside light, seaside basic, seaside gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, radial wave gooseneck, radial wave discount light, back to basics, basic seaside gooseneck,
65694 <p><span>Capture the look you love without breaking the bank! This collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p><span>Embracing historic manufacturing techniques and vintage designs, the Wilcox Gooseneck Light is modern version of deep bowl lighting. Incredibly stylish, the Wilcox starts as a flat piece of durable aluminum. Our team of skilled artisans carefully works the metal into the shade’s iconic shape. T<span>he deep bowl shade’s eye-catching style and focused beam of light create welcoming and fashionable commercial and residential décors.<span> </span></span></span></p> <p class="title">|break|</p> <ul> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/wall-lights/gooseneck-lights/wilcox-deep-bowl-gooseneck-light/" target="_blank">here</a> for our complete listing!</li> </ul> An iconic silhouette that won't break your budget! Our Barn Light Basics Wilcox Gooseneck Light is the heavy duty deep bowl shade you've been looking for! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, bowl light, bowl shaped gooseneck, deep bowl light, deep bowl gooseneck, modern gooseneck light, discount modern lights, basic modern light, wilcox gooseneck, wilcox light, wilcox basic, wilcox gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade gooseneck,
65696 <p><span>Capture the look you love without breaking the bank! Our Barn Light Basics collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p><span>With a modern twist on the iconic warehouse shade, the Wilcox combines classic lines with contemporary style. Like vintage lights made decades ago, the Wilcox prioritizes craftsmanship and performance. Modern designers are drawn to the Wilcox for its dramatic deep bowl shade which provides not only a focused beam of light, but serves as an eye-catching focal point or noticeable accent piece.</span></p> <p class="title">|break|</p> <ul> <li>Ceiling canopy will match shade finish. </li> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/ceiling-lights/cord-hung-pendant-lighting/wilcox-deep-bowl-pendant-light/" target="_blank">here</a> for our complete listing!</li> </ul> The deep bowl style you love at a price you'll love even more! Our Barn Light Basics Wilcox Pendant Light is the perfect statement for above a dining room table! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, wilcox basic, basic wilcox, wilcox basics, bowl light, bowl shaped pendant, wilcox cord, deep bowl light, deep bowl pendant, modern cord light, modern cord pendant, discount modern lights, basic modern light, wilcox light, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade cord-hung pendant,
65702 <p><span>Capture the look you love without breaking the bank! Our Barn Light Basics collection of handcrafted fixtures </span><span>are offered with minimal customizing options for easy ordering and to help save you money. These fixtures are handspun from standard-grade aluminum which is longer lasting and more weather resistant than steel lighting</span><span>. All products within this collection are crafted with pride right here in America at our Florida manufacturing facility.</span></p> <p>Bring the iconic look of RLM warehouse shades to your home or business with the Avalon! Modeled after 1930s designs, the Avalon offers a classic style to contemporary settings. In residential settings, the Avalon supplies character when installed above kitchen islands, dining room tables, and in living spaces. As commercial lighting, this pendant provides a cohesive style throughout an entire business. American made and handspun by our talented artisans, the fixture’s deep bowl shade is attentively manufactured ensuring a high-quality lighting design.</p> <p>|break|</p> <ul> <li>Formerly our "Farm &amp; Barn Warehouse Pendant"</li> <li>Ceiling canopy will match shade finish. </li> <li>Preview our entire Barn Light Basics Collection <a href="/barn-light-basics/">here</a>! </li> <li>Interested in additional customization options? Click <a href="/lighting/ceiling-lights/cord-hung-pendant-lighting/loma-pendant-light/" target="_blank">here</a><span> </span>for our complete listing!</li> </ul> The farm & barn style you love at a price you can't beat! Handspun aluminum makes our Barn Light Basics Avalon Pendant Light a durable yet stylish choice! basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, avalon basic, avalon basics, avalon light, warehouse pendant, avalon warehouse pendant, avalon cord, avalon cord light, avalon cord pendant, discount barn lights, discount warehouse lights, basic barn light, simple barn light, minimal barn light, discount lights, discount fixtures, discount, farm & barn, farm & barn light, farm and barn, farm and barn light, farm & barn pendant, farm and barn pendant, farm & barn cord, farm & barn cord pendant, back to basics,