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

Result

product_id	full_description	meta_keywords	meta_description	search_words
64853	<p>Midcentury style with American craftsmanship, the Lovell Task Lamp helps establish an elevated office or bedroom décor. From its weighted base to handcrafted shade, this lamp’s design is imbued with quality. The cone-shaped cup shade and adjustable swivel joint direct light onto paperwork, books, and homework.</p> <p>Fully customizable, the Lovell is offered with multiple finish options, including marine grade, powder coat, and natural metals like copper and brass. When outfitted with this task lamp, any space can take on a unique look and feel.</p> <p>\|break\|</p> <ul> <li>This product is made-to-order and manufactured in the USA!</li> <li>Complete with a weighted bottom to prevent lamp from tipping </li> <li>Adjustable head swivels to 90<span>°</span> degrees</li> <li><span>Includes inline on/off switch and 6 feet of cord</span></li> <li>Learn more about the Lovell Task Lamp over on our<span> <a href="/inspiration/vintage-inspired-task-lighting-with-plug-in-convenience/" target="_blank">blog</a></span>!<span><br /></span></li> </ul>	mid century modern table lamp, modern task light, custom task lamp, bedside light, adjustable task lamp, 90 degree adjustable head	This custom task lamp marries mid-century style with quality craftsmanship. This handcrafted table lamp has raw details including a brass stem and unique cord.	BLE-L-TL003, Lovell Task Lamp, Modern Table Lamp, task light, task, table light, table lamp, reading light, plug in lamp, lovell lamp, new lovell, lovell lamp, lovell table lamp, BLE-L-TL003-PC, lovell powder coat, lovell copper, lovell brass, brass lamp, copper lamp, brass table lamp, copper table lamp, brass task lamp, copper task lamp, desk lamp, lovell desk lamp, desk lamp, lamp lovell, lovel, table lamps, lovell, lovell retro lamp, lovell retro lamps, lovell table lamp, lovell table lamps, task light, task lights, task lighting, task lamp, task lamps, task table lamp, task table lamps, nightstand light, night stand light, nightstand lights, night stand lights, nightstand lighting, night stand lighting, nightstand lamp, night stand lamp, nightstand lamps, night stand lamps, reading lamp, Lovell Collection, Lovell Series, The Lovell Collection, The Lovell Series, SPS-0044, SPS 0044, SPS0044, lovelle, lovell plugin, lovell plug in, lovell plug-in, small table lamp, metal lamp shade, metal lampshade,
64854	<p>A refined yet casual look, the Lovell Plug-In Wall Sconce channels midcentury styles, becoming an integral decorative accent piece. The sconce’s cone-shaped shade is adjustable up to 90 degrees, meaning you can direct light wherever it’s needed. Perfect for bedside tables, this fixture can quickly makeover a room thanks to its plug-in cord.</p> <p>American made and handcrafted, the Lovell is fully customizable with a wide range of finish colors and options, including marine grade, powder coat, and natural metals. Create a unique look for your space and transform your décor!</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> <li>Adjustable head swivels to 90<span>°</span><span> </span>degrees</li> <li><span>Includes inline on/off switch and 8 feet of cord</span></li> <li>Learn more about the Lovell Plug-In Wall Sconce over on our<span> <a href="/inspiration/featured-customer-porcelain-wall-sconces-add-personality-to-playroom-library/" target="_blank">blog</a></span>!</li> </ul>	mid century modern wall light, plug in sconce, swivel arm sconce, bedside lighting	Channeling mid century style, the Lovell features a cone affixed to a swivel arm sconce. A decorative plug-in allows this industrial sconce to move with you.	Lovell Plug-In Wall Sconce, BLE-L-WL001, plug in, wall sconce, modern sconce, plug in sconce, lovell, lovell wall sconce, lovell sconce, portable lighting, portable light, plug in pendant, small sconce, lovel, cone shaped sconce, cone sconce, new lovell, The Lovell Plug-In Wall Sconce, Lovell Plug-In Wall Sconce, The Lovell Plug In Wall Sconce, The Lovell Wall Sconce, Lovell Wall Sconce, lovell sconce, lovell plug in, lovell plug-in, plug in, plug-in, plug-in sconce, plug in sconce, plug-in wall sconce, plug in wall sconce, plug-in lighting, plug in lighting, plug-in wall light, plug-in wall lighting, plug in wall lighting, plug-in wall light, BLE-L-WL001, copper lovell, brass lovell, brass plug-in, copper plug-in, copper plug-in sconce, brass plug-in sconce, sconce plug in, sconce plug-in, wall sconce plug in, wall sconce plug-in, plug wall sconce, plug sconce, plug wall sconces, plug sconces, wall lamps with plugs, wall lamp with plugs, wall lamps with plug, wall lamp with plug, Lowel plug in, Lowel plug-in, brass wall lamp, lovell plug in sconce, Lovell Collection, Lovell Series, The Lovell Collection, The Lovell Series, SPS-0028, SPS 0028, SPS0028, Plug ins, Plug-ins, Plug-in, Plug in, plug in wall lamp, plug in wall lamps, plug-in wall lamp, plug-in wall lamps, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor 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, lovelle, Wall sconce with plug, sconce with plug, sconce light with plug, sconce lights with plug, copper plug in, plug in barn light, plug-in barn light, plug-in light, jadeite, jadite, jadeite light, jadite light,
65590	<p>Conveying a classic midcentury style, the Lovell Wall Sconce becomes an eye-catching accent light in bedrooms, living spaces, hallways, and bathrooms. With a refined yet casual look, this wall sconce can be customized with a variety of options and colors to complement any d<span>é</span>cor. The fixture's cone-shaped shade is adjustable up to 90 degrees allowing you to direct the illumination exactly where needed. </p> <p>American made and handcrafted with attention to every detail, the Lovell is fully customizable with a wide range of finish colors and options, including marine grade, powder coat, and natural metals. Create the exact look you envision for your space and transform your décor!</p> <p>\|break\|</p> <ul> <li>Manufactured and handcrafted 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> <li>Adjustable head swivels to 90<span> </span>degrees</li> </ul>			Lovell Wall Sconce, BLE-L-WL001, wall sconce, modern sconce, lovell, lovell wall sconce, lovell sconce, small sconce, lovel, cone shaped sconce, cone sconce, new lovell, The Lovell Wall Sconce, Lovell Wall Sconce, Lovell Wall Sconce, lovell sconce, Lovell Collection, Lovell Series, The Lovell Collection, The Lovell Series, SPS-0028, SPS 0028, SPS0028, interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor 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, lovelle, jadeite, jadite, jadeite light, jadite light,