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 (64791, 65016, 64783, 64795) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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 (64791,65016,64783,64795) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64783 Modeled after vintage lighting, The Chicago Cord Hung Pendant is fully customizable and handcrafted to last for years. the chicago cord hung pendant light, the chicago, chicago cord hung pendant light, chicago pendant, cord hung pendant, vintage pendant lighting, warehouse lighting, factory lighting, BLE-C-OI, BLE-C-OI12, BLE-C-OI14, BLE-C-OI16, BLE-C-OI18, BLE-C-OI20, chicago, chicago vintage industrial, vintage industrial collection, new listing, new rlm, new vintage industrial, new chicago, BLE-C-OI12, BLE-C-OI14, BLE-C-OI16, BLE-C-OI18, BLE-C-OI20, 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, 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, The Chicago Vintage Industrial Cord Hung Pendant, Chicago Vintage Industrial Cord Hung Pendant, SPS-0023, SPS 0023, SPS0023, 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, Chicago collection, Chicago Series, The Chicago collection, the Chicago Series, 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, Chicago Series, The Chicago Series, Vintage industrial series, vintage industrial collection, The Vintage industrial series, The vintage industrial collection, Metropolis Series, Metropolitan Series, The Metropolis Series, The Metropolitan Series, jadeite, jadite, jadeite light, jadite light,
64791 We've recreated early 20th century explosion proof lighting with the stylish Cleveland Pendant! Customizable and American-made! the cleveland cord hung pendant light, cleveland cord hung pendant light, cleveland light, the cleveland, cord hung pendant lighting, vintage pendant lighting, factory lighting, explosion proof lighting, BLE-C-AI, BLE-C-AI12, BLE-C-AI14, BLE-C-AI16, cleveland, vintage industrial, vintage industrial collection, cleveland pendant, new vintage industrial, new cleveland, new listing, BLE-C-AI12, BLE-C-AI14, BLE-C-AI16, 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-0279, SPS 0279, SPS0279, 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, Cleveland collection, Cleveland Series, The Cleveland collection, the Cleveland Series, 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,
64795 Fully customizable and American made, this pendant contributes a rugged sense of style to any residential or commercial decor! the bridgeport cord hung pendant light, bridgeport cord hung pendant, pendant lighting,cord hung lighting, kitchen lighting, hallway lighting, BLE-C-MI, BLE-C12-MI, BLE-C14-MI, BLE-C16-MI, bridgeport, vintage industrial, vintage industrial collection, bridgeport pendant, new listing, new bridgeport, new vintage industrial, BLE-C-MI12, BLE-C-MI14, BLE-C-MI16, SPS-0280, SPS0280, SPS 0280, 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, Bridgeport collection, Bridgeport Series, The Bridgeport collection, the Bridgeport Series, Bridge port collection, Bridge port Series, The Bridge port collection, the Bridge port Series, 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,
65016 Meet the Rochester--a vintage-inspired, fully integrated LED light! This LED pendant is handcrafted in the USA and is fully customizable thanks to our full assortment of finishes, including marine grade! the rochester LED cord hung pendant light, rochester LED cord hung pendant light, cord hung LED pendant lights, cord hung LED lighting, island lighting, corded lighting, LED rochester light, BLE-C-SI-LED, BLE-C-SI12-LED, BLE-C-SI14-LED, BLE-C-SI16-LED, BLE-C-SI18-LED, rochester, rochester led, vintage industrial, vintage industrial led, led vintage industrial, rocherster LED, BLE-C-SI12, BLE-C-SI14, BLE-C-SI16, BLE-C-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 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, LED Industrial light, LED industrial lights, LED industrial lighting, LED industrial lighting fixture, LED industrial lighting fixtures, LED rugged light, LED rugged lights, LED rugged lighting, LED rugged lighting fixture, LED rugged lighting fixtures, LED Vintage Industrial light, LED vintage industrial lights, LED vintage industrial lighting, LED vintage industrial lighting fixture, LED vintage industrial lighting fixtures, LED cast guard light, LED cast guard lights, LED cast guard lighting, LED cast guard lighting fixture, LED cast guard lighting fixtures, LED metropolis, LED metropolis collection, LED metropolis light, LED metropolis lights, LED metropolis lighting, Industrial LED light, industrial LED lights, industrial LED lighting, industrial LED lighting fixture, industrial LED lighting fixtures, rugged LED light, rugged LED lights, rugged LED lighting, rugged LED lighting fixture, rugged LED lighting fixtures, Vintage Industrial LED light, vintage industrial LED lights, vintage industrial LED lighting, vintage industrial LED lighting fixture, vintage industrial LED lighting fixtures, cast guard LED light, cast guard LED lights, cast guard LED lighting, cast guard LED lighting fixture, cast guard LED lighting fixtures, metropolis LED, metropolis LED collection, metropolis LED light, metropolis LED lights, metropolis LED lighting, LED industrial pendant, LED industrial pendants, LED industrial ceiling pendant, LED industrial ceiling pendants, LED industrial ceiling light, LED industrial ceiling lights, LED industrial ceiling lighting, industrial LED pendant, industrial LED pendants, industrial LED ceiling pendant, industrial LED ceiling pendants, industrial LED ceiling light, industrial LED ceiling lights, industrial LED ceiling lighting, LED rugged pendant, LED rugged pendants, LED rugged ceiling pendant, LED rugged ceiling pendants, LED rugged ceiling light, LED rugged ceiling lights, LED rugged ceiling lighting, rugged LED pendant, rugged LED pendants, rugged LED ceiling pendant, rugged LED ceiling pendants, rugged LED ceiling light, rugged LED ceiling lights, rugged LED ceiling lighting, LED cast guard pendant, LED cast guard pendants, LED cast guard ceiling pendant, LED cast guard ceiling pendants, LED cast guard ceiling light, LED cast guard ceiling lights, LED cast guard ceiling lighting, cast guard LED pendant, cast guard LED pendants, cast guard LED ceiling pendant, cast guard LED ceiling pendants, cast guard LED ceiling light, cast guard LED ceiling lights, cast guard LED ceiling lighting, LED rugged cord hung pendant, LED rugged cord hung pendants, LED rugged cord hung pendant light, LED rugged cord hung pendant lights, LED rugged cord hung pendant lighting, LED rugged cord hung ceiling pendant, LED rugged cord hung ceiling pendants, LED rugged cord hung pendant light, LED rugged cord hung pendant lights, LED rugged cord hung pendant lighting, LED rugged cord hung ceiling light, LED rugged cord hung ceiling lights, LED rugged cord hung ceiling lighting, LED rugged cord pendant, LED rugged cord pendants, LED rugged cord pendant light, LED rugged cord pendant lights, LED rugged cord pendant lighting, LED rugged cord ceiling pendant, LED rugged cord ceiling pendants, LED rugged cord pendant light, LED rugged cord pendant lights, LED rugged cord pendant lighting, LED rugged cord ceiling light, LED rugged cord ceiling lights, LED rugged cord ceiling lighting, rugged LED cord hung pendant, rugged LED cord hung pendants, rugged LED cord hung pendant light, rugged LED cord hung pendant lights, rugged LED cord hung pendant lighting, rugged LED cord hung ceiling pendant, rugged LED cord hung ceiling pendants, rugged LED cord hung pendant light, rugged LED cord hung pendant lights, rugged LED cord hung pendant lighting, rugged LED cord hung ceiling light, rugged LED cord hung ceiling lights, rugged LED cord hung ceiling lighting, rugged LED cord pendant, rugged LED cord pendants, rugged LED cord pendant light, rugged LED cord pendant lights, rugged LED cord pendant lighting, rugged LED cord ceiling pendant, rugged LED cord ceiling pendants, rugged LED cord pendant light, rugged LED cord pendant lights, rugged LED cord pendant lighting, rugged LED cord ceiling light, rugged LED cord ceiling lights, rugged LED cord ceiling lighting, LED cast guard cord hung pendant, LED cast guard cord hung pendants, LED cast guard cord hung pendant light, LED cast guard cord hung pendant lights, LED cast guard cord hung pendant lighting, LED cast guard cord hung ceiling pendant, LED cast guard cord hung ceiling pendants, LED cast guard cord hung pendant light, LED cast guard cord hung pendant lights, LED cast guard cord hung pendant lighting, LED cast guard cord hung ceiling light, LED cast guard cord hung ceiling lights, LED cast guard cord hung ceiling lighting, LED cast guard cord pendant, LED cast guard cord pendants, LED cast guard cord pendant light, LED cast guard cord pendant lights, LED cast guard cord pendant lighting, LED cast guard cord ceiling pendant, LED cast guard cord ceiling pendants, LED cast guard cord pendant light, LED cast guard cord pendant lights, LED cast guard cord pendant lighting, LED cast guard cord ceiling light, LED cast guard cord ceiling lights, LED cast guard cord ceiling lighting, cast guard LED cord hung pendant, cast guard LED cord hung pendants, cast guard LED cord hung pendant light, cast guard LED cord hung pendant lights, cast guard LED cord hung pendant lighting, cast guard LED cord hung ceiling pendant, cast guard LED cord hung ceiling pendants, cast guard LED cord hung pendant light, cast guard LED cord hung pendant lights, cast guard LED cord hung pendant lighting, cast guard LED cord hung ceiling light, cast guard LED cord hung ceiling lights, cast guard LED cord hung ceiling lighting, cast guard LED cord pendant, cast guard LED cord pendants, cast guard LED cord pendant light, cast guard LED cord pendant lights, cast guard LED cord pendant lighting, cast guard LED cord ceiling pendant, cast guard LED cord ceiling pendants, cast guard LED cord pendant light, cast guard LED cord pendant lights, cast guard LED cord pendant lighting, cast guard LED cord ceiling light, cast guard LED cord ceiling lights, cast guard LED cord ceiling lighting, 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, SPS-0480, SPS0480, SPS 0480, vintage industrial led collection, vintage industrial led series, the vintage industrial led collection, the vintage industrial led series, metropolis led collection, metropolis led series, the metropolis led collection, the metropolis led series, metropolitan led collection, metropolitan led series, the metropolitan led collection, the metropolitan led series, Rochester led collection, Rochester led Series, The Rochester led collection, the Rochester led Series,