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 (64963, 64964, 65655) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64963,64964,65655) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
64963	<div> <p><span lang="en-US"><span>Effortlessly expressing styles from midcentury modern to traditional farmhouse, the Glass Ball Pendant is a natural addition to every setting. A round glass shade and a simple stem mounting are at the heart of this pendant’s design. When installed throughout a décor as either an accent piece or focal point, this fixture helps rooms feel elevated and stylish.</span></span><span> </span></p> </div> <div> <p><span lang="en-US"><span>Various finish colors and options including powder coat, copper, and brass determine the Glass Ball Pendant’s aesthetic. Several sizes and two glass options provide the proper dimensions for every space. </span></span><span> </span></p> </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> <li> <div>Looking for replacement glass for your Glass Ball Pendant? Click <a href="/accessories/hardware/glass-ball-globes/">here!</a></div> </li> </ul>		midcentury, mid-century, mid century, midcentury pendant, mid-century pendant, mid century pendant, midcentury pendant light, midcentury pendant lights, midcentury pendant lighting, mid-century pendant light, mid-century pendant lights, mid-century pendant lighting, mid century pendant light, mid century pendant lights, mid century pendant lighting, midcentury modern, mid century modern, mid-century modern, new downtown, BLE-S-GLB8, BLE-S-GLB12, BLE-S-GLB16, Glass sphere, glass spheres, glass sphere shade, glass sphere shades, sphere glass, sphere glass shade, sphere glass shades, glass sphere light, glass sphere lights, glass sphere lighting, sphere glass light, sphere glass lights, sphere glass lighting, glass sphere pendant, glass sphere pendants, glass sphere ceiling pendant, glass sphere ceiling pendants, glass sphere pendant light, glass sphere pendant lights, glass sphere pendant lighting, glass sphere ceiling light, glass sphere ceiling lights, glass sphere ceiling lighting, Sphere glass pendant, sphere glass pendants, sphere glass ceiling pendant, sphere glass ceiling pendants, sphere glass pendant light, sphere glass pendant lights, sphere glass pendant lighting, sphere glass ceiling light, sphere glass ceiling lights, sphere glass ceiling lighting, glass sphere light fixture, glass sphere light fixtures, glass sphere lighting fixture, glass sphere lighting fixtures, Round glass shade, round glass shades, round glass shade light, round glass shade lights, round glass shade lighting, Glass round shade, glass round shades, glass round shade light, glass round shade lights, glass round shade lighting, round glass light, round glass lights, round glass lighting, glass round light, glass round lights, glass round lighting, Glass round light, glass round lights, glass round lighting, Round glass shade pendant, round glass shade pendants, glass round shade pendant, glass round shade pendants, round glass pendant, round glass pendants, glass round pendant, glass round pendants, glass round ceiling pendant, glass round ceiling pendants, round glass ceiling pendant, round glass ceiling pendants, glass round pendant light, round glass pendant light, glass round pendant lights, round glass pendant lights, glass round pendant lighting, round glass pendant lighting, glass round ceiling light, round glass ceiling light, glass round ceiling lights, round glass ceiling lights, round glass ceiling lighting, glass round ceiling lighting, Glass globe shade, glass globe shades, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass globe shade fixture, glass globe shade fixtures, glass globe shade light fixture, glass globe shade light fixtures, glass globe shade lighting fixture, glass globe shade lighting fixtures, glass globe pendant, glass globe pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe pendant light, glass globe pendant lights, glass globe pendant lighting, glass globe ceiling light, glass globe ceiling lights, glass globe ceiling lighting, Globe shade, globe shades, globe shade light, globe shade lights, globe shade lighting, globe shade fixture, globe shade fixtures, globe shade light fixture, globe shade light fixtures, globe shade lighting fixture, globe shade lighting fixtures, globe light shade, globe light shades, globe light fixtures, globe light fixture, globe lighting fixture, globe lighting fixtures, Globe shade pendant, Globe shade pendants, Globe shade ceiling pendant, Globe shade ceiling pendants, globe pendant, globe pendants, globe ceiling pendant, globe ceiling pendants, globe pendant, globe pendants, globe pendant light, globe pendant lights, globe pendant lighting, globe ceiling pendant, globe ceiling pendants, globe ceiling light, globe ceiling lights, globe ceiling lighting, glass ball pendant, glass ball pendants, glass ball pendant light, glass ball pendant lights, glass ball pendant lighting, glass ball stem mount, glass ball stem mounts, glass ball stem mount light, glass ball stem mount lights, glass ball stem mount lighting, glass ball stem mount pendant, glass ball stem mount pendants, glass ball stem mount pendant light, glass ball stem mount pendant lights, glass ball stem mount pendant lighting, glass ball stem mount ceiling pendant, glass ball stem mount ceiling pendants, glass ball stem mount ceiling light, glass ball stem mount ceiling lights, glass ball stem mount ceiling lighting, BLE-S-GLB, Glass Ball collection, Glass Ball Series, the glass ball collection, the glass ball series, SPS 0076, SPS0076, SPS-0076, glass shade, glass ball shade, glass ball shades, glass ball light, glass ball lights, glass ball lighting, stems, Stem pendant lights, stem light mount, stem light mounts, stem, opaque glass pendant, clear glass pendant, glb, glbcl,
64964	<div> <div> <div lang="en-US"> <div> <p lang="en-US"><span lang="en-US"><span>With its simple curves and timeless appeal, the Glass Ball Pendant has found a home in both modern spaces and traditional settings. This versatile aesthetic is established by suspending a globe-shaped glass shade from a classic cord mounting, a design that’s simultaneously grounded and refined. From upscale décors to casually decorated venues, this timeless pendant puts the finishing touches on any project. </span></span><span> </span></p> </div> </div> </div> </div> <div> <div lang="en-US"> <div> <p lang="en-US"><span lang="en-US"><span>An abundance of finishes, multiple sizes, and opaque or clear glass customizes the Glass Ball Pendant to individual settings. Select a vibrant powder coat finish for eclectic décors or embrace copper or brass for a more sophisticated profile.</span></span><span> </span></p> </div> </div> </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> <li><span>Looking for replacement glass for your Glass Ball Pendant? Click </span><a href="https://www.barnlight.com/accessories/hardware/glass-ball-globes/">here!</a></li> </ul>		Glass Ball Pendant Light, Glass Ball Pendant, Glass Ball Pendants, Glass Ball, Glass Ball Ceiling Pendant Light, Glass Ball Ceiling Pendant, Glass Ball Ceiling Pendants, BLE-C-GLB, BLE-C-GLB8, BLE-C-GLB12, BLE-C-GLB16, glass shade, glass ball shade, glass ball shades, glass ball light, glass ball lights, glass ball lighting, Glass Ball collection, Glass Ball Series, the glass ball collection, the glass ball series, SPS 0076, SPS0076, SPS-0076, 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, opaque glass pendant, clear glass pendant, glb, glbcl,
65655	<div> <div lang="en-US"> <p lang="en-US">Combining the elegance of glass with the rustic aesthetic of natural wood, how could this pendant light be any better? We included the very latest in LED technology to make this fixture not only stylish but energy saving and cost effective too! The timeless appeal of the <span>globe-shaped glass ball suspended from a classic cord mounting is suitable for both traditional and modern décors. </span></p> <p lang="en-US"><span><span lang="en-US">With multiple sizes and a variety of wood species and cords to choose from, the Glass Ball LED Wooden Top Pendant can be easily customized to individual settings. The integrated LED module means that you will never change a light bulb and you can enjoy lower energy bills for years to come!</span><span> </span></span></p> </div> </div> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A. </li> <li>Part of our exclusive <a title="Learn more about our Timber & Ore Collection" href="https://www.barnlight.com/timber-ore-collection/">Timber & Ore Collection</a></li> <li>All wood is sourced from North American suppliers who are committed to sustainable felling and regrowth practices.</li> <li><span>Every p</span><span>iece of wood is unique with slight, natural variations such as knots and grain differences due to natural growth patterns. No two pieces will be exactly alike!</span></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> <li><span>Looking for replacement glass for your Glass Ball Pendant? Click </span><a href="https://www.barnlight.com/accessories/hardware/glass-ball-globes/">here!</a></li> </ul>	This striking pendant is the statement piece you've been looking for! Sleek opaque glass and handcrafted wood make an attractive addition to your space!	Glass Ball Pendant Light, Glass Ball Pendant, Glass Ball Pendants, Glass Ball, Glass Ball Ceiling Pendant Light, Glass Ball Ceiling Pendant, Glass Ball Ceiling Pendants, glass ball wooden pendant, glass ball wood, glass wood pendant, wood top glass ball, timber and ore, timber & ore, timber ore, timber, wood light, wooden light, wood pendant, wooden pendant, wood top light, wood accent light, BLE-C-GLB, BLE-C-GLB8, BLE-C-GLB12, BLE-C-GLB16, glass shade, glass ball shade, glass ball shades, glass ball light, glass ball lights, glass ball lighting, Glass Ball collection, Glass Ball Series, the glass ball collection, the glass ball series, SPS 0076, SPS0076, SPS-0076, 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, led wood, wood led, timber and ore led, timber ore led, led timber and ore, led timber ore, wood and glass light, glass and wood light, wood light with glass globe, wood accent light, wood accent pendant, opaque glass pendant, clear glass pendant, glb, glbcl,