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 (65791, 65883, 65896, 65890) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (65791,65883,65896,65890) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
65791	<p><span data-contrast="auto"><span data-wac-het="1">An energy-saving option abundant with decorative appeal, the Sinclair 28" LED Stem Mount Pendant is a favorite for residential and commercial spaces. Based on classic lighting designs, the large-scale, shallow bowl shade evokes vintage industrial lights which gives the Sinclair a timeless feel. With an integrated LED module that eliminates the hassle of changing light bulbs, this pendant offers an environmentally friendly alternative with 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 the wiring allowing installation indoors and out. Commercial-grade materials make this pendant one of the most long-lasting lighting fixtures available. Fully customizable with numerous </span></span><span data-contrast="auto"><span data-wac-het="1">finish colors </span></span><span data-contrast="auto"><span data-wac-het="1">and other unique options help the Sinclair become a focal point 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> </ul>		BLE-S-SBS28, BLE-S-SBS28-LED, 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, oversized led sinclair, sinclair led 28" 28 sinclair led, large oversized sinclair, sinclair led stem, stem led sinclair, oversized stem led sinclair,
65883	<p data-start="0" data-end="247">The Duo LED Stem Pendant blends modern design with energy-efficient lighting, offering both style and sustainability. Its customizable mix-and-match finishes let you tailor the look to suit any space, from bold contrasts to subtle elegance.</p> <p data-start="249" data-end="608" data-is-last-node="">Designed in 10-inch and 14-inch sizes, this pendant features a distinctive stacked bowl silhouette, suspended from a sleek stem for a refined, contemporary feel. The integrated LED technology ensures long-lasting, efficient illumination, making it an ideal choice for dining areas, kitchens, and living spaces where ambiance and functionality go hand in hand.</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>	Elevate your space with the Duo Loma LED Stem Pendant, a modern and energy-efficient light fixture with customizable finishes. Perfect for kitchens, dining areas, and living spaces.	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, duo led pendant, led duo, modern led light, modern led stem pendant, led farmhouse pendant,
65890	<p class="p1">The Cassidy LED Stem Mount Pendant brings modern industrial charm to any space with its striking silhouette and minimalist globe design. The fixed stem creates a clean, tailored look—perfect for kitchens, hallways, or commercial interiors seeking a sleek, refined aesthetic. With over 30 finish options and bright, energy-efficient LED illumination (up to 2000 lumens), it offers both performance and personality.</p> <p>\|break\|</p> <ul> <li>Manufactured in the U.S.A.</li> <li>Acrylic globe provides soft, even light diffusion</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>	Modern and minimal, the Cassidy LED Stem Pendant Light delivers clean-lined style and brilliant performance—customize with 30+ finishes to suit any space.
65896	<p class="" data-start="46" data-end="345">The Oxford LED Stem Mount Pendant brings commanding presence and refined style to any space. With its oversized 23" shade, integrated LED technology, and sturdy stem suspension, it’s engineered for both impact and performance. Perfect for kitchens, workspaces, or commercial interiors, this fixture delivers bold, modern lighting with a streamlined silhouette and a range of finish options to suit your design vision.</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> </ul>	Discover the Oxford Stem Mount Pendant — a bold 23" LED fixture with a sleek, modern silhouette and durable stem suspension, perfect for statement-making spaces.	oxford stem, led oxford, the oxford, oversized led, oversized led light, oversized light, large modern light, modern led, stem oxford, oxford collection, stem mount led,