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 (
    60751, 65529, 64869, 65649, 60735, 65590, 
    64943, 64339, 65467, 65558, 63128, 
    65686
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00067

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 (60751,65529,64869,65649,60735,65590,64943,64339,65467,65558,63128,65686) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
60735 <p>To perform practical applications in commercial spaces, the G7 features an elongated metal arm with a subtle curve at its end. Often functioning as a <a title="Sign Lighting" href="/lighting/wall-lights/sign-lights/">sign light</a>, the G7 accentuates branded logos, artwork, and more. Not purely utilitarian, this gooseneck arm’s timeless aesthetic contributes character to a décor.</p> <p><strong>|break|</strong></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, 42 inch gooseneck, gooseneck couplers, angle, angled, curve, long The G7 Gooseneck Arm is a straight arm with an angled curve. G7, Straight gooseneck, straight arm, angled curve, long straight arm, BLE-G7, G-7, arm, gooseneck arm, g-9, g9, 42 3/4" Projection, gooseneck options,
60751 <p>A gooseneck arm that’s equally practical and fashionable, the G25 features a striking shape and durable design. Available for both commercial and residential applications, this arm style projects illumination onto walls, accentuating signs, artwork, and more. The G25 is customizable with various powder coat finishes.</p> <p>|break|</p> <ul> <li>Proudly Manufactured in the U.S.A.</li> <li>Includes: Wall Backing Plate and Mounting Hardware</li> <li>Construction: Aluminum</li> </ul> G25, gooseneck arm, curve, angle, sign, 26 inch The G25 Gooseneck Arm curves leaving the shade at an angle use this gooseneck as sign lights. G25, G25 Gooseneck, Angle Gooseneck, G25 Arm, BLE-G25, G-25, gooseneck arm, arm, g25, g-25, gooseneck options,
63128 <p>This aluminum arm is used to support an existing gooseneck arm that's already mounted to a shade. Please Note: This support arm is only compatible with our 3/4" gooseneck arms: G2, G4, G6, G7, G8, G9, G10, G13, G14, G15, G17, G19, G22, G24, G25, G32, G34, G36, G40, G64 and G65.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Includes Wall Backing Plate and Mounting Hardware</li> <li>Please Note: This gooseneck arm is only compatible with Barn Light Electric's 3/4" Gooseneck Arms</li> </ul> Support arms lend an industrial, functional aesthetic to our gooseneck lighting fixtures! Our support arms are the perfect option for your gooseneck light! gooseneck options, support, gooseneck support,
64339 <p>For an extra touch of decorative flair, the G64's design incorporates a rugged chain support. This gooseneck arm complements the industrial vibe found in many contemporary homes and businesses, along with more classic décors. Customize this mounting option with a vibrant powder coat finish.</p> <p>|break|</p> <ul> <li>Proudly Manufactured in the U.S.A.</li> <li>Includes: Wall Backing Plate, Gooseneck Arm and Painted Mounting Hardware</li> </ul> G64, gooseneck arm, gooseneck, basic arm, 23 inch, chain mount gooseneck, chain gooseneck, G64, G64 Gooseneck, G64 Arm, BLE-G64, G-64, arm, gooseneck arm, g-64, g64, Gooseneck light with chain, Gooseneck mount with chain, Gooseneck with a chain, Goosenecks with a chain, 22.9" Projection gooseneck, 22.9" Projection, 22" Projection, 23" Projection, gooseneck options,
64869 <p>A classic fixture with timeless appeal, the Aero suspends a vintage-inspired shade from a rugged chain mounting. Slots, which let hints of illumination escape as uplighting, are stamped into the shade’s neck, establishing a unique design. With this pendant, residential and commercial décors can feel incredibly warm, welcoming, and stylish.</p> <p>Customizable with various finish colors and materials, cord styles, and slot options, this pendant can offer the proper aesthetic for every setting. Every Aero shade is crafted and finished by hand, ensuring a dependable, long-lasting source of light.</p> <p>|break|</p> <ul> <li>An industrial chain mount fixture, this pendant’s RLM-style shade was meticulously manufactured by hand.</li> <li>Made-to-order. Learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> </ul> A classic design for up and downlighting! Create a custom look for you space and elevate your decor with this pendant light! BLE-C-VSBA, Aero Vented Chain Hung Pendant Light, Aero Vented Chain Hung Pendant, Aero Vented Pendant Light, Aero Vented Pendant, Vented, vented pendant, vented chain hung, vent chain, astro vented, vented pendant, astro vented, aero vented, BLE-CN-VSBA12, BLE-CN-VSBA14, BLE-CN-VSBA16, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero vented series, aero vented collection, SPS-0169, SPS0169, SPS 0169, slotted, slotted light,
64943 <p>Broken light fixture? Or just want to upgrade your old schoolhouse shade with a new look? Try one of our replacement globes available in both clear and opaque glass. You can customize this drum-shaped glass with hand-painted bands of color in several patterns. </p> <p>Schoolhouse shades bring vintage style to any room and the addition of the colored bands gives these fixtures an updated look. Bring a whole new vibe to your space with a brand new schoolhouse shade!</p> <p>|break|</p> <ul> <li>Customizable with colorful painted bands. </li> <li><span>White painted band(s) not recommended if Opaque Glass is selected, as it blends into the glass.</span></li> <li><span>Please Note: <span>The single band style has a silver border outlining the chosen finish.</span></span></li> <li>If using with a non-Barn Light Electric fixture, this glass will require a fitter at least 6" wide and ¾" long screws.</li> <li>Dimensions: W 11.7" x H 10.3" </li> </ul> Fully customizable with hand-painted bands in several colors and two glass options, replace broken shade with this drum schoolhouse glass! BLE-DRM-GLASS, Drum Schoolhouse Glass, Replacement Drum Schoolhouse Glass, Drum Glass, Replacement Drum Glass, Schoolhouse Drum Glass, Replacement schoolhouse, replacement schoolhouse glass, Drum School house Glass, Replacement Drum School house Glass, School house Drum Glass, replacement school house glass, Drum Schoolhouse Globe, Replacement Drum Schoolhouse Globe, Drum Globe, Replacement Drum Globe, Schoolhouse Drum Globe, replacement schoolhouse globe, Drum School house Globe, Replacement Drum School house Globe, School house Drum Globe, replacement school house globe, Drum Schoolhouse Shade, Replacement Drum Schoolhouse Shade, Drum Shade, Replacement Drum Shade, Schoolhouse Drum Shade, replacement schoolhouse shade, Drum School house Shade, Replacement Drum School house Shade, School house Drum Shade, replacement school house shade, drum, replacement globes, striped schoolhouse,
65467 <p>With its rugged profile and compact flush mounting, the Rochester adapts to today’s most prominent styles. This versatile look is accomplished through a handcrafted metal shade and guard. An elevated industrial design, the Rochester equally suits contemporary décors and traditional settings, helping every space feel stylish and illuminated. <br /><br />The Rochester’s shade starts as a flat piece of metal. Our team of talented artisans shapes the metal by hand as it spins on a high-speed lathe. This meticulous process ensures a level of durability not found in other lighting options.</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting stem mount option.<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> A classic lighting style with a space-saving flush mounting! Handcrafted and fully customizable, put the finishing touches on your decor with the Rochester! BLE-F-SI, Rochester Flush Mount Light, Rochester Flush Mount, Rochester Flush Mount Pendant, Rochester Pendant, Rochester Pendant Light, Rochester ceiling light, Rochester flush mount ceiling pendant, Rochester flush, Flush Rochester, The Rochester Flush Mount Light, The Rochester Flush Mount, The Rochester Flush Mount Pendant, The Rochester Pendant, The Rochester Pendant Light, The Rochester ceiling light, The Rochester flush mount ceiling pendant, The Rochester flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Rochester Vintage Industrial Flush Mount Light, Rochester Vintage Industrial Flush Mount, Rochester Industrial Flush Mount Light, Rochester Industrial Flush Mount, Rochester Vintage Flush Mount Light, Rochester Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65529 <p>lorem ipsum</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial lighting is a lasting flush 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 for 28" shades.</span></li> <li>Read more about The <span>Original™ Flush Mount Pendant Light over at our<span> </span>blog!</span></li> </ul>
65558 <div>While still reminiscent of classic designs, the Loma Wall Sconce exemplifies contemporary tastes and preferences. This timeless appeal is established through the shade’s clean, simple lines and curved silhouette. An adjustable arm, which lets you select shade’s ideal position for your space, furthers the Loma’s versatility — both aesthetically and functionally. For styles ranging from chic and upscale to relaxed and casual, incorporate the Loma Wall Sconce into your décor!</div> <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><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></li> </ul> A modern wall sconce with an adjustable arm! The Loma Adjustable Wall Sconce offers the style and versatility contemporary spaces need! Handcrafted and American-made! BLE-W-DBL12, Loma Adjustable Wall Sconce, Loma Adjustable Wall Sconces, Loma Adjustable Sconce, Loma Adjustable Sconces, Loma Wall Sconce, Loma Wall Sconces, Loma Sconce, Loma Sconces, The Loma Adjustable Wall Sconce, The Loma Adjustable Wall Sconces, The Loma Adjustable Sconce, The Loma Adjustable Sconces, The Loma Wall Sconce, The Loma Wall Sconces, The Loma Sconce, The Loma Sconces, Loma Adjustable Wall Light, Loma Adjustable Wall Lights, Loma Adjustable Wall Lighting, Loma Wall Light, Loma Wall Lights, Loma Wall Lighting, The Loma Adjustable Wall Light, The Loma Adjustable Wall Lights, The Loma Adjustable Wall Lighting, The Loma Wall Light, The Loma Wall Lights, The Loma Wall Lighting, loma, lomas,
65590 <p>Conveying a classic midcentury style, the Lovell Wall Sconce becomes an eye-catching accent light in bedrooms, living spaces, hallways, and bathrooms. With a refined yet casual look, this wall sconce can be customized with a variety of options and colors to complement any d<span>é</span>cor. The fixture's cone-shaped shade is adjustable up to 90 degrees allowing you to direct the illumination exactly where needed. </p> <p>American made and handcrafted with attention to every detail, the Lovell is fully customizable with a wide range of finish colors and options, including marine grade, powder coat, and natural metals. Create the exact look you envision for your space and transform your décor!</p> <p>|break|</p> <ul> <li>Manufactured and handcrafted 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> <li>Adjustable head swivels to 90<span> </span>degrees</li> </ul> Lovell Wall Sconce, BLE-L-WL001, wall sconce, modern sconce, lovell, lovell wall sconce, lovell sconce, small sconce, lovel, cone shaped sconce, cone sconce, new lovell, The Lovell Wall Sconce, Lovell Wall Sconce, Lovell Wall Sconce, lovell sconce, Lovell Collection, Lovell Series, The Lovell Collection, The Lovell Series, SPS-0028, SPS 0028, SPS0028, interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, lovelle, jadeite, jadite, jadeite light, jadite light,
65649 <p><span>With a nod to historic vintage designs, the Sinclair offers a sleek profile and classic lines sought by both contemporary and traditional décors. The flush mounting on this handcrafted light is well suited for tight spaces such as hallways, bathrooms, and laundry rooms. Or install a row of Sinclair Flush Mount Lights in a larger space for even, consistent illumination. <br /></span></p> <p><span>Other customization options, such as a wire cage, help the Sinclair take on a more industrial-inspired look. American made to last!</span></p> <p>|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW68896088 BCX0"><span class="NormalTextRun SCXW68896088 BCX0">With its</span><span class="NormalTextRun SCXW68896088 BCX0"><span> </span>handcrafted</span><span class="NormalTextRun SCXW68896088 BCX0"> RLM warehouse<span> </span></span><span class="NormalTextRun SCXW68896088 BCX0">shade </span><span class="NormalTextRun SCXW68896088 BCX0">and meticulous manufacturing process,<span> </span></span><span class="NormalTextRun SCXW68896088 BCX0">this flush mount pendant is a reliable, rugged lighting option.</span></span><span class="EOP SCXW68896088 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></li> <li>Made-to-order, learn more about the process <a href="/video-gallery/">here</a>.</li> </ul> benjamin sinclair, benjamin shallow bowl, sinclair pendant, shallow bowl pendant, BLE-F-SBS, BLE-F-SBS10, BLE-F-SBS12, BLE-F-SBS14, BLE-F-SBS16, sinclair, sinclair flush, shallow pendant, flat pendant, shallow, flat, new listing, new sinclair, new rlm, Skylark, Skylark pendant, skylark flush mount, shallow bowl pendant, shallow bowl flush mount, BLE-F-SBS10-PC, BLE-F-SBS12-PC, BLE-F-SBS14-PC, BLE-F-SBS16-PC, flush mount lighting, exterior lighting, exterior lights, outdoor lighting, ceiling light, flush mount ceiling light, ceiling mount light, ceiling mounted light, ceiling mount lighting, ceiling mounted lighting, shallow bowl pendant light, shallow bowl lighting, shallow bowl warehouse shade, warehouse shade light, rlm warehouse shade, rlm lighting, BLE-F-SBS10, BLE-F-SBS12, BLE-F-SBS14, BLE-F-SBS16, Sinclaire, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, jadeite, jadite, jadeite light, jadite light, bowl shallow,
65686 <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>The Original™ celebrates the iconic RLM warehouse shade rooted in vintage lighting styles. While this design dates back to the early 20<sup>th</sup><span><span> </span>century, this pendant light complements the latest styles and trends favored in contemporary settings. </span></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/the-original-warehouse-cord-hung-pendant/" target="_blank">here</a> for our complete listing!</li> </ul> The farmhouse charm you love has never been more affordable! Quality and style merge beautifully with our Barn Light Basics The Original™ Warehouse Pendant! 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, original basic, the original basic, original basics, original light, the original light, warehouse pendant, original warehouse pendant, the original warehouse pendant, original cord, the original cord, original pendant, the original pendant, original cord light, the original cord light, original cord pendant, the original cord pendant, discount barn lights, discount warehouse lights, basic barn light, simple barn light, minimal barn light, back to basics, H-15112, H-15116, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,