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 = 65164 
  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 = 65164 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00188

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 = 65164 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": 3,
      "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
65164 BLE-PMD-WHU-CGG-LED E C M W A 0 A 1 1452.00 1000 0.000 0 0 0 0.00 0 1588875754 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;} 1769107795 Price increased 5% from $1257 to $1320 - DC 5/28/21 Price increased 10% from $1320 to $1452 - DC 6/2/22 Y none none 2634,2635,2637 BLE {"22397":10,"22643":10,"22644":11,"22645":12,"23116":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0 en Union Nautical LED Double Post Mount Light <p>Instantly heightening a home or business’s curb appeal, the Union’s two handspun shades are equipped with timeless, rugged metal guards. Not purely decorative flourishes, these metal guards also protect the fixture’s electrical components in outdoor settings. By producing ample illumination, the Union can brighten any space — helping them appear safer and more welcoming at night! Available with protective marine grade, vibrant powder coat colors, and elegant copper and brass finishes, this fixture can adopt anyone’s individual tastes. <br /><br />The Union integrates LED lights into its construction. With its unmatched efficiency, this innovative design produces illumination with minimal wasted energy. By reducing overall energy consumption, this technology is responsible for substantial financial relief and environmental sustainability.</p> <p>|break|</p> <ul> <li>This outdoor light includes a handcrafted, American-made RLM warehouse shade.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> </ul> Energy efficient and uniquely stylish, the Union outfits classic fixtures with high-performance LED tech. Install in public parks or parking lots to save money and bring style to the space! BLE-PMD-WHU, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union post mount, Union double post mount, union, double post, post mount, exterior light, lamppost, double arm, light pole light pole fixture, double light, light post , commercial lighting, parking lot lights, lot lights, walkway lighting, BLE-PMD-WHU, BLE-PMD-WHU14, BLE-PMD-WHU16, Union Decorative Double Post Mount Exterior Light, union, BLE-PMDD-WHU, decorative, double post, post mount, exterior light, american made, decorative post, double pole, pole light, warehouse shade, outdoor light, light fixture, patio light sidewalk light, park light, pole mount, BLE-PMDD-WHU14, BLE-PMDD-WHU16, outdoor lighting, exterior light, Union Brass Double Post Mount Exterior Light, Union Brass Double Post Mount Exterior Lights, Union Brass Double Post Mount Exterior Lighting, The Union Brass Double Post Mount Exterior Light, The Union Brass Double Post Mount Exterior Lights, The Union Brass Double Post Mount Exterior Lighting, Union Brass Double Post Mount Light, Union Brass Double Post Mount Lights, Union Brass Double Post Mount Lighting, The Union Brass Double Post Mount Light, The Union Brass Double Post Mount Lights, The Union Brass Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union Double Post Mount Exterior Lights, Union Double Post Mount Exterior Lighting, The Union Double Post Mount Exterior Light, The Union Double Post Mount Exterior Lights, The Union Double Post Mount Exterior Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Brass Post Mount Exterior Light, Union Brass Post Mount Exterior Lights, Union Brass Post Mount Exterior Lighting, The Union Brass Post Mount Exterior Light, The Union Brass Post Mount Exterior Lights, The Union Brass Post Mount Exterior Lighting, Union Brass Post Mount Light, Union Brass Post Mount Lights, Union Brass Post Mount Lighting, The Union Brass Post Mount Light, The Union Brass Post Mount Lights, The Union Brass Post Mount Lighting, Union Post Mount Exterior Light, Union Post Mount Exterior Lights, Union Post Mount Exterior Lighting, The Union Post Mount Exterior Light, The Union Post Mount Exterior Lights, The Union Post Mount Exterior Lighting, Union Post Mount Light, Union Post Mount Lights, Union Post Mount Lighting, The Union Post Mount Light, The Union Post Mount Lights, The Union Post Mount Lighting, Union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, The Union post mount, The union post mounts, The union post mount light, The union post mount lights, The union post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, The brass post mount, The brass post mounts, The brass post mount light, The brass post mount lights, The brass post mount lighting, double post mount, double post mounts, double post mount light, double post mount lights, double post mount lighting, The double post mount, The double post mounts, The double post mount light, The double post mount lights, The double post mount lighting, Post mount, post mounts, post mount light, post mount lights, post mount lighting, Union, BLE-PMD-WHU-BRS, BLE-PMDD-WHU-COP, Union Copper Decorative Double Post Mount Exterior Light, Union Copper Decorative Double Post Mount Exterior Lights, Union Copper Decorative Double Post Mount Exterior Lighting, Union Copper Decorative Double Post Mount Light, Union Copper Decorative Double Post Mount Lights, Union Copper Decorative Double Post Mount Lighting, Union Copper Double Post Mount Exterior Light, Union Copper Double Post Mount Exterior Lights, Union Copper Double Post Mount Exterior Lighting, Union Copper Double Post Mount Light, Union Copper Double Post Mount Lights, Union Copper Double Post Mount Lighting, Copper Decorative Double Post Mount Exterior Light, Copper Decorative Double Post Mount Exterior Lights, Copper Decorative Double Post Mount Exterior Lighting, Copper Double Post Mount Exterior Light, Copper Double Post Mount Exterior Lights, Copper Double Post Mount Exterior Lighting, Copper Decorative Double Post Mount Light, Copper Decorative Double Post Mount Lights, Copper Decorative Double Post Mount Lighting, Copper Double Post Mount Light, Copper Double Post Mount Lights, Copper Double Post Mount Lighting, Copper Post Mount Light, Copper Post Mount Lights, Copper Post Mount Lighting, Union, union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, Copper post mount, copper post mounts, Post mount copper light, post mount copper lights, post mount copper lighting, BLE-PMD-WHU-COP, Union Copper Double Post Mount Exterior Light, Union Copper Double Post Mount Exterior Lights, Union Copper Double Post Mount Exterior Lighting, The Union Copper Double Post Mount Exterior Light, The Union Copper Double Post Mount Exterior Lights, The Union Copper Double Post Mount Exterior Lighting, Union Copper Double Post Mount Light, Union Copper Double Post Mount Lights, Union Copper Double Post Mount Lighting, The Union Copper Double Post Mount Light, The Union Copper Double Post Mount Lights, The Union Copper Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union Double Post Mount Exterior Lights, Union Double Post Mount Exterior Lighting, The Union Double Post Mount Exterior Light, The Union Double Post Mount Exterior Lights, The Union Double Post Mount Exterior Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Copper Post Mount Exterior Light, Union Copper Post Mount Exterior Lights, Union Copper Post Mount Exterior Lighting, The Union Copper Post Mount Exterior Light, The Union Copper Post Mount Exterior Lights, The Union Copper Post Mount Exterior Lighting, Union Copper Post Mount Light, Union Copper Post Mount Lights, Union Copper Post Mount Lighting, The Union Copper Post Mount Light, The Union Copper Post Mount Lights, The Union Copper Post Mount Lighting, Union Post Mount Exterior Light, Union Post Mount Exterior Lights, Union Post Mount Exterior Lighting, The Union Post Mount Exterior Light, The Union Post Mount Exterior Lights, The Union Post Mount Exterior Lighting, Union Post Mount Light, Union Post Mount Lights, Union Post Mount Lighting, The Union Post Mount Light, The Union Post Mount Lights, The Union Post Mount Lighting, Union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, The Union post mount, The union post mounts, The union post mount light, The union post mount lights, The union post mount lighting, copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, The copper post mount, The copper post mounts, The copper post mount light, The copper post mount lights, The copper post mount lighting, double post mount, double post mounts, double post mount light, double post mount lights, double post mount lighting, The double post mount, The double post mounts, The double post mount light, The double post mount lights, The double post mount lighting, Post mount, post mounts, post mount light, post mount lights, post mount lighting, Union, Union Brass Decorative Double Post Mount Exterior Light, Union Brass Decorative Double Post Mount Exterior Lights, Union Brass Decorative Double Post Mount Exterior Lighting, Union Brass Decorative Double Post Mount Light, Union Brass Decorative Double Post Mount Lights, Union Brass Decorative Double Post Mount Lighting, Union Brass Double Post Mount Exterior Light, Union Brass Double Post Mount Exterior Lights, Union Brass Double Post Mount Exterior Lighting, Union Brass Double Post Mount Light, Union Brass Double Post Mount Lights, Union Brass Double Post Mount Lighting, Brass Decorative Double Post Mount Exterior Light, Brass Decorative Double Post Mount Exterior Lights, Brass Decorative Double Post Mount Exterior Lighting, Brass Double Post Mount Exterior Light, Brass Double Post Mount Exterior Lights, Brass Double Post Mount Exterior Lighting, Brass Decorative Double Post Mount Light, Brass Decorative Double Post Mount Lights, Brass Decorative Double Post Mount Lighting, Brass Double Post Mount Light, Brass Double Post Mount Lights, Brass Double Post Mount Lighting, Brass Post Mount Light, Brass Post Mount Lights, Brass Post Mount Lighting, Union, union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, Brass post mount, brass post mounts, Post mount brass light, post mount brass lights, post mount brass lighting, BLE-PMDD-WHU-BRS, union double, 2 light union, double union, union post, union double post, union, union 2 light, union two light, new led post, Union Nautical LED Double Post Mount Light, Union Nautical LED Double Post Mount, Union Nautical Double Post Mount Light, Union Nautical LED Post Mount Light, Union Nautical Double Post Mount, Union Nautical LED Post Mount, Union Nautical Post Mount Light, Union Nautical Post Mount, Union led Post Mount, Nautical led, Union nautical, nautical union, union led, led union, led union post mount, union led post mount, BLE-PMD-WHU14, BLE-PMD-WHU16, BLE-PMDD-WHU14, BLE-PMDD-WHU16, rustic LED Post mount, rustic LED Post mount light, rustic+LED+Post+mount, union series, union collection, the union series, the union collection, union LED series, union LED collection, the union led series, the union led collection, SPS-0271, SPS 0271, SPS0271, SPS-0271, SPS 0271, SPS0271, The Union Post Mount Collection, the Union Post Mount Series, Union Post Mount Collection, Union 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 double, LED post top, LED Post top light, LED Post Top Lights, LED Post top lighting, LED Post top fixture, LED post top fixtures, led post top light fixture, led post top light fixtures, rustic LED Post mount, rustic LED Post mounts, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting, Union Nautical LED Double Post Mount Light | Barn Light Electric 1452.000000 1858,2001,1936M 106468 Barn Light Electric Company 3 union-nautical-led-double-post-mount-light 1920/1933/1936 B