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 (
    65814, 65815, 65720, 65732, 65805, 65804, 
    65733, 65813, 65734, 65101, 65721, 
    65685
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (65814,65815,65720,65732,65805,65804,65733,65813,65734,65101,65721,65685) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65101 <p><span data-contrast="auto"><span data-wac-het="1">With its classic lines and large-scale profile, the Sinclair offers a simple yet commanding<span> </span></span></span><span data-contrast="auto"><span data-wac-het="1">look</span></span><span data-contrast="auto"><span data-wac-het="1">. Inspired by vintage shallow bowl shades, this pendant demonstrates the timelessness sought for both contemporary and traditional décors. A sturdy wire cable supports the shade’s substantial size and supplies a casual, industrial charm. As either a dramatic focal point or dynamic accent piece, the Sinclair helps every space feel stylish and elevated.  </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">Along with its memorable aesthetic, the shallow bowl shade also spreads ample illumination throughout an entire venue. Manufactured in the United States, the Sinclair is a rugged, dependable lighting option. An abundance of finish and other customizing options let this fixture adapt to any setting’s unique sense of style.</span></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 large-scale profile and classic appearance, the 28” Sinclair stands out in every décor! Customize its appearance with your favorite finish color! BLE-C-STU-SBS28, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Cord Pendant Light, Sinclair 28" Cord Pendant, Sinclair 28" Cord Light, Sinclair 28" Cord, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Cord Pendant Light, Sinclair 28 Cord Pendant, Sinclair 28 Cord Light, Sinclair 28 Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Cord Pendant Light, 28” Sinclair Cord Pendant, 28” Sinclair Cord Light, 28” Sinclair Cord, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Cord Pendant Light, 28 Sinclair Cord Pendant, 28 Sinclair Cord Light, 28 Sinclair Cord, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Cord Pendant, Sinclair Cord, 28”, 28" sinclair,
65685 <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>First found on farms and in factories in the 1930s and 40s, the sleek style of The Original™ RLM shade now offers a classic look to contemporary homes and businesses. This versatile lighting option complements a multitude of design styles including farmhouse, industrial, and many more modern favorites.</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/ceiling-lights/stem-mount-pendant-lighting/the-original-stem-mount-pendant-light/" target="_blank">here</a> for our complete listing!</li> </ul> Searching for a durable, weather resistant fixture at a price you can't beat? Our Barn Light Basics The Original™ Stem Mount Pendant is exactly what 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, the original stem, the original light, the original basic, the original stem light, original stem, original light, original basic, original stem light, discount stem mount light, discount stems, discount stem mounts, basic stems, basic stem mounts, budget stem lights, budget stem mount lights, budget friendly stem lights, original discount light, the original discount light, the original discount, original discount, original discount light, original basic, original basic light, the original basic light, the original basics, discounted deep bowl light, original basics, basic warehouse light, budget barn light, budget original, budget barn lights, discount original, original light, discount original light, original barn light, the original barn light, the original stem light, the original stem mount, discount the original stem light, original stem light, original stem mount, discount original stem light, budget discount original stem light, back to basics, H-15112, H-15116, classic warehouse shade stem mount pendant rlm, classic warehouse shade, basic original stem,
65720 <p>Harkening back to early 20<sup>th</sup><span> </span>century designs, the Parabolic Wall Sconce features a simple, half-dome shade and slender adjustable arm. This sleek style, a favorite for both contemporary and traditional spaces, is perfect as a bedside light or for any space that needs focused task lighting.</p> <p>Easy to customize with more than 30 powder coat finish colors, this attractive wall sconce can be built to complement any d<span>é</span>cor. Handcrafted in the United States, the Parabolic Wall Sconce features the same commitment to craftsmanship and quality as vintage, antique fixtures.</p> <p>|break|</p> <ul> <li>Manufactured and handcrafted in the USA</li> <li><span><span class="ui-provider fz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr">Love this design but need a plug-in version? We've got you covered! Shop our plug-in version <a href="/lighting/wall-lights/wall-sconces/parabolic-plug-in-wall-sconce/">here</a>!</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> parabolic sconce
65721 <p>The simple, rounded shade of the Parabolic Plug-In Wall Sconce offers a classic profile but can take on a more contemporary flair with a variety of powder coat finish colors. Choose traditional Black, White or Galvanized, or add updated style with Magenta, Royal Blue, or Lavendar.</p> <p>Mounted on a slender, adjustable arm, this wall light features plug-in convenience! Perfect for bedside lighting, workplace lighting, or any space that needs dedicated task lighting. American made to last!</p> <p> </p> <p>|break|</p> <ul> <li>Manufactured and handcrafted in the USA</li> <li><span><span class="ui-provider fz b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak" dir="ltr">Love this design but prefer it without the cord and plug? We've got you covered! Shop our hardwired version <a href="/lighting/wall-lights/wall-sconces/parabolic-wall-sconce/">here!</a></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> parabolic wall sconce, parabolic sconce, parabolic plugin, parabolic plug in,
65732 <p><span>The newest member of the Avalon family makes a bold statement with its impressive 42" shade! The perfect addition to any industrial or modern décor, this pendant light adds a touch of elegance to any room. Featuring a sleek design and sturdy construction, the Avalon is crafted from commercial-grade materials suitable for any residential or busy commercial space. </span></p> <p><span>The stem mount design allows the pendant to hang from the ceiling at the perfect height making it ideal for use in dining rooms, kitchens, offices, warehouses, and other areas where task lighting is needed. Available in a variety of durable powder coat finish colors so you can choose the perfect option to match your décor or commercial branding scheme.</span></p> <p>|break|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, this quality industrial lighting is a lasting stem mount option.<span> </span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",
65733 <p><span>Make a bold statement with the eye-catching Avalon Studio Light! This light features an impressive 42" handspun shade crafted from high-quality aluminum ensuring long-lasting performance. The generous shade allows for a wide spread of light making it ideal for use over large workspaces or tables. The studio mounting features both cord and cable which lends a contemporary look.</span></p> <p><span>The American-made Avalon Studio Light can be customized with one of more than two dozen powder coat finish colors as well as a variety of cord colors allowing you to create a fixture to complement your home or business décor. </span></p> <p>|break|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, <span>this quality industrial pendant</span><span> </span><span><span>is a lasting lighting option!</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required.</span></li> </ul> 42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",
65734 <p>Create a head-turning statement with the newest member of the Avalon collection! The stunning 42" shade of the Avalon Chain-Hung Pendant offers a<span> streamlined contemporary style with a nod to classic RLM lighting designs. This timeless profile is well suited for modern farmhouses, trendy restaurants, office settings, and classically styled venues.</span></p> <p><span>Choose from more than two dozen powder coat finish colors for this American-made fixture which is hand spun from commercial-grade metal. The rugged chain mounting lends an industrial flair while our careful attention to every detail ensures this light will be a long-lasting piece of your décor!</span></p> <p>|break|</p> <ul> <li>This RLM warehouse shade is handcrafted from commercial-grade materials ensuring a quality, long-lasting ceiling mount pendant.</li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 42" avalon, oversized avalon, 42 avalon, avalon 42, avalon 42",
65804 <p>Traditional yet contemporary, the Laramie’s eye-catching design embraces the hallmarks of the classic farmhouse style. The fixture’s generous 30" shade is accented with slender metal arms and joined to a rugged stem mounting. This mounting protects the wiring making this fixture suitable for both indoor and outdoor installations. </p> <p>Customizable with a variety of finish colors and other options, the Laramie can adopt any space’s preferred style. Handcrafted in America, this pendant demonstrates the unrivaled level of quality and dependability you expect from Barn Light Electric. </p> <p>|break|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, this quality industrial lighting is a lasting stem mount option.<span> </span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30",
65805 <p><span>Embracing an eye-catching industrial farmhouse style, the Laramie Chain Hung Pendant quickly becomes a focal point with its generous 30" handspun shade. Its unique design featuring slender arms joining the shade’s base and neck creates classic curves and a timeless aesthetic. </span></p> <p><span>As an American made fixture, the Laramie pairs its elevated style with the durability expected from Barn Light Electric. The shade is handspun from high-quality metal and assembled entirely by hand, a process that ensures careful attention to detail is paid throughout the entire manufacturing process. Completely customizable and made-to-order, various finish colors and other decorative features allow this pendant to adopt any venue’s style.</span></p> <p>|break|</p> <ul> <li>This RLM warehouse shade is handcrafted from commercial-grade materials ensuring a quality, long-lasting ceiling mount pendant.</li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 30",
65813 <p><span>From renovation projects to newly constructed homes, the Chestnut Chain Hung Pendant adds a timeless look to any setting. This pendant light features a generous 30" shallow-bowl shade, stacked neck design, and rugged chain mounting. With classic farmhouse appeal, this fixture complements the various styles found in today’s homes and businesses.</span><br /><br /><span>Fully made-to-order, dozens of customization options including multiple finish colors are available letting every space feature truly unique lighting fixtures. The Chestnut is hand-crafted in our Florida-based manufacturing facility ensuring an unmatched level of quality.</span></p> <p>|break|</p> <ul> <li>This RLM warehouse shade is handcrafted from commercial-grade materials ensuring a quality, long-lasting ceiling mount pendant.</li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",
65814 <p>This impressive 30" barn light will make an attention-getting addition to your home or commercial business! Choose from a variety of finish colors for the classic warehouse shade which is suspended from a durable cable mounting with an electrical cord to complete the look. This union between farmhouse details and a more relaxed mounting perfectly express the character of the Chestnut! </p> <p>American made and rugged enough for commercial applications, the Chestnut Studio Light gives its stylish take on warehouse lighting. Handcrafted to last, this pendant offers the durability needed in both industrial and high-traffic areas while still providing plenty of style.</p> <p>|break|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, <span>this quality industrial pendant</span><span> </span><span><span>is a lasting lighting option!</span></span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required.</span></li> </ul> 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",
65815 <p>With a nod to early American barn lights, the Chestnut Stem Mount Pendant showcases a truly timeless style. Suspended from a rugged stem mounting, the massive 30" Chestnut offers significant style and function and instills any space with a southern charm. The stem mounting protects the wiring making the Chestnut suitable for installation in high-traffic areas or as exterior lighting.</p> <p>Available with an assortment of customization options, the Chestnut can be created to complement the style of your space. Manufactured entirely by hand, the Chestnut features the high quality expected of American-made lighting. Let the Chestnut become a long-lasting addition to your décor!</p> <p>|break|</p> <ul> <li>Hand built with an American-made RLM warehouse shade, this quality industrial lighting is a lasting stem mount option.<span> </span></li> <li>Made-to-order; learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required. </span></li> </ul> 30" chestnut, oversized chestnut, 30 chestnut, chestnut 30, chestnut 30",