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 (63811, 63815, 63813, 63812, 63814) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00061

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": 5,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (63811,63815,63813,63812,63814) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_description	search_words
63811	<p>It’s the accessories you select that tie together a room’s style and establish a truly fashionable setting. Looking to our own classic RLM shades for inspiration, we’ve constructed a unique floor lamp capable of defining your décor. Incorporating our Fargo shade, this lamp adheres to both modern and vintage aesthetics. Finished with the color of your choice, the Fargo spreads splashes of color throughout your entire home or apartment. Several cord styles and stem options helps your new floor lamp feel one-of-a-kind!</p> <p>Allowing the perfect touches of accent lighting for any setting, the Fargo’s neck adjusts up to ninety degrees. The base is weighted to prevent the lamp from tipping over, while indicating its high quality construction. Use the Fargo to brighten your spaces and set the tone for 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>Floor lamp features a cast iron weighted bottom to prevent lamp from tipping</li> <li>Includes inline on/off switch</li> <li>Adjustable head swivels to 90 degrees</li> </ul> <p> </p>	Providing the fashionable accessories needed by every space, the Fargo blends floor lamps and RLM shades. Handmade in the United States and fully customizable!	BLE-L-FL001, The Fargo Floor Lamp, The Fargo Floor Lamps, Fargo Floor Lamps, The Fargo Floor Lamps, Fargo Floor Lamp, The Fargo Lamp, The Fargo Lamps, Fargo Lamps, Fargo RLM Lamp, Fargo RLM Lamps, Fargo RLM Floor Lamp, Fargo RLM Floor Lamps, The Fargo RLM Floor Lamp, The Fargo RLM Floor Lamps, RLM floor lamp, RLM floor lamps, RLM Lamp, RLM lamps, RLM-style lamp, RLM-style lamps, RLM Style Lamp, RLM Style Lamps, RLM-style floor lamp, RLM-style floor lamps, RLM style floor lamp, RLM style floor lamps, floor lamp, floor lamps, fargo, fargo lamps, warehouse shade lamp, warehouse shade lamps, warehouse shade floor lamps, warehouse shade floor lamp, warehouse shade lamp, warehouse shade lamps, warehouse shade style floor lamp, warehouse shade style floor lamps, warehouse lamp, warehouse lamps, warehouse floor lamp, warehouse floor lamps, floor lamps with shade, floor lamps with shades, lamp shade, lampshade, lampshades, lamp shades, floor lamp shade, floor lamp shades, floor lamps with RLM shade, floor lamps with RLM shades, floor lamp with RLM shade, floor lamp with RLM shades, floor lamp with warehouse shade, floor lamps with warehouse shade, floor lamp with warehouse shades, floor lamps with warehouse shades, floor lamp with shade, floor lamp with shades, lamp with shade, lamp with shades, floor lamp with barn shade, floor lamp with barn shades, lamp with barn shade, lamp with barn shades, lamps, barn lamp, barn lamps, barn floor lamp, barn floor lamps, barn light lamp, barn light lamps, barn lights lamp, barn lights lamps, barn lighting lamp, barn lighting lamps, barn light floor lamp, barn light floor lamps, barn lights floor lamp, barn lights floor lamps, barn lighting floor lamp, barn lighting floor lamps, barn style lamp, barn-style lamp, barn style lamps, barn-style lamps, barn style floor lamp, barn-style floor lamp, barn-style floor lamps, barn style floor lamps, standing lamp, standing lamps, standing floor lamp, standing floor lamps, pharmacy lamp, floor light,
63812	<p>Offering the decorative touches every space needs, we’ve made a selection of our shades available as floor lamps. Centered on the classic RLM look, the Sinclair bridges both modern and classic sensibilities. Giving any room its own distinct personality, this floor lamp helps your home or apartment feel warm and lived-in.</p> <p>This lamp includes a sturdy stem and a weighted base to create a durable and long lasting floor lamp. Adjustable up to ninety degrees, the Sinclair provides the right amount of light to any setting. Because our lamps are made-to-order, you’re able to customize the Sinclair to reflect your tastes. Select the finish color, stem option, and cord style and give your space the perfect fashionable accessory!</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>Floor lamp features a cast iron weighted bottom to prevent lamp from tipping</li> <li>Includes inline on/off switch</li> <li>Adjustable head swivels to 90 degrees</li> </ul>	Incorporating classic shade designs, this floor lamp grabs attention in any setting. Fully customizable to your tastes! This lamp is constructed and assembled in the United States!	BLE-L-FL002, The Skylark Floor Lamp, The Skylark Floor Lamps, Skylark Floor Lamps, The Skylark Floor Lamps, Skylark Floor Lamp, The Skylark Lamp, The Skylark Lamps, Skylark Lamps, Skylark RLM Lamp, Skylark RLM Lamps, Skylark RLM Floor Lamp, Skylark RLM Floor Lamps, The Skylark RLM Floor Lamp, The Skylark RLM Floor Lamps, RLM floor lamp, RLM floor lamps, RLM Lamp, RLM lamps, RLM-style lamp, RLM-style lamps, RLM Style Lamp, RLM Style Lamps, RLM-style floor lamp, RLM-style floor lamps, RLM style floor lamp, RLM style floor lamps, floor lamp, floor lamps, skylark, skylark lamps, warehouse shade lamp, warehouse shade lamps, warehouse shade floor lamps, warehouse shade floor lamp, warehouse shade lamp, warehouse shade lamps, warehouse shade style floor lamp, warehouse shade style floor lamps, warehouse lamp, warehouse lamps, warehouse floor lamp, warehouse floor lamps, floor lamps with shade, floor lamps with shades, lamp shade, lampshade, lampshades, lamp shades, floor lamp shade, floor lamp shades, floor lamps with RLM shade, floor lamps with RLM shades, floor lamp with RLM shade, floor lamp with RLM shades, floor lamp with warehouse shade, floor lamps with warehouse shade, floor lamp with warehouse shades, floor lamps with warehouse shades, The Sky lark Floor Lamp, The Sky lark Floor Lamps, Sky lark Floor Lamps, The Sky lark Floor Lamps, Sky lark Floor Lamp, The Sky lark Lamp, The Sky lark Lamps, Sky lark Lamps, Sky lark RLM Lamp, Sky lark RLM Lamps, Sky lark RLM Floor Lamp, Sky lark RLM Floor Lamps, The Sky lark RLM Floor Lamp, The Sky lark RLM Floor Lamps, sky lark, sky lark lamps, floor lamp with shade, floor lamp with shades, lamp with shade, lamp with shades, floor lamp with barn shade, floor lamp with barn shades, lamp with barn shade, lamp with barn shades, lamps, barn lamp, barn lamps, barn floor lamp, barn floor lamps, barn light lamp, barn light lamps, barn lights lamp, barn lights lamps, barn lighting lamp, barn lighting lamps, barn light floor lamp, barn light floor lamps, barn lights floor lamp, barn lights floor lamps, barn lighting floor lamp, barn lighting floor lamps, barn style lamp, barn-style lamp, barn style lamps, barn-style lamps, barn style floor lamp, barn-style floor lamp, barn-style floor lamps, barn style floor lamps, standing lamp, standing lamps, standing floor lamp, standing floor lamps, floor light,
63813	<p>The importance of fashionable accessories is often overlooked when decorating a room. The proper furniture, paint colors, and other design elements establish a setting’s overall aesthetic. But the accessories you include take your décor to the next level. Our latest line of floor lamps presents the opportunity to imbue a new sense of style into your spaces. Transforming our prominent warehouse shades into fashionable floor lamps, the Gladstone embraces a familiar look.</p> <p>Fully customizable with various finish colors, cord styles, and stem options, the Gladstone adapts to your personal tastes. This flexible appearance lets the Gladstone adhere to a wide range of sensibilities — ranging from modern to classic! Outfitted with a plug-in socket and an adjustable arm, the Gladstone is the perfect accessory to give any space a spontaneous makeover!</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>Floor lamp features a cast iron weighted bottom to prevent lamp from tipping</li> <li>Includes inline on/off switch</li> <li>Adjustable head swivels to 90 degrees</li> </ul>	We’ve reinterpreted our classic RLM shades as fashionable floor lamps. The resulting look is perfect for modern and classic looks! Fully customizable and USA made!	BLE-L-FL003, The Getty Floor Lamp, The Getty Floor Lamps, Getty Floor Lamps, The Getty Floor Lamps, Getty Floor Lamp, The Getty Lamp, The Getty Lamps, Getty Lamps, Getty RLM Lamp, Getty RLM Lamps, Getty RLM Floor Lamp, Getty RLM Floor Lamps, The Getty RLM Floor Lamp, The Getty RLM Floor Lamps, RLM floor lamp, RLM floor lamps, RLM Lamp, RLM lamps, RLM-style lamp, RLM-style lamps, RLM Style Lamp, RLM Style Lamps, RLM-style floor lamp, RLM-style floor lamps, RLM style floor lamp, RLM style floor lamps, floor lamp, floor lamps, Getty, Getty lamps, warehouse shade lamp, warehouse shade lamps, warehouse shade floor lamps, warehouse shade floor lamp, warehouse shade lamp, warehouse shade lamps, warehouse shade style floor lamp, warehouse shade style floor lamps, warehouse lamp, warehouse lamps, warehouse floor lamp, warehouse floor lamps, floor lamps with shade, floor lamps with shades, lamp shade, lampshade, lampshades, lamp shades, floor lamp shade, floor lamp shades, floor lamps with RLM shade, floor lamps with RLM shades, floor lamp with RLM shade, floor lamp with RLM shades, floor lamp with warehouse shade, floor lamps with warehouse shade, floor lamp with warehouse shades, floor lamps with warehouse shades, floor lamp with shade, floor lamp with shades, lamp with shade, lamp with shades, floor lamp with barn shade, floor lamp with barn shades, lamp with barn shade, lamp with barn shades, lamps, barn lamp, barn lamps, barn floor lamp, barn floor lamps, barn light lamp, barn light lamps, barn lights lamp, barn lights lamps, barn lighting lamp, barn lighting lamps, barn light floor lamp, barn light floor lamps, barn lights floor lamp, barn lights floor lamps, barn lighting floor lamp, barn lighting floor lamps, barn style lamp, barn-style lamp, barn style lamps, barn-style lamps, barn style floor lamp, barn-style floor lamp, barn-style floor lamps, barn style floor lamps, standing lamp, standing lamps, standing floor lamp, standing floor lamps, pharmacy lamp, floor light,
63814	<p>Displaying a unique aesthetic, this floor lamp embraces the charms of RLM shades. The Conoco flaunts a shallow bowl design — a look intended for both contemporary and traditional tastes! Perfect for sudden makeovers, adding floor lamps is an easy way to alter your home’s look without undertaking a major renovation project. For established décors, the Conoco provides the accent pieces needed to take your home’s style to another level!</p> <p>Customizable to your space’s specific requirements, the Conoco is available with various powder coat colors, stem finishes, and cord styles. Imbued with a sense of quality, the Conoco’s weighted base prevents tipping, and provides the lamp with a sturdy foundation. The shade's angle is adjustable up to ninety degrees. Assembled and constructed by hand, the Conoco is a long term feature of 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>Floor lamp features a cast iron weighted bottom to prevent lamp from tipping</li> <li>Includes inline on/off switch</li> <li>Adjustable head swivels to 90 degrees</li> </ul>	Incorporating a flat, shallow bowl shade into its design, the Conoco displays a uniquely fashionable aesthetic. The perfect accessory for any home or apartment!	BLE-L-FL004, The Circle b Floor Lamp, The Circle b Floor Lamps, Circle b Floor Lamps, The Circle b Floor Lamps, Circle b Floor Lamp, The Circle b Lamp, The Circle b Lamps, Circle b Lamps, Circle b RLM Lamp, Circle b RLM Lamps, Circle b RLM Floor Lamp, Circle b RLM Floor Lamps, The Circle b RLM Floor Lamp, The Circle b RLM Floor Lamps, RLM floor lamp, RLM floor lamps, RLM Lamp, RLM lamps, RLM-style lamp, RLM-style lamps, RLM Style Lamp, RLM Style Lamps, RLM-style floor lamp, RLM-style floor lamps, RLM style floor lamp, RLM style floor lamps, floor lamp, floor lamps, Circle b, Circle b lamps, warehouse shade lamp, warehouse shade lamps, warehouse shade floor lamps, warehouse shade floor lamp, warehouse shade lamp, warehouse shade lamps, warehouse shade style floor lamp, warehouse shade style floor lamps, warehouse lamp, warehouse lamps, warehouse floor lamp, warehouse floor lamps, floor lamps with shade, floor lamps with shades, lamp shade, lampshade, lampshades, lamp shades, floor lamp shade, floor lamp shades, floor lamps with RLM shade, floor lamps with RLM shades, floor lamp with RLM shade, floor lamp with RLM shades, floor lamp with warehouse shade, floor lamps with warehouse shade, floor lamp with warehouse shades, floor lamps with warehouse shades, The Circle Floor Lamp, The Circle Floor Lamps, Circle Floor Lamps, The Circle Floor Lamps, Circle Floor Lamp, The Circle Lamp, The Circle Lamps, Circle Lamps, Circle RLM Lamp, Circle RLM Lamps, Circle RLM Floor Lamp, Circle RLM Floor Lamps, The Circle RLM Floor Lamp, The Circle RLM Floor Lamps, Circle, Circle lamps, floor lamp with shade, floor lamp with shades, lamp with shade, lamp with shades, floor lamp with barn shade, floor lamp with barn shades, lamp with barn shade, lamp with barn shades, lamps, barn lamp, barn lamps, barn floor lamp, barn floor lamps, barn light lamp, barn light lamps, barn lights lamp, barn lights lamps, barn lighting lamp, barn lighting lamps, barn light floor lamp, barn light floor lamps, barn lights floor lamp, barn lights floor lamps, barn lighting floor lamp, barn lighting floor lamps, barn style lamp, barn-style lamp, barn style lamps, barn-style lamps, barn style floor lamp, barn-style floor lamp, barn-style floor lamps, barn style floor lamps, standing lamp, standing lamps, standing floor lamp, standing floor lamps, pharmacy lamp, floor light,
63815	<p>It’s typically difficult to make an apartment or rental property your own. Even alterations as minor as painting the walls are disallowed by many leases. Under these restrictive guidelines, décors are often sparsely decorated and don’t always feel like home. Imparting a sense of personality, the Fluted Shade Floor Lamp helps your spaces appear lived-in and welcoming. This floor lamp embraces a festive wavy design, and distinguishes your setting from other units. Adjustable up to ninety degrees, the shade delivers the right touches to your rooms. By employing fashionable accessories, you’re able to show off a style true to your personal tastes and preferences!</p> <p>Home owners additionally find applications for this floor lamp. The various powder coat colors, cord options, and stem finishes let this lamp become truly unique. Bring this stylish accessory to your house or apartment, and make it the highlight of 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>Floor lamp features a cast iron weighted bottom to prevent lamp from tipping</li> <li>Includes inline on/off switch</li> <li>Adjustable head swivels to 90 degrees</li> </ul>	This floor lamp flaunts a festive style and wavy shade! Give your space the perfect decorative features. Customizable with the color, stem finish, and cord of your choice!	BLE-L-FL005, The Fluted shade Floor Lamp, The Fluted shade Floor Lamps, Fluted shade Floor Lamps, The Fluted shade Floor Lamps, Fluted shade Floor Lamp, The Fluted shade Lamp, The Fluted shade Lamps, Fluted shade Lamps, Fluted shade RLM Lamp, Fluted shade RLM Lamps, Fluted shade RLM Floor Lamp, Fluted shade RLM Floor Lamps, The Fluted shade RLM Floor Lamp, The Fluted shade RLM Floor Lamps, RLM floor lamp, RLM floor lamps, RLM Lamp, RLM lamps, RLM-style lamp, RLM-style lamps, RLM Style Lamp, RLM Style Lamps, RLM-style floor lamp, RLM-style floor lamps, RLM style floor lamp, RLM style floor lamps, floor lamp, floor lamps, Fluted shade, Fluted shade lamps, warehouse shade lamp, warehouse shade lamps, warehouse shade floor lamps, warehouse shade floor lamp, warehouse shade lamp, warehouse shade lamps, warehouse shade style floor lamp, warehouse shade style floor lamps, warehouse lamp, warehouse lamps, warehouse floor lamp, warehouse floor lamps, floor lamps with shade, floor lamps with shades, lamp shade, lampshade, lampshades, lamp shades, floor lamp shade, floor lamp shades, floor lamps with RLM shade, floor lamps with RLM shades, floor lamp with RLM shade, floor lamp with RLM shades, floor lamp with warehouse shade, floor lamps with warehouse shade, floor lamp with warehouse shades, floor lamps with warehouse shades, The Fluted Floor Lamp, The Fluted Floor Lamps, Fluted Floor Lamps, The Fluted Floor Lamps, Fluted Floor Lamp, The Fluted Lamp, The Fluted Lamps, Fluted Lamps, Fluted RLM Lamp, Fluted RLM Lamps, Fluted RLM Floor Lamp, Fluted RLM Floor Lamps, The Fluted RLM Floor Lamp, The Fluted RLM Floor Lamps, Fluted shade, Fluted shade lamps, floor lamp with shade, floor lamp with shades, lamp with shade, lamp with shades, floor lamp with barn shade, floor lamp with barn shades, lamp with barn shade, lamp with barn shades, lamps, barn lamp, barn lamps, barn floor lamp, barn floor lamps, barn light lamp, barn light lamps, barn lights lamp, barn lights lamps, barn lighting lamp, barn lighting lamps, barn light floor lamp, barn light floor lamps, barn lights floor lamp, barn lights floor lamps, barn lighting floor lamp, barn lighting floor lamps, barn style lamp, barn-style lamp, barn style lamps, barn-style lamps, barn style floor lamp, barn-style floor lamp, barn-style floor lamps, barn style floor lamps, new lamp, standing lamp, standing lamps, standing floor lamp, standing floor lamps, pharmacy lamp, fluted light, fluted lights, floor light,