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

Query time 0.00189

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 = 64149 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": 6,
      "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
64149 BLE-WVG2-RGU P E C M A A 0 A 1 849.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;} 1755544416 Price increased 5% from $601 to $631 - DC 5/24/21 Price increased 10% from $631 to $695 - DC 5/31/22 Price increased from $695 to $849 - DC 6/29/23 Y none none 1067,1068 BLE {"23061":1,"23065":3,"22397":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0 en Static Ring Double Vanity Light <p>A simplified approach is preferred in contemporary design and this double vanity light exemplifies this latest trend. Five metal rings join together to create a memorable, yet streamline industrial guard. Adhering to current tastes, while still effortlessly conveying timeless charms, this double wall light can be seamlessly integrated into nearly any décor. Optional glass inserts, available with several distinct tints, enhance the Static Ring’s vintage appeal, or this feature can be excluded for a more minimalist aesthetic.</p> <p>This wall sconce sets the tone for undersized bathrooms and powder rooms, but larger settings often utilize several fixtures above multiple sinks. Curved gooseneck arms give the Static Ring a touch of traditional charm, while a more streamlined look is achieved with the straight arms. Offered with our full arsenal of powder coat finishes, including both lively and restrained options, this wall light matches anyone’s personal tastes!</p> <p>|break|</p> <ul> <li><span>Features two die casted guards and optional jelly jar glass!</span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> This double vanity light provides a distinct look to residential and commercial restrooms. Industrial style for modern and traditional décors! Fully customizable! BLE-WVS2-RGU-PC, Static Ring Double Vanity Light, Static Ring Double Vanity Lights, Static Ring Double Vanity Lighting, The Static Ring Double Vanity Light, The Static Ring Double Vanity Lights, The Static Ring Double Vanity Lighting, Static Ring Vanity Light, Static Ring Vanity Lights, Static Ring Vanity Lighting, The Static Ring Vanity Light, The Static Ring Vanity Lights, The Static Ring Vanity Lighting, Static Ring Double Vanity Sconce, Static Ring Double Vanity Sconces, Static Ring Double Vanity Wall Sconce, Static Ring Double Vanity Wall Sconces, Static Ring Vanity Sconce, Static Ring Vanity Sconces, Static Ring Vanity Wall Sconce, Static Ring Vanity Wall Sconces, Static Ring 2-light Vanity Light, Static Ring 2-light Vanity Lights, Static Ring 2-light Vanity Lighting, The Static Ring 2-light Vanity Light, The Static Ring 2-light Vanity Lights, The Static Ring 2-light Vanity Lighting, The Static Ring Vanity Lighting, Static Ring 2-light Vanity Sconce, Static Ring 2-light Vanity Sconces, Static Ring 2-light Vanity Wall Sconce, Static Ring 2-light Vanity Wall Sconces, Static 2 light Vanity Light, Static 2 light Vanity Lights, Static 2 light Vanity Lighting, The Static 2 light Vanity Light, The Static 2 light Vanity Lights, The Static 2 light Vanity Lighting, The Static Vanity Lighting, Static 2 light Vanity Sconce, Static 2 light Vanity Sconces, Static 2 light Vanity Wall Sconce, Static 2 light Vanity Wall Sconces, Static Double Vanity Light, Static Double Vanity Lights, Static Double Vanity Lighting, The Static Double Vanity Light, The Static Double Vanity Lights, The Static Double Vanity Lighting, Static Vanity Light, Static Vanity Lights, Static Vanity Lighting, The Static Vanity Light, The Static Vanity Lights, The Static Vanity Lighting, Static Double Vanity Sconce, Static Double Vanity Sconces, Static Double Vanity Wall Sconce, Static Double Vanity Wall Sconces, Static Vanity Sconce, Static Vanity Sconces, Static Vanity Wall Sconce, Static Vanity Wall Sconces, Static 2-light Vanity Light, Static 2-light Vanity Lights, Static 2-light Vanity Lighting, The Static 2-light Vanity Light, The Static 2-light Vanity Lights, The Static 2-light Vanity Lighting, The Static Vanity Lighting, Static 2-light Vanity Sconce, Static 2-light Vanity Sconces, Static 2-light Vanity Wall Sconce, Static 2-light Vanity Wall Sconces, Static 2 light Vanity Light, Static 2 light Vanity Lights, Static 2 light Vanity Lighting, The Static 2 light Vanity Light, The Static 2 light Vanity Lights, The Static 2 light Vanity Lighting, The Static Vanity Lighting, Static 2 light Vanity Sconce, Static 2 light Vanity Sconces, Static 2 light Vanity Wall Sconce, Static 2 light Vanity Wall Sconces, Ring Double Vanity Light, Ring Double Vanity Lights, Ring Double Vanity Lighting, The Ring Double Vanity Light, The Ring Double Vanity Lights, The Ring Double Vanity Lighting, Ring Vanity Light, Ring Vanity Lights, Ring Vanity Lighting, The Ring Vanity Light, The Ring Vanity Lights, The Ring Vanity Lighting, Ring Double Vanity Sconce, Ring Double Vanity Sconces, Ring Double Vanity Wall Sconce, Ring Double Vanity Wall Sconces, Ring Vanity Sconce, Ring Vanity Sconces, Ring Vanity Wall Sconce, Ring Vanity Wall Sconces, Ring 2-light Vanity Light, Ring 2-light Vanity Lights, Ring 2-light Vanity Lighting, The Ring 2-light Vanity Light, The Ring 2-light Vanity Lights, The Ring 2-light Vanity Lighting, The Ring Vanity Lighting, Ring 2-light Vanity Sconce, Ring 2-light Vanity Sconces, Ring 2-light Vanity Wall Sconce, Ring 2-light Vanity Wall Sconces, Ring 2 light Vanity Light, Ring 2 light Vanity Lights, Ring 2 light Vanity Lighting, The Ring 2 light Vanity Light, The Ring 2 light Vanity Lights, The Ring 2 light Vanity Lighting, The Ring Vanity Lighting, Ring 2 light Vanity Sconce, Ring 2 light Vanity Sconces, Ring 2 light Vanity Wall Sconce, Ring 2 light Vanity Wall Sconces, Double Vanity Light, Double Vanity Lights, Double Vanity Lighting, The Double Vanity Light, The Double Vanity Lights, The Double Vanity Lighting, Vanity Light, Vanity Lights, Vanity Lighting, The Vanity Light, The Vanity Lights, The Vanity Lighting, Double Vanity Sconce, Double Vanity Sconces, Double Vanity Wall Sconce, Double Vanity Wall Sconces, Vanity Sconce, Vanity Sconces, Vanity Wall Sconce, Vanity Wall Sconces, 2-light Vanity Light, 2-light Vanity Lights, 2-light Vanity Lighting, The 2-light Vanity Light, The 2-light Vanity Lights, The 2-light Vanity Lighting, The Vanity Lighting, 2-light Vanity Sconce, 2-light Vanity Sconces, 2-light Vanity Wall Sconce, 2-light Vanity Wall Sconces, 2 light Vanity Light, 2 light Vanity Lights, 2 light Vanity Lighting, The 2 light Vanity Light, The 2 light Vanity Lights, The 2 light Vanity Lighting, The Vanity Lighting, 2 light Vanity Sconce, 2 light Vanity Sconces, 2 light Vanity Wall Sconce, 2 light Vanity Wall Sconces, 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, wall vanity, wall vanity light, static ring sconce, static ring wall sconce, static vanity, static 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, 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-0030, SPS 0030, SPS0030, 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, teal, 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, Static Ring Double Vanity Light | Barn Light Electric 849.000000 1531,1761,1808,1834,2002,1902M 225320 Barn Light Electric Company 6 static-ring-double-vanity-light 1887/1896/1902 B