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 (60978, 60975, 60981, 61621) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00060

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 (60978,60975,60981,61621) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
60975 modern barn light vanity sconce, vanity lighting, mud room wall sconce, rustic barn light sconce, rustic two light sconce, 2 light barn light sconce, rlm warehouse shade Add this bathroom wall light as a rustic vanity light with a modern touch. This double sconce bathroom light is sure to look great in your bathroom or closet. Austin Vanity Light, Vanity Light, Bathroom Light, Austin, 2-light, vanity sconce, Double sconce, Wall light, BLE-WVS2-WHA8-PC, BLE-WVS2-WHA10-PC, wall vanity, wall vanity light, wall vanity, wall vanity light, austin 2-light, austin vanity, austin vanity sconce, austin vanity wall sconce, austin 2-light vanity sconce, austin 2-light vanity wall sconce, BLE-WSV2-WHA8, BLE-WSV2-WHA10, esso vanity, Vanity lightdouble sconce, Vanity light double sconce, vanity, bath light, bath lights, bath lighting, bath sconce, bath wall sconce, bath sconces, bath sconces, bath wall sconces, bath sconce light, bath sconce lights, bath sconce lighting, bathroom light, bathroom lights, bathroom lighting, bathroom sconce, bathroom wall sconce, bathroom sconces, bathroom sconces, bathroom wall sconces, bathroom sconce light, bathroom sconce lights, bathroom sconce lighting, bath room light, bath room lights, bath room lighting, bath room sconce, bath room wall sconce, bath room sconces, bath room sconces, bath room wall sconces, bath room sconce light, bath room sconce lights, bath room sconce lighting, Austin series, austin collection the austin series, the austin collection, SPS-0035, SPS 0035, SPS0035, SPS-0031, SPS 0031, SPS0031, Vintage green farmhouse vanity, Vintage green farm house vanity, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, double light wall sconces, vanity plates, vanity double sconce,
60978 2 light vanity sconce, vanity light, bathroom wall light, bathroom wall light, double barn sconce, double vanity, bathroom vanity light, bathroom barn lighting, shabby chic bathroom lighting, shabby chic bathroom lighting With plenty of curves and shabby chic styling, the Union 2-Light Vanity Sconce adds ample illumination with refined, barn light fixtures. Elevate any bathroom or powder room! Universal Vanity Light, Vanity Light, 2 light, vanity sconce, Bathroom Light, double sconce, Vanity, BLE-W-WHUVL10-PC, 2 light vanity sconce, vanity light, bathroom wall light, bathroom wall light, double barn sconce, double vanity, bathroom vanity light, bathroom barn lighting, shabby chic bathroom lighting, shabby chic bathroom lighting, BLE-WVS2-WHU10, wall vanity, wall vanity light, 2-light vanity, 2 light vanity, two light vanity, 2-light vanity sconce, 2 light vanity sconce, two light vanity sconce, 2-light vanity light, 2 light vanity light, two light vanity light, two light vanity wall sconce, two light vanity, vanity, Vanity lightdouble sconce, Vanity light double sconce, bath light, bath lights, bath lighting, bath sconce, bath wall sconce, bath sconces, bath sconces, bath wall sconces, bath sconce light, bath sconce lights, bath sconce lighting, bathroom light, bathroom lights, bathroom lighting, bathroom sconce, bathroom wall sconce, bathroom sconces, bathroom sconces, bathroom wall sconces, bathroom sconce light, bathroom sconce lights, bathroom sconce lighting, bath room light, bath room lights, bath room lighting, bath room sconce, bath room wall sconce, bath room sconces, bath room sconces, bath room wall sconces, bath room sconce light, bath room sconce lights, bath room sconce lighting, union series, union collection, the union series, the union collection, SPS-0410, SPS 0410, SPS0410, Vintage green farmhouse vanity, Vintage green farm house vanity, Wall mount sconce, wall mount sconces, sconce wall mount, sconce wall mounted, wall mount light, wall mount lights, wall mount lighting, wall mounted light, wall mounted lights, wall mounted lighting, wall mount sconce light, wall mount sconce lights, wall mount sconce lighting, wall mounted sconce light, wall mounted sconce lights, wall mounted sconce lighting, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, 10 inch, 10 inch shade, 10" shade, Union 2 light Vanity, Union 2 light Vanity sconce, double light wall sconces, vanity plates, vanity double sconce,
60981 wesco, wilcox, 2 light vanity sconce, vanity lighting, barn bathroom lighting, double barn light sconce, modern deep bowl bathroom light, deep bowl shade light fixture, bathroom wall light, wall light for bathroom, Wilcox 2-Light Vanity Sconce, vanity lig Looking for bathroom lighting? This double sconce vanity light has a modern touch with its deep bowl shades, perfect bathroom wall light. Wesco Vanity Light, Wesco, 2 light, vanity sconce, Vanity Light, Vanity, Bathroom Light, Bathroom, Wall light, double sconce, BLE-WVS2-DBW-PC, wesco, 2 light vanity sconce, vanity lighting, barn bathroom lighting, double barn light sconce, modern deep bowl bathroom light, deep bowl shade light fixture, bathroom wall light, wall light for bathroom, BLE-WVS2-DBW8-PC, BLE-WVS2-DBW10-PC, wall vanity, wall vanity light, wilcox 2-light vanity, wilcox vanity, wilcox 2, wilcox double vanity, deep bowl vanity, wesco, wilcox, 2 light vanity sconce, vanity lighting, barn bathroom lighting, double barn light sconce, modern deep bowl bathroom light, deep bowl shade light fixture, bathroom wall light, wall light for bathroom, Wilcox 2-Light Vanity Sconce, vanity light, 2-light vanity light, Wesco 2-Light Vanity Sconce, wesco 2-light, wesco 2 light, BLE-WVS2-DBW8, BLE-WVS2-DBW10, Vanity lightdouble sconce, Vanity light double sconce, vanity, bath light, bath lights, bath lighting, bath sconce, bath wall sconce, bath sconces, bath sconces, bath wall sconces, bath sconce light, bath sconce lights, bath sconce lighting, bathroom light, bathroom lights, bathroom lighting, bathroom sconce, bathroom wall sconce, bathroom sconces, bathroom sconces, bathroom wall sconces, bathroom sconce light, bathroom sconce lights, bathroom sconce lighting, bath room light, bath room lights, bath room lighting, bath room sconce, bath room wall sconce, bath room sconces, bath room sconces, bath room wall sconces, bath room sconce light, bath room sconce lights, bath room sconce lighting, SPS-0286, SPS 0286, SPS0286, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, wilcox bowl, double light wall sconces, vanity plates, vanity double sconce, classic deep bowl shade,
61621 three light vanity lighting, 3-light schoolhouse sconce, glass globe vanity light, american made lighting, light fixture for bathroom, mirror lighting, vintage inspired lighting, schoolhouse mirror light The Primary lights up your bathroom and powder room with schoolhouse flair! Three glass globes with painted bands hang from curved arms! Graduate 3-Light Schoolhouse Vanity Light, BLE-W-SCH10-36VAN, Graduate, schoolhouse sconce, schoolhouse vanity light, Sophomore, sophomore schoolhouse, sophomore vanity light, sophomore schoolhouse light, the sophomore schoolhouse, the sophomore vanity light, the sophomore schoolhouse light, Primary Schoolhouse Sconce, Primary Schoolhouse Wall Sconce, Primary School house Sconce, Primary School house Wall Sconce, Primary Schoolhouse Sconce Light, Primary School house Sconce Light, Primary Sconce, Primary Sconces, Primary Sconce Light, Primary 3-Light Schoolhouse Vanity Light, Primary 3 Light Schoolhouse Vanity Light, Primary three Light Schoolhouse Vanity Light, Primary 3-Light Schoolhouse Vanity sconce, Primary 3-Light Schoolhouse Vanity Wall Sconce, Primary Schoolhouse Vanity Light, Primary Schoolhouse Vanity Sconce, Primary Schoolhouse Vanity Wall Sconce, Primary Vanity Light, Primary Vanity Sconce, Primary Vanity Wall Sconce, wall vanity, wall vanity light, glass wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass sconce, glass sconce fixture, glass sconce fixtures, glass wall sconce, glass wall sconce fixture, glass wall sconce fixtures, glass shade sconce, glass shade wall sconce, glass sconce light, glass shade sconce light, glass globe sconce, glass globe wall sconce, glass globe wall sconces, glass globe sconce light, glass shade sconce, glass shade sconces, glass shade wall sconce, glass shade wall sconces, glass shade sconce 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, BLE-W-SCH10-36VAN, BLE-W-SCHCL10-36VAN, 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-0324, SPS 0324, SPS0324, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, vanity plates, striped schoolhouse, striped schoolhouse light,