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 (
    65856, 65860, 65937, 65859, 65861, 65888, 
    65956, 65838, 65890, 65889, 65836, 
    65891, 65964
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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": 13,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65856,65860,65937,65859,65861,65888,65956,65838,65890,65889,65836,65891,65964) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65836 <div> <div lang="en-US"> <p lang="en-US">Blending modern minimalism with organic warmth, The Carver LED Wall Light features a sleek circular design with a smooth, aluminum outer frame and a central handcrafted solid wood accent. This energy-efficient fixture is powered by integrated LED technology, providing a soft, ambient glow while ensuring long-lasting performance and low energy consumption.</p> <p class="p1"><span class="s1">Available in three size options, The Carver is versatile enough for various applications, from accent lighting in hallways to statement pieces in living spaces and bedrooms. Designed for both aesthetics and functionality, this fixture delivers a perfect balance of natural texture and contemporary design.</span></p> </div> </div> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.  </li> <li> <div>Part of our exclusive <a title="Learn more about our Timber &amp; Ore Collection" href="/timber-ore-collection/">Timber &amp; Ore Collection</a></div> </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> Elevate your space with The Carver LED Wall Light, a modern fixture featuring a sleek circular design, wood-grain accent, and energy-efficient LED technology. Available in three sizes for versatile styling. Carver LED Wall Light, Modern LED Wall Sconce, Wood Accent Wall Light, Minimalist LED Light Fixture, Contemporary Wall Lighting, Natural Wood Wall Sconce, Round LED Wall Lamp, Energy-Efficient Wall Light, Warm Ambient LED Fixture, Designer Wall Lighting, Neutral Tone Wall Light, Soft Glow LED Wall Fixture, Decorative Indoor Wall Lamp, Organic Modern Wall Light, Three Size LED Wall Light
65838 <p class="p1"><span class="s1">The Cassidy Pendant brings contemporary character to any space with its clean lines and utilitarian aesthetic. Featuring a steel shade and a smooth white globe diffuser, this fixture delivers up to 2000 lumens of warm, energy-efficient LED light—ideal for task or ambient lighting.</span></p> <p class="p1"><span class="s1">Suspended from a durable cord, the Cassidy is designed to suit kitchens, dining rooms, entryways, and commercial settings alike. Its timeless silhouette and rugged construction offer both form and function, while the soft glow from the globe keeps the atmosphere warm and welcoming.</span></p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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> Add modern charm with vintage flair—this Cassidy LED Pendant pairs a sleek finishes with a timeless globe shade for a bold, design-forward statement. Shop now!
65856 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11 ¼" x Dia. 6 ¼" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37098,
65859 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 11" x Dia.7 ⅞" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37101,
65860 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> 25</span></span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 10 ¼" x Dia. 6 ¾" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37102,
65861 <p><span>Enhance your lighting experience with our vintage-inspired bulbs, a versatile solution that can be installed in any light fixture or used independently to create a stunning focal point. Whether you’re aiming for a vintage charm or sleek modern aesthetic, these bulbs are made to fit any space. This energy-efficient bulb is suitable to replace traditional<span> </span></span><span>40</span><span>W incandescent bulbs, providing a substantial energy savings without compromising on style.</span></p> <p>|break|</p> <ul> <li>Dimensions: MOL 6 ⅞" x Dia. 5" </li> <li>Full Glass Construction </li> <li>Smooth Dimming with Forward/Reverse Phase Controls </li> <li>330° Omnidirectional Beam Angle </li> </ul> new bulb, led bulb, green creative, 37103,
65888 <p class="p1">Elevate your space with the clean lines and sculptural silhouette of the Cassidy LED Pendant, including a galvanized studio cable for added architectural appeal. This contemporary fixture features a soft opal globe diffuser and your choice of two shade sizes, offering flexibility in both style and scale. Designed to suit a variety of residential and commercial spaces, it delivers up to 2000 lumens of energy-efficient LED illumination—making it a smart and stylish choice for any interior</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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> A modern LED pendant with minimalist lines and two shade sizes, the Cassidy pairs sleek design with powerful, energy-efficient illumination—ideal for residential or commercial interiors.
65889 <p class="p1">The Cassidy LED Globe Chain Pendant combines industrial charm with modern versatility. Featuring a clean globe diffuser and a wide, flat shade, this fixture offers a bold yet balanced silhouette. The sturdy chain mount includes a quicklink for easy, adjustable hanging height, making it adaptable to a variety of spaces—from kitchen islands to commercial settings.</p> <p class="p1">With over 30 finish options available, you can tailor the look to perfectly suit your design vision. Energy-efficient LED technology delivers up to 2000 lumens of bright, ambient light.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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> The Cassidy LED Globe Chain Pendant combines modern style with customizable features, including adjustable hanging length and over 30 finish options. Shop now to elevate your lighting.
65890 <p class="p1">The Cassidy LED Stem Mount Pendant brings modern industrial charm to any space with its striking silhouette and minimalist globe design. The fixed stem creates a clean, tailored look—perfect for kitchens, hallways, or commercial interiors seeking a sleek, refined aesthetic. With over 30 finish options and bright, energy-efficient LED illumination (up to 2000 lumens), it offers both performance and personality.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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> Modern and minimal, the Cassidy LED Stem Pendant Light delivers clean-lined style and brilliant performance—customize with 30+ finishes to suit any space.
65891 <p class="p1">The Cassidy LED Globe Flush Mount Pendant offers a sleek, low-profile design that blends streamlined simplicity with bold visual impact. Its sculptural silhouette—featuring a wide shade and opal globe diffuser—delivers ambient, glare-free light while hugging close to the ceiling, making it ideal for lower-clearance spaces. Available in over 30 finish options, this fixture brings refined style and reliable performance to kitchens, hallways, or entryways alike.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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> The Cassidy LED Globe Flush Mount Light pairs bold, modern design with a space-saving profile—available in 30+ finishes for a customized, low-clearance lighting solution.
65937 <p data-start="163" data-end="509">Clean lines and handcrafted details meet in the Suora LED Linear Suspension Light. This striking fixture pairs a solid wood bar with a sleek, powder-coated canopy, blending warmth and modern style with subtle curves, exposed cables, and rich wood grain. Offered in multiple sizes, wood species, finish options, and color temperatures, Suora delivers efficient, dimmable LED lighting—perfect for kitchens, dining areas, offices, and workspaces of all styles.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Adjustable suspension cables for flexible installation</li> <li>Crafted with FSC-certified hardwoods from North American suppliers, ensuring sustainable forestry practices.</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> LED linear light, wood suspension light, modern pendant lighting, handcrafted lighting, linear pendant, Suora light, kitchen island lighting, American made lighting, minimalist lighting, customizable light fixture Discover the Suora LED Linear Suspension Light, a sleek wood pendant handcrafted for modern spaces. Customizable finishes, energy-efficient LED, and timeless design make it perfect for dining areas, kitchens, and workspaces. Made in the USA. c-stu-dcm, c-stu-scm, linear suora, suora linear,
65956 <div> <div lang="en-US"> <p data-start="52" data-end="341">The Carver LED Flush Mount Light brings together clean lines and natural materials in a ceiling fixture that feels both modern and inviting. A handcrafted wood centerpiece adds warmth to the sleek aluminum frame, while integrated LED technology ensures soft, energy-efficient illumination.</p> <p data-start="343" data-end="673">Offered in three sizes, the Carver is a versatile choice for spaces that need a subtle statement—whether it’s brightening a hallway, adding character to a bedroom, or complementing an open living area. Designed with simplicity and craftsmanship in mind, this flush mount fixture delivers timeless style with practical performance.</p> </div> </div> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.  </li> <li> <div>Part of our exclusive <a title="Learn more about our Timber &amp; Ore Collection" href="/timber-ore-collection/">Timber &amp; Ore Collection</a></div> </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> The Carver Flush Mount Light blends sleek, modern design with organic warmth. Powered by energy-efficient LED technology, this low-profile fixture delivers soft, inviting illumination for any space. Carver LED Wall Light, Modern LED Wall Sconce, Wood Accent Wall Light, Minimalist LED Light Fixture, Contemporary Wall Lighting, Natural Wood Wall Sconce, Round LED Wall Lamp, Energy-Efficient Wall Light, Warm Ambient LED Fixture, Designer Wall Lighting, Neutral Tone Wall Light, Soft Glow LED Wall Fixture, Decorative Indoor Wall Lamp, Organic Modern Wall Light, Three Size LED Wall Light, Flush Mount Light, Modern Flush Light, Modern Flush Mount Wall Light, Carver Flush Mount Light, Modern Wood Accent Light, LED Flush Mount Fixture, Handcrafted Wood Lighting, Low Profile Ceiling Light, Modern Rustic Flush Light, Energy Efficient Flush Mount
65964 <p class="p1"><span class="s1">The Isos LED Cone Studio Pendant blends modern minimalism with handcrafted warmth. Its clean cone shape and integrated LED technology provide efficient, ambient light. Customize your look with a wide range of exterior and interior finishes, and choose a wood or metal top to match your style, whether you prefer something natural and organic or sleek and contemporary. Thoughtfully crafted in Florida, the Isos Pendant offers a versatile lighting solution that feels both modern and inviting.</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 LED Cone Studio Pendant combines modern form with natural warmth, featuring hand-spun metal and an optional wood accent. Made in Florida. isos studio, led isos, the isos, oversized led, oversized led light, oversized light, large modern light, modern led, studio isos, isos collection, studio mount led, oversized studio light, adjustable led light,