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 (
    64622, 60741, 64623, 64626, 60747, 62254, 
    60730, 62260, 60740, 61387, 60742, 
    61171
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00074

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": 12,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64622,60741,64623,64626,60747,62254,60730,62260,60740,61387,60742,61171) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
60730 <p>An eye-catching option, the G2’s bold lines and iconic profile provide hints of character to residential and commercial décors. Along with these decorative touches, the metal gooseneck arm also protects the fixture’s wires. With an eclectic assortment of finish colors, the G2 can embrace any space’s style.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> g2 gooseneck, gooseneck arm, curvy gooseneck, 39 inch arm, long gooseneck, gooseneck couplers, The G2 Gooseneck Arm is a curvy arm with a 39 1/4 inch projection. G2 gooseneck, G2 Arm, Curvy gooseneck, long gooseneck, BLE-G2, G-2, arm, g2, g-2, gooseneck arm dimensions, gooseneck options,
60740 <p>Equally decorative and practical, the G12’s simple design offers the versatility needed in contemporary spaces. This durable metal arm protects a fixture’s wires while expressing a classic sense of style. Select from a vast assortment of powder coat finish colors and create the perfect look for your space!</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> curved arm, curved gooseneck, 11 inch gooseneck, gooseneck couplers, short gooseneck, short arm, The G12 Gooseneck Arm is has a curves down in the center. G12, G-12, curvd gooseneck, curved arm, short gooseneck, BLE-G12, gooseneck arm, arm, g-12, g12, gooseneck arm dimensions, gooseneck options,
60741 <p>Indebted to vintage styles, the G13’s minimalist design and curved profile is a favorite for both contemporary décors and traditionally decorated venues. Thanks to its sturdy metal construction, this gooseneck arm can be used for interior and exterior lighting applications. A diverse selection of finish colors lets the G13 adopt a wide variety of looks and styles.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> curved arm, curved gooseneck, porcelain, 11 inch gooseneck, gooseneck couplers, short gooseneck, short arm, The G13 Gooseneck Arm is has a curves down in the center. This short gooseneck comes with couplers and is painted to match our porcelain. G-13, G13, curved gooseneck, curved arm, porcelain gooseneck, shor gooseneck, BLE-G13, arm, gooseneck arm, g-13, g13, g31, gooseneck arm dimensions, gooseneck options,
60742 <p>To establish its timeless style, the G14 features a straight metal arm. By embracing simplicity in its design, this gooseneck arm complements today’s most popular styles, ranging from fashionable farmhouse looks and contemporary industrial-inspired décors. American made and fully customizable, the G14 is available with a wide array of finish colors!</p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> straight arm, straight gooseneck, 14 inch gooseneck, gooseneck couplers, The G1 Gooseneck Arm is a straight arm with a 14 inch projection. arm, gooseneck G-14, G14, Straight gooseneck, straight arm, BLE-G14, g-14, g14, gooseneck arm dimensions, gooseneck options, g14 arm,
60747 <p>By embracing a straightforward appearance, this gooseneck arm design delivers hints of style to nearly any location. The G17’s sturdy metal structure protects a fixture’s wires, offering the durability desired by modern homes and businesses. Available with a wide assortment of finish colors, the G17 can adopt any décor’s color scheme. </p> <p>|break|</p> <ul> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> straight arm, straight gooseneck, 11 inch gooseneck, gooseneck couplers, The G17 Gooseneck Arm is a straight arm with a 11 inch projection. G-17, G17, Straight gooseneck, straight arm, BLE-G17, g-17, g17, gooseneck arm dimensions, gooseneck options,
61171 <p>Thanks to its tall design and rounded lines, the G32 offers a classic sense of style. While this gooseneck was influenced by vintage lighting, its timeless profile still appeals to many contemporary décors. Durably crafted and fully customizable, the G32 can be customized with your choice of finish colors.</p> <p>|break|</p> <ul> <li><strong>Includes:</strong><span> </span>Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong><span> </span>Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> The classic Barn Light electric gooseneck arm. Replace damaged arms of gooseneck lights or give an existing warehouse shade a brand new look. G32 Gooseneck Arm, G-32, G32, gooseneck, arm, sign gooseneck arm,g-32, g32, replacement gooseneck arm, replacement gooseneck, gooseneck arm, gooseneck arm dimensions, gooseneck options,
61387 <p>To create a rugged design and timeless profile, the G40 incorporates a metal support arm, providing the sturdiness and industrial appeal modern homes and businesses desire. Customizable with various finish colors, this gooseneck arm complements nearly every style favored in contemporary décors.</p> <p>|break|</p> <ul> <li><strong>Mounting: </strong>Gooseneck can be mounted with the support arm above or below the main gooseneck. </li> <li><strong>Includes:</strong> Wall Backing Plate and Mounting Hardware</li> <li><strong>Construction:</strong> Aluminum</li> <li><strong>Manufactured in the U.S.A.</strong></li> </ul> long gooseneck arm, double gooseneck arm, heavy duty wall mount arm, dual mount gooseneck arm. commercial gooseneck arm The G40 gooseneck arm has a double arm for extra support in high wind and snow load locations. Designed to be used with large lamp shades. G-40, gooseneck arm, heavy duty gooseneck arm, double arm gooseneck, G40, arm, Heavy Duty Double Gooseneck Arm, gooseneck arm dimensions, gooseneck options,
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,
62260 <p>Thanks to its sturdy metal design, the Standard Cast Guard offers a touch of industrial character to traditional RLM-style and nautical lighting fixtures. Various powder coat finish colors let the guard match any space’s look!</p> <p>|break|</p> <ul> <li>Please Note<strong>:</strong> Cast guards will only fit in fixtures that have been manufactured with the threading to fit them.  </li> </ul> vapor proof guard parts, die cast vapor proof guard, light bulb cast guard, vapor tight cast guard This replacement die cast guard fits standard vapor proof and threaded fixtures and comes with a custom finish. Free Shipping with replacement light parts. BLE-CGG, Standard Cast Guard, Industrial Light Parts, light parts, cast guard, cast guard replacement, guard replacement, lighting accessories, vapor proof guard, standard vapor proof, cast hard,
64622 <p>Eye-catching yet practical, the Oval embraces a sophisticated style and efficient technology. The bulb’s soft rounded shape expresses an elevated contemporary aesthetic, one intended to capture attention as a decorative feature or function as an accent piece. To cast a calming white glow, the bulb’s finish slightly dampens its illumination. Thanks to its LEDs, the Oval significantly reduces a venue’s overall electricity demands, resulting in a cost-effective and environmentally sustainable design.</p> <p>|break|</p> <ul> <li>Dimensions: W 6.4" x H 5.7"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light + Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> Decorative LED light bulbs! Including this bulb in a room establishes an elevated décor and reduces energy needs! Efficient, budget minded, and sustainable! 28NOMA-6W-2700K-E26-MP-120V, Oval LED Tala Lamp, Oval LED Tala Lamps, The Oval LED Tala Lamp, The Oval LED Tala Lamps, Oval LED Tala Bulb, Oval LED Tala Bulbs, Oval LED Tala Light Bulb, Oval LED Tala Light Bulbs, Oval LED Bulb, Oval LED Bulbs, Oval LED Light Bulb, Oval LED Light Bulbs, Tala, Tala LED, Tala Bulb, Tala Light Bulb, Tala LED Bulb, Tala LED Bulbs, Tala LED Light Bulb, Tala LED Light bulbs, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb,
64623 <p>By adopting a unique triangular shape and the latest LED technology, the Noma’s design prioritizes aesthetics and performance equally. Representative of the latest contemporary styles, the Noma’s soft shape and eye-catching lines let it stand out as a decorative accent piece. To lower power bills and promote environmental sustainability, the Noma’s LEDs convert electricity into illumination with unparalleled efficiency. The Noma’s soft white finish produces gentle light, helping rooms feel warm, welcoming, and comfortable.</p> <p>|break|</p> <ul> <li>Dimensions: W 6.4" x H 5.7"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light + Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> Eye-catching, high performance LED Bulbs! The Noma functions as a decorative feature while illuminating a space! Energy efficient and environmentally friendly! 28NOMA, 28NOMA, Noma, Noma bulb, noma bulbs, noma light bulb, noma light bulbs, noma lighting bulb, noma lighting bulbs, tala, tala bulb, tala bulbs, tala light bulb, tala light bulbs, tala lighting bulb, tala lighting bulbs, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, tube bulb, tube bulbs, tube light bulb, tube light bulbs, tube lighting bulb, tube lighting bulbs, led tube bulb, led tube bulbs, led tube light bulb, led tube light bulbs, led tube lighting bulb, led tube lighting bulbs, tube led bulb, tube led bulbs, tube led light bulb, tube led light bulbs, tube led lighting bulb, tube led lighting bulbs,
64626 <p>With its diminutive size and enduring style, the Lurra contributes a touch of character to lighting fixtures. To create its timeless aesthetic, the Lurra incorporates a short tubular design and eye-catching LED filaments. This look complements both traditional décors and contemporary spaces. As an efficient source of light, these LED bulbs reduce a venue’s overall energy consumption saving money and greatly benefiting the environment.</p> <p>|break|</p> <ul> <li>Dimensions: W 9.8" x H 9.8"</li> <li><span>Brass Cap with Mouth-Blown Glass</span></li> <li>Energy Commission (CEC) Title 20 Certified</li> <li>Read more about Barn Light x Tala over on our <a href="https://www.barnlight.com/inspiration/barn-lights-tala-bulbs-create-stunning-design-solutions/" target="_blank">blog</a>!</li> </ul> A fashionable, efficient LED light bulb! The Lurra presents a classic style and is environmentally and budget friendly! Replace standard bulbs with this stylish LED bulb! Lurra LED Tala Lamp, The Lurra LED Tala Lamp, Lurra LED Tala Lamps, The Lurra LED Tala Lamps, Lurra LED Lamp, Lurra LED Lamps, Lurra LED Tala Bulb, Lurra LED Tala Bulbs, Lurra LED Tala Light Bulb, Lurra LED Tala Light Bulbs, Lurra LED Light Bulb, Lurra LED Bulb, Lurra LED Bulbs, Lurra LED Light Bulbs, LED Bulb, LED Bulbs, LED Light Bulb, LED Light Bulbs, Tala, Tala Bulb, Tala Bulbs, Tala Light Bulb, Tala Light Bulbs, Tala, Lurra, 28LURA-3W-2200K-E26-T-120V, decorative bulb, decorative bulbs, decorative light bulb, decorative light bulbs, decorative lighting bulb, decorative lighting bulbs, decorative led bulb, decorative led bulbs, decorative led light bulb, decorative led light bulbs, decorative led lighting bulb, decorative led lighting bulbs, led decorative bulb, led decorative bulbs, led decorative light bulb, led decorative light bulbs, led decorative lighting bulb, led decorative lighting bulbs, stylish bulb, stylish bulbs, stylish light bulb, stylish light bulbs, stylish lighting bulb, stylish lighting bulbs, stylish led bulb, stylish led bulbs, stylish led light bulbs, stylish led lighting bulb, stylish led lighting bulbs, led stylish bulb, led stylish bulbs, led stylish light bulb, led stylish light bulbs, led stylish lighting bulb, tube bulb, tube bulbs, tube light bulb, tube light bulbs, tube lighting bulb, tube lighting bulbs, led tube bulb, led tube bulbs, led tube light bulb, led tube light bulbs, led tube lighting bulb, led tube lighting bulbs, tube led bulb, tube led bulbs, tube led light bulb, tube led light bulbs, tube led lighting bulb, tube led lighting bulbs, 28 lurra,