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 (
    63377, 63378, 63376, 63383, 63379, 63380
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (63377,63378,63376,63383,63379,63380) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
63376 <p>A striking yet playful statement piece, the Seaside is popular in both residential and commercial lighting plans. This festive character is due to its fluted shade. Naturally complementing nautical styles, this post mount light is an ideal fixture for docks and waterfront properties. However, its eye-catching profile also helps parking lots and seating areas feel unique, illuminated, and stylish.</p> <p>Outfitted with cutting-edge technology, the Seaside represents the ideal balance between practicality and style. Efficiently producing lighting, integrated LED fixtures require less electricity to brighten outdoor locations — saving money and helping the environment!</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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> </ul> Defined by its festive shade and rustic guard, the Seaside becomes the highlight of any décor! Now integrating LED modules, the Seaside saves money and energy! The Radial Wave LED Industrial Guard Post Mount, Radial Wave LED Industrial Guard Post Mount, Radial Wave LED Industrial Post Mount, The Radial Wave LED Industrial Post Mount, The Radial Wave LED Guard Post Mount, Radial Wave LED Guard Post Mount, The Radial Wave LED Post Mount, Radial Wave LED Post Mount, Radial Wave LED post mounts, radial wave led post mount light, radial wave led post mount lights, radial wave led post mount lighting, radial wave post mount, radial wave post mounts, radial wave post mount light, radial wave post mount lights, radial wave post mount lighting, led post mount, led post mounds, led post mount lights, led post mount lighting, led post mount light, post mount led, post mount leds, post mount led light, post mount led lights, post mount led lighting, BLE-PMS-TGG-RWS-LED, Seaside LED Industrial Guard Post Mount Light, Seaside LED Industrial Guard Post Mount, Seaside LED Industrial Guard Post Mounts, Seaside Industrial Guard Post Mount Light, Seaside Industrial Guard Post Mount, Seaside LED Post Mount Light, Seaside LED Post Mount, industrial guard post mount, industrial guard LED post mount, led industrial guard post mount, seaside, sea side, sea, BLE-PMS-TGG-RWS12, BLE-PMS-TGG-RWS14, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, SPS-0456, SPS 0456, SPS0456, seaside led series, seaside led collection, sea side led series, sea side led collection, the seaside led series, the seaside led collection, the sea side led series, the sea side led collection, Lampposts, Lamppost, Lamp posts, Lamp post, LED Lampposts, LED Lamppost, LED Lamp posts, LED Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, LED pier mount, LED pier mounts, LED pier mount light, LED pier mount lights, LED pier mount lighting, LED pier mount fixture, LED pier mount fixtures, LED pier mount light fixture, LED pier mount light fixtures, LED pier mount lighting fixture, LED pier mount lighting fixtures, pier mount LED, pier mount LED light, pier mount LED lights, pier mount LED lighting, pier mount LED fixture, pier mount LED fixtures, pier mount LED light fixture, pier mount LED light fixtures, pier mount LED lighting fixture, pier mount LED lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting, H-19112, H-19114, H-19116, classic radial shade, classic radial shade post light,
63377 <p>Post mount fixtures are incorporated into exterior lighting plans for a variety of reasons. Locations like docks need to be bright and illuminated for safety purposes, while outdoor seating areas should be welcoming and functional at night. However, many of the fixtures used for these tasks lack basic aesthetic appeal. Mounted to posts, the Aero tops a rugged metal guard with a timeless RLM shade. By showcasing the same style as <a title="Aero Gooseneck Light" href="/lighting/wall-lights/gooseneck-lights/aero-gooseneck-light/">goosenecks</a><span data-preserver-spaces="true"> </span><span data-preserver-spaces="true">and <a title="Aero Pendant Light" href="/lighting/ceiling-lights/cord-hung-pendant-lighting/aero-pendant-light/">pendants</a></span><span data-preserver-spaces="true">, the Aero offers a uniform look to both residential and commercial properties.</span></p> <p><span data-preserver-spaces="true">Now employing the latest LED technology, the Aero brightens outdoor settings with more efficiency than standard options. Known for wasting minimal electricity, LED lighting helps reduce a building’s overall energy consumption. This results in smaller power bills and a decreased environmental footprint. Take advantage of these benefits and redefine your exterior décor!</span></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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> <li><span><span>Read more about the Aero LED Industrial Guard Post Mount Light over on our <a href="https://www.barnlight.com/inspiration/rugged-outdoor-lighting-in-variety-of-mounts-suits-homeowners-style/" target="_blank">blog</a>!</span></span></li> </ul> Looking for a decorative, but functional, addition to your space? The Aero blends industrial fixture styles and cutting-edge LED technology, a long lasting and durable post mount light! The Astro LED Industrial Guard Post Mount, Astro LED Industrial Guard Post Mount, The Astro LED Industrial Post Mount, Astro LED Industrial Post Mount, The Astro LED Guard Post Mount, Astro LED Guard Post Mount, The Astro LED Post Mount, Astro LED Post Mount, The Astro LED Industrial Guard Post Mount light, The Astro LED Industrial Guard Post Mount lights, The Astro LED Industrial Guard Post Mount lighting, Astro LED Industrial Guard Post Mount Light, Astro LED Industrial Guard Post Mount Lights, Astro LED Industrial Guard Post Mount Lighting, Astro LED Post Mount Light, Astro LED Post Mount Lights, Astro LED Post Mount Lighting, LED Post Mount, Post Mount LED, LED post mount light, led post mount lights, led post mount lighting, post mount led light, post mount led lights, post mount led lighting, BLE-PMS-TGG-SBA-LED, The Aero LED Industrial Guard Post Mount, Aero LED Industrial Guard Post Mount, The Astro LED Industrial Post Mount, Astro LED Industrial Post Mount, The Astro LED Guard Post Mount, Astro LED Guard Post Mount, The Astro LED Post Mount, Astro LED Post Mount, The Astro LED Industrial Guard Post Mount light, The Astro LED Industrial Guard Post Mount lights, The Astro LED Industrial Guard Post Mount lighting, Astro LED Industrial Guard Post Mount Light, Astro LED Industrial Guard Post Mount Lights, Astro LED Industrial Guard Post Mount Lighting, Astro LED Post Mount Light, Astro LED Post Mount Lights, Astro LED Post Mount Lighting, Aero post mount, Aero industrial post mount, Aero, Industrial guard post mount, industrial guard post mount light, industrial guard led, industrial guard led post mount, tgg, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, aero led series, aero LED collection, SPS-0458, SPS0458, SPS 0458, Lampposts, Lamppost, Lamp posts, Lamp post, LED Lampposts, LED Lamppost, LED Lamp posts, LED Lamp post, BLE PMS, lamp post lights, outdoor pole lights, light post lighting,
63378 <p>This authentic rugged creation provides a decorative alternative to strictly utilitarian exterior lighting options. An RLM shade is attached to an upright metal guard to establish an eye-catching design. Mounting this fixture to a sturdy post allows spaces far from a building to receive a timeless appearance and plenty of light. Installed on docks, in sitting areas, or near gates, the Original™ helps every setting feel safe, secure, and welcoming.</p> <p>Housing a technologically advanced lighting source, this post mount adds a functional new dimension to its design. Integrated LED components efficiently transform electricity into illumination, alleviating lighting’s financial and environmental impact. Take advantage of these aesthetic and practical benefits and add industrial post mounts to your outdoor lighting plan!</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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> <li><span><span>Read more about The Original™ LED Industrial Guard Post Mount Light over on our <a href="https://www.barnlight.com/inspiration/led-lighting-brings-both-style-efficiency-to-hgtv-stars-home/" target="_blank">blog</a>!</span></span></li> </ul> One of our most popular shades, the Original™, is now available as a post mount light! Now fitted with LEDs, this exterior lighting is perfect for homes and businesses! The Original™ LED Industrial Guard Post Mount, Original™ LED Industrial Guard Post Mount, The Original™ LED Industrial Post Mount, Original™ LED Industrial Post Mount, The Original™ LED Guard Post Mount, Original™ LED Guard Post Mount, The Original™ LED Post Mount, Original™ LED Post Mount, The Original™ LED Post Mount Light, The Original™ LED Post Mount Lights, The Original™ LED Post Mount Lighting, Original™ LED Post Mount Light, Original™ LED Post Mount Lights, Original™ LED Post Mount Lighting, LED Post Mount, LED Post Mounts, LED Post Mount Light, LED Post Mount Lights, LED Post Mount Lighting, Post Mount LED, Post Mount LED Light, Post Mount LED Lights, Post Mount LED Lighting, The Original™, BLE-PMS-TGG-WHS-LED, The Original LED Industrial Guard Post Mount, Original LED Industrial Guard Post Mount, The Original LED Industrial Guard Post Mount Light, Original LED Guard Post Mount, The Original LED Guard Post Mount, Original, Original™, Original Post Mount, Original Post Mount Light, Original™ Post Mount Light, Original Post Mount, Original Post Mounts, Original™ Post Mount, Original™ Post Mounts, industrial post mount, industrial post mounts, industrial guard post mount, industrial guard post mounts, industrial post mount light, industrial guard post mount light, industrial guard light, industrial guard pole light, industrial pole light, pole light, industrial dock light, industrial guard dock light, dock light, BLE-PMS-TGG-WHS12, BLE-PMS-TGG-WHS14, original+led+post+mount, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0448, SPS0448, SPS 0448, original led series, original™ led series, originaltm led series, original led collection, original™ led collection, originaltm led collection, the original led series, the original™ led series, the originaltm led series, the original led collection, the original™ led collection, the originaltm led collection, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, LED post top, original led post mount, Lampposts, Lamppost, Lamp posts, Lamp post, LED Lampposts, LED Lamppost, LED Lamp posts, LED Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, LED pier mount, LED pier mounts, LED pier mount light, LED pier mount lights, LED pier mount lighting, LED pier mount fixture, LED pier mount fixtures, LED pier mount light fixture, LED pier mount light fixtures, LED pier mount lighting fixture, LED pier mount lighting fixtures, pier mount LED, pier mount LED light, pier mount LED lights, pier mount LED lighting, pier mount LED fixture, pier mount LED fixtures, pier mount LED light fixture, pier mount LED light fixtures, pier mount LED lighting fixture, pier mount LED lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting, H-15112, H-15114, classic warehouse shade post light rlm, classic warehouse shade,
63379 <p>Outdoor lighting is a vital addition to both residential and commercial properties, and the Union features the combination of functionality and style these spaces need. Instantly boosting a building’s curb appeal, this exterior fixture helps homes and businesses appear welcoming and vibrant at night. Aesthetically, a sleek, retro-inspired style offers a timeless feel, meaning the Union can continue to complement a property as tastes change and evolve.</p> <p><br />The Union is powered by cutting-edge LED components, which are integrated directly into its design. This technology emits illumination with unmatched efficiency, offering both environmental and financial benefits.</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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> </ul> One of our most versatile fixtures, the Universal efficiently brightens outdoor spaces. Cost effective and eco-friendly, transform your outdoor spaces with LED post mounts! The Universal LED Industrial Guard Post Mount, Universal LED Industrial Guard Post Mount, The Universal LED Industrial Guard Post Mount Light, The Universal LED Industrial Guard Post Mount Lights, The Universal LED Industrial Guard Post Mount Lighting, The Universal LED Industrial Post Mount, Universal LED Industrial Post Mount, The Universal LED Guard Post Mount, Universal LED Guard Post Mount, The Universal LED Post Mount, Universal LED Post Mount, The Universal LED Post Mounts, The Universal LED Post Mount Light, The Universal LED Post Mount Lights, The Universal LED Post Mount Lighting, Universal LED Post Mount Light, Universal LED Post Mount Lights, Universal LED Post Mount Lighting, LED post mount, led post mounts, led post mount light, led post mount lights, led post mount lighting, post mount led, post mount led light, post mount led lights, post mount led lighting, BLE-PMS-TGG-WHU-LED, Union LED Industrial Guard Post Mount Light, Union LED Industrial Guard Post Mount, Union LED Industrial Guard, Union LED Industrial Post Mount Light, Union LED Industrial Post Mount, Universal Industrial Guard Post Mount, BLE-PMS-TGG-WHU, decorative walkway light, industrial guard pole light, exterior lighting, pole mount, pole light, post mount, post mount light, BLE-PMS-TGG-WHU12, BLE-PMS-TGG-WHU14, Union Industrial Guard Post Mount Light, Union Industrial Guard Post Mount, Industrial Guard Post Mount Light, Industrial Guard Post Mount, Industrial post mount, industrial post mounts, union post mount, union post mount light, BLE-PMS-TGG-WHU14, BLE-PMS-TGG-WHU16, SPS-0247, SPS 0247, SPS0247, union series, union collection, the union series, the union collection, SPS-0159, SPS0159, SPS 0159, union LED series, union LED collection, the union led series, the union led collection, Union led post lamp, Union led post lamps, LED Union post lamp, LED Union post lamps, Lampposts, Lamppost, Lamp posts, Lamp post, LED Lampposts, LED Lamppost, LED Lamp posts, LED Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, LED pier mount, LED pier mounts, LED pier mount light, LED pier mount lights, LED pier mount lighting, LED pier mount fixture, LED pier mount fixtures, LED pier mount light fixture, LED pier mount light fixtures, LED pier mount lighting fixture, LED pier mount lighting fixtures, pier mount LED, pier mount LED light, pier mount LED lights, pier mount LED lighting, pier mount LED fixture, pier mount LED fixtures, pier mount LED light fixture, pier mount LED light fixtures, pier mount LED lighting fixture, pier mount LED lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting,
63380 <p>The Bomber successfully pairs vintage influences and timeless styles with modern technology, an ideal addition to any exterior lighting plan. By topping a rugged metal guard with a curved RLM shade, this post mount light contributes illumination and character to outdoor spaces. Mounted to posts or poles, the Bomber helps docks, patios, and other outdoor spaces feel connected to the rest of a building’s décor.</p> <p>Every Bomber is made-to-order in the United States, indicative of our commitment to craftsmanship. Through this meticulous construction process, we’re able to produce an incredibly long-lasting post mount light. That practicality is echoed by the integrated LED components. Far more efficient than standard incandescent bulbs, the Bomber reduces a building’s overall energy consumption. Simply installing this fixture results in lower power bills and stylish settings.</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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> </ul> Our timeless shade designs are fitted to rustic guard, resulting in a stylish and durable post mount light! Now fitted with LEDs, the Bomber produces light with unmatched efficiency! The Old Dixie LED Industrial Guard Post Mount, Old Dixie LED Industrial Guard Post Mount, The Old Dixie LED Industrial Post Mount, Old Dixie LED Industrial Post Mount, The Old Dixie LED Guard Post Mount, Old Dixie LED Guard Post Mount, Old Dixie LED Post Mount, Old Dixie LED Post Mount Light, Old Dixie LED Post Mount Lights, Old Dixie LED Post Mount Lighting, LED Post Mount, LED Post mounts, LED post mount light, led post mount lights, led post mount lighting, post mount led, post mount led light, post mount led lights, post mount led lighting, old dixie, industrial post mount, industrial post mounts, industrial post mount light, industrial post mount lights, industrial post mount lighting, BLE-PMS-TGG-WHB-LED, The Bomber LED Industrial Guard Post Mount, Bomber LED Industrial Guard Post Mount, The Bomber LED Industrial Post Mount, Bomber LED Industrial Post Mount, The Bomber LED Guard Post Mount, Bomber LED Guard Post Mount, Bomber LED Post Mount, Bomber LED Post Mount Light, Bomber LED Post Mount Lights, Bomber LED Post Mount Lighting, Bomber industrial post mount, bomber industrial post mounts, bomber post mount, bomber post mounts, bomber led post mount, bomber led post mounts, industrial post mount, industrial guard post mount, led post mount, led post mounts, BLE-PMS-TGG-WHB11, BLE-PMS-TGG-WHB13, SPS-0245, SPS 0245, SPS0245, Lampposts, Lamppost, Lamp posts, Lamp post, LED Lampposts, LED Lamppost, LED Lamp posts, LED Lamp post, pier mount, pier mounts, pier mount light, pier mount lights, pier mount lighting, pier mount fixture, pier mount fixtures, pier mount light fixture, pier mount light fixtures, pier mount lighting fixture, pier mount lighting fixtures, LED pier mount, LED pier mounts, LED pier mount light, LED pier mount lights, LED pier mount lighting, LED pier mount fixture, LED pier mount fixtures, LED pier mount light fixture, LED pier mount light fixtures, LED pier mount lighting fixture, LED pier mount lighting fixtures, pier mount LED, pier mount LED light, pier mount LED lights, pier mount LED lighting, pier mount LED fixture, pier mount LED fixtures, pier mount LED light fixture, pier mount LED light fixtures, pier mount LED lighting fixture, pier mount LED lighting fixtures, BLE PMS, lamp post lights, outdoor pole lights, light post lighting, H-15111, H-15113, H-15115, H-15117, curved warehouse shade, curved warehouse shade post light,
63383 <p>Home and businesses are always searching for the most efficient, durable, and stylish lighting. At Barn Light Electric, we keep those desires in mind as we design our fixtures. This post mount light unites the longevity of LEDs with the industrial appeal of rugged metal guards. The integrated LED technology consumes far less energy than traditional options, eliminating much of the costs and pollution attributed to brightening a space.</p> <p>The LEDs are shielded by an industrial guard and glass, which protects these components while they illuminate outdoor spaces. While incredibly functional, this feature also grants the Atomic a classic, versatile sense of style. Its timeless aesthetic and rugged profile are in line with many of the looks currently in favor. With various customizing options, the Atomic can put the finishing touches on any 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><span>3.5" heavy duty aluminum post mount fitter | fits 3" OD pole</span></li> <li><span><span>8'-12' smooth or fluted heavy duty s</span><span>teel</span><span> optional direct burial pole</span></span></li> </ul> The efficiency of LED technology and the industrial profile of our rustic lighting meet in this post mount light! Save money and add a new sense of style with this fixture! The Atomic LED Industrial Guard Post Mount, Atomic LED Industrial Guard Post Mount, The Atomic LED Industrial Post Mount, Atomic LED Industrial Post Mount, The Atomic LED Guard Post Mount, Atomic LED Guard Post Mount, The Atomic LED Post Mount, Atomic LED Post Mount, The Atomic LED Post Mounts, Atomic LED Post Mounts, The Atomic LED Post Mount light, Atomic LED Post Mount light, The Atomic LED Post Mount lights, Atomic LED Post Mount lights, The Atomic LED Post Mount lighting, Atomic LED Post Mount lighting, led post mount, led post mounts, led post mount light, led post mount lights, led post mount lighting, post mount, post mounts, post mount led, post mount led lights, post mount led lights, post mount led lighting, pole, pole light, pole lights, pole lighting, BLE-PMS-TGG/WH-LED, BLE-PMS-TGG-WH-LED, industrial post, industrial post mount, industrial post mount light, industrial light, industrial pole light, dock light, industrial dock light, industrial guard post, industrial guard post mount, industrial guard post light, industrial guard post fixture, BLE PMS, lamp post lights, outdoor pole lights, light post lighting,