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 (
    62019, 62023, 62020, 62022, 62018, 65461, 
    65814, 65815, 65813
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00070

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": 9,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (62019,62023,62020,62022,62018,65461,65814,65815,65813) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description	search_words
62018	<p>From restoration projects to newly constructed modern homes, the Chestnut Pendant contributes a grounded character to any setting. This pendant light’s timeless profile embraces a shallow bowl shade and stacked neck design. A timeless look, this fixture complements the various styles found in today’s houses and businesses.<br /> <br />Fully made-to-order, dozens of customization options, including multiple finishes and cords, 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.</p> <p>\|break\|</p> <ul> <li>Hand-built with an American made RLM warehouse shade, this quality industrial pendant is a lasting cord hung 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> <li>Read more about the Chestnut Pendant Light over on our<span> </span><a href="https://www.barnlight.com/inspiration/mid-century-kitchen-remodel/" target="_blank">blog!</a></li> </ul>	early electric style barn lighting, restored barn light, cord hung pendant light, barn swag light, twist cord pendant light, barn light pendant with cage, galvanized barn light pendant, custom lighting, custom ceiling lighting	From restoration to modern homes, the Chestnut Pendant is the ideal way to add early electric design. Customize its mounting, finish, and accessories!	cord hung pendant, cord hung, cord light, chestnut cord pendant, chestnut pendant, cord hung pendant light, barn swag light, twist cord pendant light, twist cord barn light, BLE-C-CLAR-PC, chestnut, The Chestnut Pendant, the chesnut cord pendant, chestnut ceiling lamp, hanging lamp, outdoor pendant, BLE-C-CLAR8-PC, BLE-C-CLAR10-PC, BLE-C-CLAR12-PC, BLE-C-CLAR14-PC, BLE-C-CLAR16-PC, new chestnut, chest nut, chesnut, chestnut, chest nut pendant, chesnut pendant, chestnut cord, chesnut cord, chest nut cord, BLE-C-CLAR8, BLE-C-CLAR10, BLE-C-CLAR12, BLE-C-CLAR14, BLE-C-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, 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,
62019	<p>Nodding to the styles of early American barn lights, the Chestnut Stem Mount Pendant showcases a truly timeless style. Suspending a stylish warehouse shade from a rugged stem mounting, the Chestnut represents the best of barn lighting: style and function. Featuring a similar look to <a title="The Laramie Stem Mount Pendant" href="/lighting/ceiling-lights/stem-mount-pendant-lighting/laramie-stem-mount-pendant-light/">the Laramie</a> — removing the decorative arms — this pendant light instills any space with a southern charm. The stem mounting adds functionality into the mix. Protecting the fixture, the Chestnut is able to stand up to installation in high traffic areas or as exterior lighting.</p> <p>Available with an assortment of customization options, the Chestnut mirrors the look of your space. Able to blend in or stand out, select the powder coat finish color best suiting your needs. 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 decor!</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. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>	porch pendant light, industrial stem mount porch light, exterior hanging pendant, barn light ceiling pendant, suspended warehouse shade, hanging barn light, doorway lighting	Taking a nod from early American lights, the Chestnut Pendant is a period style warehouse shade suspended in a stem ceiling mount. Lovely for porch lighting!	BLE-S-CLAR-PC, Chestnut Stem Mount Pendant, stem light, stem mount light, stemmount, stem light, barn light shade pendant light, hanging pendant, ceiling pendant, stem mount pendant, chestnut stem pendant, chestnut, chestnut pendant, the chestnut, chestnuts, chestnut light, laramie, BLE-S-CLAR8-PC, BLE-S-CLAR10-PC, BLE-S-CLAR12-PC, BLE-S-CLAR14-PC, BLE-S-CLAR16-PC, new listing, chestnut, chestnut stem, chesnut, chesnut stem, chest nut, chestnut pendant, chesnut pendant, chest nut pendant, new chestnut, BLE-S-CLAR8, BLE-S-CLAR10, BLE-S-CLAR12, BLE-S-CLAR14, BLE-S-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, 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,
62020	<p>Inspired by the spirit and style of traditional farmhouses, the Chestnut Gooseneck features a sleek shallow bowl design and classic lines. This shade is affixed to a gooseneck arm, establishing an iconic look. The fixture’s chic yet rugged profile feels timeless and appeals to both vintage-inspired and modern décors.</p> <p>Suitable for interior and exterior installation, the Chestnut is constructed by hand in the United States. Fully customizable, various finishes and arm styles lets anyone create truly unique looks!</p> <p>\|break\|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW116670060 BCX0"><span class="NormalTextRun SCXW116670060 BCX0">Meticulously handcrafted from</span><span class="NormalTextRun SCXW116670060 BCX0"><span> </span>high-quality, commercial-grade materials for a dependable</span><span class="NormalTextRun SCXW116670060 BCX0"><span> </span>indoor/outdoor wall light option.</span></span><span class="EOP SCXW116670060 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 Chestnut Gooseneck Light over on our<span> <a href="https://www.barnlight.com/inspiration/american-made-barn-lights-weather-high-altitude-environment-with-style/" target="_blank">blog</a>!</span></li> </ul>	decorative barn lights, galvanized gooseneck barn light, outdoor lighting, hand crafted lighting, gooseneck barn light	Inspired by the spirit and steadfastness of early American barn lights, Chestnut Gooseneck is a locally made outdoor light fixture ready for modern venues!	chestnut, the chestnut, chestnuts, chestnut light, laramie, gooseneck, goose-neck, goosenecks, goose neck, gooeneck, wall light, outdoor light, decorative barn light, BLE-G-CLAR-PC, chestnut gooseneck, chest nut gooseneck, barnlight gooseneck, BLE-G-CLAR12-PC, BLE-G-CLAR14-PC, BLE-G-CLAR16-PC, new listing, new chestnut, chesnut, chest nut, chestnut gooseneck light, chest nut goose neck light, chesnut gooseneck, chesnut goose neck, chestnut goosenecks, BLE-G-CLAR8, BLE-G-CLAR10, BLE-G-CLAR12, BLE-G-CLAR14, BLE-G-CLAR16, SPS-0063, SPS 0063, SPS0063, The Chestnut Collection, The Chestnut Series, Chestnut Collection, Chestnut Series, 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, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg,
62022	<p>This decorative barn light makes the perfect addition to your vintage porch or hallway lighting. Customize the Chestnut Wall Sconce with one of our vivid powder coat finish colors and other accessories like cast guard and glass. Or turn it into a plug-in sconce, offering you a portable and versatile wall light.</p> <p>American made and rugged enough for commercial applications, this industrial wall lighting gives its stylish take on warehouse lighting. The Chestnut offers the durability needed in both industrial and high traffic areas, while still providing a hint of style.</p> <p>\|break\|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial wall lighting is a lasting sconce 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>	barn light wall sconce, down light sconce, barn wall sconce, decorative barn light sconce, wall light fixture, american made wall sconce lighting, wall lighting, plug-in lighting, plug in wall lights	This decorative barn light makes the perfect addition to your vintage porch and hallway lighting. Customize your Chestnut wall sconce's powder coat finish!	wall sconce, hallway light, down light, shade sconce, sconce, wall light, wall sconce, wall sconces, scone, wall sconce lighting, traditional wall sconce light, wall sconce light, BLE-W-CLAR-PC, chestnut, the chestnut, chestnuts, chestnut light, laramie, laramie sconce, BLE-W-CLAR12-PC, BLE-W-CLAR14-PC, plug-in lighting, plug in lighting, plug in sconce, plug-in sconce, plug-in wall sconce, plug in wall lights, plug-in wall lights, chestnut sconce, new chestnut, chestnut sconce, chest nut sconce, chesnut sconce, chestnut sconces, chestnut wall sconce, chesnut wall sconce, chest nut wall sconce, BLE-W-CLAR12-N, BLE-W-CLAR12, BLE-W-CLAR14-N, BLE-W-CLAR14, SPS-0348, SPS 0348, SPS0348, The Chestnut Wall Sconce Collection, Chestnut Wall Sconce Collection, The Chestnut Wall Sconce Series, Chestnut Wall Sconce series, The Chestnut Sconce Collection, Chestnut Sconce Collection, The Chestnut Sconce Series, Chestnut Sconce series, 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,
62023	<p>Got a small space but still want loads of style? Check out the Bantam Chestnut Wall Sconce which packs maximum light and style into a mini shade. Perfect for doorways, halls, and porches, the plug-in cord option brings this industrial wall lighting to apartments or rental properties.</p> <p>This American made decorative wall light can be customized with one of our beautiful finish options. This sconce light gives any room a sleek, modern look. Sturdy enough to be installed as outdoor lighting or in commercial venues, the Bantam Chestnut Wall Sconce is ideal for any location.</p> <p>\|break\|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial wall lighting is a lasting sconce 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> <li>Read more about the Bantam Chestnut Wall Sconce over on our <a href="https://www.barnlight.com/inspiration/barn-pendants-wall-sconces-add-farmhouse-charm-to-new-build/" target="_blank">blog</a>!</li> </ul>	small barn light wall sconce, hallway light fixture, mini down light sconce, mini barn wall sconce, decorative barn light sconce, barn lighting sconce, bantam light fixture, wall sconce lighting, barn wall lantern, plug-in warehouse lighting	This mini shade barn light makes the perfect addition to your porch and hallway lighting. The Chestnut's decorative shade comes in a variety of colorful hues!	mini, small wall sconce, mini down light sconce, mini wall sconce, barn light sconce, lighting sconce, bantam light fixture, wall sconce lighting, BLE-W-CLAR8-PC, mini sconce, mini barn light, mini arm sconce, bantam , chestnut, mini chestnut, bantam chestnut, bantam, chestnut sconce, chestnut wall light, wall light, chest nut, mini scone, plug-in, plug in, plug-in wall sconces, plug in wall sconces, plug-in lighting, plug in lighting, farmhouse, farm house, modern farmhouse, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, new chestnut, bantam, bantam chestnut, bantam wall sconce, bantam chesnut, bantam chest nut, bantam chestnut wall sconce, bantam chestnut sconce, chestnut sconce, chestnut wall sconce, chesnut, chest nut, chestnut, BLE-W-CLAR8, BLE-W-CLAR10, SPS-0349, SPS 0349, SPS0349, bantam chestnut, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce 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, plug in barn light, plug-in barn light, plug-in light, mini outdoor sconce, bantam sconce,
65461	<p><span data-contrast="auto"><span>The Chestnut brings an elevated sense of style and plenty of illumination to a home or business’s undersized settings. With influences from classic light</span></span><span data-contrast="auto"><span>s</span></span><span data-contrast="auto"><span>, this fixture features the simple curves and straightforward appeal sought by today’s most popular </span></span><span data-contrast="auto"><span>look</span></span><span data-contrast="auto"><span>s</span></span><span data-contrast="auto"><span>. </span></span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></p> <p><span data-contrast="auto"><span>Various finishes and other customizing options control this fixture’s aesthetic. The Chestnut’s<span> </span></span></span><span data-contrast="auto"><span>timeless </span></span><span data-contrast="auto"><span>lines can take on a refined, upscale appearance with natural metals while powder coat finishes complement farmhouse or industrial décors. </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. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Learn more about the Chestnut Flush Mount Light over on our<span> blog!</span></li> </ul>		Classic styles in a flush mount pendant! The Chestnut features a timeless, fully customizable design! Handcrafted in the USA for unmatched durability!	BLE-F-CLAR, Chestnut Flush Mount Light, Chestnut Flush Mount, Chestnut Flush Mount Pendant, Chestnut Pendant, Chestnut Pendant Light, Chestnut ceiling light, Chestnut flush mount ceiling pendant, Chestnut flush, Flush Chestnut, The Chestnut Flush Mount Light, The Chestnut Flush Mount, The Chestnut Flush Mount Pendant, The Chestnut Pendant, The Chestnut Pendant Light, The Chestnut ceiling light, The Chestnut flush mount ceiling pendant, The Chestnut flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant,
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",