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

Query time 0.00123

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 = 64905 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": 8,
      "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
64905 BLE-G-DRM P E C M A A 0 A 1 408.00 1000 0.000 0 0 0 0.00 0 1571848727 0 N N N D N P N N N Y 10 1355979600 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;} 1739564678 Price increased 10% from $278 to $306 - DC 5/24/22 Price increased from $306 to $320 - DC 11/3/22 Price increased from $320 to $408 - DM 9/6/23 Y none none 649,651,652,834 BLE-G {"22791":3,"21941":12,"22931":9,"22932":9,"22798":10,"22799":11,"22800":11,"22801":11} 1056013 0 0 0 0 0 0 0 0 1 0.00 0 en Drum Schoolhouse Gooseneck Light <p>Whether installed in contemporary venues or traditional settings, this schoolhouse light helps every space feel stylish, welcoming, and perfectly illuminated. Centering its design on a drum-shaped glass shade and an iconic gooseneck arm, this fixture communicates contemporary decorative preferences through traditional influences. As an accent piece or focal point, this wall light gives any décor a defining sense of character and memorable appearance.</p> <p>Outfitted with hand-painted bands, the shade commands attention and stands out wherever it’s installed. Other customizing options include glass styles, unique finishes, and gooseneck arms.</p> <p>|break|</p> <ul> <li>Features a customizable glass schoolhouse globe and hand-spun fitter.</li> <li>This light is made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>White painted band(s) not recommended if opaque glass is selected, as it blends into the glass.</li> </ul> Add a classic yet contemporary style to any space with this drum schoolhouse gooseneck light! Endlessly customizable with various finishes and hand-painted band patterns! BLE-G-DRM, Drum Schoolhouse Gooseneck Light, Drum Schoolhouse Gooseneck, Drum Gooseneck, Drum Gooseneck Light, Drum Wall Light, Drum Wall Lighting, Drum Schoolhouse, Schoolhouse drum, schoolhouse drum light, schoolhouse drum gooseneck, schoolhouse gooseneck light, drum schoolhouse wall light, schoolhouse drum wall light, Schoolhouse gooseneck, schoolhouse goosenecks, schoolhouse gooseneck light, schoolhouse wall light, schoolhouse, schoolhouse lighting, Drum School house Gooseneck Light, Drum School house Gooseneck, Drum School house, School house drum, school house drum light, school house drum gooseneck, school house gooseneck light, drum school house wall light, school house drum wall light, School house gooseneck, school house goosenecks, school house gooseneck light, school house wall light, school house, school house lighting, Drum, Glass drum shade, glass drum shades, drum glass shade, drum glass shades, drum schoolhouse glass, drum schoolhouse glass shade, drum schoolhouse glass shades, schoolhouse drum glass, schoolhouse drum glass shade, schoolhouse drum glass shades, drum school house glass, drum school house glass shade, drum school house glass shades, school house drum glass, school house drum glass shade, school house drum glass shades, Drum schoolhouse light shade, drum schoolhouse light shades, drum schoolhouse lighting shade, drum schoolhouse lighting shades, Drum school house light shade, drum school house light shades, drum school house lighting shade, drum school house lighting shades, Glass drum fixture, glass drum fixtures, glass drum light fixture, glass drum light fixtures, glass drum lighting fixture, glass drum lighting fixtures, glass drum lighting shade, glass drum lighting shades, glass drum light shade, glass drum light shades, drum glass light shade, drum glass light shades, drum glass lighting shade, drum glass lighting shades, Glass schoolhouse shade, glass schoolhouse shades, schoolhouse glass shade, schoolhouse glass shades, glass schoolhouse light shade, glass schoolhouse light shades, glass schoolhouse lighting shades, glass schoolhouse lighting shade, schoolhouse glass light shade, schoolhouse glass light shades, schoolhouse glass lighting shade, schoolhouse glass lighting shades, Glass school house shade, glass school house shades, school house glass shade, school house glass shades, glass school house light shade, glass school house light shades, glass school house lighting shades, glass school house lighting shade, school house glass light shade, school house glass light shades, school house glass lighting shade, school house glass lighting shades, Drum glass gooseneck, glass drum gooseneck, drum glass goose neck, glass drum goose necks, drum glass gooseneck light, glass drum gooseneck light, glass drum gooseneck lights, glass drum gooseneck lighting, drum glass gooseneck light, drum glass gooseneck lights, drum glass gooseneck lighting, drum glass goose neck light, glass drum goose neck light, glass drum goose neck lights, glass drum goose neck lighting, drum glass goose neck light, drum glass goose neck lights, drum glass goose neck lighting, Glass shade gooseneck, glass shade goosenecks, glass shade goose neck, glass shade goose necks, glass shade gooseneck light, glass shade gooseneck lights, glass shade gooseneck lighting, glass shade goose neck light, glass shade goose neck lights, glass shade goose neck lighting, Drum shade gooseneck, drum shade goose neck, drum shade goosenecks, drum shade goose necks, drum shade gooseneck light, drum shade gooseneck lights, drum shade gooseneck lighting, drum shade goose neck light, drum shade goose neck lights, drum shade goose neck lighting, Drum glass shade gooseneck, drum glass shade goosenecks, drum glass shade goose neck, drum glass shade goose necks, drum glass shade gooseneck light, drum glass shade gooseneck lights, drum glass shade gooseneck lighting, drum glass shade goose neck light, drum glass shade goose neck lights, drum glass shade goose neck lighting, Glass drum schoolhouse, glass drum school house, Glass drum gooseneck, glass drum goosenecks, glass drum gooseneck light, glass drum gooseneck lights, glass drum gooseneck lighting, glass drum goose neck light, glass drum goose neck lights, glass drum goose neck lighting, Drum schoolhouse shade gooseneck, drum schoolhouse shade goosenecks, drum schoolhouse shade gooseneck light, drum schoolhouse shade gooseneck lights, drum schoolhouse shade gooseneck lighting, Drum schoolhouse shade goose neck, drum schoolhouse shade goose necks, drum schoolhouse shade goose neck light, drum schoolhouse shade goose neck lights, drum schoolhouse shade goose neck lighting, Glass shade schoolhouse, glass shade school house, glass shade gooseneck, glass shade goosenecks, glass shade gooseneck light, glass shade gooseneck lights, glass shade gooseneck lighting, glass shade goose necks, glass shade goose neck light, glass shade goose neck lights, glass shade goose neck lighting, drum glass wall light, glass drum wall light, glass drum wall lights, glass drum wall lighting, drum glass wall light, drum glass wall lights, drum glass wall lighting, drum glass wall fixture, drum glass wall fixtures, drum glass wall light fixture, drum glass wall light fixtures, drum glass wall lighting fixture, drum glass wall lighting fixtures, glass drum wall light, glass drum wall lights, glass drum wall lighting, glass drum wall light fixture, glass drum wall light fixtures, glass drum wall lighting fixture, glass drum wall lighting fixtures, drum shade wall light, drum shade wall lights, drum shade wall lighting, drum shade wall fixture, drum shade wall fixtures, drum shade wall light fixture, drum shade wall light fixtures, drum shade wall lighting fixture, drum shade wall lighting fixtures, drum glass shade wall light, drum glass shade wall lights, drum glass shade wall lighting, drum glass shade wall fixture, drum glass shade wall fixtures, drum glass shade wall light fixture, drum glass shade wall light fixtures, drum glass shade wall lighting fixture, drum glass shade wall lighting fixtures, glass drum gooseneck light, glass drum gooseneck lights, glass drum gooseneck lighting, drum schoolhouse shade wall light, drum schoolhouse shade wall lights, drum schoolhouse shade wall lighting, drum schoolhouse shade wall fixture, drum schoolhouse shade wall fixtures, drum schoolhouse shade wall light fixture, drum schoolhouse shade wall light fixtures, drum schoolhouse shade wall lighting fixture, drum schoolhouse shade wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass shade wall fixture, glass shade wall fixtures, glass shade wall light fixture, glass shade wall light fixtures, glass shade wall lighting fixture, glass shade wall lighting fixtures, Goose neck interior, Gooseneck interior, Goose neck light interior, Gooseneck light interior, interior goose neck, interior gooseneck light, interior goose neck light, Clear glass shades, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, Drum Schoolhouse collection, Drum schoolhouse series, the Drum schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, Drum series, drum collection, SPS-0486, SPS0486, SPS 0486, Gooseneck schoolhouse, Gooseneck school house, Goose neck schoolhouse, schoolhouse gooseneck, schoolhouse goosenecks, school house gooseneck, school house goosenecks, school light, school lights, school lighting, school, 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 gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, striped schoolhouse, striped schoolhouse light, Drum Schoolhouse Gooseneck Light | Barn Light Electric 408.000000 1530,1547,1697,1757,1827,1883,2002,1897M 148714 Barn Light Electric Company 50 drum-schoolhouse-gooseneck-light 1887/1896/1897 B