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

Query time 0.00139

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 = 64190 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
64190 BLE-PMD-SBA E C M W A 0 A 1 861.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;} 1769625879 Price increased 5% from $745 to $782- DC 5/28/21 Price increased 10% from $782 to $861 - DC 6/1/22 Y none none 1830,1831,1832 BLE {"22397":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0 en Aero Double Post Mount Light <p>With its flared base and stacked neck design, the American-made Aero reinvents classic designs for contemporary installation. The Aero joins two timeless RLM shades with a durable post mounting to create the ideal exterior light. Commercial venues often use the Aero to carry a touch of style throughout their entire property, elevating their curb appeals. Homeowners incorporate this post mount light to illuminate sprawling driveways, large balconies, and private docks.</p> <p>Despite an emphasis on style, the Aero still demonstrates the meticulous craftsmanship we’re known for. Solid pieces of metal are spun on a lathe, and are carefully manipulated by hand until they assume the Aero’s unique shape. Available with our overflowing selection of finish options — including marine grade, powder coat, solid copper, and elegant brass — let the Aero adapt to anyone’s preferred aesthetic!</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> A versatile outdoor post mount light, the Aero is the ideal fixture for residential and commercial spaces! BLE-PMD-SBA, The Aero Double Post Mount Light, The Aero Double Post Mount Lights, The Aero Double Post Mount Lighting, Aero Double Post Mount Light, Aero Double Post Mount Lights, Aero Double Post Mount Lighting, Aero Double Post Mount Exterior Light, BLE-PMD-SBA, aero, double post, post mount, exterior light, double light, light pole, contemporary outdoor light, outdoor light, double arm, lamppost, outdoor deck lighting, deck lighting, driveway lights, restaurant, patio lighting, BLE-PMD-SBA14, BLE-PMD-SBA16, Aero Decorative Double Post Mount Exterior Light, Aero light pole, Aero post mount, BLE-PMDD-SBA, aero, decorative, double post, post mount, exterior light, double pole, pole light, decorative post, post mount light, light pole, BLE-PMDD-SBA14, BLE-PMDD-SBA16, post light, 2-light post light, two light, Aero Decorative 2-Light Post Mount Light, Aero Copper Decorative Double Post Mount Exterior Light, Aero Copper Decorative Double Post Mount Exterior Lights, Aero Copper Decorative Double Post Mount Exterior Lighting, Aero Copper Decorative Double Post Mount Light, Aero Copper Decorative Double Post Mount Lights, Aero Copper Decorative Double Post Mount Lighting, Aero Copper Double Post Mount Exterior Light, Aero Copper Double Post Mount Exterior Lights, Aero Copper Double Post Mount Exterior Lighting, Aero Copper Double Post Mount Light, Aero Copper Double Post Mount Lights, Aero 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, Aero, aero post mount, aero post mounts, aero post mount light, aero post mount lights, aero post mount lighting, Copper post mount, copper post mounts, Post mount copper light, post mount copper lights, post mount copper lighting, BLE-PMDD-SBA-COP, BLE-PMD-SBA-COP, Aero Copper Double Post Mount Exterior Light, Aero Copper Double Post Mount Exterior Lights, Aero Copper Double Post Mount Exterior Lighting, The Aero Copper Double Post Mount Exterior Light, The Aero Copper Double Post Mount Exterior Lights, The Aero Copper Double Post Mount Exterior Lighting, Aero Copper Double Post Mount Light, Aero Copper Double Post Mount Lights, Aero Copper Double Post Mount Lighting, The Aero Copper Double Post Mount Light, The Aero Copper Double Post Mount Lights, The Aero Copper Double Post Mount Lighting, Aero Double Post Mount Exterior Light, Aero Double Post Mount Exterior Lights, Aero Double Post Mount Exterior Lighting, The Aero Double Post Mount Exterior Light, The Aero Double Post Mount Exterior Lights, The Aero Double Post Mount Exterior Lighting, Aero Double Post Mount Light, Aero Double Post Mount Lights, Aero Double Post Mount Lighting, The Aero Double Post Mount Light, The Aero Double Post Mount Lights, The Aero Double Post Mount Lighting, Aero Copper Post Mount Exterior Light, Aero Copper Post Mount Exterior Lights, Aero Copper Post Mount Exterior Lighting, The Aero Copper Post Mount Exterior Light, The Aero Copper Post Mount Exterior Lights, The Aero Copper Post Mount Exterior Lighting, Aero Copper Post Mount Light, Aero Copper Post Mount Lights, Aero Copper Post Mount Lighting, The Aero Copper Post Mount Light, The Aero Copper Post Mount Lights, The Aero Copper Post Mount Lighting, Aero Post Mount Exterior Light, Aero Post Mount Exterior Lights, Aero Post Mount Exterior Lighting, The Aero Post Mount Exterior Light, The Aero Post Mount Exterior Lights, The Aero Post Mount Exterior Lighting, Aero Post Mount Light, Aero Post Mount Lights, Aero Post Mount Lighting, The Aero Post Mount Light, The Aero Post Mount Lights, The Aero Post Mount Lighting, Aero post mount, aero post mounts, aero post mount light, aero post mount lights, aero post mount lighting, The Aero post mount, The aero post mounts, The aero post mount light, The aero post mount lights, The aero 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, Aero, BLE-PMD-SBA-BRS, Aero Brass Double Post Mount Exterior Light, Aero Brass Double Post Mount Exterior Lights, Aero Brass Double Post Mount Exterior Lighting, The Aero Brass Double Post Mount Exterior Light, The Aero Brass Double Post Mount Exterior Lights, The Aero Brass Double Post Mount Exterior Lighting, Aero Brass Double Post Mount Light, Aero Brass Double Post Mount Lights, Aero Brass Double Post Mount Lighting, The Aero Brass Double Post Mount Light, The Aero Brass Double Post Mount Lights, The Aero Brass Double Post Mount Lighting, Aero Brass Post Mount Exterior Light, Aero Brass Post Mount Exterior Lights, Aero Brass Post Mount Exterior Lighting, The Aero Brass Post Mount Exterior Light, The Aero Brass Post Mount Exterior Lights, The Aero Brass Post Mount Exterior Lighting, Aero Brass Post Mount Light, Aero Brass Post Mount Lights, Aero Brass Post Mount Lighting, The Aero Brass Post Mount Light, The Aero Brass Post Mount Lights, The Aero Brass Post Mount Lighting, Aero Post Mount Exterior Light, Aero Post Mount Exterior Lights, Aero Post Mount Exterior Lighting, The Aero Post Mount Exterior Light, The Aero Post Mount Exterior Lights, The Aero Post Mount Exterior Lighting, Aero Post Mount Light, Aero Post Mount Lights, Aero Post Mount Lighting, The Aero Post Mount Light, The Aero Post Mount Lights, The Aero Post Mount Lighting, Aero post mount, aero post mounts, aero post mount light, aero post mount lights, aero post mount lighting, The Aero post mount, The aero post mounts, The aero post mount light, The aero post mount lights, The aero 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, Aero Brass Decorative Double Post Mount Exterior Light, Aero Brass Decorative Double Post Mount Exterior Lights, Aero Brass Decorative Double Post Mount Exterior Lighting, Aero Brass Decorative Double Post Mount Light, Aero Brass Decorative Double Post Mount Lights, Aero Brass Decorative Double Post Mount Lighting, Aero Brass Double Post Mount Exterior Light, Aero Brass Double Post Mount Exterior Lights, Aero Brass Double Post Mount Exterior Lighting, Aero Brass Double Post Mount Light, Aero Brass Double Post Mount Lights, Aero 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, Brass post mount, brass post mounts, Post mount brass light, post mount brass lights, post mount brass lighting, BLE-PMDD-SBA-BRS, aero, aero post, aero double post, 2 light aero, double aero, double aero post, double aero post mount, 2 light aero post, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, SPS-0025, SPS 0025, SPS0025, The Aero Post Mount Collection, The Aero Post Mount Series, Aero Post Mount Collection, Aero 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, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting, Aero Double Post Mount Light | Barn Light Electric 861.000000 1616,1835,2001,1907M 203061 Barn Light Electric Company 5 the-aero-double-post-mount-exterior-light 1887/1904/1907 B