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 (
    65103, 65454, 65102, 65596, 65597, 65683, 
    65608, 65612, 65602, 65610, 65611, 
    65598, 65873, 65965
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00085

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": 14,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65103,65454,65102,65596,65597,65683,65608,65612,65602,65610,65611,65598,65873,65965) 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,
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,
65598 <p><span>With a shape reminiscent of a vintage beaker pendant, the Fontana Stem Mount Pendant Light is updated with a dash of mid-century style. This satin black pendant is crafted from hand-worked iron and encompassed by a glass shade which lends a contemporary feel. The sturdy stem mounting ensures this fixture is suitable for both residential and commercial settings. </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>Satin Black Finish </li> <li>Adjustable Stem </li> </ul> With plenty of mid century style, this stem mount pendant light is crafted from iron and finished in black for a timeless feel. F7663, F7663-SBK, atticus, troy, glass pendant, glass pendant light, glass and metal pendant, glass and metal light fixture, glass and metal light, triangle light, beaker light, mid-century modern light, mid-century light fixture, mid-century pendant light, perforated light fixture, perforated pendant, clear glass light, modern fixture, modern light, modern light fixture, modern pendant, geometric light, angular light fixture,
65602 <p>With subtle curves and perforated shades, the six fixtures of the Trevino Chandelier are affixed to sturdy stems creating an eye-catching centerpiece for your space. Hand-worked from steel, this light offers gentle lighting that is slightly diffused behind each curved shade. Finished with Modern Bronze and Aged Brass for a classic vibe!</p> <p>|break|</p> <ul> <li>This product is imported by Troy, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Light Bulbs Not Included </li> <li>Includes: (1) 6" Stem, (2) 12" Stems and (1) 18" Stem</li> </ul> A multi-light chandelier that is both functional & stylish. Perfect for dining rooms, living rooms, and commercial spaces. F6876, F6878, F7118, F7116, pilsen, troy , metal chandelier, industrial chandelier, cylinder shade chandelier, mixed metal chandelier, 6 light chandelier, 8 light chandelier, modern chandelier,
65608 <p><span>Minimalist style with maximum presence! The Lennox 5-Light Chandelier features five shades suspended from sprawling metal arms all in a soft black finish. The stem is adjustable and the shades can be rotated to cast light directly where you need it most. Add this dramatic chandelier to your dining room or commercial space for eye-catching style!</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>Features a Soft Black Finish </li> <li>Adjustable Stem </li> </ul> This multi-light chandelier offers a minimalist profile with maximum style! With adjustable stem & shades to direct light where needed! F7815, leo, troy, 5 light chandelier, minimalist chandelier, minimal chandelier, thin chandelier, parabolic chandelier, modern chandelier, skinny chandelier, adjustable chandelier,
65610 <p><span>The iconic hourglass shape of the Russo Stem Mount Pendant Light offers a classic mid-century modern feel. An opal glass globe peeks from beneath the sleek shade while the metal band centered on the shade adds a touch of color. Perfect for kitchen islands, dining room tables, or home office spaces, this adjustable stem mount pendant can be customized with either a Black or White shade.</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>Opal Shiny Glass</li> <li>Features an Adjustable Stem </li> </ul> A ceiling pendant light with a mid century modern vibe. Suitable for kitchen lighting, dining lighting or commercial spaces! F8615-SBK/PN, F8615-SWH/PB, scout, troy, hourglass pendant light, hour glass pendant light, modern pendant, angular pendant, opal glass globe pendant, glass and metal pendant, glass and metal light, mid-century modern light,
65611 <p>Multiple bulbs tuck under a shallow shade crafted from hand-worked iron to create the Briggs Chain Hung Pendant Light. Oozing with industrial style and detailing, this chain hung pendant is perfect for the man cave, kitchen, hallway, or craft room. Beautifully finished in Brooklyn Bronze for a rugged and classic look!</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>Features a Rope Covered Stem and Chain Mounting</li> <li>12" Shade will Include One Socket, 18" Shade will Include 3 Sockets and 26" Shade will Include 4 Sockets</li> <li>Brooklyn Bronze Finish  </li> </ul> A chain hung pendant that oozes industrial styling is perfect for the man cave, kitchen, or garage workshop! F3144, F3145, F3146, brooklyn light, troy, rope, rope pendant, rope and chain pendant, rope accent pendant light, cabin pendant, cabin pendant light, lakehouse pendant, lakehouse pendant light, rustic light, natural pendant light, mixed material pendant light,
65612 <p><span>The Callaway Chandelier offers an elevated and contemporary look with its sleek frame and clear seeded glass. Crafted from steel, this eye-catching chandelier adds a dramatic statement to dining spaces, kitchens, and commercial settings. Change the look of the light by simply switching out styles of light bulbs to create the perfect glow. Easy to customize with Oil Rubbed Bronze and Polished Nickel finishes.</span></p> <p>|break|</p> <ul> <li>This product is imported by Feiss, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Polished Nickel or Oil-Rubbed Bronze Finish with Clear Seeded Glass</li> <li>Light Bulbs Not Included </li> </ul> Chandelier lighting makes a dramatic statement with its multi-bulb design and clear seeded glass frame! F3073-5PN, F3073-5ORB, harrow, harrow chandelier, feiss, linear chandelier, 5-light chandelier, 5 light chandelier, modern chandelier, glass chandelier, glass box chandelier, seeded glass chandelier, glass light, glass chandelier, double stem chandelier, rectangle chandelier, linear pendant light,
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,
65873 <p data-start="129" data-end="448">The Duo Stem Pendant is a bold and versatile lighting fixture designed for both style and flexibility. Featuring a mix-and-match design, this pendant allows you to choose three different finishes for the top, bottom and interior, giving you complete creative control to complement any interior.</p> <p data-start="450" data-end="745">Available in 10-inch and 14-inch sizes, the Duo Pendant showcases a stacked bowl design, offering a modern yet timeless aesthetic. Suspended from a sleek, thin stem, this pendant is perfect for dining rooms, kitchens, and living spaces, casting a warm and inviting glow.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Customizable with the unique ability to select different finishes for the bottom shade’s interior and exterior.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> Customize your lighting with the Duo Loma Stem Pendant, available in 10" and 14" sizes with mix-and-match finishes. Featuring a stacked bowl design, this modern pendant is perfect for kitchens, dining areas, and living spaces. Shop now! duo pendant, duo stem, duo stem mount, duo light, duo fixture, modern pendant, modern stem mount, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round pendant, dome pendant, mid-century modern pendant, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse pendant, sleek pendant, neutral pendant,
65965 <p class="p1"><span>With its sleek profile and refined simplicity, the Isos Cone Studio Pendant brings contemporary style to any setting. Offered in three unique shade sizes, this pendant lets you create just the right look and level of impact. Choose from a wide selection of exterior and interior finishes, then top it with your choice of wood or metal for a natural or modern accent. The result is a clean, versatile aesthetic that feels effortlessly sophisticated.</span></p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span><span>Adjustable length with Griplock<strong class="Yjhzub">®</strong><span> </span>technology</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a></li> </ul> The Isos Cone Studio Pendant features a sleek, contemporary design available in three shade sizes. Customize with a variety of finishes and a wood or metal top for a look that’s clean, versatile, and effortlessly sophisticated. isos studio, cord isos, the isos, oversized light, triangle light, geometric light, geometric pendant, large modern light, modern pendant, studio isos, isos collection, studio mount, oversized studio light, adjustable light,