SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = 'M', 
      CONCAT(
        cscart_products_categories.category_id, 
        'M'
      ), 
      cscart_products_categories.category_id
    )
  ) as category_ids, 
  popularity.total as popularity, 
  IF(
    shared_prices.product_id IS NOT NULL, 
    MIN(
      IF(
        shared_prices.percentage_discount = 0, 
        shared_prices.price, 
        shared_prices.price - (
          shared_prices.price * shared_prices.percentage_discount
        )/ 100
      )
    ), 
    MIN(
      IF(
        cscart_product_prices.percentage_discount = 0, 
        cscart_product_prices.price, 
        cscart_product_prices.price - (
          cscart_product_prices.price * cscart_product_prices.percentage_discount
        )/ 100
      )
    )
  ) as price, 
  companies.company as company_name, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id 
  AND shared_prices.company_id = 1 
  AND shared_prices.lower_limit = 1 
  AND shared_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.company_id = 1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 1900 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 64355 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = 1 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
WHERE 
  cscart_products.product_id = 64355 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00160

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "shared_prices",
      "access_type": "system",
      "possible_keys": [
        "usergroup",
        "product_id",
        "company_id",
        "lower_limit",
        "usergroup_id"
      ],
      "rows": 0,
      "filtered": 0,
      "const_row_not_found": true
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "status"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "companies",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["company_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "popularity",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "total"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_sales",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "pa"],
      "key": "PRIMARY",
      "key_length": "6",
      "used_key_parts": ["category_id", "product_id"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_prices",
      "access_type": "range",
      "possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
      "rowid_filter": {
        "range": {
          "key": "lower_limit",
          "used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
        },
        "rows": 2,
        "selectivity_pct": 0.074128984
      },
      "rows": 2,
      "filtered": 100,
      "attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 64355 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_products_categories",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "pt"],
      "key": "pt",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 9,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "c_status", "p_category_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["category_id"],
      "ref": ["cscart_migrate.cscart_products_categories.category_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "cscart_categories.company_id = 1 and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "dispatch",
      "key_length": "210",
      "used_key_parts": [
        "dispatch",
        "object_id",
        "type",
        "lang_code",
        "company_id"
      ],
      "ref": ["const", "const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_discussion",
      "access_type": "ref",
      "possible_keys": ["object_id"],
      "key": "object_id",
      "key_length": "6",
      "used_key_parts": ["object_id", "object_type"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
    }
  }
}

Result

