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 (
    65705, 65561, 64614, 60731, 60726, 60750, 
    60734, 61388, 64622, 60741, 64623, 
    64626
  ) 
  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": 12,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65705,65561,64614,60731,60726,60750,60734,61388,64622,60741,64623,64626) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
60726 <p>With its straightforward aesthetic, the G1 complements nearly every style popular in today’s homes and businesses. Durably constructed and American made, the G1 brings the classic look of gooseneck lighting to indoor and outdoor locations. Over a dozen finishes ensure there’s the right color for every space!</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> straight arm, straight gooseneck, 14 inch gooseneck, gooseneck couplers, The G1 Gooseneck Arm is a straight arm with just over a 14" inch projection. arm, gooseneck, G-1, G1, Straight gooseneck, straight arm, BLE-G1, g1, g-1, gooseneck arm dimensions, gooseneck options,
60731 <p>Thanks to its straightforward appearance and limited projection, the G3 complements a wide array of styles, including minimalist designs, farmhouse décors, and industrial-inspired aesthetics. This sturdy metal arm can be used for interior and exterior lighting applications and is customizable with a vast array of finish colors.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> straight arm, straight gooseneck, 7 inch gooseneck, gooseneck couplers, short arm, short gooseneck, The G3 Gooseneck Arm is a straight arm with a 7 1/4 inch projection. G-3, G3, Straight gooseneck, straight arm, short straight arm, short gooseneck, BLE-G3, g-3, g3, gooseneck arm dimensions, gooseneck options,
60734 <p>Embracing timeless styles and traditional lines, the G6 is perfect for both contemporary and vintage-inspired décors. An incredibly versatile mounting option, this durable gooseneck arm is intended for both interior and exterior settings. Thanks to a wide variety of finish colors, the G6 can adopt nearly any space’s preferred style.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> curvy arm, curvy gooseneck, 28 inch gooseneck, gooseneck couplers, The G6 Gooseneck Arm is a curvy arm with a 28 inch projection. G6, BLE-G6, G-6, gooseneck arm, arm, g6, g-6, g6 arm, G6 Gooseneck Arm, G6 Gooseneck Arms, G6 Gooseneck Arm - 28.5" Projection, 28.5" Projection Gooseneck Arm, gooseneck arm dimensions, gooseneck options,
60741 <p>Indebted to vintage styles, the G13’s minimalist design and curved profile is a favorite for both contemporary décors and traditionally decorated venues. Thanks to its sturdy metal construction, this gooseneck arm can be used for interior and exterior lighting applications. A diverse selection of finish colors lets the G13 adopt a wide variety of looks and styles.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> curved arm, curved gooseneck, porcelain, 11 inch gooseneck, gooseneck couplers, short gooseneck, short arm, The G13 Gooseneck Arm is has a curves down in the center. This short gooseneck comes with couplers and is painted to match our porcelain. G-13, G13, curved gooseneck, curved arm, porcelain gooseneck, shor gooseneck, BLE-G13, arm, gooseneck arm, g-13, g13, g31, gooseneck arm dimensions, gooseneck options,
60750 <p>Adopting an eye-catching curved profile, the G24 contributes character to both interior and exterior spaces. Crafted by hand in the United States, this versatile gooseneck arm features the durability home and business owners desire. Customizable with a variety of finish colors, the G24 can embrace today’s most popular looks. </p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> G24, gooseneck arm, curvy, 22 inch, extends, down, low hanging The G24 Gooseneck Arm is a standard curvy gooseneck with a 22 inch projection that extends further down. Perfect for low hanging lights. G24, Low hanging gooseneck, Standard Gooseneck, Gooseneck Arm, BLE-G24, G-24, gooseneck arm, arm, g24, g-24, g42, gooseneck arm dimensions, gooseneck options,
61388 <p>Thanks to its metal support arm, the G36 provides hints of character to traditional settings and complements trendy industrial-inspired décors. Durably crafted and capable of installation indoors or out, this gooseneck arm is among the most versatile mounting options available. To help the G36 embrace any space’s style, we offer a diverse assortment of powder coat finishes.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Includes: Wall Backing Plate and Mounting Hardware</li> <li>Construction: Aluminum</li> </ul> oversized gooseneck arm, garage lighting, barn lighting, long gooseneck arm, double gooseneck arm, heavy duty wall mount arm, flexible gooseneck arm G36 gooseneck arm has a 49.7 inch projection is designed for use with large lamp shades. Adjustable second arm provides support with flexibility in mounting height. G-36, G36, gooseneck arm, heavy duty gooseneck arm, double arm gooseneck, adjustable gooseneck arm, arm, g-36, g36, gooseneck arm dimensions, gooseneck options,
64614 <p>Simultaneously decorative and functional, this LED light bulb establishes a unique partnership between captivating aesthetics and sustainable technology. Made from mouth-blown glass, the bulb features a curved design that appears naturally sculpted. The bulb’s iron tinted glass produces a gentle ambient glow, giving a space a warm atmosphere and inviting décor. Thanks to the LEDs, this environmentally sustainable and budget friendly light bulb reduces a home or business’s overall energy consumption.</p> <p>|break|</p> <ul> <li>Dimensions: W 4.92" x H 6.89"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light + Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> Partnering beautiful aesthetics and cutting-edge technology, this LED light bulb brings a decorative character and energy efficiency to homes and businesses! 28VORN-I-2W-2200K-E26-T-120V, Voronoi I LED Tala Lamp, Voronoi I LED Tala Lamps, The Voronoi I LED Tala Lamp, The Voronoi I LED Tala Lamps, Voronoi I LED Tala Bulb, Voronoi I LED Tala Light Bulb, Voronoi I LED Tala Light Bulbs, Tala Lamps, Tala Light Bulb, Tala Bulbs, Tala Light Bulbs, Voronoi, Voronoi Light Bulb, Voronoi Light Bulbs, Voronoi Bulb, Voronoi LED Bulb, Voronoi LED Bulbs, Voronoi LED Light Bulb, Voronoi LED Light Bulbs, Voronoi, Voronoi I, LED Bulb, LED Bulbs, LED Light Bulb, LED Light Bulbs, Tala Lamp, Tala Lamps, tala, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, globe tala,
64622 <p>Eye-catching yet practical, the Oval embraces a sophisticated style and efficient technology. The bulb’s soft rounded shape expresses an elevated contemporary aesthetic, one intended to capture attention as a decorative feature or function as an accent piece. To cast a calming white glow, the bulb’s finish slightly dampens its illumination. Thanks to its LEDs, the Oval significantly reduces a venue’s overall electricity demands, resulting in a cost-effective and environmentally sustainable design.</p> <p>|break|</p> <ul> <li>Dimensions: W 6.4" x H 5.7"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light + Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> Decorative LED light bulbs! Including this bulb in a room establishes an elevated décor and reduces energy needs! Efficient, budget minded, and sustainable! 28NOMA-6W-2700K-E26-MP-120V, Oval LED Tala Lamp, Oval LED Tala Lamps, The Oval LED Tala Lamp, The Oval LED Tala Lamps, Oval LED Tala Bulb, Oval LED Tala Bulbs, Oval LED Tala Light Bulb, Oval LED Tala Light Bulbs, Oval LED Bulb, Oval LED Bulbs, Oval LED Light Bulb, Oval LED Light Bulbs, Tala, Tala LED, Tala Bulb, Tala Light Bulb, Tala LED Bulb, Tala LED Bulbs, Tala LED Light Bulb, Tala LED Light bulbs, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb,
64623 <p>By adopting a unique triangular shape and the latest LED technology, the Noma’s design prioritizes aesthetics and performance equally. Representative of the latest contemporary styles, the Noma’s soft shape and eye-catching lines let it stand out as a decorative accent piece. To lower power bills and promote environmental sustainability, the Noma’s LEDs convert electricity into illumination with unparalleled efficiency. The Noma’s soft white finish produces gentle light, helping rooms feel warm, welcoming, and comfortable.</p> <p>|break|</p> <ul> <li>Dimensions: W 6.4" x H 5.7"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light + Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> Eye-catching, high performance LED Bulbs! The Noma functions as a decorative feature while illuminating a space! Energy efficient and environmentally friendly! 28NOMA, 28NOMA, Noma, Noma bulb, noma bulbs, noma light bulb, noma light bulbs, noma lighting bulb, noma lighting bulbs, tala, tala bulb, tala bulbs, tala light bulb, tala light bulbs, tala lighting bulb, tala lighting bulbs, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, tube bulb, tube bulbs, tube light bulb, tube light bulbs, tube lighting bulb, tube lighting bulbs, led tube bulb, led tube bulbs, led tube light bulb, led tube light bulbs, led tube lighting bulb, led tube lighting bulbs, tube led bulb, tube led bulbs, tube led light bulb, tube led light bulbs, tube led lighting bulb, tube led lighting bulbs,
64626 <p>With its diminutive size and enduring style, the Lurra contributes a touch of character to lighting fixtures. To create its timeless aesthetic, the Lurra incorporates a short tubular design and eye-catching LED filaments. This look complements both traditional décors and contemporary spaces. As an efficient source of light, these LED bulbs reduce a venue’s overall energy consumption saving money and greatly benefiting the environment.</p> <p>|break|</p> <ul> <li>Dimensions: W 9.8" x H 9.8"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light x Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> A fashionable, efficient LED light bulb! The Lurra presents a classic style and is environmentally and budget friendly! Replace standard bulbs with this stylish LED bulb! Lurra LED Tala Lamp, The Lurra LED Tala Lamp, Lurra LED Tala Lamps, The Lurra LED Tala Lamps, Lurra LED Lamp, Lurra LED Lamps, Lurra LED Tala Bulb, Lurra LED Tala Bulbs, Lurra LED Tala Light Bulb, Lurra LED Tala Light Bulbs, Lurra LED Light Bulb, Lurra LED Bulb, Lurra LED Bulbs, Lurra LED Light Bulbs, LED Bulb, LED Bulbs, LED Light Bulb, LED Light Bulbs, Tala, Tala Bulb, Tala Bulbs, Tala Light Bulb, Tala Light Bulbs, Tala, Lurra, 28LURA-3W-2200K-E26-T-120V, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, tube bulb, tube bulbs, tube light bulb, tube light bulbs, tube lighting bulb, tube lighting bulbs, led tube bulb, led tube bulbs, led tube light bulb, led tube light bulbs, led tube lighting bulb, led tube lighting bulbs, tube led bulb, tube led bulbs, tube led light bulb, tube led light bulbs, tube led lighting bulb, tube led lighting bulbs, 28 lurra,
65561 <p><span data-contrast="none" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW188947922 BCX0"><span class="NormalTextRun SCXW188947922 BCX0">An alluring modern creation,<span> </span></span><span class="NormalTextRun SCXW188947922 BCX0">the Newport</span><span class="NormalTextRun SCXW188947922 BCX0"><span> </span>was designed with today’s styles in mind. To adopt a striking contemporary aesthetic, this pendant’s shade presents a<span> </span></span><span class="NormalTextRun SCXW188947922 BCX0">clean, rounded<span> </span></span><span class="NormalTextRun SCXW188947922 BCX0">silhouette.<span> </span></span><span class="NormalTextRun SCXW188947922 BCX0">The Newport</span><span class="NormalTextRun SCXW188947922 BCX0"><span> </span>suspends this sophisticated shade from a cord mounting allowing installation throughout a home or business’s interior spaces. Handcrafted and American-made, the Newport offers the durability and ruggedness<span> </span></span><span class="NormalTextRun SCXW188947922 BCX0">you’ve come to expect from</span><span class="NormalTextRun SCXW188947922 BCX0"><span> </span>Barn Light Electric.</span></span><span class="EOP SCXW188947922 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></p> <p>|break|</p> <ul> <li>Manufactured and hand-crafted in the USA</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul> Handcrafted, fully customizable modern lighting fixtures! The Newport elevates any décor with its contemporary, eye-catching profile! BLE-C-NWP9, Newport Pendant Light, Newport Pendant Lights, Newport Pendant Lighting, Newport Pendant, Newport Pendants, Newport Ceiling Pendant, Newport Ceiling Pendants, Newport Ceiling Light, Newport Ceiling Lights, Newport Ceiling Lighting, Newport Cord Pendant Light, Newport Cord Pendant Lights, Newport Cord Pendant Lighting, Newport Cord Pendant, Newport Cord Pendants, Newport Cord Ceiling Pendant, Newport Cord Ceiling Pendants, Newport Cord Ceiling Light, Newport Cord Ceiling Lights, Newport Cord Ceiling Lighting, Newport Cord Hung Pendant Light, Newport Cord Hung Pendant Lights, Newport Cord Hung Pendant Lighting, Newport Cord Hung Pendant, Newport Cord Hung Pendants, Newport Cord Hung Ceiling Pendant, Newport Cord Hung Ceiling Pendants, Newport Cord Hung Ceiling Light, Newport Cord Hung Ceiling Lights, Newport Cord Hung Ceiling Lighting, Newport Cord Mount Pendant Light, Newport Cord Mount Pendant Lights, Newport Cord Mount Pendant Lighting, Newport Cord Mount Pendant, Newport Cord Mount Pendants, Newport Cord Mount Ceiling Pendant, Newport Cord Mount Ceiling Pendants, Newport Cord Mount Ceiling Light, Newport Cord Mount Ceiling Lights, Newport Cord Mount Ceiling Lighting, Newport, The Newport, New port, the New port, Newport cord, cord newport, newport cord hung, newport cord mount, cord hung newport, cord mount newport,
65705 <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>A classic RLM-inspired shade, the Bomber’s timeless design appeals to both traditional and contemporary décors. This aesthetic versatility is due to the Bomber’s sleek curves and straightforward lines. As a cord hung pendant, the Bomber can deliver its fashionable look throughout any residential or business setting. </span><span>American made and handspun by our talented artisans, the Bomber features the meticulous craftsmanship necessary for a long lifespan.</span></p> <p>|break|</p> <ul> <li>Formerly our "Farm &amp; Barn Cord Hung 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> Classic RLM style at a price your wallet will thank you for! Our Barn Light Basics Bomber Pendant Light has simplified options for a stress-free shopping experience! Farm Light, cord hung, discount light, pendant, BLE-C-STL15-PC, farm and barn, farm and barn cord, new listing, new farm and barn, farm and barn cord hung pendant, low cost, low cost lighting, farm & barn, discount lighting, bomber light, bomber pendant, bomber cord, cord hung bomber, basics bomber, bomber basics, bomber basics cord, cord hung bomber basics, budget lighting, simple light, basic light, back to basics, basic bomber, bomber basic, farm and barn, farm and barn pendant, farm & barn,