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

Query time 0.00152

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_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 = 65176 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
65176 BLE-PMD-DCS-CGG-LED E C M W A 0 A 1 1314.00 1000 0.000 0 0 0 0.00 0 1589227800 0 N N N D N R N N N Y 30 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;} 1769108856 Price increased 5% from $1137 to $1194 - DC 5/28/21 Price increased 10% from $1194 to $1314 - DC 6/2/22 Y none none 2682,2683,2685 BLE {"22397":10,"23230":9,"22643":10,"22644":11,"22645":12,"23116":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0 en Sterling Nautical LED Double Post Mount Light <p>To create a fixture that outperforms every other option, the Sterling integrates LED components into its design. This innovative technology produces light with incredible efficiency and maximizes the fixture’s potential output. With various lumen options and color temperatures available, these LEDs can emit illumination with the proper brightness and tone for every space. <br /><br />However, this efficiency doesn’t restrict the Sterling’s sense of style. Instead, its two streamlined shades make a dramatic statement in outdoor décors and demand attention as it spreads light across a property. Rugged guards balance out the fixture’s aesthetic and establish an industrial-leaning look. Available with an array of vibrant finishes — copper, brass, marine grade, and powder coat — our post mount lights can take on the right style for any space.</p> <p>|break|</p> <ul> <li>Hand built with American made RLM warehouse shades, this quality outdoor light is a lasting post mount option. </li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> Contemporary aesthetics and high-performance LED components meets classic lighting designs! Save money, help out the environment, and transform outdoor spaces with the Sterling! BLE-PMD-DCS, The Sterling Deep Cone Reflector Double Post Mount Light, The Sterling Deep Cone Reflector Double Post Mount Lights, The Sterling Deep Cone Reflector Double Post Mount Lighting, Sterling Deep Cone Reflector Double Post Mount Light, Sterling Deep Cone Reflector Double Post Mount Lights, Sterling Deep Cone Reflector Double Post Mount Lighting, The Sterling Deep Cone Reflector Copper Double Post Mount Light, The Sterling Deep Cone Reflector Copper Double Post Mount Lights, The Sterling Deep Cone Reflector Copper Double Post Mount Lighting, Sterling Deep Cone Reflector Copper Double Post Mount Light, Sterling Deep Cone Reflector Copper Double Post Mount Lights, Sterling Deep Cone Reflector Copper Double Post Mount Lighting, The Sterling Deep Cone Reflector Brass Double Post Mount Light, The Sterling Deep Cone Reflector Brass Double Post Mount Lights, The Sterling Deep Cone Reflector Brass Double Post Mount Lighting, Sterling Deep Cone Reflector Brass Double Post Mount Light, Sterling Deep Cone Reflector Brass Double Post Mount Lights, Sterling Deep Cone Reflector Brass Double Post Mount Lighting, The Sterling Deep Cone Double Post Mount Light, The Sterling Deep Cone Double Post Mount Lights, The Sterling Deep Cone Double Post Mount Lighting, Sterling Deep Cone Double Post Mount Light, Sterling Deep Cone Double Post Mount Lights, Sterling Deep Cone Double Post Mount Lighting, The Sterling Deep Cone Copper Double Post Mount Light, The Sterling Deep Cone Copper Double Post Mount Lights, The Sterling Deep Cone Copper Double Post Mount Lighting, Sterling Deep Cone Copper Double Post Mount Light, Sterling Deep Cone Copper Double Post Mount Lights, Sterling Deep Cone Copper Double Post Mount Lighting, The Sterling Deep Cone Brass Double Post Mount Light, The Sterling Deep Cone Brass Double Post Mount Lights, The Sterling Deep Cone Brass Double Post Mount Lighting, Sterling Deep Cone Brass Double Post Mount Light, Sterling Deep Cone Brass Double Post Mount Lights, Sterling Deep Cone Brass Double Post Mount Lighting, The Sterling Reflector Double Post Mount Light, The Sterling Reflector Double Post Mount Lights, The Sterling Reflector Double Post Mount Lighting, Sterling Reflector Double Post Mount Light, Sterling Reflector Double Post Mount Lights, Sterling Reflector Double Post Mount Lighting, The Sterling Reflector Copper Double Post Mount Light, The Sterling Reflector Copper Double Post Mount Lights, The Sterling Reflector Copper Double Post Mount Lighting, Sterling Reflector Copper Double Post Mount Light, Sterling Reflector Copper Double Post Mount Lights, Sterling Reflector Copper Double Post Mount Lighting, The Sterling Reflector Brass Double Post Mount Light, The Sterling Reflector Brass Double Post Mount Lights, The Sterling Reflector Brass Double Post Mount Lighting, Sterling Reflector Brass Double Post Mount Light, Sterling Reflector Brass Double Post Mount Lights, Sterling Reflector Brass Double Post Mount Lighting, The Sterling Double Post Mount Light, The Sterling Double Post Mount Lights, The Sterling Double Post Mount Lighting, Sterling Double Post Mount Light, Sterling Double Post Mount Lights, Sterling Double Post Mount Lighting, The Sterling Copper Double Post Mount Light, The Sterling Copper Double Post Mount Lights, The Sterling Copper Double Post Mount Lighting, Sterling Copper Double Post Mount Light, Sterling Copper Double Post Mount Lights, Sterling Copper Double Post Mount Lighting, The Sterling Brass Double Post Mount Light, The Sterling Brass Double Post Mount Lights, The Sterling Double Post Mount Lighting, Sterling Brass Double Post Mount Light, Sterling Brass Double Post Mount Lights, Sterling Brass Double Post Mount Lighting, copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, deep cone, reflector, deep cone post mount, deep cone post mount light, deep cone post mounts, deep cone post mount lights, deep cone post mount lighting, reflector post mount, reflector post mounts, reflector post mount light, reflector post mount lighting, reflector post mount lights, Sterling Deep Cone Reflector Double Post Mount Exterior Light, BLE-PMD-DCS, sterling, deep cone, reflector, deep cone reflector, double post, post mount, exterior light, lamppost, post light, reflector shades, double light, garden lights, patio post lights, restaurant post, post outdoor lighting, outdoor lighting, BLE-PMD-DCS14, BLE-PMD-DCS16, sterling shade, sterling post mount, sterling deep, sterling exterior light, sterling, deep cone, cone reflector, reflector, decorative, double post , post mount, exterior light, double pole, double Sterling Deep Cone Reflector Decorative Double Post Mount Exterior Light, Sterling light pole, sterling post mount, deep cone light pole, deep cone post mount, reflector light pole, reflector post mount, BLE-PMDD-DCS, pole light, pole light, light fixture, american made, decorative post mount, post mount light, mount light, outdoor lighting, commercial lighting, BLE-PMDD-DCS14, BLE-PMDD-DCS16, sterling, sterling double post, sterling double post mount light, sterling 2 light post, sterling 2 light, 2 light sterling, deep cone post, double deep cone post mount, 2 light deep cone post mount, reflector post mount, 2 light reflector post mount, post mount sterling, sterling 2 light post mount, sterling two light post, sterling two light, new led post, Sterling LED Double Post Mount Light, Sterling LED Post Mount, Sterling Double LED Post Mount, Sterling Double Post Mount, Sterling led, LED sterling, led post mount, post mount led, Sterling Nautical LED Double Post Mount Light, Sterling Nautical LED Double Post Mount, Sterling Nautical LED Post Mount Light, Sterling Nautical LED Post Mount, Sterling Nautical Double Post Mount Light, Sterling Nautical Double Post Mount, Sterling LED Double Post Mount Light, Sterling LED Double Post Mount, Sterling Nautical Post Mount Light, Sterling Nautical Post Mount, Sterling LED Post Mount Light, Sterling LED Post Mount, Nautical LED, LED nautical, Nautical post mount, led post mount, BLE-PMD-DCS14, BLE-PMD-DCS16, BLE-PMDD-DCS14, BLE-PMDD-DCS16, SPS-0270, SPS 0270, SPS0270, The Sterling Post Mount Collection, The Sterling Post Mount Series, Sterling Post Mount Collection, Sterling Post Mount Series, rustic LED Post mount, rustic LED Post mounts, barn lights on pole, outdoor pole lights, light post lighting, Sterling Nautical LED Double Post Mount Light | Barn Light Electric 1314.000000 1598,1666,1858,2001,1936M 108015 Barn Light Electric Company sterling-nautical-led-double-post-mount-light 1920/1933/1936 B