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 (
    64744, 64745, 64749, 64747, 64746, 65301
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64744,64745,64749,64747,64746,65301) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
64744	<p>This classic gooseneck fixture combines the integrity of high-quality metals with fashionable lighting designs. Originally developed to spread illumination evenly throughout industrial settings, the Dominion’s shallow RLM shade offers a timeless aesthetic, one that complements both modern and traditional styles. A fashionable addition to any exterior décor, the Dominion significantly contributes to a home or business’s curb appeal.</p> <p>The Dominion is entirely made-to-order and is customizable to your specifications. Available with colorful powder coat, elegant copper or brass, and our weather-resistant marine grade finishes, the Dominion can match any setting’s particular style. Manufactured by hand in the United States, this gooseneck light demonstrates unmatched durability!</p> <p>\|break\|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW220589230 BCX0"><span class="NormalTextRun SCXW220589230 BCX0">A rugged, handcrafted</span><span class="NormalTextRun SCXW220589230 BCX0"><span> </span></span><span class="NormalTextRun SCXW220589230 BCX0">gooseneck wall light, this industrial fixture is<span> </span></span><span class="NormalTextRun SCXW220589230 BCX0">a long-</span><span class="NormalTextRun SCXW220589230 BCX0">lasting</span><span class="NormalTextRun SCXW220589230 BCX0"><span> </span></span><span class="NormalTextRun SCXW220589230 BCX0">indoor/outdoor lighting option. </span></span><span class="EOP SCXW220589230 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> <li>Learn more about the Dominion Gooseneck Light over on our<span> <a href="https://www.barnlight.com/inspiration/gooseneck-lights-in-the-kitchen-oh-but-yes/" target="_blank">blog</a>!</span></li> </ul>	gooseneck lights for signs, gooseneck warehouse light, gooseneck down lighting, shallow bowl gooseneck fixture, exterior gooseneck lighting, residential exterior lighting, outside lighting, american made outdoor lighting, home exterior barn lighting	The Dominion's shallow bowl reflector mounted to our iconic gooseneck arm makes the perfect down light your home exteriors, garages, and barn lighting!	BLE-G-SBD12, dominion, shallow bowl gooseneck light, BLE-G-SBD12, BLE-G-SBD14, BLE-G-SBD16, BLE-G-SBD, dominion gooseneck, shallow gooseneck, new dominion, new rlm, new listing, District Gooseneck Light, BLE-G-SBD12, district, gooseneck light, shallow bowl gooseneck light, BLE-G-SBD12-PC, BLE-G-SBD14-PC, BLE-G-SBD16-PC, interior gooseneck, interior gooseneck lighting, exterior lighting, exterior gooseneck lighting, exterior wall light, exterior wall lighting, The District Gooseneck Light, district gooseneck, district gooseneck lighting, district wall light, district exterior wall light, distinct wall mount, exterior wall mount, outdoor wall mount, interior wall mount, gooseneck lighting, outdoor gooseneck lighting, exterior gooseneck, shallow bowl gooseneck, shallow bowl shade, shallow bowl gooseneck lighting, dominion gooseneck light, district gooseneck light, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, bleg, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse gooseneck,
64745	<p>First developed for a wide light spread, the Dominion’s timeless RLM style remains relevant to modern décors. This design incorporates a flared shallow bowl shade and durable stem mounting, establishing a pendant that’s equally fashionable and dependable. The inclusion of a stem mounting helps the Dominion withstand installation in wet outdoor locations. <br /><br />By expressing timeless styles, the Dominion is a favorite in both contemporary and traditional spaces. Thanks to its stem mounting, the Dominion offers a slightly more formal appearance than other fixtures. Handcrafted and American made, a diverse range of customization options gives the Dominion a truly unique aesthetic. Finishes include our protective marine grade, vivid powder coat, and refined copper and brass.</p> <p>\|break\|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW35936510 BCX0"><span class="NormalTextRun SCXW35936510 BCX0">A<span> </span></span><span class="NormalTextRun SCXW35936510 BCX0">rugged, long-lasting indoor/outdoor light, this</span><span class="NormalTextRun SCXW35936510 BCX0"> stem mount pendant offers the<span> </span></span><span class="NormalTextRun SCXW35936510 BCX0">durability and quality associated with hands-on American manufacturing.</span></span><span class="EOP SCXW35936510 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="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>	hand spun pendant shade, stem mounted pendant lighting, shallow bowl pendant, shallow bowl factory reflector, utility lighting, warehouse light, retail store lighting	Inspired by vintage pendant lighting, the Dominion showcases an artisan hand-spun shallow bowl shade and durable stem mount.	dominion, BLE-S-SBD12, BLE-S-SBD14, BLE-S-SBD16, BLE-S-SBD, shallow bowl pendant, stem mount pendant, stem mount light, benjamin dominion, dominion stem, dominion pendant, shallow stem, flat stem, shallow, flat, stem dominion, new listing, new dominion, new rlm, dominion, district, District Stem Light, district, shallow bowl, pendant, BLE-S-SBD12, stem mount pendant, BLE-S-SBD12-PC, BLE-S-SBD14-PC, BLE-S-SBD16-PC, BLE-S-SBD12, BLE-S-SBD14, BLE-S-SBD16, Outdoor farm light, wet rated outdoor pendant, wet rated outdoor pendants, wet-rated outdoor pendant, wet-rated outdoor pendants, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, stems, Stem pendant lights, stem light mount, stem light mounts, stem, pastel, 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, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, 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, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse stem mount,
64746	<p>Suspending a timeless RLM shade from a rugged chain mounting, the Dominion establishes an authentic industrial aesthetic. The Dominion’s shallow bowl design articulates influences from vintage lighting fixtures. However, thanks to the shade’s streamlined profile, this pendant still appeals to contemporary spaces. With this versatile style, along with a diverse selection of finishes and other customization options, the Dominion can become one of a home or business’s most important decorative features.</p> <p>To ingrain the shade with an unparalleled sense of durability, our team of talented artisans constructs the Dominion entirely by hand. We spin flat pieces of metal at a high speed and carefully work the material into the necessary shape. This combination of craftsmanship and high-quality metal results in an incredibly long-lasting source of illumination.</p> <p>\|break\|</p> <ul> <li>This chain mount pendant features a handcrafted, American made RLM warehouse shade.</li> <li>Made-to-order. Learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>	industrial swag lamp, beautiful barn lighting, decorative lights, chain hung ceiling lights, american made lighting	Uniting timeless styles and meticulous craftsmanship, this pendant is perfect for homes and businesses. Fully made-to-order in the USA!	BLE-C-SBD-CN36, Steber Dominion Chain Hung Pendant, Steber Dominion Chain Hung Pendants, The Steber Dominion Chain Hung Pendant, The Steber Dominion Chain Hung Pendants, Dominion Chain Hung Pendant, Dominion Chain Hung Pendants, The Dominion Chain Hung Pendant, The Dominion Chain Hung Pendants, Steber Dominion Chain Hung Pendant, Steber Dominion Chain Hung Pendants, The Steber Dominion Chain Hung Pendant, The Steber Dominion Chain Hung Pendants, Steber Dominion Chain Pendant, Steber Dominion Chain Pendants, The Steber Dominion Chain Pendant, The Steber Dominion Chain Pendants, Dominion Chain Pendant, Dominion Chain Pendants, The Dominion Chain Pendant, The Dominion Chain Pendants, Steber Dominion Chain Mount Pendant, Steber Dominion Chain Mount Pendants, The Steber Dominion Chain Mount Pendant, The Steber Dominion Chain Mount Pendants, Dominion Chain Mount Pendant, Dominion Chain Mount Pendants, The Dominion Chain Mount Pendant, The Dominion Chain Mount Pendants, Steber Dominion Chain Mount Pendant, Steber Dominion Chain Mount Pendants, The Steber Dominion Chain Mount Pendant, The Steber Dominion Chain Mount Pendants, Steber Dominion Chain Pendant, Steber Dominion Chain Pendants, The Steber Dominion Chain Pendant, The Steber Dominion Chain Pendants, Dominion Chain Pendant, Dominion Chain Pendants, The Dominion Chain Pendant, The Dominion Chain Pendants, new listing, new rlm, new dominion, District Chain Hung Pendant, BLE-C-SBD-PC-CN36, district, chain hung, chain, swag light, district chain hung, district chain, chain hung district, chain district, district swag, shallow bowl chain, chain mount light, district chain hung, BLE-CN-SBD12, BLE-CN-SBD14, BLE-CN-SBD16, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, Chain barn light, Chain barn lights, Chain barn lighting, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade,
64747	<p>The Dominion Cord Hung Pendant imparts a modern sensibility to classic lighting designs. The shade’s sleek streamlined profile offers a sense of character in any location. As a decorative addition to modern and farmhouse kitchens, the Dominion is a fashionable alternative to standard options like track lighting. Installed in businesses, the Dominion helps establish an eye-catching commercial identity and style.</p> <p>Constructed entirely in the United States, our team of metal spinners carefully shapes the District’s shade by hand. We use solid, commercial-grade metal in the construction of each shade which helps it withstand installation in high-traffic commercial venues. Entirely built-to-order, the Dominion offers the opportunity to create a truly unique look. Choose from a selection of finish options, guards, and cord styles and bring a new focal point to your home or business!</p> <p>\|break\|</p> <ul> <li>This American-made RLM warehouse shade embraces commercial-grade metals and our attentive, hands-on manufacturing process, resulting in a long-lasting industrial pendant.</li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li>Read more about the Dominion Pendant Light over on our<span> <a href="/inspiration/style-me-sunday-we-scream-for-ice-cream/" target="_blank">blog</a>!</span></li> </ul>	lighting pendant, barn light pendant, shallow bowl pendant light, vintage industrial lighting, GU24 compatible lighting, warehouse shade cord hung pendants, american made ceiling light, shallow bowl ceiling light, hanging light	This hanging pendant light features vintage barn lighting style with vibrant color options! The District's shallow bowl makes a statement in any space.	BLE-C-SBD12, dominion, shallow bowl pendant, BLE-C-SBD, BLE-C-SBD14, BLE-C-SBD16, dominion pendant, ivanhoe dominion, shallow pendant, shallow, flat pendant, new listing, new rlm, new dominion, dominion, district, District Cord Hung Pendant, BLE-C-SBD12, district, shallow bowl, cord hung pendant, BLE-C-SBD12-PC, BLE-C-SBD14-PC, BLE-C-SBD16-PC, BLE-C-SBD12, BLE-C-SBD14, BLE-C-SBD16, SPS-0152, SPS0152, SPS0152, Dominion Series, Dominion Collection, The Dominion Series, The Dominion Collection, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse cord-hung pendant,
64749	<p>To impart a touch of style into homes and businesses, the Dominion Wall Sconce features a sleek shallow bowl shade. Influenced by early 20th century designs, the Dominion offers a timeless profile and versatile appearance. A diverse assortment of finishes — marine grade, powder coat, copper, and brass — and other customization options lets anyone create a one-of-a-kind look for their space. <br /><br />This American made wall sconce is crafted entirely by hand. Constructed with meticulous attention paid to every detail, the Dominion offers the durability and style desired by every home or business owner.</p> <p>\|break\|</p> <ul> <li>Hand-built with an RLM warehouse shade, this industrial sconce demonstrates the ruggedness and <span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW46039875 BCX0"><span class="NormalTextRun SCXW46039875 BCX0">quality</span></span> found exclusively in American-made lighting.</li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li>Read more about the Dominion Wall Sconce over on our <a href="https://www.barnlight.com/inspiration/sleek-wall-sconces-offer-scandinavian-touch-to-exterior-remodel/" target="_blank">blog</a>!</li> </ul>		Incorporate the charm of vintage farmhouse lighting with this barn wall sconce! Customize the Dominion's shallow bowl shade to your space!	BLE-W-SBD, Wheeler™ Dominion Wall Sconce, wheeler sconce, wheeler dominion, new listing, new rlm, new dominion, dominion, BLE-W-SBD-PC, The District Sconce, district, barn sconce, shallow bowl, shallow bowl sconce, outdoor sconce, wall sconce, wall light, shallow bowl wall light, BLE-W-SBD12-PC, BLE-W-SBD14-PC, BLE-W-SBD16-PC, wall light, warehouse light, warehouse shade, wall lighting, plug in wall light, plug-in wall light, plug-in sconce, plug in sconce, plug in wall sconce, plug-in wall sconce, industrial wall sconce, industrial wall light, industrial lighting, BLE-W-SBD12-N, BLE-W-SBD12, BLE-W-SBD14-N, BLE-W-SBD14, SPS-0223, SPS0223, SPS 0223, Dominion Sconce Collection, Dominion Sconce Series, Dominion Wall Sconce Collection, Dominion Wall Sconce Series, Wall mount outdoor lights, Wall mount outdoor light, Wall mount outdoor lighting, Wall mount outdoor light fixture, Wall mount outdoor light fixtures, Wall mount outdoor lighting fixture, Wall mount outdoor lighting fixtures, wall light sconce, wall light sconces, Wall sconce outdoor, outdoor Wall sconce, outdoor Wall sconces, Wall sconces outdoor, sconce outdoor, outdoor sconce, outdoor sconces, sconces outdoor, 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, plug in barn light, plug-in barn light, plug-in light, jadeite, jadite, jadeite light, jadite light, bowl shallow, H-15512, H-15514, H-15516, shallow dome warehouse shade,
65301	<p>Featuring a vintage-inspired design, the Dominion’s subtle shade coordinates with both modern and traditional preferences. Thanks to its compact flush mounting, this fixture delivers hints of character and inviting illumination to the smaller areas of a home or business. Additionally, this mounting allows installation in outdoor settings by protecting the fixture’s wires and electrical components. <br /><br />To give the Dominion its distinctive personality, an abundance of finish options is available — including colorful powder coat, inimitable porcelain, and sophisticated copper or brass. This American-made fixture features the durability offered only with a meticulous hands-on manufacturing process.</p> <p>\|break\|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant lighting 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>		Timeless lighting styles for smaller spaces, this flush mount pendant stands out in any décor! American made and fully customizable!	BLE-F-SBD, Dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush mount pendant light, dominion flush mount pendant lights, dominion flush mount pendant lighting, dominion flush mount, dominion flush mounts, dominion flush mount pendant, dominion flush mount pendants, dominion flush pendant, dominion flush pendants, dominion flush mount light, dominion flush pendant, flush mount dominion, flush dominion, Dominion flush, dominion flush pendant, dominion flush pendant light, dominion flush mount pendants, flush mount, flush mount light, flush mount pendant light, flush mount pendant lighting, H-15512, H-15514, H-15516, shallow dome warehouse shade, shallow dome warehouse flush mount,