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

Query time 0.00056

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64774,65674) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
64774 <p>Discovering inspiration in vintage designs, the Elliptical sign light features a tapered cone shade and iconic gooseneck arm. Angle shade lighting casts light onto commercial signs and awnings, resulting in a brighter, more inviting storefront. In interior applications, the Elliptical can illuminate murals, menu boards, and the artwork or photos hanging on walls.<br /> <br />Available in four sizes and with an abundance of colorful powder coat finishes, our sign lighting can become truly your own. Bring a functional style to any commercial lighting plan with the Elliptical!</p> <p>|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW101993154 BCX0"><span class="NormalTextRun SCXW101993154 BCX0">Meticulously handcrafted from</span><span class="NormalTextRun SCXW101993154 BCX0"><span> </span>high-quality, commercial-grade materials for a dependable</span><span class="NormalTextRun SCXW101993154 BCX0"><span> </span>indoor/outdoor wall light option.</span></span><span class="EOP SCXW101993154 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li>Learn more about the Elliptical Sign Light over on our<span> <a href="/inspiration/featured-customer-barn-lights-give-nod-to-past-at-historic-hotel/" target="_blank">blog</a>!</span></li> </ul> clamshell sign light, sign lighting, elongated shade sign light, deep cone sign light, vintage angle shades, galvanized sign lights, american made sign light, gooseneck light, retail lighting, light fixtures for retail, commercial gooseneck lighting, clam Inspired by vintage designs, our Elliptical Sign Light features a tapered cone shade that's perfect for commercial lighting applications! Customizable and USA-made! Elliptical Sign Light, BLE-G-ASEL-PC, elliptical, clamshell sign lights, angle shade, sign light, elongated shade sign light, 10ELA, BLE-G-ASL9-PC, BLE-G-ASL11-PC, BLE-G-ASL13-PC, BLE-G-ASL15-PC, Elliptical sign lighting, elliptical angle shade, angle shade sign lighting, angle shade lighting, angle shade gooseneck lighting, angle shade lighting, angle shade gooseneck lighting, angle shade gooseneck, elliptical angle shade sign lighting, elliptical angle shade lighting, elliptical angle shade lighting, elliptical gooseneck light, elliptical gooseneck lighting, new listing, new rlm, new elliptical, Gooseneck sign light, gooseneck sign lights, gooseneck sign lighting, goose neck sign light, goose neck sight lights, goose neck sign lighting, gooseneck angle shade, goose neck angle shade, gooseneck angle shades, goose neck angle shades, gooseneck sign, sign gooseneck, BLE-G-ASL9, BLE-G-ASL11, BLE-G-ASL13, BLE-G-ASL15, RLM sign light, rlm sign lights, rlm sign lighting, elliptical collection, elliptical series, the elliptical collection, the elliptical series, SPS-0082, SPS 0082, SPS0082, Angle shade, angle shades, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, outdoor wall mount light, outdoor wall mount lights, outdoor wall mount 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, picture light,
65674 <p><span>Inspired by classic vintage designs, the Elliptical Stem Mount Pendant features a tapered cone shade and sturdy stem mounting. The angled shade is crafted to cast light onto commercial signs and awnings resulting in a brighter, more inviting storefront. In interior applications, this American-made pendant can illuminate murals, menu boards, and artwork or photos hanging on walls.</span><br /><span> </span><br /><span>Available in a variety of sizes and a rainbow of brilliant powder coat finishes, the Elliptical Stem Mount Pendant can be easily customized to reflect your style and branding scheme. Bring this functional, handcrafted beauty to your commercial lighting plan!</span></p> <p class="title">|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW67911049 BCX0"><span class="NormalTextRun SCXW67911049 BCX0">Hand-built with meticulous attention to detail, this indoor/out</span><span class="NormalTextRun SCXW67911049 BCX0">door<span> </span></span><span class="NormalTextRun SCXW67911049 BCX0">pendant </span><span class="NormalTextRun SCXW67911049 BCX0">is a dependable, long-lasting</span><span class="NormalTextRun SCXW67911049 BCX0"> lighting option.</span></span><span class="EOP SCXW67911049 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> </ul> BLE-S-ASL8-PC, BLE-S-ASL10-PC, BLE-S-ASL12-PC, BLE-S-ASL14-PC, BLE-S-ASL, BLE-S-ASL-PC, Stem Elliptical, Stem Mount Elliptical, Elliptical Stem Mount, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, Elliptical Stem Mount Pendant, Elliptical Stem Mount Pendants, warehouse lighting, pendant lighting, pendant lights, new rlm, new stem, elliptical series, elliptical collection, elliptical series, elliptical collection, Pendent outdoor, pendant outdoor, Pendant light outdoor, pendant shade, pendant wet, pendent wet, pendant hanging lights, outdoor hanging pendant, outdoor hanging light, Outdoor ceiling mount, outside barn light, outside barn lights, outside barn lighting, outdoor barn light, outdoor barn lights, outdoor barn lighting, outdoor lighting fixture, outdoor lighting fixtures, elliptical stem/flush, elliptical stem pendant, elliptical stem light, elliptical stem mount, elliptical stem/flush, elliptical stem pendant, elliptical stem light, stems, Stem pendant lights, stem light mount, stem light mounts, stem, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, exterior ceiling mount light, exterior ceiling mount lights, exterior ceiling mount lighting, exterior ceiling mount light fixture, exterior ceiling mount light fixtures, exterior ceiling mount lighting fixture, exterior ceiling mount lighting fixtures, exterior ceiling mount, exterior ceiling mounts, exterior ceiling mount fixture, exterior ceiling mount fixtures, Ceiling mount exterior light, Ceiling mount exterior lights, Ceiling mount exterior lighting, Ceiling mount exterior light fixture, Ceiling mount exterior light fixtures, Ceiling mount exterior lighting fixture, Ceiling mount exterior lighting fixtures, Warehouse pendent, Warehouse pendents, Ware house pendent, Ware house pendents, Warehouse pendent light, Warehouse pendent lights, Warehouse pendent lighting, Ware house pendent light, Ware house pendent lights, Ware house pendent lighting, Warehouse ceiling pendent, Warehouse ceiling pendents, Ware house ceiling pendent, Ware house ceiling pendents, pendent light, pendent lights, pendent lighting, pendent, ceiling pendent, ceiling pendents, outdoor pendent, outdoor pendents, outdoor pendent light, outdoor pendent lights, outdoor pendent lighting, outdoor ceiling pendent, outdoor ceiling pendents, jadeite, jadite, jadeite light, jadite light, sign light stem, stem sign light, sign light stem mount, stem mount sign light,