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 (
    65626, 65466, 65803, 65564, 65459, 65469, 
    65468, 65814, 65815, 65720, 65732, 
    65479
  ) 
  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 (65626,65466,65803,65564,65459,65469,65468,65814,65815,65720,65732,65479) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
65459 <p><span data-contrast="auto"><span>The Wilcox brings an eye-catching look to any space — no matter what style! A timeless design, the slight separation between the shade and mounting allows a touch of illumination to escape as </span></span><span data-contrast="auto"><span>uplighting</span></span><span data-contrast="auto"><span>. Functional and decorative, the Wilcox functions as either an accent piece or focal point in residential and commercial locations.  </span></span><span data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></p> <p><span data-contrast="auto"><span>A diverse array of customizing options lets the Wilcox assume the perfect look for every space. Bright, playful colors help this flush mount pendant stand out while dark or neutral finishes help the Wilcox blend in with existing designs. </span></span></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 timeless design, the Wilcox Uplight Flush Mount Pendant Light offers style and illumination to residential and commercial settings! American made, handcrafted, and fully customizable! Wilcox Flush Mount Light, Wilcox Flush Mount, Wilcox Flush Mount Pendant, Wilcox Pendant, Wilcox Pendant Light, Wilcox ceiling light, Wilcox flush mount ceiling pendant, Wilcox flush, Flush Wilcox, The Wilcox Flush Mount Light, The Wilcox Flush Mount, The Wilcox Flush Mount Pendant, The Wilcox Pendant, The Wilcox Pendant Light, The Wilcox ceiling light, The Wilcox flush mount ceiling pendant, The Wilcox flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Wilcox Uplight Flush Mount Light, Wilcox Uplight Flush Mount, The Wilcox Uplight Flush Mount Light, The Wilcox Uplight Flush Mount, H-16312, H-16314, H-16316, uplight deep bowl shade,
65466 <p>Inspired by vintage designs, the Bridgeport brings an industrial edge to residential and commercial settings. A handcrafted warehouse shade functions as this aesthetic's foundation, while a compact flush mounting allows installation in undersized areas. With this eye-catching yet grounded character, the Bridgeport stands out in nearly every lighting application. <br /><br />Made in our Florida-based facility, the Bridgeport backs up its rugged appearance with a meticulous construction process. Because we handle the manufacturing ourselves, this flush mount pendant is fully customizable and made to order.</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> Fully customizable industrial lighting styles! The Bridgeport brings an authentic rugged character to residential and commercial settings! Bridgeport Flush Mount Light, Bridgeport Flush Mount, Bridgeport Flush Mount Pendant, Bridgeport Pendant, Bridgeport Pendant Light, Bridgeport ceiling light, Bridgeport flush mount ceiling pendant, Bridgeport flush, Flush Bridgeport, The Bridgeport Flush Mount Light, The Bridgeport Flush Mount, The Bridgeport Flush Mount Pendant, The Bridgeport Pendant, The Bridgeport Pendant Light, The Bridgeport ceiling light, The Bridgeport flush mount ceiling pendant, The Bridgeport flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, BLE-F-MI, Bridgeport Vintage Industrial Flush Mount Light, Bridgeport Vintage Industrial Flush Mount, Bridgeport Industrial Flush Mount Light, Bridgeport Industrial Flush Mount, Bridgeport Vintage Flush Mount Light, Bridgeport Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65468 <p>While the Cleveland’s design finds inspiration in vintage lighting, its rugged edge falls in line with the latest contemporary preferences. This flush mount pendant joins a sturdy metal shade and guard together, establishing an authentic industrial charm. Thanks to its space-saving mounting, the Cleveland can bring style and illumination to undersized spaces. <br /><br />Handcrafted and American made, this ceiling light features the durability and high quality associated with Barn Light Electric. Each Cleveland Flush Mount Light is fully customizable with various finishes and other unique 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> Classic industrial styles, handcrafted and American made! The Cleveland Flush Mount Light is fully customizable and will elevate any home or business! BLE-F-AI, Cleveland Flush Mount Light, Cleveland Flush Mount, Cleveland Flush Mount Pendant, Cleveland Pendant, Cleveland Pendant Light, Cleveland ceiling light, Cleveland flush mount ceiling pendant, Cleveland flush, Flush Cleveland, The Cleveland Flush Mount Light, The Cleveland Flush Mount, The Cleveland Flush Mount Pendant, The Cleveland Pendant, The Cleveland Pendant Light, The Cleveland ceiling light, The Cleveland flush mount ceiling pendant, The Cleveland flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Cleveland Vintage Industrial Flush Mount Light, Cleveland Vintage Industrial Flush Mount, Cleveland Industrial Flush Mount Light, Cleveland Industrial Flush Mount, Cleveland Vintage Flush Mount Light, Cleveland Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65469 <p>Vintage lights live on in this flush mount pendant. The Syracuse’s look is evocative of the fixtures once used in industrial facilities like warehouses or factories. While inspired by these classic lights, this flush mount still feels timeless and complements many of today’s most popular styles. <br /><br />Just like those original fixtures, the Syracuse utilizes high-quality commercial-grade materials. To construct the shade, our team transform flat pieces of metal into the necessary shape entirely by hand. The Syracuse is made-to-order and is fully customizable with various finishes and other options.</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting flush 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 vintage-inspired, fully customizable flush mount pendant. Bring the handcrafted Syracuse to your home or business for a truly one-of-a-kind decor! BLE-F-CI, Syracuse Flush Mount Light, Syracuse Flush Mount, Syracuse Flush Mount Pendant, Syracuse Pendant, Syracuse Pendant Light, Syracuse ceiling light, Syracuse flush mount ceiling pendant, Syracuse flush, Flush Syracuse, The Syracuse Flush Mount Light, The Syracuse Flush Mount, The Syracuse Flush Mount Pendant, The Syracuse Pendant, The Syracuse Pendant Light, The Syracuse ceiling light, The Syracuse flush mount ceiling pendant, The Syracuse flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Syracuse Vintage Industrial Flush Mount Light, Syracuse Vintage Industrial Flush Mount, Syracuse Industrial Flush Mount Light, Syracuse Industrial Flush Mount, Syracuse Vintage Flush Mount Light, Syracuse Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65479 <p>Whether found in a commercial building or residential property, the Cleveland helps every space feel stylish and illuminated—with minimal wasted energy. Turning to vintage industrial fixtures for inspiration, this flush mount pendant presents a truly timeless aesthetic. Equally suiting contemporary and traditional décors, the Cleveland helps any room take on a unique, elevated aesthetic. <br /> <br />Functionally, the Cleveland’s integrated LED components produce illumination far more efficiently than standard options. This technology wastes little electricity as heat as it emits light, considerably scaling down a building’s energy consumption. Eco-friendly, budget-conscious, and undeniably stylish: Transform any space with the Cleveland!</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 flush mount LED light with a vintage industrial style! The Cleveland integrates hyper-efficient LED technology into its design! Eco-conscious, budget-friendly, and endlessly customizable! BLE-F-AI-LED, Cleveland LED, LED cleveland, Cleveland LED Flush Mount Light, Cleveland LED Flush Mount, Cleveland LED Flush Mount Lighting, Cleveland LED Flush Mount Lights, Cleveland LED Flush Mount pendant, Cleveland LED Flush Mount pendant Light, Cleveland LED Flush Light, Cleveland LED Flush pendant Light, Cleveland LED Flush pendant, Cleveland, BLE-F-AI, Cleveland Flush Mount Light, Cleveland Flush Mount, Cleveland Flush Mount Pendant, Cleveland Pendant, Cleveland Pendant Light, Cleveland ceiling light, Cleveland flush mount ceiling pendant, Cleveland flush, Flush Cleveland, The Cleveland Flush Mount Light, The Cleveland Flush Mount, The Cleveland Flush Mount Pendant, The Cleveland Pendant, The Cleveland Pendant Light, The Cleveland ceiling light, The Cleveland flush mount ceiling pendant, The Cleveland flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Cleveland Vintage Industrial Flush Mount Light, Cleveland Vintage Industrial Flush Mount, Cleveland Industrial Flush Mount Light, Cleveland Industrial Flush Mount, Cleveland Vintage Flush Mount Light, Cleveland Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,
65564 <div>Minimalism can still be imaginative! Imbued with creativity, the Ellington is an instant favorite in today’s homes and businesses. Clean, simple lines are the basis of the Ellington’s modern appeal. This interpretation consists of a simple flush mounting, a bare bulb socket, and the design’s signature flat shade. With this stylish flush mount pendant, any setting can adopt an updated contemporary aesthetic.</div> <p>|break|</p> <ul> <li>Manufactured in the U.S.A. </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 Ellington’s modern, minimalist look brings style and plenty of light to homes and businesses. Customizable with various finish colors! BLE-F-EGT, Ellington Flush Mount Light, Ellington Flush Mount, Ellington Pendant Lighting, Ellington Pendant Lights, Ellington Ceiling Flush Light, Ellington Ceiling Pendant, Ellington Ceiling Pendants, Ellington Ceiling Light, Ellington Ceiling lights, Ellington ceiling lighting, Ellington pendant, Ellington Pendants, Ellington, Ellington Light, Ellington Lights, Ellington Flush, Ellington Lighting, flush mount, flush, modern flush mount, modern light, simple light, minimal light, surface mount fixture, surface mounted, surface mount, ceiling mount, surface fixture, surface light, ceiling mounted, ellingtons
65626 <p>Create a fun and festive atmosphere for your next backyard gathering with these Smart String Lights! Energy-efficient, multicolored LED bulbs hang from a 36-foot cord to establish a delightful setting to your porch or patio. Wi-fi and Bluetooth enabled for ease of use!</p> <p>|break|</p> <ul> <li>18 Sockets - E26 Medium Base</li> <li>Wi-Fi and Bluetooth Enabled</li> <li>Includes (18) S14 Clear 0.3W Plastic Bulbs (Equivalent to 7.5W Incandescent)</li> <li>30 Lumens, 3000K-7000K Color Temperature (Multi-Color)</li> <li>Can Be Connected Up to 20 Sets</li> <li>ETL Rated for Wet Location Use</li> </ul> Outdoor Café String Lights, string lights, cord lights, heavy duty cord lights, Outdoor String Lights, Outdoor String Light, Outdoor String Lighting, outdoor string, festoon, festoon lighting, festoon lights, outside hanging lights, 18812313, string lights, string light, string lighting, outdoor string light, outdoor string lights, outdoor string lighting, Out door string light, out door string lights, out door string lighting, Exterior string light, exterior string lights, exterior string lighting, Outdoor rated string lights, outdoor rated string lighting, outdoor rated string light, Out door rated string lights, out door rated string lighting, out door rated string light, Exterior rated string light, exterior rated string lights, exterior rated string lighting, sing light, sting light, bulbs with strings, led string lights, led cafe lights, led festoon, led festoon lights, led hanging light, led string light, colorful lights, smart string lights, smart led lights, multicolor light, multi-color string light, colorful string light, wifi light, wifi string light,
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
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",
65803 <p><span>Giving traditional RLM fixtures a modern update, the Laramie Studio Light suspends a handspun 30" shade from a sturdy metal cable. An easy-to-customize electrical cord is casually draped around the support wire imparting a relaxed vibe to the pendant’s design. By uniting classic influences and contemporary preferences, this fixture is a natural fit for today’s most popular styles.</span></p> <p><span>Perfectly suited for both residential and commercial spaces, the Laramie Studio Light offers a wide span of illumination without sacrificing any style points. Customize with a variety of finish colors and other options to create the perfect light for your space!</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> 30" laramie, oversized laramie, 30 laramie, laramie 30, laramie 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",