SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    58884, 62123, 29986, 60914, 29983, 29992, 
    29989, 63034, 62012, 61430, 62240, 
    63755, 62259, 61340, 61337, 62252, 
    61336, 62253, 62254, 62260, 64941, 
    62258, 64942, 64943
  ) 
  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": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (58884,62123,29986,60914,29983,29992,29989,63034,62012,61430,62240,63755,62259,61340,61337,62252,61336,62253,62254,62260,64941,62258,64942,64943) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
29983 Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Lighting Accessories, Light Hardware Accessories, Stem Mount 1/2 inch or 3/4 inch round aluminum pipe threaded on both ends that connects the ceiling canopy and the shade, can be hung both vertically and horizontally. Barn Light - 1/2" & 3/4" IP Stem Extensions, stem, stem replacement, lighting hardware, hardware, pipe extension
29986 wall mount plate, backing plate, gooseneck holder, wall bracket, wall mount for gooseneck, wall mount for goosenecks, farm light wall mount, wall light mount, barn lighting hardware, Looking for durable and industrial barn style wall mounting? This gooseneck wall mount bracket comes in 1/2" and 1/4" options with a variety of finishes. Barn Light - Gooseneck Backing Plates, wall mount bracket, wall bracket, backing plate
29989 Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Lighting Accessories, Light Hardware Accessories Barn Light - Stem Mount Canopy,BLE-SMC-, standard canopy, canopy, stem canopy, BLE-SC, SC
29992 Lighting protector, wire guard for warehouse lights, round wire guard accessory, light diffuser cage, light shade diffuser, glare reducer cage, exterior light glare reducer This wire cage comes in 8 through 20 inch sizes for your interior and exterior RLM lighting. Use this light accessory as a glare diffuser, or decorative accent! Barn Light - Wire Guards 8" to 27", wire guard, bulb protector, wire cage, wire cages, metal decorative bulb shield, metal bulb shield, decorative shield, protective metal shield, protective shield, bulb guard, bulb shield, metal bulb guard, cage, wire, wire guard, wire guards, cage for light bulbs,
58884 gooseneck socket replacement, vintage barn light socket replacement, porcelain enamel socket replacement This socket assembly is often used as a replacement part for vintage porcelain enamel barn lights, and can fit any Barn Light with a hex hole in the neck. Socket Assembly - Coupler - 7' Wire, socket, coupler, lighting parts, vintage light repair, socket replacement, replacement socket, gooseneck socket, stem socket, light socket,
60914 hang straight, ceiling canopy, light canopy kit, canopy kit, hang straight canopy, sloped ceiling, vaulted ceiling, light canopy parts, ceiling canopy, slope, vaulted, pitch, ceiling, Lighting Hardware, Lighting Hardware Accessories, Light Hardware Acc This light canopy kit includes a hang straight canopy for mounting a stem fixture on a sloped or vaulted ceiling. Shop parts needed to hang lighting in your home. wall mount bracket, wall bracket, backing plate, Hang Straight Ceiling Canopy, slope, vaulted, pitch, ceiling, Light Hardware Accessories, accessory, hang straight, straight hang, hang straight canopy, ceiling canopy, sloped ceiling, vaulted ceiling, ceiling hang straight canopy, mount for sloped ceiling, mounting for slope ceiling, mounting for sloped ceiling, sloped ceiling mount, hang right, hang right canopy,
61336 heavy duty backing plate, lighting accessories, lighting wall hardware, backing plates, gooseneck lighting hardware, heavy duty lighting hardware, gooseneck wall mount, support for gooseneck light fixtures, heavy duty square backing plate Browse our lighting accessories, light hardware, and backing plates. This heavy duty backing plate is made for gooseneck lighting in commercial settings and will stand the test of time! heavy duty backing plate, heavy duty, backing plate, lighting accessories, lighting hardware, backing plates, gooseneck lighting, BLE-HDBP, heavy duty backing plate, lighting accessories, lighting wall hardware, backing plates, gooseneck lighting hardware, heavy duty lighting hardware, gooseneck wall mount, support for gooseneck light fixtures, heavy duty square backing plate, heavy duty baseplate, heavy duty mount, heavy duty bp, heavy duty back plate,
61337 decorative canopy cover, light canopy, canopy parts, light canopy parts, canopy cover, decorative canopy, gooseneck, backing plates, Decorative Backing Plate Cover Shop for quality gooseneck parts fromt he lighting company you trust! This Decorative Backing Plate Cover made to fit any of our gooseneck backing plates. decorative canopy cover, light canopy, canopy parts,light canopy parts, canopy cover, decorative canopy, gooseneck, backing plates, BLE-DCC, decorative bp cover,
61340 heavy duty, stem mount, canopy, light canopy, heavy duty mount, heavy duty canopy, commercial, heavy lighting, Lighting Hardware, Lighting Hardware Accessories, Light Hardware Accessories, Lights Hardware Accessories, Hardware Accessories, Heavy Duty, L This light canopy has a heavy duty mount. Use this heavy duty canopy to secure commercial lighting and heavy lighting. ceiling bracket, stem canopy, backing plate, heavy duty canopy, ceiling canopy, ceiling mount,
61430 heavy duty post mount accessory, heavy duty post mount burial pole, weather resistant aluminum pole, single outdoor post, aluminum post mount pole, galvanized steel burial pole An essential for post mount assembly, Barn Light Electric's Direct Burial Pole supports post mount lighting fixtures while protecting the hard wiring in exterior conditions. Direct Burial Pole, burial pole, post mount accessories, ground mount, post mount, BLE-DBP, post mount stand, light stand, light pole, PMDB, poles, pole, lamp post lights, direct burial post, direct burial poles,
62012 outdoor light sensor, dusk to dawn light sensor, outdoor dusk to dawn sensor, photocell light sensor, photo sensor for barn lighting, dusk-to-dawn barn light, weather proof barn light dusk to dawn sensor, dusk to dawn coverplate Install our dusk-to-dawn sensor to your gooseneck barn light's backing plate for energy efficient light. This photocell turns on at dusk and off at dawn. BLE-DD, Dusk-to-Dawn Photocell, outdoor light sensor, dusk to dawn light sensor, outdoor dust to dawn sensor, photocell light sensor, photo sensor for barn lighting, dusk-to-dawn barn light, weather proof barn light dust to dawn sensor, dusk to dawn coverplate, solar, photo cell, dawn to dusk, dusk to dawn photocell, dusk to dawn sensor, photo cells, photocell sensor, dusk til dawn, dusk till dawn
62123 vintage barn light pendant kit, socket and cord kit, pendant cords, replacement cords, pendant light restoration. For refurbishing or repairing vintage barn light pendants. This socket and light cord kit includes 8 feet of customized cord, porcelain socket, and hex coupler. BLE-SKA-5101, Replacement Socket & Cord for Pendants, replacement socket, replacement cord, replacement socket for pendant, socket, cord, socket and cord, cord replacement, light socket, barn light parts, cord hung pendant without shade, cord and socket, socket and cord,
62240 specialty hex nut, hex nut cover, copper hex nut, copper barn light hex cover, copper lamp parts, copper lighting accessories Conceal metal hex nuts with our hex nut cover. This hex cover fits snugly on shade mounts, proving a sleek and polished look. BLE-HEXC-COP, Copper Hex Cover, specialty hex nut, hex nut cover, copper hex nut, copper barn light hex cover, copper lamp parts, copper lighting accessories, hex cover, decorative hex cover, LDCHX, hex coupling
62252 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 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 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,
62258 Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts. Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts. BLE-TGG, industrial cast guard parts, vapor proof cast guard, vapor proof guard replacement, replacement lamp guard, Heavy Duty Cast Guard, light parts, cast guard, replacement cast guard, replacement heavy duty cast guard, cast hard,
62259 replacement part for refrigerator light, wire guard replacement, vapor proof wire guard, wire guard light accessory The wire guard replacement is ideal for vapor proof fixtures, industrial guard and glass fixtures, and refrigerator lights. This wire guard light accessory comes with Free Shipping. BLE-WGG, Wire Guard, Protective Wire Guard, wire guard replacement, replacement wire guard, light accessories, light parts, wire guard part, individual wire guard, cast hard,
62260 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,
63034 Gooseneck Hardware, lighting hardware, Swivel knuckle, swivel knuckle joint The Swivel Knuckle is a piece of hardware that joins the mounting option and warehouse shade, allowing for a greater range of motion. Swivel Knuckle, swivel, knuckle, knuckel, swivle, hardware, hard ware, hardware fixtures, lighting hardware, barn hardware, barn hard ware, lighting hardware, lighting hard ware, lighting fixture hardware, fixture hardware, knuckle hardware, knuckle hard ware, BLE-SWK, swivel joint, swivel knuckle joint, knuckle joint, adjustable knuckle,
63755 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,
64941 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 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 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,