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

Query time 0.00175

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": 0,
      "filtered": 0,
      "unique_row_not_found": true
    },
    "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": 1,
      "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')"
    },
    "block-nl-join": {
      "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": "cscart_product_prices.product_id = 61623 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1)"
      },
      "buffer_type": "flat",
      "buffer_size": "8Kb",
      "join_type": "BNL",
      "attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 61623 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_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
61623 BLE-S-CH011-SCH P E C M A A 0 A 1 1155.00 1000 0.000 0 0 0 0.00 0 1365998400 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;} 1779997847 Price increased 5% from $1000 to $1050 - DC 5/28/21 Price increased 10% from $1050 to $1155 - DC 5/24/22 Y none none 702,703,704,705 BLE-S-CH011 {"22825":1,"22826":3,"22796":4,"22797":4,"22795":4,"22794":4,"22798":5,"22395":6} 1056013 0 0 0 0 0 0 0 0 1 0.00 0 en Primary 4-Light Straight Arm Schoolhouse Chandelier <p>Crafted by talented American artisans, the Primary 4-Light Schoolhouse Chandelier features rugged industrial arms and decorative schoolhouse globes, complete with your choice of colorful stripes and shade style. While schoolhouse lighting embraces a classic, more traditional look, they remain popular in contemporary settings, largely thanks to their sophisticated yet grounded appeal.</p> <p>Regularly installed in residential areas, this multi-light chandelier is perfect for installation above tables in dining rooms or illuminating living rooms. Or apply this schoolhouse chandelier to your commercial lighting needs in restaurants, retail spaces, and offices too!</p> <p>|break|</p> <ul> <li>Features four customizable glass schoolhouse globes with hand-spun fitters.</li> <li>This chandelier is made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> <li>Learn more about the Primary 4-Light Schoolhouse Chandelier over on our<span> <a href="https://www.barnlight.com/inspiration/featured-customer-custom-schoolhouse-lighting-adds-playful-retro-style/" target="_blank">blog</a></span>!</li> <li>Please Note: Custom stem lengths are available upon request, please contact our sales department for additional information.</li> </ul> straight arm schoolhouse light chandelier, decorative glass chandelier, school house light fixture, schoolhouse light chandeliers, colorful light fixtures, classic schoolhouse lighting, american made schoolhouse light, period schoolhouse lighting American made lighting, this 4-light schoolhouse ceiling light fixture showcases industrial arms and decorative glass globes and custom color bands. Free Shipping! University Schoolhouse Chandelier, BLE-S-SCH-CH011, the university, schoolhouse chandelier, glass chandelier, The University 4-Light Schoolhouse Chandelier, the university chandelier, 4-light chandelier, chandelier lighting, schoolhouse chandelier lighting, ceiling lighting, schoolhouse ceiling lighting, schoolhouse shade, ceiling lighting, chandelier ceiling light, chandelier ceiling lighting, university ceiling lighting, university lighting, university ceiling lighting, indoor chandelier, Junior, Junior Schoolhouse Chandelier, Junior Schoolhouse, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary 4-Light Straight Arm Schoolhouse Chandelier, Primary 4-Light Schoolhouse Chandelier, Primary 4-Light Chandelier, Primary four Light Straight Arm Schoolhouse Chandelier, Primary four Light Schoolhouse Chandelier, Primary Straight Arm Schoolhouse Chandelier, Primary Schoolhouse Chandelier, Primary Chandelier, 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, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, glass chandelier, glass chandeliers, glass shade chandelier, glass shade chandeliers, glass globe chandelier, glass globe chandeliers, BLE-S-CH011-SCH10, BLE-S-CH011-SCH14, BLE-S-CH011-SCHCL10, BLE-S-CH011-SCHCL14, 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, School house chandelier collection, school house chandelier series, Schoolhouse chandelier collection, schoolhouse chandelier series, Primary schoolhouse chandelier collection, primary schoolhouse chandelier series, SPS-0067, SPS 0067, SPS0067, striped schoolhouse, striped schoolhouse light, Primary 4-Light Schoolhouse Chandelier | Barn Light Electric Keywords: schoolhouse light, 4 light chandelier, schoolhouse chandelier, schoolhouse globe 1155.000000 2010M 507457 Barn Light Electric Company primary-4-light-straight-arm-schoolhouse-chandelier 1887/1888/2010 B