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 (64778, 64776, 64777, 65467) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64778,64776,64777,65467) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
64776 <p>Inspired by early 20th century explosion-proof lighting, The Rochester’s industrial design complements the various styles prominent in contemporary décors. This pendant establishes this aesthetic by joining an eye-catching guard to a classic RLM warehouse shade. Thanks to the fixture’s stem mounting, this look can be found in both interior and exterior locations.</p> <p>Attentively hand-crafted, The Rochester demonstrates the ruggedness and quality associated with American made lighting. Starting with commercial grade metal, our team of artisans diligently construct each shade. Because each fixture is made-to-order, you can customize its look with various guard and finish options, including porcelain and powder coat.</p> <p>|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW24703722 BCX0"><span class="NormalTextRun SCXW24703722 BCX0">Hand-built with meticulous attention to detail, this indoor/out</span><span class="NormalTextRun SCXW24703722 BCX0">door<span> </span></span><span class="NormalTextRun SCXW24703722 BCX0">pendant </span><span class="NormalTextRun SCXW24703722 BCX0">is a dependable, long-lasting</span><span class="NormalTextRun SCXW24703722 BCX0"> lighting option.</span></span><span class="EOP SCXW24703722 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="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Learn more about the Rochester Vintage Industrial Stem Mount Pendant Light over on our<span> <a href="/inspiration/professionals-corner-vintage-industrial-theme-sparks-design-for-kid-sanctuary/" target="_blank">blog</a>!</span></li> </ul> Inspired from early 20th century explosion proof lighting, The Rochester Vintage Industrial Pendant includes a customizable stem mount affixed to a classic rounded metal shade. rochester stem mount pendant, the rochester stem mount pendant, stem mount lighting, stem mounted ceiling lights, industrial mounted ceiling lighting, rochester, vintage stem mount light, BLE-S-SI, BLE-S-SI12, BLE-S-SI14, BLE-S-SI16, BLE-S-SI18, rochester, rochester stem, stem rochester, vintage industrial, vintage industrial collection, vintage industrial stem, rochester pendant, new listing, new rochester, new vintage industrial, BLE-S-SI12, BLE-S-SI14, BLE-S-SI16, BLE-S-SI18, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, Industrial stem hung pendant, industrial stem hung pendants, industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling pendant, Industrial stem hung ceiling pendants, Industrial stem hung pendant light, Industrial stem hung pendant lights, Industrial stem hung pendant lighting, Industrial stem hung ceiling light, Industrial stem hung ceiling lights, Industrial stem hung ceiling lighting, Industrial stem pendant, industrial stem pendants, industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling pendant, Industrial stem ceiling pendants, Industrial stem pendant light, Industrial stem pendant lights, Industrial stem pendant lighting, Industrial stem ceiling light, Industrial stem ceiling lights, Industrial stem ceiling lighting, rugged stem hung pendant, rugged stem hung pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling pendant, rugged stem hung ceiling pendants, rugged stem hung pendant light, rugged stem hung pendant lights, rugged stem hung pendant lighting, rugged stem hung ceiling light, rugged stem hung ceiling lights, rugged stem hung ceiling lighting, rugged stem pendant, rugged stem pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling pendant, rugged stem ceiling pendants, rugged stem pendant light, rugged stem pendant lights, rugged stem pendant lighting, rugged stem ceiling light, rugged stem ceiling lights, rugged stem ceiling lighting, cast guard stem hung pendant, cast guard stem hung pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling pendant, cast guard stem hung ceiling pendants, cast guard stem hung pendant light, cast guard stem hung pendant lights, cast guard stem hung pendant lighting, cast guard stem hung ceiling light, cast guard stem hung ceiling lights, cast guard stem hung ceiling lighting, cast guard stem pendant, cast guard stem pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling pendant, cast guard stem ceiling pendants, cast guard stem pendant light, cast guard stem pendant lights, cast guard stem pendant lighting, cast guard stem ceiling light, cast guard stem ceiling lights, cast guard stem ceiling lighting, industrial pendant, industrial pendants, industrial ceiling pendant, industrial ceiling pendants, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, rugged pendant, rugged pendants, rugged ceiling pendant, rugged ceiling pendants, rugged ceiling light, rugged ceiling lights, rugged ceiling lighting, cast guard pendant, cast guard pendants, cast guard ceiling pendant, cast guard ceiling pendants, cast guard ceiling light, cast guard ceiling lights, cast guard ceiling lighting, SPS-0277, SPS0277, SPS 0277, vintage industrial collection, vintage industrial series, the vintage industrial collection, the vintage industrial series, metropolis collection, metropolis series, the metropolis collection, the metropolis series, metropolitan collection, metropolitan series, the metropolitan collection, the metropolitan series, Rochester collection, Rochester Series, The Rochester collection, the Rochester Series, 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, jadeite, jadite, jadeite light, jadite light,
64777 <p>Embracing influences from early 20th century fixtures, The Rochester combines a classic RLM warehouse shade and rugged guard with a cord and chain mounting. This vintage industrial design offers a timeless aesthetic, one that complements traditional and contemporary styles equally. As a decorative addition in residential or commercial décors, this pendant functions as either an eye-catching focal point or subtle accent piece.</p> <p>Handcrafted from high-quality materials, The Rochester is among the most durable and dependable lighting options. Available in multiple shade sizes and with dozens of porcelain and powder coat finishes, this chain hung pendant is easily customized.</p> <p>|break|</p> <ul> <li>This chain mount pendant features a handcrafted, American made RLM warehouse shade.</li> <li>Made-to-order. Learn more about the process <a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> <br /><br /> Our fully customizable chain hung pendant light is styled from fixtures commonly found in warehouses and factories! Indoor and damp location rated. the rochester chain hung pendant, rochester chain hung pendant, rochester light, chain hung pendant light, chain hung lighting, deep bowl lighting, vintage pendants, factory lighting, BLE-C-SI-CN36, BLE-C-SI12-CN36, BLE-C-SI14-CN36, BLE-C-SI16-CN36, BLE-C-SI18-CN36, rochester, vintage industrial, vintage industrial collection, rochester chain, new listing, new rochester, new vintage industrial, BLE-CN-SI12, BLE-CN-SI14, BLE-CN-SI16, BLE-CN-SI18, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, Industrial chain hung pendant, industrial chain hung pendants, industrial chain hung pendant light, Industrial chain hung pendant lights, Industrial chain hung pendant lighting, Industrial chain hung ceiling pendant, Industrial chain hung ceiling pendants, Industrial chain hung pendant light, Industrial chain hung pendant lights, Industrial chain hung pendant lighting, Industrial chain hung ceiling light, Industrial chain hung ceiling lights, Industrial chain hung ceiling lighting, Industrial chain pendant, industrial chain pendants, industrial chain pendant light, Industrial chain pendant lights, Industrial chain pendant lighting, Industrial chain ceiling pendant, Industrial chain ceiling pendants, Industrial chain pendant light, Industrial chain pendant lights, Industrial chain pendant lighting, Industrial chain ceiling light, Industrial chain ceiling lights, Industrial chain ceiling lighting, rugged chain hung pendant, rugged chain hung pendants, rugged chain hung pendant light, rugged chain hung pendant lights, rugged chain hung pendant lighting, rugged chain hung ceiling pendant, rugged chain hung ceiling pendants, rugged chain hung pendant light, rugged chain hung pendant lights, rugged chain hung pendant lighting, rugged chain hung ceiling light, rugged chain hung ceiling lights, rugged chain hung ceiling lighting, rugged chain pendant, rugged chain pendants, rugged chain pendant light, rugged chain pendant lights, rugged chain pendant lighting, rugged chain ceiling pendant, rugged chain ceiling pendants, rugged chain pendant light, rugged chain pendant lights, rugged chain pendant lighting, rugged chain ceiling light, rugged chain ceiling lights, rugged chain ceiling lighting, cast guard chain hung pendant, cast guard chain hung pendants, cast guard chain hung pendant light, cast guard chain hung pendant lights, cast guard chain hung pendant lighting, cast guard chain hung ceiling pendant, cast guard chain hung ceiling pendants, cast guard chain hung pendant light, cast guard chain hung pendant lights, cast guard chain hung pendant lighting, cast guard chain hung ceiling light, cast guard chain hung ceiling lights, cast guard chain hung ceiling lighting, cast guard chain pendant, cast guard chain pendants, cast guard chain pendant light, cast guard chain pendant lights, cast guard chain pendant lighting, cast guard chain ceiling pendant, cast guard chain ceiling pendants, cast guard chain pendant light, cast guard chain pendant lights, cast guard chain pendant lighting, cast guard chain ceiling light, cast guard chain ceiling lights, cast guard chain ceiling lighting, industrial pendant, industrial pendants, industrial ceiling pendant, industrial ceiling pendants, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, rugged pendant, rugged pendants, rugged ceiling pendant, rugged ceiling pendants, rugged ceiling light, rugged ceiling lights, rugged ceiling lighting, cast guard pendant, cast guard pendants, cast guard ceiling pendant, cast guard ceiling pendants, cast guard ceiling light, cast guard ceiling lights, cast guard ceiling lighting, SPS-0277, SPS0277, SPS 0277, vintage industrial collection, vintage industrial series, the vintage industrial collection, the vintage industrial series, metropolis collection, metropolis series, the metropolis collection, the metropolis series, metropolitan collection, metropolitan series, the metropolitan collection, the metropolitan series, Rochester collection, Rochester Series, The Rochester collection, the Rochester Series, jadeite, jadite, jadeite light, jadite light,
64778 <p>The Rochester can trace its roots back to the early 20th century when RLM shades first illuminated warehouses and factories. To pay homage to those original fixtures, the Rochester joins a rugged guard to a traditional shade, creating an authentic industrial design. As either an accent piece or focal point, The Rochester feels at home in many of today’s most popular styles, including trendy modern décors and more classically decorated settings.</p> <p>Easily customized with various cords, guards, and finishes, The Rochester can feature the perfect look for your space. Thanks to commercial-grade materials and a meticulous manufacturing process, this pendant light offers the high quality expected from American made fixtures.</p> <p>|break|</p> <ul> <li>Hand-built with an American made RLM warehouse shade, this quality industrial pendant is a lasting cord hung option.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li>Read more about the Rochester Vintage Industrial Cord Hung Pendant Light over on our<span> <a href="/inspiration/industrial-barn-lights-satisfy-both-form-and-function-in-garage-studio/" target="_blank">blog</a>!</span></li> </ul> A completely customizable vintage-inspired pendant light! Select from various finishes, cord types and guards to make The Rochester fit your space! the rochester cord hung pendant light, rochester cord hung pendant light, kitchen lighting, cord hung pendant lights, cord hung lighting, island lighting, corded lighting, BLE-C-SI, BLE-C-SI12, BLE-C-SI14, BLE-C-SI16, BLE-C-SI18, rochester, vintage industrial, vintage industrial collection, rochester vintage, rochester pendant, new listing, new vintage industrial, new rochester, Industrial light, industrial lights, industrial lighting, industrial lighting fixture, industrial lighting fixtures, rugged light, rugged lights, rugged lighting, rugged lighting fixture, rugged lighting fixtures, Vintage Industrial light, vintage industrial lights, vintage industrial lighting, vintage industrial lighting fixture, vintage industrial lighting fixtures, cast guard light, cast guard lights, cast guard lighting, cast guard lighting fixture, cast guard lighting fixtures, metropolis, metropolis collection, metropolis light, metropolis lights, metropolis lighting, Industrial cord hung pendant, industrial cord hung pendants, industrial cord hung pendant light, Industrial cord hung pendant lights, Industrial cord hung pendant lighting, Industrial cord hung ceiling pendant, Industrial cord hung ceiling pendants, Industrial cord hung pendant light, Industrial cord hung pendant lights, Industrial cord hung pendant lighting, Industrial cord hung ceiling light, Industrial cord hung ceiling lights, Industrial cord hung ceiling lighting, Industrial cord pendant, industrial cord pendants, industrial cord pendant light, Industrial cord pendant lights, Industrial cord pendant lighting, Industrial cord ceiling pendant, Industrial cord ceiling pendants, Industrial cord pendant light, Industrial cord pendant lights, Industrial cord pendant lighting, Industrial cord ceiling light, Industrial cord ceiling lights, Industrial cord ceiling lighting, rugged cord hung pendant, rugged cord hung pendants, rugged cord hung pendant light, rugged cord hung pendant lights, rugged cord hung pendant lighting, rugged cord hung ceiling pendant, rugged cord hung ceiling pendants, rugged cord hung pendant light, rugged cord hung pendant lights, rugged cord hung pendant lighting, rugged cord hung ceiling light, rugged cord hung ceiling lights, rugged cord hung ceiling lighting, rugged cord pendant, rugged cord pendants, rugged cord pendant light, rugged cord pendant lights, rugged cord pendant lighting, rugged cord ceiling pendant, rugged cord ceiling pendants, rugged cord pendant light, rugged cord pendant lights, rugged cord pendant lighting, rugged cord ceiling light, rugged cord ceiling lights, rugged cord ceiling lighting, cast guard cord hung pendant, cast guard cord hung pendants, cast guard cord hung pendant light, cast guard cord hung pendant lights, cast guard cord hung pendant lighting, cast guard cord hung ceiling pendant, cast guard cord hung ceiling pendants, cast guard cord hung pendant light, cast guard cord hung pendant lights, cast guard cord hung pendant lighting, cast guard cord hung ceiling light, cast guard cord hung ceiling lights, cast guard cord hung ceiling lighting, cast guard cord pendant, cast guard cord pendants, cast guard cord pendant light, cast guard cord pendant lights, cast guard cord pendant lighting, cast guard cord ceiling pendant, cast guard cord ceiling pendants, cast guard cord pendant light, cast guard cord pendant lights, cast guard cord pendant lighting, cast guard cord ceiling light, cast guard cord ceiling lights, cast guard cord ceiling lighting, industrial pendant, industrial pendants, industrial ceiling pendant, industrial ceiling pendants, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, rugged pendant, rugged pendants, rugged ceiling pendant, rugged ceiling pendants, rugged ceiling light, rugged ceiling lights, rugged ceiling lighting, cast guard pendant, cast guard pendants, cast guard ceiling pendant, cast guard ceiling pendants, cast guard ceiling light, cast guard ceiling lights, cast guard ceiling lighting, SPS-0277, SPS0277, SPS 0277, vintage industrial collection, vintage industrial series, the vintage industrial collection, the vintage industrial series, metropolis collection, metropolis series, the metropolis collection, the metropolis series, metropolitan collection, metropolitan series, the metropolitan collection, the metropolitan series, Rochester collection, Rochester Series, The Rochester collection, the Rochester Series, white pendant, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, jadeite, jadite, jadeite light, jadite light,
65467 <p>With its rugged profile and compact flush mounting, the Rochester adapts to today’s most prominent styles. This versatile look is accomplished through a handcrafted metal shade and guard. An elevated industrial design, the Rochester equally suits contemporary décors and traditional settings, helping every space feel stylish and illuminated. <br /><br />The Rochester’s shade starts as a flat piece of metal. Our team of talented artisans shapes the metal by hand as it spins on a high-speed lathe. This meticulous process ensures a level of durability not found in other lighting options.</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial pendant is a lasting stem mount option.<span> </span></li> <li>Made-to-order. Learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> A classic lighting style with a space-saving flush mounting! Handcrafted and fully customizable, put the finishing touches on your decor with the Rochester! BLE-F-SI, Rochester Flush Mount Light, Rochester Flush Mount, Rochester Flush Mount Pendant, Rochester Pendant, Rochester Pendant Light, Rochester ceiling light, Rochester flush mount ceiling pendant, Rochester flush, Flush Rochester, The Rochester Flush Mount Light, The Rochester Flush Mount, The Rochester Flush Mount Pendant, The Rochester Pendant, The Rochester Pendant Light, The Rochester ceiling light, The Rochester flush mount ceiling pendant, The Rochester flush, Flush Mount, Flush Mount Light, Flush Mount Pendant, Flush Mount Ceiling Pendant, Rochester Vintage Industrial Flush Mount Light, Rochester Vintage Industrial Flush Mount, Rochester Industrial Flush Mount Light, Rochester Industrial Flush Mount, Rochester Vintage Flush Mount Light, Rochester Vintage Flush Mount, Vintage Industrial Flush Mount Light, Vintage Industrial Flush Mount, Industrial flush mount, industrial flush mount light, metropolitan,