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 (
    63755, 62252, 62253, 62254, 64941, 64942, 
    64943, 64815, 65519
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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": 9,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (63755,62252,62253,62254,64941,64942,64943,64815,65519) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
62252 <p>Love your light fixture but have broken glass? Replace your vapor proof glass jar with our replacement jelly jar in clear glass!</p> <p>|break|</p> <ul> <li>Dimensions: 3" W x 7" L</li> <li>Please Note: Light fixtures from other manufacturers may require different threading than our replacement glass.</li> <li>IMPORTANT: This glass is <span style="text-decoration: underline;">NOT</span> to be used with halogen lights or placed in a completely unprotected environment.</li> </ul> replacement glass, jelly jar replacement, vapor proof light parts, clear glass jelly jar Replace your broken vapor proof glass jar with our replacement jelly jar in clear glass. Receive free shipping with your replacement glass jar. replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Clear Jelly Jar Glass, BLE-CGG-GLASS-CLR, clear glass replacement, replacement clear jelly jar
62253 <p>Replace your broken vapor proof glass jar with a new frosted jelly jar glass. This frosted jelly jar will give your light a soft glow! </p> <p>|break|</p> <ul> <li>Dimensions: 3" W x 7" L</li> <li>Please Note: Light fixtures from other manufacturers may require different threading than our replacement glass.</li> <li>IMPORTANT: This glass is <span style="text-decoration: underline;">NOT</span> to be used with halogen lights or placed in a completely unprotected environment.</li> </ul> replacement jelly jar, cast guard and glass parts, jelly jar with frosted glass, industrial light parts Shop for replacement frosted glass jelly jars from our selection of threaded glass! replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Frosted Jelly Jar Glass, replacement frosted jelly jar, BLE-CGG-GLASS-FST
62254 <p>Got a broken jelly jar glass or just want to change up your look without changing the entire fixture? Choose the Ribbed Jelly Jar Glass to give your light a special glow!</p> <p>|break|</p> <ul> <li>Dimensions: 3" W x 7" L</li> <li>Please Note: Light fixtures from other manufacturers may require different threading than our replacement glass.</li> <li>IMPORTANT: This glass is <span style="text-decoration: underline;">NOT</span> to be used with halogen lights or placed in a completely unprotected environment.</li> </ul> holophane jelly jar replacement, jelly jar glass replacement, cast guard and glass light parts Find a replacement for your broken jelly jar from our selection of threaded jars and accessories, or change the jelly jar you currently have to achieve a new look! replacement glass, light parts, jelly jar, individual jelly jar, replacement jelly jar, replacement jar, vapor jar replacement, individual vapor jar, Ribbed Jelly Jar Glass, replacement Ribbed Jelly Jar Glass, BLE-CGG-GLASS-RIB, ribbed, ribbed glass, ribbed glass guard, ribbed glass guards, rib glass,
63755 <p>We understand that accidents happen, and at some point you may need to replace a broken schoolhouse shade. That’s why we offer these replacement clear globes with hand-painted, colorful stripes. This allows your home or business to maintain its fashionable aesthetic when trading out damaged globes for a brand new one.</p> <p>These shades aren’t only useful for replacing broken shades. If you adopt a new color scheme while renovating your space, you can simply swap out the old shade for one with a new coordinating color instead of installing a new fixture!</p> <p>|break|</p> <ul> <li>Customizable with colorful painted bands. </li> <li><span>White painted band(s) not recommended if Opaque Glass is selected, as it blends into the glass.</span></li> <li><span>Please Note: <span>The single band style has a silver border outlining the chosen finish.</span></span></li> <li>If using with a non-Barn Light Electric fixture, this glass will require a fitter at least 6" wide and ¾" long screws.</li> </ul> Swap out broken or damaged schoolhouse shades with these fashionable replacements. Customize these glass globes with hand-painted stripes! BLE-SCH-GLASS, Opaque Schoolhouse Glass, Opaque Schoolhouse Glass Shade, Opaque Schoolhouse Glass shades, schoolhouse glass shade, schoolhouse glass shades, schoolhouse shade, schoolhouse shades, replacement, replacement shade, replacement shades, replacement glass shade, replacement glass shades, replacement schoolhouse, replacement schoolhouse shade, replacement schoolhouse shades, school house, schoolhouse, school house shade, school house shades, replacement school house shade, replacement school house shades, schoolhouse globe, schoolhouse globes, school house globe, school house globes, replacement school house globe, replacement school house globes, replacement opaque shade, replacement opaque shades, replacement Opaque Schoolhouse Glass, replacement Opaque Schoolhouse Glass shade, replacement Opaque Schoolhouse Glass shades, replacement glass, replacement globes, striped schoolhouse, striped schoolhouse light,
64815 <p>This glass jelly jar emits light with a green tint, completely transforming a fixture’s appearance and purpose. Performing both decorative and functional applications, this glass guard can become an integral addition to a business’s décor.</p> <p>|break|</p> <ul> <li>Dimensions: 3" W x 7" L</li> <li>Please Note: Light fixtures from other manufacturers may require different threading than our replacement glass.</li> <li>IMPORTANT: This glass is <span style="text-decoration: underline;">NOT</span> to be used with halogen lights or placed in a completely unprotected environment.</li> </ul> A favorite for practical and decorative applications in commercial settings, this green glass guard gives our fixtures a new purpose! Green Jelly Jar Glass, Green Glass, Green Jelly Jar, replacement green glass, replacement jelly jar, replacement glass, green replacement glass, green replacement glass guard, green glass guard, glass guard, jelly jar, jelly jars, glass guards, BLE-CGG-GLASS-GRN, colored glass, colored glass jelly jar, colored jelly jar,
64941 <p>Broken light fixture? Or just want to upgrade your old schoolhouse shade with a new look? Try one of our replacement globes available in both clear and opaque glass. You can customize this stylish, acorn-shaped glass with hand-painted bands of color in several patterns. </p> <p>Schoolhouse shades bring vintage style to any room and the addition of the colored bands gives these fixtures an updated look. Bring a whole new vibe to your space with a brand new schoolhouse shade!</p> <p>|break|</p> <ul> <li>Customizable with colorful painted bands. </li> <li><span>White painted band(s) not recommended if Opaque Glass is selected, as it blends into the glass.</span></li> <li><span>Please Note: <span>The single band style has a silver border outlining the chosen finish.</span></span></li> <li>If using with a non-Barn Light Electric fixture, this glass will require a fitter at least 6" wide and ¾" long screws.</li> <li>Dimensions: W 11.5" x H 10.9"</li> </ul> A replacement acorn schoolhouse glass shade for your favorite Barn Light Electric fixtures! Customize the glass with hand-painted bands for a unique look! Acorn Schoolhouse Glass, Replacement Acorn Schoolhouse Glass, Acorn Glass, Replacement Acorn Glass, Schoolhouse Acorn Glass, Replacement schoolhouse, replacement schoolhouse glass, Acorn School house Glass, Replacement Acorn School house Glass, School house Acorn Glass, replacement school house glass, Acorn Schoolhouse Globe, Replacement Acorn Schoolhouse Globe, Acorn Globe, Replacement Acorn Globe, Schoolhouse Acorn Globe, replacement schoolhouse globe, Acorn School house Globe, Replacement Acorn School house Globe, School house Acorn Globe, replacement school house globe, Acorn Schoolhouse Shade, Replacement Acorn Schoolhouse Shade, Acorn Shade, Replacement Acorn Shade, Schoolhouse Acorn Shade, replacement schoolhouse shade, Acorn School house Shade, Replacement Acorn School house Shade, School house Acorn Shade, replacement school house shade, acorn, BLE-ACN-GLASS, replacement globes, striped schoolhouse, striped schoolhouse light,
64942 <p>Broken light fixture? Or just want to upgrade your old schoolhouse shade with a new look? Try one of our replacement 10" glass globes available in both clear and opaque glass. You can customize this round globe with hand-painted bands of color in several patterns. </p> <p>Schoolhouse shades bring vintage style to any room and the addition of the colored bands gives these fixtures an updated look. Bring a whole new vibe to your space with a brand new schoolhouse shade!</p> <p>|break|</p> <ul> <li>Customizable with colorful painted bands. </li> <li><span>White painted band(s) not recommended if Opaque Glass is selected, as it blends into the glass.</span></li> <li><span>Please Note: <span>The single band style has a silver border outlining the chosen finish.</span></span></li> <li>If using with a non-Barn Light Electric fixture, this glass will require a fitter at least 6" wide and ¾" long screws.</li> </ul> This replacement round schoolhouse glass is available in multiple sizes and with hand-painted bands in various colors! BLE-RND-GLASS, Round Schoolhouse Glass, Replacement Round Schoolhouse Glass, Round Glass, Replacement Round Glass, Schoolhouse Round Glass, Replacement schoolhouse, replacement schoolhouse glass, Round School house Glass, Replacement Round School house Glass, School house Round Glass, replacement school house glass, Round Schoolhouse Globe, Replacement Round Schoolhouse Globe, Round Globe, Replacement Round Globe, Schoolhouse Round Globe, replacement schoolhouse globe, Round School house Globe, Replacement Round School house Globe, School house Round Globe, replacement school house globe, Round Schoolhouse Shade, Replacement Round Schoolhouse Shade, Round Shade, Replacement Round Shade, Schoolhouse Round Shade, replacement schoolhouse shade, Round School house Shade, Replacement Round School house Shade, School house Round Shade, replacement school house shade, round, replacement globes, striped schoolhouse, striped schoolhouse light,
64943 <p>Broken light fixture? Or just want to upgrade your old schoolhouse shade with a new look? Try one of our replacement globes available in both clear and opaque glass. You can customize this drum-shaped glass with hand-painted bands of color in several patterns. </p> <p>Schoolhouse shades bring vintage style to any room and the addition of the colored bands gives these fixtures an updated look. Bring a whole new vibe to your space with a brand new schoolhouse shade!</p> <p>|break|</p> <ul> <li>Customizable with colorful painted bands. </li> <li><span>White painted band(s) not recommended if Opaque Glass is selected, as it blends into the glass.</span></li> <li><span>Please Note: <span>The single band style has a silver border outlining the chosen finish.</span></span></li> <li>If using with a non-Barn Light Electric fixture, this glass will require a fitter at least 6" wide and ¾" long screws.</li> <li>Dimensions: W 11.7" x H 10.3" </li> </ul> Fully customizable with hand-painted bands in several colors and two glass options, replace broken shade with this drum schoolhouse glass! BLE-DRM-GLASS, Drum Schoolhouse Glass, Replacement Drum Schoolhouse Glass, Drum Glass, Replacement Drum Glass, Schoolhouse Drum Glass, Replacement schoolhouse, replacement schoolhouse glass, Drum School house Glass, Replacement Drum School house Glass, School house Drum Glass, replacement school house glass, Drum Schoolhouse Globe, Replacement Drum Schoolhouse Globe, Drum Globe, Replacement Drum Globe, Schoolhouse Drum Globe, replacement schoolhouse globe, Drum School house Globe, Replacement Drum School house Globe, School house Drum Globe, replacement school house globe, Drum Schoolhouse Shade, Replacement Drum Schoolhouse Shade, Drum Shade, Replacement Drum Shade, Schoolhouse Drum Shade, replacement schoolhouse shade, Drum School house Shade, Replacement Drum School house Shade, School house Drum Shade, replacement school house shade, drum, replacement globes, striped schoolhouse,
65519 <p><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">Swapping out damaged glass in our Glass Ball Pendants has never been<span> </span></span></span><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">simpler</span></span><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW45342300 BCX0"><span class="NormalTextRun SCXW45342300 BCX0">, thanks to these replacement globes. We’ve made all three sizes and both opaque and clear shades available, that way you can easily recreate your pendant’s initial style.</span></span><span class="EOP SCXW45342300 BCX0" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}"> </span></p> Change out broken glass shades with these stylish replacements! Available in three sizes and opaque and clear! BLE-GLB-GLASS, replacement glass ball, replacement glass ball shade, replacement glass ball shades, replacement ball, replacement ball shade, replacement ball shades, replacement glass shade, replacement glass shades, Glass ball shade, glass ball shades, ball shade, ball shades, replacement globes, bubble glass, glb, glbcl,