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

Query time 0.00185

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 = 64365 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
64365 BLE-C-CYLV P E C M A A 0 A 1 200.00 1000 0.000 0 0 0 0.00 0 1516121965 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;} 1768927680 Price increased by 5% from $172 to $181 - DC 5/27/21 Price increased by 10% from $181 to $200 - DC 5/20/22 Y none none 710,711 BLE-C-CYLV {"21970":3,"21954":5,"22033":6,"22903":8,"21941":10,"23553":6,"23858":5,"23859":5,"23860":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0 en Venice Cylinder Cord Pendant Light <p>Representative of the latest trends and styles, the Venice Cylinder Pendant helps homeowners, professional designers, and businesses implement unique, fashionable décors. With its clean lines and eye-catching profile, the Venice’s chic approach offers a contemporary update to any setting, while still fitting in with the various looks commonly found in modern homes. Decorative slots, offered in several creative patterns and designs, elevate the pendant’s aesthetic with striking details and touches of uplight.</p> <p>Reinforced by our sincere commitment to quality, the Venice’s shade is constructed entirely from commercial-grade materials. With an abundance of finish colors, cord styles, and other customization options, it’s easy to personalize a pendant light for your space!</p> <p>|break|</p> <ul> <li>Manufactured and hand-crafted in the USA</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>!</li> <li>Read more about the Venice Cylinder Pendant Light over on our<span> <a href="https://www.barnlight.com/inspiration/new-cylinder-pendant-lights-exude-modern-style/" target="_blank">blog</a></span>!</li> </ul> A modern shape and unique slot shapes! The Venice is ideal for residential spaces and commercial applications. Bring hand-crafted and American made lights to your space! BLE-C-CYLV, The Venice Cylinder Cord Hung Pendant, The Venice Cylinder Cord Hung Pendants, The Venice Cylinder Cord Hung Pendant Light, The Venice Cylinder Cord Hung Pendant Lights, The Venice Cylinder Cord Hung Pendant Lighting, The Venice Cylinder Cord Hung Ceiling Pendant, The Venice Cylinder Cord Hung Ceiling Pendants, The Venice Cylinder Cord Hung Ceiling Light, The Venice Cylinder Cord Hung Ceiling Lights, The Venice Cylinder Cord Hung Ceiling Lighting, The Venice Cylinder Cord Hung Light, The Venice Cylinder Cord Hung Lights, The Venice Cylinder Cord Hung Lighting, Venice Cylinder Cord Hung Pendant, Venice Cylinder Cord Hung Pendants, Venice Cylinder Cord Hung Pendant Light, Venice Cylinder Cord Hung Pendant Lights, Venice Cylinder Cord Hung Pendant Lighting, Venice Cylinder Cord Hung Ceiling Pendant, Venice Cylinder Cord Hung Ceiling Pendants, Venice Cylinder Cord Hung Ceiling Light, Venice Cylinder Cord Hung Ceiling Lights, Venice Cylinder Cord Hung Ceiling Lighting, Venice Cylinder Cord Hung Light, Venice Cylinder Cord Hung Lights, Venice Cylinder Cord Hung Lighting, The Venice Cylinder Pendant, The Venice Cylinder Pendants, The Venice Cylinder Pendant Light, The Venice Cylinder Pendant Lights, The Venice Cylinder Pendant Lighting, The Venice Cylinder Ceiling Pendant, The Venice Cylinder Ceiling Pendants, The Venice Cylinder Ceiling Light, The Venice Cylinder Ceiling Lights, The Venice Cylinder Ceiling Lighting, The Venice Cylinder Light, The Venice Cylinder Lights, The Venice Cylinder Lighting, Venice Cylinder Pendant, Venice Cylinder Pendants, Venice Cylinder Pendant Light, Venice Cylinder Pendant Lights, Venice Cylinder Pendant Lighting, Venice Cylinder Ceiling Pendant, Venice Cylinder Ceiling Pendants, Venice Cylinder Ceiling Light, Venice Cylinder Ceiling Lights, Venice Cylinder Ceiling Lighting, Venice Cylinder Light, Venice Cylinder Lights, Venice Cylinder Lighting, The Venice Cylinder Cord Mount Pendant, The Venice Cylinder Cord Mount Pendants, The Venice Cylinder Cord Mount Pendant Light, The Venice Cylinder Cord Mount Pendant Lights, The Venice Cylinder Cord Mount Pendant Lighting, The Venice Cylinder Cord Mount Ceiling Pendant, The Venice Cylinder Cord Mount Ceiling Pendants, The Venice Cylinder Cord Mount Ceiling Light, The Venice Cylinder Cord Mount Ceiling Lights, The Venice Cylinder Cord Mount Ceiling Lighting, The Venice Cylinder Cord Mount Light, The Venice Cylinder Cord Mount Lights, The Venice Cylinder Cord Mount Lighting, Venice Cylinder Cord Mount Pendant, Venice Cylinder Cord Mount Pendants, Venice Cylinder Cord Mount Pendant Light, Venice Cylinder Cord Mount Pendant Lights, Venice Cylinder Cord Mount Pendant Lighting, Venice Cylinder Cord Mount Ceiling Pendant, Venice Cylinder Cord Mount Ceiling Pendants, Venice Cylinder Cord Mount Ceiling Light, Venice Cylinder Cord Mount Ceiling Lights, Venice Cylinder Cord Mount Ceiling Lighting, Venice Cylinder Cord Mount Light, Venice Cylinder Cord Mount Lights, Venice Cylinder Cord Mount Lighting, The Venice Cord Mount Pendant, The Venice Cord Mount Pendants, The Venice Cord Mount Pendant Light, The Venice Cord Mount Pendant Lights, The Venice Cord Mount Pendant Lighting, The Venice Cord Mount Ceiling Pendant, The Venice Cord Mount Ceiling Pendants, The Venice Cord Mount Ceiling Light, The Venice Cord Mount Ceiling Lights, The Venice Cord Mount Ceiling Lighting, The Venice Cord Mount Light, The Venice Cord Mount Lights, The Venice Cord Mount Lighting, Venice Cord Mount Pendant, Venice Cord Mount Pendants, Venice Cord Mount Pendant Light, Venice Cord Mount Pendant Lights, Venice Cord Mount Pendant Lighting, Venice Cord Mount Ceiling Pendant, Venice Cord Mount Ceiling Pendants, Venice Cord Mount Ceiling Light, Venice Cord Mount Ceiling Lights, Venice Cord Mount Ceiling Lighting, Venice Cord Mount Light, Venice Cord Mount Lights, Venice Cord Mount Lighting, The Venice Cord Hung Pendant, The Venice Cord Hung Pendants, The Venice Cord Hung Pendant Light, The Venice Cord Hung Pendant Lights, The Venice Cord Hung Pendant Lighting, The Venice Cord Hung Ceiling Pendant, The Venice Cord Hung Ceiling Pendants, The Venice Cord Hung Ceiling Light, The Venice Cord Hung Ceiling Lights, The Venice Cord Hung Ceiling Lighting, The Venice Cord Hung Light, The Venice Cord Hung Lights, The Venice Cord Hung Lighting, Venice Cord Hung Pendant, Venice Cord Hung Pendants, Venice Cord Hung Pendant Light, Venice Cord Hung Pendant Lights, Venice Cord Hung Pendant Lighting, Venice Cord Hung Ceiling Pendant, Venice Cord Hung Ceiling Pendants, Venice Cord Hung Ceiling Light, Venice Cord Hung Ceiling Lights, Venice Cord Hung Ceiling Lighting, Venice Cord Hung Light, Venice Cord Hung Lights, Venice Cord Hung Lighting, The Cylinder Cord Hung Pendant, The Cylinder Cord Hung Pendants, The Cylinder Cord Hung Pendant Light, The Cylinder Cord Hung Pendant Lights, The Cylinder Cord Hung Pendant Lighting, The Cylinder Cord Hung Ceiling Pendant, The Cylinder Cord Hung Ceiling Pendants, The Cylinder Cord Hung Ceiling Light, The Cylinder Cord Hung Ceiling Lights, The Cylinder Cord Hung Ceiling Lighting, The Cylinder Cord Hung Light, The Cylinder Cord Hung Lights, The Cylinder Cord Hung Lighting, Cylinder Cord Hung Pendant, Cylinder Cord Hung Pendants, Cylinder Cord Hung Pendant Light, Cylinder Cord Hung Pendant Lights, Cylinder Cord Hung Pendant Lighting, Cylinder Cord Hung Ceiling Pendant, Cylinder Cord Hung Ceiling Pendants, Cylinder Cord Hung Ceiling Light, Cylinder Cord Hung Ceiling Lights, Cylinder Cord Hung Ceiling Lighting, Cylinder Cord Hung Light, Cylinder Cord Hung Lights, Cylinder Cord Hung Lighting, The Cylinder Pendant, The Cylinder Pendants, The Cylinder Pendant Light, The Cylinder Pendant Lights, The Cylinder Pendant Lighting, The Cylinder Ceiling Pendant, The Cylinder Ceiling Pendants, The Cylinder Ceiling Light, The Cylinder Ceiling Lights, The Cylinder Ceiling Lighting, The Cylinder Light, The Cylinder Lights, The Cylinder Lighting, Cylinder Pendant, Cylinder Pendants, Cylinder Pendant Light, Cylinder Pendant Lights, Cylinder Pendant Lighting, Cylinder Ceiling Pendant, Cylinder Ceiling Pendants, Cylinder Ceiling Light, Cylinder Ceiling Lights, Cylinder Ceiling Lighting, Cylinder Light, Cylinder Lights, Cylinder Lighting, cylinder, venice, cylinder pendant, cylinder pendants, cylinder collection, venice, cylinder, cylinders, cylinders pendant, BLE-C-CYLV-SML, BLE-C-CYLV-LRG, venice pendant, venice pendants, narrow slot vent, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded, Venice Cylinder Cord Pendant Light | Barn Light Electric 200.000000 1542,1611,1701,1745,2002,1889M 649042 Barn Light Electric Company 27 venice-cylinder-pendant-light 1887/1888/1889 B