product_id product_code product_type trustmark_origin trustmark_certified trustmark_leadtime trustmark_location trustmark_return owner_id status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params updated_timestamp pricing_note use_new_layout category_image tax_code upc_code product_detail_ids nav_sku sku_columns nav_review_user_id hide_price vendor_fulfilled hide_commercial_price non_returnable ble_basics commercial_hidden allow_configurator enable_customize enable_buy_american base_cost redline_p lang_code product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message internal promo_text price category_ids popularity company_name sales_amount seo_name seo_path discussion_type
64355 BLE-L-WL-DME P E C M A A 0 A 1 443.00 1000 0.000 0 0 0 0.00 0 1513178930 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 1747931668 Price increased by $39 - DC 5/6/20 Price increased 5% from $320 to $336 - DC 5/25/21 Price increased 10% from $336 to $370 - DC 5/24/22 Price decreased from $370 to $365 - DM 9/28/23 Price increased from $365 to $443 - DM 11/28/23 Y none none 600,3254 BLE-L-WL-DME {"22685":1,"22690":2} 1008383 0 0 0 0 0 0 0 0 1 0.00 0 en Downtown Swing Arm Plug-In Wall Sconce <p>To help every room feel completely different and highly fashionable, the Downtown Swing Arm’s eye-catching minimalist design includes a convenient plug-in cord. Because of its straightforward installation and lack of hardwiring, the Downtown offers a simple method of imparting personality to rental houses and apartments.  With sconces flanking the headboard in master bedrooms and couches in living spaces, rooms are imbued with a distinguishing look. When mounted above desks and work stations, the Downtown functions as a unique task light for offices.</p> <p>Unobstructed by a shade, the bright light emanated by the bare bulb socket supplies warmth and general illumination to undersized locations. Several different customization options—a swivel knuckle for greater adjustability, an extended arm, and a variety of finish colors—assures this swing arm sconce can reflect any space’s specific needs!</p> <p>|break|</p> <ul> <li>Manufactured in the U.S.A.</li> <li><span>This light fixture is made-to-order to suit your custom specifications. Learn more about the process </span><a href="https://www.barnlight.com/behind-the-scenes-video-footage/" target="_blank">here</a><span>!</span></li> <li>Read more about our Downtown Swing Arm Plug-In Sconce over on our <a href="/inspiration/swing-arm-sconces-put-the-fun-in-functional-wall-lighting/" target="_blank">blog</a>!</li> </ul> Portable and easy to install, this plug-in wall sconce is the perfect lighting for apartments and rental houses! Fully customizable and made in the USA! The Downtown Swing Arm Plug-In Sconce, The Downtown Swing Arm Plug-In Sconces, The Downtown Swing Arm Plug-In Wall Sconce, The Downtown Swing Arm Plug-In Wall Sconces, The Downtown Swing Arm Plug-In Sconce Light, The Downtown Swing Arm Plug-In Sconce Lights, The Downtown Swing Arm Plug-In Sconce Lighting, The Downtown Swing Arm Plug-In Wall Light, The Downtown Swing Arm Plug-In Wall Lights, The Downtown Swing Arm Plug-In Wall Lighting, The Downtown Plug-In Swing Arm Sconce, The Downtown Plug-In Swing Arm Sconces, The Downtown Plug-In Swing Arm Wall Sconce, The Downtown Plug-In Swing Arm Wall Sconces, The Downtown Plug-In Swing Arm Sconce light, The Downtown Plug-In Swing Arm Sconce lights, The Downtown Plug-In Swing Arm Sconce lighting, The Downtown Plug-In Swing Arm Wall light, The Downtown Plug-In Swing Arm wall lights, The Downtown Plug-In Swing Arm wall lighting, The Downtown Swing Arm Plug In Sconce, The Downtown Swing Arm Plug In Sconces, The Downtown Swing Arm Plug In Wall Sconce, The Downtown Swing Arm Plug In Wall Sconces, The Downtown Swing Arm Plug In Sconce Light, The Downtown Swing Arm Plug In Sconce Lights, The Downtown Swing Arm Plug In Sconce Lighting, The Downtown Swing Arm Plug In Wall Light, The Downtown Swing Arm Plug In Wall Lights, The Downtown Swing Arm Plug In Wall Lighting, The Downtown Plug In Swing Arm Sconce, The Downtown Plug In Swing Arm Sconces, The Downtown Plug In Swing Arm Wall Sconce, The Downtown Plug In Swing Arm Wall Sconces, The Downtown Plug In Swing Arm Sconce light, The Downtown Plug In Swing Arm Sconce lights, The Downtown Plug In Swing Arm Sconce lighting, The Downtown Plug In Swing Arm Wall light, The Downtown Plug In Swing Arm wall lights, The Downtown Plug In Swing Arm wall lighting, The Downtown Plug-In Sconce, The Downtown Plug-In Sconces, The Downtown Plug-In Wall Sconce, The Downtown Plug-In Wall Sconces, The Downtown Plug-In Sconce Light, The Downtown Plug-In Sconce Lights, The Downtown Plug-In Sconce Lighting, The Downtown Plug-In Wall Light, The Downtown Plug-In Wall Lights, The Downtown Plug-In Wall Lighting, The Downtown Plug In Sconce, The Downtown Plug In Sconces, The Downtown Plug In Wall Sconce, The Downtown Plug In Wall Sconces, The Downtown Plug In Sconce Light, The Downtown Plug In Sconce Lights, The Downtown Plug In Sconce Lighting, The Downtown Plug In Wall Light, The Downtown Plug In Wall Lights, The Downtown Plug In Wall Lighting, Downtown Swing Arm Plug-In Sconce, Downtown Swing Arm Plug-In Sconces, Downtown Swing Arm Plug-In Wall Sconce, Downtown Swing Arm Plug-In Wall Sconces, Downtown Swing Arm Plug-In Sconce Light, Downtown Swing Arm Plug-In Sconce Lights, Downtown Swing Arm Plug-In Sconce Lighting, Downtown Swing Arm Plug-In Wall Light, Downtown Swing Arm Plug-In Wall Lights, Downtown Swing Arm Plug-In Wall Lighting, Downtown Plug-In Swing Arm Sconce, Downtown Plug-In Swing Arm Sconces, Downtown Plug-In Swing Arm Wall Sconce, The Downtown Plug-In Swing Arm Wall Sconces, Downtown Plug-In Swing Arm Sconce light, Downtown Plug-In Swing Arm Sconce lights, Downtown Plug-In Swing Arm Sconce lighting, Downtown Plug-In Swing Arm Wall light, Downtown Plug-In Swing Arm wall lights, Downtown Plug-In Swing Arm wall lighting, Downtown Swing Arm Plug In Sconce, Downtown Swing Arm Plug In Sconces, Downtown Swing Arm Plug In Wall Sconce, Downtown Swing Arm Plug In Wall Sconces, Downtown Swing Arm Plug In Sconce Light, Downtown Swing Arm Plug In Sconce Lights, Downtown Swing Arm Plug In Sconce Lighting, Downtown Swing Arm Plug In Wall Light, Downtown Swing Arm Plug In Wall Lights, Downtown Swing Arm Plug In Wall Lighting, Downtown Plug In Swing Arm Sconce, Downtown Plug In Swing Arm Sconces, Downtown Plug In Swing Arm Wall Sconce, Downtown Plug In Swing Arm Wall Sconces, Downtown Plug In Swing Arm Sconce light, Downtown Plug In Swing Arm Sconce lights, Downtown Plug In Swing Arm Sconce lighting, Downtown Plug In Swing Arm Wall light, Downtown Plug In Swing Arm wall lights, Downtown Plug In Swing Arm wall lighting, Downtown Plug-In Sconce, Downtown Plug-In Sconces, Downtown Plug-In Wall Sconce, Downtown Plug-In Wall Sconces, Downtown Plug-In Sconce Light, Downtown Plug-In Sconce Lights, Downtown Plug-In Sconce Lighting, Downtown Plug-In Wall Light, Downtown Plug-In Wall Lights, Downtown Plug-In Wall Lighting, Downtown Plug In Sconce, Downtown Plug In Sconces, Downtown Plug In Wall Sconce, Downtown Plug In Wall Sconces, Downtown Plug In Sconce Light, Downtown Plug In Sconce Lights, Downtown Plug In Sconce Lighting, Downtown Plug In Wall Light, swing out light, Downtown Plug In Wall Lights, Downtown Plug In Wall Lighting, downtown, down town, down town minimalist, downtown minimalist, The Downtown Swing Arm Sconce, The Downtown Swing Arm Sconces, The Downtown Swing Arm Wall Sconce, The Downtown Swing Arm Wall Sconces, Downtown Swing Arm Sconce, Downtown Swing Arm Sconces, Downtown Swing Arm Wall Sconce, Downtown Swing Arm Wall Sconces, The Downtown Minimalist Swing Arm Sconce, The Downtown Minimalist Swing Arm Sconces, The Downtown Minimalist Swing Arm Wall Sconce, The Downtown Minimalist Swing Arm Wall Sconces, Downtown Minimalist Swing Arm Sconce, Downtown Minimalist Swing Arm Sconces, Downtown Minimalist Swing Arm Wall Sconce, Downtown Minimalist Swing Arm Wall Sconces, The Minimalist Swing Arm Sconce, The Minimalist Swing Arm Sconces, The Minimalist Swing Arm Wall Sconce, The Minimalist Swing Arm Wall Sconces, Minimalist Swing Arm Sconce, Minimalist Swing Arm Sconces, Minimalist Swing Arm Wall Sconce, Minimalist Swing Arm Wall Sconces, The Swing Arm Sconce, The Swing Arm Sconces, The Swing Arm Wall Sconce, The Swing Arm Wall Sconces, Swing Arm Sconce, Swing Arm Sconces, Swing Arm Wall Sconce, Swing Arm Wall Sconces, Swing Arm, Swing Arm Light, Swing Arm Lights, Swing Arm Lighting, Swing Arm Wall Light, Swing Arm Wall lights, swing arm wall lighting, Adjustable sconce, adjustable sconces, adjustable wall sconce, adjustable wall sconces, adjustable light, adjustable lights, adjustable lighting, adjustable wall light, adjustable wall lights, adjustable wall lighting, Bare bulb sconce, bare bulb sconces, bare bulb, bare bulb wall sconce, bare bulb wall sconces, bare bulb light, bare bulb lights, bare bulb lighting, bare bulb wall light, bare bulb wall lights, bare bulb wall lighting, bare bulb socket, bare bulb socket, Minimalist swing arm light, minimalist swing arm lights, minimalist swing arm lighting, Minimalist swing arm wall light, minimalist swing arm wall lights, minimalist swing arm wall lighting, The Downtown Swing Arm Light, The Downtown Swing Arm Lights, The Downtown Swing Arm Lighting, The Downtown Swing Arm Wall Light, The Downtown Swing Arm Wall Lights, The Downtown Swing Arm Wall Lighting, extended arm sconce, extended arm sconces, extended arm wall sconce, extended arm wall sconces, extended arm, BLE-L-WL009-PC, downtown swing arm, BLE-LWL-DME, swing arm, swingarm, swingarm, swingarm sconce, swingarm light, swingarm lights, swing arm light, swing arm lights, bare bulb adjustable sconce, adjustable bare bulb sconce, bare bulb adjustable sconces, adjustable bare bulb sconces, bare bulb adjustable wall sconce, adjustable bare bulb wall sconce, bare bulb adjustable wall sconces, adjustable bare bulb wall sconces, bare bulb adjustable sconce light, adjustable bare bulb sconce light, bare bulb adjustable sconce lights, adjustable bare bulb sconce lights, bare bulb adjustable sconce lighting, adjustable bare bulb sconce lighting, bare bulb adjustable sconce light fixture, adjustable bare bulb sconce light fixture, bare bulb adjustable sconce light fixtures, adjustable bare bulb sconce light fixtures, bare bulb adjustable sconce lighting fixture, adjustable bare bulb sconce lighting fixtures, bare bulb swing arm sconce, swing arm bare bulb sconce, bare bulb swing arm sconces, swing arm bare bulb sconces, bare bulb swing arm wall sconce, swing arm bare bulb wall sconce, bare bulb swing arm wall sconces, swing arm bare bulb wall sconces, bare bulb swing arm sconce light, swing arm bare bulb sconce light, bare bulb swing arm sconce lights, swing arm bare bulb sconce lights, bare bulb swing arm sconce lighting, swing arm bare bulb sconce lighting, bare bulb swing arm sconce light fixture, swing arm bare bulb sconce light fixture, bare bulb swing arm sconce light fixtures, swing arm bare bulb sconce light fixtures, bare bulb swing arm sconce lighting fixture, swing arm bare bulb sconce lighting fixtures, Bare bulb sconce, bare bulb sconces, bare bulb wall sconce, bare bulb wall sconces, bare bulb sconce light, bare bulb sconce lights, bare bulb sconce lighting, bare bulb sconce light fixture, bare bulb sconce light fixtures, bare bulb sconce lighting fixture, bare bulb sconce lighting fixtures, Bare bulb wall light, wall light bare bulb, bare bulb wall lights, bare bulb wall lighting, bare bulb wall light fixture, bare bulb wall light fixtures, bare bulb wall lighting fixture, bare bulb wall fixture, bare bulb wall fixtures, Bare bulb light, bare bulb lights, bare bulb lighting, bare bulb light fixture, bare bulb light fixtures, bare bulb lighting fixture, bare bulb lighting fixtures, Bare bulb plug in, bare bulb plug-in, plug in bare bulb, plug-in bare bulb, Bare bulb plug in sconce, bare bulb plug-in sconce, plug in bare bulb sconce, plug-in bare bulb sconce, Bare bulb plug in wall sconce, bare bulb plug-in wall sconce, plug in bare bulb wall sconce, plug-in bare bulb wall sconce, Bare bulb plug in sconces, bare bulb plug-in sconces, plug in bare bulb sconces, plug-in bare bulb sconces, Bare bulb plug in wall sconces, bare bulb plug-in wall sconces, plug in bare bulb wall sconces, plug-in bare bulb wall sconces, Bare bulb plug in sconce light, bare bulb plug-in sconce light, plug in bare bulb sconce light, plug-in bare bulb sconce light, Bare bulb plug in sconce lights, bare bulb plug-in sconce lights, plug in bare bulb sconce lights, plug-in bare bulb sconce lights, Bare bulb plug in sconce lighting, bare bulb plug-in sconce lighting, plug in bare bulb sconce lighting, plug-in bare bulb sconce lighting, Bare bulb plug in sconce light fixture, bare bulb plug-in sconce light fixture, plug in bare bulb sconce light fixture, plug-in bare bulb sconce light fixture, Bare bulb plug in sconce light fixtures, bare bulb plug-in sconce light fixtures, plug in bare bulb sconce light fixtures, plug-in bare bulb sconce light fixtures, Bare bulb plug in sconce lighting fixture, bare bulb plug-in sconce lighting fixture, plug in bare bulb sconce lighting fixture, plug-in bare bulb sconce lighting fixture, Bare bulb plug in sconce lighting fixtures, bare bulb plug-in sconce lighting fixtures, plug in bare bulb sconce lighting fixtures, plug-in bare bulb sconce lighting fixtures, swing at plug in, sconce plug in, sconce plug-in, wall sconce plug in, wall sconce plug-in, plug wall sconce, plug sconce, plug wall sconces, plug sconces, wall lamps with plugs, wall lamp with plugs, wall lamps with plug, wall lamp with plug, Downtown Collection, Downtown Series, The Downtown Collection, The Downtown Series, Down town Collection, Down town Series, The Down town Collection, The Down town Series, Minimalist collection, Minimalist series, The Minimalist collection, The Minimalist series, Downtown Minimalist Collection, Downtown Minimalist Series, The Downtown Minimalist Collection, The Downtown Minimalist Series, Down town Minimalist Collection, Down town Minimalist Series, The Down town Minimalist Collection, The Down town Minimalist Series, SPS-0113, SPS 0113, SPS0113, swing arm collection, swing arm series, the swing arm collection, the swing arm series, adjustable arms, pastel, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, 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, Wall sconce with plug, sconce with plug, sconce light with plug, sconce lights with plug, reading lights, adjustable arm sconce, wall sconce downtown, wall reading lamps, swing sconce, plug in barn light, plug-in barn light, plug-in light, H-LC-A3B, H-LC, H-LC antique wall light, antique wall light, Downtown Swing Arm Plug-In Sconce | Barn Light Electric 443.000000 1531,1748,1795,1809,1832,1833,1899,1901,1900M 324132 Barn Light Electric Company 20 downtown-swing-arm-plug-in-sconce 1887/1896/1900 B