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 (64713) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
64713 <p>Complete with the same styling as our larger gooseneck lights, this compact industrial wall sconce is designed to fit into any home or business. The Bowie Wall Sconce is available in two shade sizes, and is able to be installed in tight areas like closets or hallways. However, the size of this wall lighting does not impact its durability. As industrial lighting, the Bowie Wall Sconce is manufactured with quality materials in the United States. This industrial wall sconce is also wet rated, making it the perfect addition to front porches and patios.</p> <p>Customize your wall sconce with one of a dozen finish colors, ranging from traditional to vibrant.</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A. </li> <li><span>Made-to-order, learn more about the process </span><a href="/behind-the-scenes-video-footage" target="_blank">here</a>.</li> <li>Please Note: If a raw copper, weathered copper, oil-rubbed copper and/or weathered brass finish is selected for this wall sconce, product will include black accessories. If a raw brass finish is selected, accessories will be raw brass. Please see product images for further reference.</li> <li>Read more about our Bowie Wall Sconce over on our <a href="/inspiration/before-after-vintage-inspired-lights-help-transform-victorian-home/" target="_blank">blog</a>!</li> </ul> galvanized wall sconce, american made barn lighting, small wall sconce sconce, warehouse sconce, mini porch light, mini shade vanity light, small wall light, small barn wall sconce, plug-in sconces Our rustic outdoor barn light sconce, the Bowie Sconce, packs a punch with its compact style and custom finishes that are bound to complement your home! Bowie, small sconce, wall sconce, bowie wall sconce, wall light, bathroom, vanity, bedroom, galvanized wall sconce, american made barn lighting, small wall sconce sconce, warehouse sconce, mini porch light, mini shade vanity light, small wall light, small barn wall sconce, mini, mini sconce, mini shade, BLE-W-WHBO6-PC, BLE-W-WHBO8-PC, porch light, porch sconce, wall sconce porch light, bowie porch light, bowie lighting, warehouse shade, warehouse lighting, industrial wall sconce, bowie industrial wall sconce, bathroom lighting, bathroom wall sconce, bathroom wall light, 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, BLE-W-WHB06, BLE-W-WHB08, bowie sconce, bowie sconces, bowie wall light, bowie wall lights, bowie wall lighting, SPS-0004, SPS 0004, SPS0004, bowie copper wall sconce, bowie copper wall sconces, bowie copper sconce, bowie copper sconces, Pink sconce, Pink sconces, Pink wall sconce, Pink wall sconces, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, 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, Mini Bowie wall sconce, Mini Bowie sconces, Mini bowie, The Bowie wall sconce, The Bowie wall sconces, Copper Outdoor light, Copper Shade, copper outdoor, Copper barn lights, Copper outdoor lights, copper outdoor lighting, Outdoor copper, exterior copper, Copper exterior light, Outdoor copper light, copper exterior lights, Copper exterior lighting, Copper exterior barn light, copper exterior, small sconces, mini outdoor sconce,