Sandbox

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 (
    65673, 65560, 65674, 65815, 65732, 65804, 
    65102, 65597, 65610, 65598, 65873
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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": 11,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65673,65560,65674,65815,65732,65804,65102,65597,65610,65598,65873) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
65102	<p><span data-contrast="auto"><span data-wac-het="1">A practical option abundant with decorative appeal, the Sinclair is a favorite for residential and commercial spaces. Classic lighting is central to this fixture’s design. The large-scale shallow bowl shade evokes vintage industrial lights, which gives the Sinclair a timeless feel. At home in contemporary and traditional décors, this pendant offers every setting a grounded, elevated character. </span></span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}" data-wac-het="1"> </span></p> <p><span data-contrast="auto"><span data-wac-het="1">The Sinclair’s rugged stem mounting protects its wires, allowing installation indoors and out. Commercial-grade materials make this pendant one of the most reliable lighting fixtures available. Fully customizable, numerous powder coat </span></span><span data-contrast="auto"><span data-wac-het="1">finishes</span></span><span data-contrast="auto"><span data-wac-het="1"> and other unique options help the Sinclair stand out in any space.</span></span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}" data-wac-het="1"> </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 28” shade and stem mounting, the Sinclair stands out in every home or business. Durably crafted and fully customizable, create the perfect look for your space!	BLE-S-SBS28, Sinclair 28" Pendant Light, Sinclair 28" Pendant, Sinclair 28" Light, Sinclair 28" Stem Pendant Light, Sinclair 28" Stem Pendant, Sinclair 28" Stem Light, Sinclair 28" Stem, Sinclair 28 Pendant Light, Sinclair 28 Pendant, Sinclair 28 Light, Sinclair 28 Stem Pendant Light, Sinclair 28 Stem Pendant, Sinclair 28 Stem Light, Sinclair 28 Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28” Sinclair Pendant Light, 28” Sinclair Pendant, 28” Sinclair Light, 28” Sinclair Stem Pendant Light, 28” Sinclair Stem Pendant, 28” Sinclair Stem Light, 28” Sinclair Stem, 28 Sinclair Pendant Light, 28 Sinclair Pendant, 28 Sinclair Light, 28 Sinclair Stem Pendant Light, 28 Sinclair Stem Pendant, 28 Sinclair Stem Light, 28 Sinclair Stem, Sinclair, Sinclair Pendant Light, Sinclair Pendant, Sinclair Stem Pendant, Sinclair Stem, 28”, Sinclair 28” Stem Mount Pendant Light, Sinclair 28" Stem Mount Pendant, Sinclair 28" Stem Mount, Sinclair 28" Stem Mount Light, Sinclair 28 Stem Mount Pendant Light, Sinclair 28 Stem Mount Pendant, Sinclair 28 Stem Mount, Sinclair 28 Stem Mount Light, 28” Sinclair Stem Mount Pendant Light, 28” Sinclair Stem Mount Pendant, 28” Sinclair Stem Mount, 28” Sinclair Stem Mount Light, 28 Sinclair Stem Mount Pendant Light, 28 Sinclair Stem Mount Pendant, 28 Sinclair Stem Mount, 28 Sinclair Stem Mount Light, 28" sinclair,
65560	<p><span data-contrast="none" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW211308895 BCX0"><span class="NormalTextRun SCXW211308895 BCX0">Decorative and functional,<span> </span></span><span class="NormalTextRun SCXW211308895 BCX0">the Newport</span><span class="NormalTextRun SCXW211308895 BCX0"><span> </span>adopts the soft, subtle lines favored in many contemporary settings. With this straightforward yet eye-catching shape, this shade is a natural fit for modern homes and businesses. A stem mounting adds a slightly more formal look to the design while offering greater protection in high-traffic or outdoor areas. Thanks to this extra durability, the Newport becomes a long-term highlight of any décor.</span></span><span class="EOP SCXW211308895 BCX0" data-ccp-props="{"201341983":0,"335559739":160,"335559740":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>	A made-to-order, meticulously crafted modern pendant light! This stem mount light brings an eye-catching look to homes and businesses!	BLE-S-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 stem Pendant Light, Newport stem Pendant Lights, Newport stem Pendant Lighting, Newport stem Pendant, Newport stem Pendants, Newport stem Ceiling Pendant, Newport stem Ceiling Pendants, Newport stem Ceiling Light, Newport stem Ceiling Lights, Newport stem Ceiling Lighting, Newport stem Hung Pendant Light, Newport stem Hung Pendant Lights, Newport stem Hung Pendant Lighting, Newport stem Hung Pendant, Newport stem Hung Pendants, Newport stem Hung Ceiling Pendant, Newport stem Hung Ceiling Pendants, Newport stem Hung Ceiling Light, Newport stem Hung Ceiling Lights, Newport stem Hung Ceiling Lighting, Newport stem Mount Pendant Light, Newport stem Mount Pendant Lights, Newport stem Mount Pendant Lighting, Newport stem Mount Pendant, Newport stem Mount Pendants, Newport stem Mount Ceiling Pendant, Newport stem Mount Ceiling Pendants, Newport stem Mount Ceiling Light, Newport stem Mount Ceiling Lights, Newport stem Mount Ceiling Lighting, Newport, The Newport, New port, the New port, Newport stem, stem newport, newport stem hung, newport stem mount, stem hung newport, stem mount newport,
65597	<p>Bringing industrial elements into your décor has never been easier with the Copeland Stem Mount Pendant! Starting with a sturdy stem mounting, this fixture features a polished nickel vented cap atop a prismatic clear glass shade. A <span>metal-rimmed, Fresnel lens glass diffuser focuses the illumination for better task lighting and is held in place with knurled thumbscrews adding another beautiful industrial detail. </span></p> <p>\|break\|</p> <ul> <li>This product is imported by Hudson Valley, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Features a Fresnel Lens Prismatic Glass Diffuser</li> <li>Includes a 3", 6", 12" and (2) 18" stems </li> </ul>	This sturdy stem mount pendant oozes industrial style but the prismatic glass shade adds a touch of elegance!	7311, 7311-AGB, 7311-OB, 7311-SN, 7311-PN, 7308, 7308-AGB, 7308-OB, 7308-SN, 7308-PN, 7311, 7315-AGB, 7315-OB, 7315-SN, 7315-PN, haverhill, hudson valley, glass pendant light, diffuser pendant light, light with metal arms, glass and metal light, ribbed glass, ribbed, ribbed glass pendant, glass stem light, glass farmhouse light, ambient glass lighting, glass industrial light,
65598	<p><span>With a shape reminiscent of a vintage beaker pendant, the Fontana Stem Mount Pendant Light is updated with a dash of mid-century style. This satin black pendant is crafted from hand-worked iron and encompassed by a glass shade which lends a contemporary feel. The sturdy stem mounting ensures this fixture is suitable for both residential and commercial settings. </span></p> <p>\|break\|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Satin Black Finish </li> <li>Adjustable Stem </li> </ul>	With plenty of mid century style, this stem mount pendant light is crafted from iron and finished in black for a timeless feel.	F7663, F7663-SBK, atticus, troy, glass pendant, glass pendant light, glass and metal pendant, glass and metal light fixture, glass and metal light, triangle light, beaker light, mid-century modern light, mid-century light fixture, mid-century pendant light, perforated light fixture, perforated pendant, clear glass light, modern fixture, modern light, modern light fixture, modern pendant, geometric light, angular light fixture,
65610	<p><span>The iconic hourglass shape of the Russo Stem Mount Pendant Light offers a classic mid-century modern feel. An opal glass globe peeks from beneath the sleek shade while the metal band centered on the shade adds a touch of color. Perfect for kitchen islands, dining room tables, or home office spaces, this adjustable stem mount pendant can be customized with either a Black or White shade.</span></p> <p>\|break\|</p> <ul> <li>This product is imported by Troy Lighting, a 3<sup>rd</sup> party vendor, and is not manufactured by Barn Light Electric</li> <li>Opal Shiny Glass</li> <li>Features an Adjustable Stem </li> </ul>	A ceiling pendant light with a mid century modern vibe. Suitable for kitchen lighting, dining lighting or commercial spaces!	F8615-SBK/PN, F8615-SWH/PB, scout, troy, hourglass pendant light, hour glass pendant light, modern pendant, angular pendant, opal glass globe pendant, glass and metal pendant, glass and metal light, mid-century modern light,
65673	<p><span>Inspired by vintage gas station lights, the Emblem incorporates a rounded angle shade and sturdy stem mounting allowing installation in nearly any setting. Perfectly suited for utilitarian needs, the Emblem Stem Mount Pendant highlights commercial signage, artwork and murals, and other decorative features both indoors and out.</span></p> <p><span>Easy to customize with a variety of shade sizes and finishes including marine grade, powder coat, and natural metals, the Emblem Stem Mount Pendant adds curb appeal during daylight hours and brilliant illumination at night. Handcrafted and made in America to last!</span></p> <p class="title">\|break\|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW67911049 BCX0"><span class="NormalTextRun SCXW67911049 BCX0">Hand-built with meticulous attention to detail, this indoor/out</span><span class="NormalTextRun SCXW67911049 BCX0">door<span> </span></span><span class="NormalTextRun SCXW67911049 BCX0">pendant </span><span class="NormalTextRun SCXW67911049 BCX0">is a dependable, long-lasting</span><span class="NormalTextRun SCXW67911049 BCX0"> lighting option.</span></span><span class="EOP SCXW67911049 BCX0" data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> </ul>		BLE-S-ASE8-PC, BLE-S-ASE10-PC, BLE-S-ASE12-PC, BLE-S-ASE14-PC, BLE-S-ASE, BLE-S-ASE-PC, Stem Emblem, Stem Mount Emblem, Emblem Stem Mount, Emblem Stem Mount Pendant, Emblem Stem Mount Pendants, Emblem Stem Mount Pendant, Emblem Stem Mount Pendants, Emblem Stem Mount Pendant, EmblemStem Mount Pendants, Emblem Stem Mount Pendant, Emblem Stem Mount Pendants, warehouse lighting, pendant lighting, pendant lights, new rlm, new stem, emblem series, emblem collection, emblem series, emblem collection, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, emblem stem/flush, emblem stem pendant, emblem stem light, emblem stem mount, emblem stem/flush, emblem stem pendant, emblem stem light, stems, Stem pendant lights, stem light mount, stem light mounts, stem, 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, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, jadeite, jadite, jadeite light, jadite light, sign light stem, stem sign light, sign light stem mount, stem mount sign light,
65674	<p><span>Inspired by classic vintage designs, the Elliptical Stem Mount Pendant features a tapered cone shade and sturdy stem mounting. The angled shade is crafted to cast light onto commercial signs and awnings resulting in a brighter, more inviting storefront. In interior applications, this American-made pendant can illuminate murals, menu boards, and artwork or photos hanging on walls.</span><br /><span> </span><br /><span>Available in a variety of sizes and a rainbow of brilliant powder coat finishes, the Elliptical Stem Mount Pendant can be easily customized to reflect your style and branding scheme. Bring this functional, handcrafted beauty to your commercial lighting plan!</span></p> <p class="title">\|break\|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW67911049 BCX0"><span class="NormalTextRun SCXW67911049 BCX0">Hand-built with meticulous attention to detail, this indoor/out</span><span class="NormalTextRun SCXW67911049 BCX0">door<span> </span></span><span class="NormalTextRun SCXW67911049 BCX0">pendant </span><span class="NormalTextRun SCXW67911049 BCX0">is a dependable, long-lasting</span><span class="NormalTextRun SCXW67911049 BCX0"> lighting option.</span></span><span class="EOP SCXW67911049 BCX0" data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> </ul>		BLE-S-ASL8-PC, BLE-S-ASL10-PC, BLE-S-ASL12-PC, BLE-S-ASL14-PC, BLE-S-ASL, BLE-S-ASL-PC, Stem Elliptical, Stem Mount Elliptical, Elliptical Stem Mount, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, warehouse lighting, pendant lighting, pendant lights, new rlm, new stem, elliptical series, elliptical collection, elliptical series, elliptical collection, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, elliptical stem/flush, elliptical stem pendant, elliptical stem light, elliptical stem mount, elliptical stem/flush, elliptical stem pendant, elliptical stem light, stems, Stem pendant lights, stem light mount, stem light mounts, stem, 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, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, jadeite, jadite, jadeite light, jadite light, sign light stem, stem sign light, sign light stem mount, stem mount sign light,
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",
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",
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",
65873	<p data-start="129" data-end="448">The Duo Stem Pendant is a bold and versatile lighting fixture designed for both style and flexibility. Featuring a mix-and-match design, this pendant allows you to choose three different finishes for the top, bottom and interior, giving you complete creative control to complement any interior.</p> <p data-start="450" data-end="745">Available in 10-inch and 14-inch sizes, the Duo Pendant showcases a stacked bowl design, offering a modern yet timeless aesthetic. Suspended from a sleek, thin stem, this pendant is perfect for dining rooms, kitchens, and living spaces, casting a warm and inviting glow.</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Customizable with the unique ability to select different finishes for the bottom shade’s interior and exterior.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> </ul>	Customize your lighting with the Duo Loma Stem Pendant, available in 10" and 14" sizes with mix-and-match finishes. Featuring a stacked bowl design, this modern pendant is perfect for kitchens, dining areas, and living spaces. Shop now!	duo pendant, duo stem, duo stem mount, duo light, duo fixture, modern pendant, modern stem mount, modern light, two-toned light, twotoned light, two-tone, two tone fixture, customizable light, round pendant, dome pendant, mid-century modern pendant, midcentury, wood accent, wooden accent, wood, farmhouse, farmhouse pendant, sleek pendant, neutral pendant,