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

Query time 0.00140

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 = 64301 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": 4,
      "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
64301 BLE-PMTD-DCS E C M W A 0 A 1 1440.00 1000 0.000 0 0 0 0.00 0 1489982400 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;} 1769626259 Price increased 5% from $1247 to $1309 - DC 5/28/21 Price increased 10% from $1309 to $1440 - DC 6/1/22 Y none none 1851,1852,1853 BLE {"22396":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0 en Sterling Triple Post Mount Light <p>With its sleek, contemporary lines, the Sterling grabs attention in every outdoor space while still conforming to various decorative mindsets. When installed in parking lots or along sidewalks, this post mount light establishes a memorable curb appeal. Sophisticated copper and brass give the shades a distinguished appearance. Marine grade and powder coat help the Sterling adapt to a setting’s preferred aesthetic.<br /><br />While the Sterling demonstrates the latest modern styles, it still embraces attentive, hands-on craftsmanship. Solid, commercial-grade metal is spun by hand, giving each shade the durability necessary for installation in outdoor settings. Rugged yet eye-catching, elevate every space with this post mount light!</p> <p>|break|</p> <ul> <li>This durable outdoor light includes a hand-built, American-made RLM warehouse shade.</li> <li>Made-to-order, learn more about the process <a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> <br /><br /> Sleek and stylish, the Sterling is the ideal post mount light for homes and businesses! Made in the USA! Customizable with marine grade, powder coat, copper, and brass! BLE-PMTD-DCS, The Sterling Deep Cone Reflector 3-Light Post Mount Light, The Sterling Deep Cone Reflector 3-Light Post Mount Lights, The Sterling Deep Cone Reflector 3-Light Post Mount Lighting, Sterling Deep Cone Reflector 3-Light Post Mount Light, Sterling Deep Cone Reflector 3-Light Post Mount Lights, Sterling Deep Cone Reflector 3-Light Post Mount Lighting, The Sterling Deep Cone Reflector 3 Light Post Mount Light, The Sterling Deep Cone Reflector 3 Light Post Mount Lights, The Sterling Deep Cone Reflector 3 Light Post Mount Lighting, Sterling Deep Cone Reflector 3 Light Post Mount Light, Sterling Deep Cone Reflector 3 Light Post Mount Lights, Sterling Deep Cone Reflector 3 Light Post Mount Lighting, The Sterling Reflector 3-Light Post Mount Light, The Sterling Reflector 3-Light Post Mount Lights, The Sterling Reflector 3-Light Post Mount Lighting, Sterling Reflector 3-Light Post Mount Light, Sterling Reflector 3-Light Post Mount Lights, Sterling Reflector 3-Light Post Mount Lighting, The Sterling Reflector 3 Light Post Mount Light, The Sterling Reflector 3 Light Post Mount Lights, The Sterling Reflector 3 Light Post Mount Lighting, Sterling Reflector 3 Light Post Mount Light, Sterling Reflector 3 Light Post Mount Lights, Sterling Reflector 3 Light Post Mount Lighting, The Sterling Deep Cone 3-Light Post Mount Light, The Sterling Deep Cone 3-Light Post Mount Lights, The Sterling Deep Cone 3-Light Post Mount Lighting, Sterling Deep Cone 3-Light Post Mount Light, Sterling Deep Cone 3-Light Post Mount Lights, Sterling Deep Cone 3-Light Post Mount Lighting, The Sterling Deep Cone 3 Light Post Mount Light, The Sterling Deep Cone 3 Light Post Mount Lights, The Sterling Deep Cone 3 Light Post Mount Lighting, Sterling Deep Cone 3 Light Post Mount Light, Sterling Deep Cone 3 Light Post Mount Lights, Sterling Deep Cone 3 Light Post Mount Lighting, The Sterling 3-Light Post Mount Light, The Sterling 3-Light Post Mount Lights, The Sterling 3-Light Post Mount Lighting, 3-Light Post Mount Light, Sterling 3-Light Post Mount Lights, Sterling 3-Light Post Mount Lighting, The Sterling 3 Light Post Mount Light, The Sterling 3 Light Post Mount Lights, The Sterling 3 Light Post Mount Lighting, Sterling 3 Light Post Mount Light, Sterling 3 Light Post Mount Lights, Sterling 3 Light Post Mount Lighting, The Sterling Deep Cone Reflector Brass 3-Light Post Mount Light, The Sterling Deep Cone Reflector 3-Light Brass Post Mount Lights, The Sterling Deep Cone Reflector 3-Light Brass Post Mount Lighting, Sterling Deep Cone Reflector Brass 3-Light Post Mount Light, Sterling Deep Cone Reflector Brass 3-Light Post Mount Lights, Sterling Deep Cone Reflector Brass 3-Light Post Mount Lighting, The Sterling Deep Cone Reflector Brass 3 Light Post Mount Light, The Sterling Deep Cone Reflector Brass 3 Light Post Mount Lights, The Sterling Deep Cone Reflector brass 3 Light Post Mount Lighting, Sterling Deep Cone Reflector brass 3 Light Post Mount Light, Sterling Deep Cone Reflector brass 3 Light Post Mount Lights, Sterling Deep Cone Reflector brass 3 Light Post Mount Lighting, The Sterling Reflector brass 3-Light Post Mount Light, The Sterling Reflector brass 3-Light Post Mount Lights, The Sterling Reflector brass 3-Light Post Mount Lighting, Sterling Reflector brass 3-Light Post Mount Light, Sterling Reflector brass 3-Light Post Mount Lights, Sterling Reflector brass 3-Light Post Mount Lighting, The Sterling Reflector brass 3 Light Post Mount Light, The Sterling Reflector brass 3 Light Post Mount Lights, The Sterling Reflector brass 3 Light Post Mount Lighting, Sterling Reflector brass 3 Light Post Mount Light, Sterling Reflector brass 3 Light Post Mount Lights, Sterling Reflector brass 3 Light Post Mount Lighting, The Sterling Deep Cone brass 3-Light Post Mount Light, The Sterling Deep Cone brass 3-Light Post Mount Lights, The Sterling Deep Cone brass 3-Light Post Mount Lighting, Sterling Deep Cone brass 3-Light Post Mount Light, Sterling Deep Cone brass 3-Light Post Mount Lights, Sterling Deep Cone brass 3-Light Post Mount Lighting, The Sterling Deep Cone brass 3 Light Post Mount Light, The Sterling Deep Cone brass 3 Light Post Mount Lights, The Sterling Deep Cone brass 3 Light Post Mount Lighting, Sterling Deep Cone brass 3 Light Post Mount Light, Sterling Deep Cone brass 3 Light Post Mount Lights, Sterling Deep Cone 3 Light brass Post Mount Lighting, The Sterling 3-Light brass Post Mount Light, The Sterling 3-Light brass Post Mount Lights, The Sterling 3-Light brass Post Mount Lighting, 3-Light brass Post Mount Light, Sterling brass 3-Light Post Mount Lights, Sterling brass 3-Light Post Mount Lighting, The Sterling brass 3 Light Post Mount Light, The Sterling brass 3 Light Post Mount Lights, The Sterling brass 3 Light Post Mount Lighting, Sterling brass 3 Light Post Mount Light, Sterling brass 3 Light Post Mount Lights, Sterling brass 3 Light Post Mount Lighting, brass post mount light, brass post mount lights, brass post mount lighting, The Sterling Deep Cone Reflector Copper 3-Light Post Mount Light, The Sterling Deep Cone Reflector 3-Light Copper Post Mount Lights, The Sterling Deep Cone Reflector 3-Light Copper Post Mount Lighting, Sterling Deep Cone Reflector Copper 3-Light Post Mount Light, Sterling Deep Cone Reflector Copper 3-Light Post Mount Lights, Sterling Deep Cone Reflector Copper 3-Light Post Mount Lighting, The Sterling Deep Cone Reflector Copper 3 Light Post Mount Light, The Sterling Deep Cone Reflector Copper 3 Light Post Mount Lights, The Sterling Deep Cone Reflector copper 3 Light Post Mount Lighting, Sterling Deep Cone Reflector copper 3 Light Post Mount Light, Sterling Deep Cone Reflector copper 3 Light Post Mount Lights, Sterling Deep Cone Reflector copper 3 Light Post Mount Lighting, The Sterling Reflector copper 3-Light Post Mount Light, The Sterling Reflector copper 3-Light Post Mount Lights, The Sterling Reflector copper 3-Light Post Mount Lighting, Sterling Reflector copper 3-Light Post Mount Light, Sterling Reflector copper 3-Light Post Mount Lights, Sterling Reflector copper 3-Light Post Mount Lighting, The Sterling Reflector copper 3 Light Post Mount Light, The Sterling Reflector copper 3 Light Post Mount Lights, The Sterling Reflector copper 3 Light Post Mount Lighting, Sterling Reflector copper 3 Light Post Mount Light, Sterling Reflector copper 3 Light Post Mount Lights, Sterling Reflector copper 3 Light Post Mount Lighting, The Sterling Deep Cone copper 3-Light Post Mount Light, The Sterling Deep Cone copper 3-Light Post Mount Lights, The Sterling Deep Cone copper 3-Light Post Mount Lighting, Sterling Deep Cone copper 3-Light Post Mount Light, Sterling Deep Cone copper 3-Light Post Mount Lights, Sterling Deep Cone copper 3-Light Post Mount Lighting, The Sterling Deep Cone copper 3 Light Post Mount Light, The Sterling Deep Cone copper 3 Light Post Mount Lights, The Sterling Deep Cone copper 3 Light Post Mount Lighting, Sterling Deep Cone copper 3 Light Post Mount Light, Sterling Deep Cone copper 3 Light Post Mount Lights, Sterling Deep Cone 3 Light copper Post Mount Lighting, The Sterling 3-Light copper Post Mount Light, The Sterling 3-Light copper Post Mount Lights, The Sterling 3-Light copper Post Mount Lighting, 3-Light copper Post Mount Light, Sterling copper 3-Light Post Mount Lights, Sterling copper 3-Light Post Mount Lighting, The Sterling copper 3 Light Post Mount Light, The Sterling copper 3 Light Post Mount Lights, The Sterling copper 3 Light Post Mount Lighting, Sterling copper 3 Light Post Mount Light, Sterling copper 3 Light Post Mount Lights, Sterling copper 3 Light Post Mount Lighting, copper post mount light, copper post mount lights, copper post mount lighting, sterling post, sterling 3 light, sterling triple, sterling, 3 light post, triple post, deep cone post mount, reflector post mount, 3 post, sterling post mount, BLE-DCS14, BLE-DCS16, SPS-0270, SPS 0270, SPS0270, The Sterling Post Mount Collection, Sterling Post mount Collection, The Sterling Post Mount Series, Sterling Post mount Series, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, post mount triple, lamp post lights, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting, Sterling Triple Post Mount Light | Barn Light Electric 1440.000000 1627,1835,2001,1907M 194314 Barn Light Electric Company the-sterling-deep-cone-reflector-3-light-post-mount-light 1887/1904/1907 B