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 (61329, 61622, 61322, 61326) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (61329,61622,61322,61326) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61322 cord hung schoolhouse pendant, school house lighting pendant cord hung, modern schoolhouse pendant, painted globe light, school house light, globe light with painted bands, colored band around the glass globe, american made schoolhouse light The iconic schoolhouse light fixture on a casual cord! Customize your cord-hung pendant's size and detail with colorful hand-painted bands on the glass globe. Elementary Schoolhouse Cord Hung Light, schoolhouse, cord hung, schoolhouse pendant, striped, striped lampshade, vintage pendants, school house, school house light, painted glass, painted light, BLE-C-SCH-PC, cord hung lighting, cord hung light, cord hung light, cord hung schoolhouse, cord hung schoolhouse light, schoolhouse light, schoolhouse pendant, school house pendant, pendant lighting, schoolhouse pendant lighting, cord pendant, cord pendant lighting, schoolhouse cord pendant, schoolhouse cord light, ceiling light, schoolhouse ceiling light, schoolhouse ceiling pendant, ceiling pendant, ceiling pendant lighting, schoolhouse ceiling pendant lighting, Rudimentary, Rudimentary Schoolhouse, Rudimentary Schoolhouse Light, Rudimentary Schoolhouse Cord Hung Light, The Rudimentary Schoolhouse Cord Hung Light, The Rudimentary Schoolhouse, The Rudimentary Schoolhouse Light, Elementary, Elementery, Elementory, Elementary schoolhouse, elementary school house, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Pendant Light, Primary Schoolhouse Pendant, Primary Pendant Light, Primary School house Pendant Light, Primary School house Pendant, Primary Pendant, Primary Schoolhouse Ceiling Light, Primary School house Ceiling Light, Primary Ceiling Light, Primary Schoolhouse Ceiling Pendant, Primary Schoolhouse Ceiling Pendants, Primary School house ceiling Pendant, Primary ceiling Pendant, Primary ceiling pendants, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, BLE-C-SCH10, BLE-C-SCH14, BLE-C-SCHCL10, BLE-C-SCHCL14, Pendant schoolhouse, Schoolhouse pendant glass, School house pendant light with stripes, Pendant island lights, sch, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0069, SPS0069, SPS 0069, Primary school pendant light, Primary school pendant lights, Primary school pendant lighting, school light, school lights, school lighting, school, 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, Schoolhouse primary, Schoolhouse fixture, Schoolhouse fixtures, Schoolhouse light fixture, Schoolhouse light fixtures, primary cord pendant, striped schoolhouse, striped schoolhouse light,
61326 stem-mount schoolhouse light, stem mount light with schoolhouse shade, hand painted bands, utilitarian pendant light, schoolhouse stem mount with painted band, vintage schoolhouse pendant The schoolhouse pendant light you love, with more styling options! Add personality with a custom stem or colorful hand-painted bands on the classic glass globe. Primary Schoolhouse Stem Mount Light, schoolhouse, stem mount, schoolhouse pendant, striped, striped lampshade, vintage pendants, school house, school house light, kitchen, bath, painted glass, painted light, BLE-S-SCH-PC, schoolhouse lighting, schoolhouse stem mount, schoolhouse pendant lighting, schoolhouse stem mount pendant, schoolhouse stem mount pendant lighting, ceiling light, schoolhouse ceiling light, schoolhouse ceiling pendant, pendant lighting, schoolhouse pendant lighting, school house light, school house lighting, school house ceiling light, schoolhouse shade, school house shade, Dean, Dean Schoolhouse Light, Dean Schoolhouse Stem Mount Light, Primary, Primary Pendant, Primary Pendants, Primary Pendant Light, Primary Pendant Lights, Primary Pendant Lighting, Primary Pendant, Primary Pendant Light, Primary Pendant Lights, Primary Pendant Lighting, primary, primary stem mount, primary stem mounts, primary stem, stem mount primary, primery, primry, scolhouse, school house stem, schoolhouse stem, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, glass LED lighting, glass LED lighting fixture, glass LED lighting fixtures, glass LED shade, glass LED shades, glass shade LED light, glass shade LED lights, glass shade LED lighting, glass LED globe, glass LED globes, glass LED globe shade, glass LED globe shades, glass globe LED light, glass globe LED lighting, glass globe shade LED light, glass globe shade LED lights, glass globe shade LED lighting, glass LED light fixture, glass LED light fixtures, LED glass lighting, LED glass lighting fixture, LED glass lighting fixtures, LED glass shade, LED glass shades, LED glass shade light, LED glass shade lights, LED glass shade lighting, LED glass globe, LED glass globes, LED glass globe shade, LED glass globe shades, LED glass globe light, LED glass globe lighting, LED glass globe shade light, LED glass globe shade lights, LED glass globe shade lighting, LED glass light fixture, LED glass light fixtures, glass LED pendant light, glass LED pendant lights, glass LED pendant lighting, glass LED pendant light fixture, glass LED pendant light fixtures, glass LED pendant lighting fixture, glass LED pendant lighting fixtures, glass shade LED pendant light, glass shade LED pendant lights, glass shade LED pendant lighting, glass globe LED pendant light, glass globe LED pendant lighting, glass globe LED pendant lighting, glass globe LED pendant lights, glass globe shade LED pendant light, glass globe shade LED pendant lights, glass globe shade LED pendant lighting, glass LED ceiling light, glass LED ceiling lights, glass LED ceiling lighting, glass LED ceiling lighting fixture, glass LED ceiling lighting fixtures, glass shade LED ceiling light, glass shade LED ceiling lights, glass shade LED ceiling lighting, glass globe LED ceiling light, glass globe LED ceiling lighting, glass globe shade LED ceiling light, glass globe shade LED ceiling lights, glass globe shade LED ceiling lighting, glass LED ceiling light fixture, glass LED ceiling light fixtures, glass LED ceiling pendant, glass LED ceiling pendants, glass shade LED ceiling pendant, glass shade LED ceiling pendants, glass globe LED ceiling pendant, glass globe LED ceiling pendants, glass globe shade LED ceiling pendant, glass globe shade LED ceiling pendants, LED glass pendant light, LED glass pendant lights, LED glass pendant lighting, LED glass pendant light fixture, LED glass pendant light fixtures, LED glass pendant lighting fixture, LED glass pendant lighting fixtures, LED glass shade pendant light, LED glass shade pendant lights, LED glass shade pendant lighting, LED glass globe pendant light, LED glass globe pendant lighting, LED glass globe pendant lighting, LED glass globe pendant lights, LED glass globe shade pendant light, LED glass globe shade pendant lights, LED glass globe shade pendant lighting, LED glass ceiling light, LED glass ceiling lights, LED glass ceiling lighting, LED glass ceiling lighting fixture, LED glass ceiling lighting fixtures, LED glass shade ceiling light, LED glass shade ceiling lights, LED glass shade ceiling lighting, LED glass globe ceiling light, LED glass globe ceiling lighting, LED glass globe shade ceiling light, LED glass globe shade ceiling lights, LED glass globe shade ceiling lighting, LED glass ceiling light fixture, LED glass ceiling light fixtures, LED glass ceiling pendant, LED glass ceiling pendants, LED glass shade ceiling pendant, LED glass shade ceiling pendants, LED glass globe ceiling pendant, LED glass globe ceiling pendants, LED glass globe shade ceiling pendant, LED glass globe shade ceiling pendants, BLE-S-SCH10, BLE-S-SCH14, BLE-S-SCHCL10, BLE-S-SCHCL14, Pendant schoolhouse, glass pendant, Schoolhouse pendant glass, School house pendant light with stripes, sch, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0069, SPS0069, SPS 0069, primary school house stem, primary schoolhouse stem, stems, Stem pendant lights, stem light mount, stem light mounts, stem, school light, school lights, school lighting, school, Schoolhouse primary, Schoolhouse fixture, Schoolhouse fixtures, Schoolhouse light fixture, Schoolhouse light fixtures, striped schoolhouse, striped schoolhouse light,
61329 schoolhouse light with stripe, classic striped schoolhouse light, schoolhouse light with painted band, painted schoolhouse light, hand painted light shades, flush mount schoolhouse-fixture This flush mount schoolhouse light features clean, utilitarian lines and multiple colorful customization options. Add retro flair with hand-painted bands! Intermediate Schoolhouse Semi-Flush Mount Light, schoolhouse, semi flush mount, semi flush, painted shade, striped, striped lampshade, painted, lined, vintage, ceiling lights, school house, BLE-FSF-SCH-PC, schoolhouse lighting, schoolhouse flush mount, schoolhouse semi flush mount, schoolhouse shade, schoolhouse light, schoolhouse ceiling light, flush mount ceiling light, schoolhouse flush mount ceiling light, ceiling light schoolhouse, ceiling lighting, schoolhouse ceiling lighting, Principal, Principal Schoolhouse Light, The Principal Schoolhouse Light, Principal Schoolhouse, Principal Schoolhouse Light, Intermediate, The Intermediate, Intermediate, intermidiate, intermedite, intermedate, schoolhouse flush, school house flush, school house, flush schoolhouse, flush school house, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Semi-Flush Mount Light, Primary Schoolhouse Flush Mount Light, Primary Schoolhouse Light, Primary Schoolhouse Semi-Flush LightPrimary Schoolhouse Semi-Flush Mount, Primary Schoolhouse Semi-Flush Mounts, Primary Semi-Flush Mount Light, Primary Flush Mount, Primary Schoolhouse Semi Flush Mount Light, Primary Semi Flush Mount Light, Primary Schoolhouse Semi Flush Mount, semi-flush schoolhouse, semi flush schoolhouse, semi-flush schoolhouse light, semi flush schoolhouse light, semi-flush schoolhouse, semi flush schoolhouse, semi-flush schoolhouse light, semi flush schoolhouse light, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, BLE-FSF-SCH10, BLE-FSF-SCH14, BLE-FSF-SCHCL10, BLE-FSF-SCHCL14, glass pendant, semi flush primary, semi-flush primary, Schoolhouse pendant glass, School house pendant light with strips, sch, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0069, SPS0069, SPS 0069, Flush mount school house, Flush mount schoolhouse, natural metals, natural metal, Semi flush light, Semi flush lights, Semi flush lighting, Small mount lighting, Small mount light, Small mount lights, Flushmount schoolhouse lights, Flush mount schoolhouse lights, foyer light, foyer lights, foyer lighting, school light, school lights, school lighting, school, Schoolhouse primary, Schoolhouse fixture, Schoolhouse fixtures, Schoolhouse light fixture, Schoolhouse light fixtures, ceiling flush mount, milk glass ceiling mount, striped schoolhouse, striped schoolhouse light,
61622 gooseneck arm chandelier, decorative globe chandelier, schoolhouse chandelier with colorful bands, schoolhouse chandelier, school house chandelier fixture, american made schoolhouse lighting, period arts chandelier Schoolhouse lights at its best! Handcrafted by local artisans, our Primary Schoolhouse Chandelier casts a nostalgic glow in your home’s interior. BLE-S-SCH-CH007, The Alma Mater Schoolhouse Chandelier, Alma Mater, schoolhouse chandelier, schoolhouse lighting, schoolhouse chandelier lighting, chandelier lighting, chandelier light, schoolhouse ceiling light, ceiling light, chandelier ceiling light, chandeliers, schoolhouse chandeliers, alma mater schoolhouse, alma mater schoolhouse lighting, 4-light chandelier, four light chandelier, 4-light chandelier lighting, four light chandelier lighting, schoolhouse 4-light, schoolhouse four light, Senior, Senior Schoolhouse, Senior schoolhouse light, senior schoolhouse chandelier, S-CH007, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary 4-Light Schoolhouse Chandelier, Primary 4 Light Schoolhouse Chandelier Primary four Light Schoolhouse Chandelier, Primary Schoolhouse chandelier, schoolhouse chandelier, Primary 4-Light School house Chandelier, Primary 4 Light School house Chandelier Primary four Light School house Chandelier, Primary School house chandelier, school house chandelier, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, glass chandelier, glass chandeliers, glass shade chandelier, glass shade chandeliers, glass globe chandelier, glass globe chandeliers, BLE-S-CH007-SCH10, BLE-S-CH007-SCH14, BLE-S-CH007-SCHCL10, BLE-S-CH007-SCHCL14, Schoolhouse pendant chandelier, Schoolhouse pendant chandeliers, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, School house chandelier collection, school house chandelier series, Schoolhouse chandelier collection, schoolhouse chandelier series, Primary schoolhouse chandelier collection, primary schoolhouse chandelier series, SPS-0172, SPS 0172, SPS0172, striped schoolhouse, striped schoolhouse light,