Sandbox

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 = 1941 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 64152 
  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 = 64152 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00122

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 = 64152 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": 5,
      "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
64152	BLE-WVG3-RGU-LED	P	E	C	M	A	D	0	A	1	1262.00	1000	0.000	0	0	0	0.00	0	1486443600	0	N	N	N	D	N	R	N	N	N	Y	10	1486443600	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;}	1732212101	Price increased by $37 - DC 4/14/20 Price increased 5% from $1092 to $1147 - DC 6/1/21 Price increased 10% from $1147 to $1262 - DC 6/2/22	Y		none	none	1073,1074	BLE	{"23068":1,"23069":3,"23116":4,"22644":5}	1008383	0	0	0	1	0	0	0	0	1	0.00	0	en	Static Ring LED Triple Vanity Light			<p>Simplicity at its finest! Perched above sinks and vanities, this wall light imbues a distinguishing character to your bathroom as it brightens the space below. Influenced by vintage designs, this vanity sconce’s straightforward industrial style is favored in both contemporary and traditional décors. Three streamline guards, complete with charming glass inserts, establish this nearly universal appeal. By subtly displaying its rustic profile, the Stick Ring coordinates with a bathroom’s other decorative features to create a cohesive aesthetic. Numerous powder coat finishes and glass options let this vanity sconce adapt to any bathroom’s particular aesthetic.</p> <p>Outfitted with state-of-the-art LED modules, the Static Ring provides additional benefits beyond its memorable style. This LED vanity sconce efficiently converts electricity into light, greatly reducing a home or business’s overall energy demands. Define your bathroom’s look — and cut down on your power bills — with this vanity light!</p> <p>\|break\|</p> <ul> <li>This vanity light features three die casted guards and jelly jar glass!</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul>		Memorable style, efficient design. This vanity wall sconce shows off a timeless industrial style! A fully customizable vanity wall sconce!	BLE-WVS3-RGU-LED, Static Ring LED Triple Vanity Light, Static Ring LED Triple Vanity Lights, Static Ring LED Triple Vanity Lighting, The Static Ring LED Triple Vanity Light, The Static Ring LED Triple Vanity Lights, The Static Ring LED Triple Vanity Lighting, Static Ring LED Triple Vanity Wall Light, Static Ring LED Triple Vanity Wall Lights, Static Ring LED Triple Vanity Wall Lighting, The Static Ring LED Triple Vanity Wall Light, The Static Ring LED Triple Vanity Wall Lights, The Static Ring LED Triple Vanity Wall Lighting, Static Ring LED Triple Vanity Sconce, Static Ring LED Triple Vanity Sconces, Static Ring LED Triple Vanity Wall Sconce, Static Ring LED Triple Vanity Wall Sconces, Ring LED Triple Vanity Light, Ring LED Triple Vanity Lights, Ring LED Triple Vanity Lighting, The Ring LED Triple Vanity Light, The Ring LED Triple Vanity Lights, The Ring LED Triple Vanity Lighting, Ring LED Triple Vanity Wall Light, Ring LED Triple Vanity Wall Lights, Ring LED Triple Vanity Wall Lighting, The Ring LED Triple Vanity Wall Light, The Ring LED Triple Vanity Wall Lights, The Ring LED Triple Vanity Wall Lighting, Ring LED Triple Vanity Sconce, Ring LED Triple Vanity Sconces, Ring LED Triple Vanity Wall Sconce, Ring LED Triple Vanity Wall Sconces, Ring LED Vanity Light, Ring LED Vanity Lights, Ring LED Vanity Lighting, The Ring LED Vanity Light, The Ring LED Vanity Lights, The Ring LED Vanity Lighting, Ring LED Vanity Wall Light, Ring LED Vanity Wall Lights, Ring LED Vanity Wall Lighting, The Ring LED Vanity Wall Light, The Ring LED Vanity Wall Lights, The Ring LED Vanity Wall Lighting, Static LED Triple Vanity Light, Static LED Triple Vanity Lights, Static LED Triple Vanity Lighting, The Static LED Triple Vanity Light, The Static LED Triple Vanity Lights, The Static LED Triple Vanity Lighting, Static LED Triple Vanity Wall Light, Static LED Triple Vanity Wall Lights, Static LED Triple Vanity Wall Lighting, The Static LED Triple Vanity Wall Light, The Static LED Triple Vanity Wall Lights, The Static LED Triple Vanity Wall Lighting, Static LED Triple Vanity Sconce, Static LED Triple Vanity Sconces, Static LED Triple Vanity Wall Sconce, Static LED Triple Vanity Wall Sconces, Static LED Vanity Light, Static LED Vanity Lights, Static LED Vanity Lighting, The Static LED Vanity Light, The Static LED Vanity Lights, The Static LED Vanity Lighting, Static LED Vanity Wall Light, Static LED Vanity Wall Lights, Static LED Vanity Wall Lighting, The Static LED Vanity Wall Light, The Static LED Vanity Wall Lights, The Static LED Vanity Wall Lighting, LED Triple Vanity Light, LED Triple Vanity Lights, LED Triple Vanity Lighting, The LED Triple Vanity Light, The LED Triple Vanity Lights, The LED Triple Vanity Lighting, LED Triple Vanity Wall Light, LED Triple Vanity Wall Lights, LED Triple Vanity Wall Lighting, The LED Triple Vanity Wall Light, The LED Triple Vanity Wall Lights, The LED Triple Vanity Wall Lighting, LED Triple Vanity Sconce, LED Triple Vanity Sconces, LED Triple Vanity Wall Sconce, LED Triple Vanity Wall Sconces, LED Vanity Light, LED Vanity Lights, LED Vanity Lighting, The LED Vanity Light, The LED Vanity Lights, The LED Vanity Lighting, LED Vanity Wall Light, LED Vanity Wall Lights, LED Vanity Wall Lighting, The LED Vanity Wall Light, The LED Vanity Wall Lights, The LED Vanity Wall Lighting, Static Ring LED Vanity Light, Static Ring LED Vanity Lights, Static Ring LED Vanity Lighting, The Static Ring LED Vanity Light, The Static Ring LED Vanity Lights, The Static Ring LED Vanity Lighting, Static Ring LED Vanity Wall Light, Static Ring LED Vanity Wall Lights, Static Ring LED Vanity Wall Lighting, The Static Ring LED Vanity Wall Light, The Static Ring LED Vanity Wall Lights, The Static Ring LED Vanity Wall Lighting, Static Ring LED 3-light Vanity Light, Static Ring LED 3-light Vanity Lights, Static Ring LED 3-light Vanity Lighting, The Static Ring LED 3-light Vanity Light, The Static Ring LED 3-light Vanity Lights, The Static Ring LED 3-light Vanity Lighting, Static Ring LED 3-light Vanity Wall Light, Static Ring LED 3-light Vanity Wall Lights, Static Ring LED 3-light Vanity Wall Lighting, The Static Ring LED 3-light Vanity Wall Light, The Static Ring LED 3-light Vanity Wall Lights, The Static Ring LED 3-light Vanity Wall Lighting, Static Ring LED 3-light Vanity Sconce, Static Ring LED 3-light Vanity Sconces, Static Ring LED 3-light Vanity Wall Sconce, Static Ring LED 3-light Vanity Wall Sconces, Ring LED 3-light Vanity Light, Ring LED 3-light Vanity Lights, Ring LED 3-light Vanity Lighting, The Ring LED 3-light Vanity Light, The Ring LED 3-light Vanity Lights, The Ring LED 3-light Vanity Lighting, Ring LED 3-light Vanity Wall Light, Ring LED 3-light Vanity Wall Lights, Ring LED 3-light Vanity Wall Lighting, The Ring LED 3-light Vanity Wall Light, The Ring LED 3-light Vanity Wall Lights, The Ring LED 3-light Vanity Wall Lighting, Ring LED 3-light Vanity Sconce, Ring LED 3-light Vanity Sconces, Ring LED 3-light Vanity Wall Sconce, Ring LED 3-light Vanity Wall Sconces, Static LED 3-light Vanity Light, Static LED 3-light Vanity Lights, Static LED 3-light Vanity Lighting, The Static LED 3-light Vanity Light, The Static LED 3-light Vanity Lights, The Static LED 3-light Vanity Lighting, Static LED 3-light Vanity Wall Light, Static LED 3-light Vanity Wall Lights, Static LED 3-light Vanity Wall Lighting, The Static LED 3-light Vanity Wall Light, The Static LED 3-light Vanity Wall Lights, The Static LED 3-light Vanity Wall Lighting, Static LED 3-light Vanity Sconce, Static LED 3-light Vanity Sconces, Static LED 3-light Vanity Wall Sconce, LED 3-light Vanity Light, LED 3-light Vanity Lights, LED 3-light Vanity Lighting, The LED 3-light Vanity Light, The LED 3-light Vanity Lights, The LED 3-light Vanity Lighting, LED 3-light Vanity Wall Light, LED 3-light Vanity Wall Lights, LED 3-light Vanity Wall Lighting, The LED 3-light Vanity Wall Light, The LED 3-light Vanity Wall Lights, The LED 3-light Vanity Wall Lighting, LED 3-light Vanity Sconce, LED 3-light Vanity Sconces, LED 3-light Vanity Wall Sconce, LED 3-light Vanity Wall Sconces, Static Ring LED 3 light Vanity Light, Static Ring LED 3 light Vanity Lights, Static Ring LED 3 light Vanity Lighting, The Static Ring LED 3 light Vanity Light, The Static Ring LED 3 light Vanity Lights, The Static Ring LED 3 light Vanity Lighting, Static Ring LED 3 light Vanity Wall Light, Static Ring LED 3 light Vanity Wall Lights, Static Ring LED 3 light Vanity Wall Lighting, The Static Ring LED 3 light Vanity Wall Light, The Static Ring LED 3 light Vanity Wall Lights, The Static Ring LED 3 light Vanity Wall Lighting, Static Ring LED 3 light Vanity Sconce, Static Ring LED 3 light Vanity Sconces, Static Ring LED 3 light Vanity Wall Sconce, Static Ring LED 3 light Vanity Wall Sconces, Ring LED 3 light Vanity Light, Ring LED 3 light Vanity Lights, Ring LED 3 light Vanity Lighting, The Ring LED 3 light Vanity Light, The Ring LED 3 light Vanity Lights, The Ring LED 3 light Vanity Lighting, Ring LED 3 light Vanity Wall Light, Ring LED 3 light Vanity Wall Lights, Ring LED 3 light Vanity Wall Lighting, The Ring LED 3 light Vanity Wall Light, The Ring LED 3 light Vanity Wall Lights, The Ring LED 3 light Vanity Wall Lighting, Ring LED 3 light Vanity Sconce, Ring LED 3 light Vanity Sconces, Ring LED 3 light Vanity Wall Sconce, Ring LED 3 light Vanity Wall Sconces, Static LED 3 light Vanity Light, Static LED 3 light Vanity Lights, Static LED 3 light Vanity Lighting, The Static LED 3 light Vanity Light, The Static LED 3 light Vanity Lights, The Static LED 3 light Vanity Lighting, Static LED 3 light Vanity Wall Light, Static LED 3 light Vanity Wall Lights, Static LED 3 light Vanity Wall Lighting, The Static LED 3 light Vanity Wall Light, The Static LED 3 light Vanity Wall Lights, The Static LED 3 light Vanity Wall Lighting, Static LED 3 light Vanity Sconce, Static LED 3 light Vanity Sconces, Static LED 3 light Vanity Wall Sconce, LED 3 light Vanity Light, LED 3 light Vanity Lights, LED 3 light Vanity Lighting, The LED 3 light Vanity Light, The LED 3 light Vanity Lights, The LED 3 light Vanity Lighting, LED 3 light Vanity Wall Light, LED 3 light Vanity Wall Lights, LED 3 light Vanity Wall Lighting, The LED 3 light Vanity Wall Light, The LED 3 light Vanity Wall Lights, The LED 3 light Vanity Wall Lighting, LED 3 light Vanity Sconce, LED 3 light Vanity Sconces, LED 3 light Vanity Wall Sconce, LED 3 light Vanity Wall Sconces, vanity light, vanity lights, vanity lighting, LED Bathroom vanity light, LED bathroom vanity lights, LED bathroom vanity lighting, LED bathroom vanity sconce, LED bathroom vanity sconces, LED bathroom vanity wall sconce, LED bathroom vanity wall sconces, LED bathroom vanity wall light, LED bathroom vanity wall lights, LED bathroom vanity wall lighting, LED vanity wall light, LED vanity wall lights, LED vanity wall lighting, LED bathroom light, LED bathroom lights, LED bathroom lighting, LED Bath room vanity light, LED bath room vanity lights, LED bath room vanity lighting, LED bath room vanity sconce, LED bath room vanity sconces, LED bath room vanity wall sconce, LED bath room vanity wall sconces, LED bath room vanity wall light, LED bath room vanity wall lights, LED bath room vanity wall lighting, LED bath room light, LED bath room lights, LED bath room lighting, LED bathroom, LED bath room, Bathroom vanity LED light, bathroom vanity LED lights, bathroom vanity LED lighting, bathroom vanity LED sconce, bathroom vanity LED sconces, bathroom vanity LED wall sconce, bathroom vanity LED wall sconces, bathroom vanity LED wall light, bathroom vanity LED wall lights, bathroom vanity LED wall lighting, vanity LED wall light, vanity LED wall lights, vanity LED wall lighting, bathroom LED light, bathroom LED lights, bathroom LED lighting, Bath room vanity LED light, bath room vanity LED lights, bath room vanity LED lighting, bath room vanity LED sconce, bath room vanity LED sconces, bath room vanity LED wall sconce, bath room vanity LED wall sconces, bath room vanity LED wall light, bath room vanity LED wall lights, bath room vanity LED wall lighting, bath room LED light, bath room LED lights, bath room LED lighting, bathroom LED, bath room LED, bathroom LED light, Bathroom LED lights, Bathroom LED Lighting, bath room LED light, Bath room LED lights, Bath room LED Lighting, Bathroom vanity light, bathroom vanity lights, bathroom vanity lighting, bathroom vanity sconce, bathroom vanity sconces, bathroom vanity wall sconce, bathroom vanity wall sconces, bathroom vanity wall light, bathroom vanity wall lights, bathroom vanity wall lighting, vanity wall light, vanity wall lights, vanity wall lighting, bathroom light, bathroom lights, bathroom lighting, Bath room vanity light, bath room vanity lights, bath room vanity lighting, bath room vanity sconce, bath room vanity sconces, bath room vanity wall sconce, bath room vanity wall sconces, bath room vanity wall light, bath room vanity wall lights, bath room vanity wall lighting, bath room light, bath room lights, bath room lighting, bathroom, bath room, ring vanity, wall vanity, wall vanity light, static ring sconce, static ring led sconce, led static ring sconce, static ring vanity light, static ring vanity, led static ring vanity, static ring led vanity, static ring led vanity light, ring guard, ring guards, ring guard fixture, ring guard fixtures, ring guard light fixture, ring guard light fixtures, ring, ring fixture, ring fixtures, ring light fixture, ring light fixtures, industrial ring guard, industrial ring guards, ring industrial guard fixtures, ring industrial guard light fixture, industrial ring guard light fixtures, ring industrial guard, ring industrial guards, ring industrial guard fixtures, ring industrial guard light fixture, ring industrial guard light fixtures, Ring guard sconce, ring guard sconces, ring guard wall sconce, ring guard wall sconces, ring guard sconce light, ring guard sconce lighting, ring guard wall light, ring guard wall lights, ring guard wall lighting, ring sconce, ring sconces, ring wall sconce, ring wall sconces, ring wall light, ring wall lights, ring wall lighting, ring sconce light, ring sconce lights, ring sconce lighting, industrial ring guard sconce, industrial ring guard sconces, ring industrial guard wall sconce, ring industrial guard wall sconces, ring industrial guard wall light, ring industrial guard wall lights, ring industrial guard wall lighting, Ring LED, LED ring, LED ring guard, ring guard led, SPS-0312, SPS 0312, SPS0312, static ring collection, static ring series, the static ring collection, the static ring series, static ring guard collection, static ring guard series, the static ring guard collection, the static ring guard series, static guard collection, static guard series, the static guard collection, the static guard series, 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, vanity plates,	Static Ring LED Triple Vanity Light \| Barn Light Electric				1262.000000	1592,1808,1863,2002,1941M	238635	Barn Light Electric Company	3	static-ring-led-triple-vanity-light	1920/1938/1941	B