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

Query time 0.00129

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 = 64187 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": 9,
      "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
64187 BLE-PMD-WHS E C M W A 0 A 1 922.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;} 1767809306 Price increased 5% from $798 to $838 - DC 5/28/21 Price increased 10% from $838 to $922 - DC 6/1/22 Y none none 1783,1784,1785 BLE {"22397":10} 0 0 0 0 0 0 0 0 0 1 0.00 0 en The Original™ Double Post Mount Light <p>The classic look of vintage warehouse shades in a double post mount light! The Original™, one of our most popular shades, dispenses plenty of light throughout parking lots, walkways, and restaurant patios. For residential applications, this post mount light brightens long driveways and highlights landscaping. Thanks to its timeless style, The Original™ instantly becomes a key piece in your outdoor décor.</p> <p>Several finishes adjust the appearance of The Original™, letting you customize this fixture to your specific requirements. Unique powder coat finishes elevate a space’s curb appeal while copper and brass give The Original™ a memorable appearance!</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<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Learn more about The Original™ Double Post Mount Light over on our<span> <a href="https://www.barnlight.com/inspiration/featured-customer-dark-sky-friendly-lights-for-the-grand-canyon/" target="_blank">blog</a>!</span></li> </ul> These American made double pole light fixtures with two warehouse shades. Add this stylish post mount light as a restaurant outdoor light or sidewalk light! BLE-PMD-WHS, The Sky Chief Double Post Mount Light, The Sky Chief Double Post Mount Lights, The Sky Chief Double Post Mount Lighting, Sky Chief Double Post Mount Light, Sky Chief Double Post Mount Lights, Sky Chief Double Post Mount Lighting, sky chief, decorative, double post, post mount, exterior light, Sky Chief Decorative Double Post Mount Exterior Light, sky chief light pole, BLE-PMDD-WHS, american made, double pole, pole light, light fixture, warehouse shade, decorative post, post mount light, restaurant outdoor light, outdoor light, sidewalk light, BLE-PMDD-WHS14, BLE-PMDD-WHS16, BLE-PMDD-WHS18, BLE-PMDD-WHS20, Sky chief Post Mount Exterior Light , sky chief post mount, BLE-PMD-WHS, sky chief, double post, post mount, exterior light, double light, lamppost, double arm, post light, modern outdoor light, outdoor light, driveway lighting, commercial lights, garden lights, pole light, pose light, pole mount, BLE-PMD-WHS14, BLE-PMD-WHS16, BLE-PMD-WHS18, BLE-PMD-WHS20, Sky chief Brass Double Post Mount Exterior Light, Sky chief Brass Double Post Mount Exterior Lights, Sky chief Brass Double Post Mount Exterior Lighting, The Sky chief Brass Double Post Mount Exterior Light, The Sky chief Brass Double Post Mount Exterior Lights, The Sky chief Brass Double Post Mount Exterior Lighting, Sky chief Brass Double Post Mount Light, Sky chief Brass Double Post Mount Lights, Sky chief Brass Double Post Mount Lighting, The Sky chief Brass Double Post Mount Light, The Sky chief Brass Double Post Mount Lights, The Sky chief Brass Double Post Mount Lighting, Sky chief Double Post Mount Exterior Light, Sky chief Double Post Mount Exterior Lights, Sky chief Double Post Mount Exterior Lighting, The Sky chief Double Post Mount Exterior Light, The Sky chief Double Post Mount Exterior Lights, The Sky chief Double Post Mount Exterior Lighting, Sky chief Double Post Mount Light, Sky chief Double Post Mount Lights, Sky chief Double Post Mount Lighting, The Sky chief Double Post Mount Light, The Sky chief Double Post Mount Lights, The Sky chief Double Post Mount Lighting, Sky chief Brass Post Mount Exterior Light, Sky chief Brass Post Mount Exterior Lights, Sky chief Brass Post Mount Exterior Lighting, The Sky chief Brass Post Mount Exterior Light, The Sky chief Brass Post Mount Exterior Lights, The Sky chief Brass Post Mount Exterior Lighting, Sky chief Brass Post Mount Light, Sky chief Brass Post Mount Lights, Sky chief Brass Post Mount Lighting, The Sky chief Brass Post Mount Light, The Sky chief Brass Post Mount Lights, The Sky chief Brass Post Mount Lighting, Sky chief Post Mount Exterior Light, Sky chief Post Mount Exterior Lights, Sky chief Post Mount Exterior Lighting, The Sky chief Post Mount Exterior Light, The Sky chief Post Mount Exterior Lights, The Sky chief Post Mount Exterior Lighting, Sky chief Post Mount Light, Sky chief Post Mount Lights, Sky chief Post Mount Lighting, The Sky chief Post Mount Light, The Sky chief Post Mount Lights, The Sky chief Post Mount Lighting, Sky chief post mount, sky chief post mounts, sky chief post mount light, sky chief post mount lights, sky chief post mount lighting, The Sky chief post mount, The sky chief post mounts, The sky chief post mount light, The sky chief post mount lights, The sky chief 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, Sky chief, sky, chief, sky cheif, cheif, BLE-PMDD-WHS-COP, Sky chief Copper Decorative Double Post Mount Exterior Light, Sky chief Copper Decorative Double Post Mount Exterior Lights, Sky chief Copper Decorative Double Post Mount Exterior Lighting, Sky chief Copper Decorative Double Post Mount Light, Sky chief Copper Decorative Double Post Mount Lights, Sky chief Copper Decorative Double Post Mount Lighting, Sky chief Copper Double Post Mount Exterior Light, Sky chief Copper Double Post Mount Exterior Lights, Sky chief Copper Double Post Mount Exterior Lighting, Sky chief Copper Double Post Mount Light, Sky chief Copper Double Post Mount Lights, Sky chief 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, Sky chief, sky chief post mount, sky chief post mounts, sky chief post mount light, sky chief post mount lights, sky chief post mount lighting, Copper post mount, copper post mounts, Post mount copper light, post mount copper lights, post mount copper lighting, sky, chief, sky cheif, cheif, BLE-PMD-WHS-COP, Sky chief Copper Double Post Mount Exterior Light, Sky chief Copper Double Post Mount Exterior Lights, Sky chief Copper Double Post Mount Exterior Lighting, The Sky chief Copper Double Post Mount Exterior Light, The Sky chief Copper Double Post Mount Exterior Lights, The Sky chief Copper Double Post Mount Exterior Lighting, Sky chief Copper Double Post Mount Light, Sky chief Copper Double Post Mount Lights, Sky chief Copper Double Post Mount Lighting, The Sky chief Copper Double Post Mount Light, The Sky chief Copper Double Post Mount Lights, The Sky chief Copper Double Post Mount Lighting, Sky chief Double Post Mount Exterior Light, Sky chief Double Post Mount Exterior Lights, Sky chief Double Post Mount Exterior Lighting, The Sky chief Double Post Mount Exterior Light, The Sky chief Double Post Mount Exterior Lights, The Sky chief Double Post Mount Exterior Lighting, Sky chief Double Post Mount Light, Sky chief Double Post Mount Lights, Sky chief Double Post Mount Lighting, The Sky chief Double Post Mount Light, The Sky chief Double Post Mount Lights, The Sky chief Double Post Mount Lighting, Sky chief Copper Post Mount Exterior Light, Sky chief Copper Post Mount Exterior Lights, Sky chief Copper Post Mount Exterior Lighting, The Sky chief Copper Post Mount Exterior Light, The Sky chief Copper Post Mount Exterior Lights, The Sky chief Copper Post Mount Exterior Lighting, Sky chief Copper Post Mount Light, Sky chief Copper Post Mount Lights, Sky chief Copper Post Mount Lighting, The Sky chief Copper Post Mount Light, The Sky chief Copper Post Mount Lights, The Sky chief Copper Post Mount Lighting, Sky chief Post Mount Exterior Light, Sky chief Post Mount Exterior Lights, Sky chief Post Mount Exterior Lighting, The Sky chief Post Mount Exterior Light, The Sky chief Post Mount Exterior Lights, The Sky chief Post Mount Exterior Lighting, Sky chief Post Mount Light, Sky chief Post Mount Lights, Sky chief Post Mount Lighting, The Sky chief Post Mount Light, The Sky chief Post Mount Lights, The Sky chief Post Mount Lighting, Sky chief post mount, sky chief post mounts, sky chief post mount light, sky chief post mount lights, sky chief post mount lighting, The Sky chief post mount, The sky chief post mounts, The sky chief post mount light, The sky chief post mount lights, The sky chief 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, Sky chief, sky, chief, sky cheif, cheif, BLE-PMDD-WHS-BRS-LED, Sky Chief Brass Decorative Double LED Post Mount Light, Sky Chief Brass Decorative Double LED Post Mount Lights, Sky Chief Brass Decorative Double LED Post Mount Lighting, Sky Chief Decorative Double LED Post Mount Light, Sky Chief Decorative Double LED Post Mount Lights, Sky Chief Decorative Double LED Post Mount Lighting, Sky Chief Brass Double LED Post Mount Light, Sky Chief Brass Double LED Post Mount Lights, Sky Chief Brass Double LED Post Mount Lighting, Sky Chief Brass Decorative Double Post Mount Light, Sky Chief Brass Decorative Double Post Mount Lights, Sky Chief Brass Decorative Double Post Mount Lighting, Sky Chief Post Mount Light, Sky Chief Post Mount Lights, Sky Chief Post Mount Lighting, Sky Chief Brass Post Mount Light, Sky Chief Brass Post Mount Lights, Sky Chief Brass Post Mount Lighting, Sky Chief LED Post Mount Light, Sky Chief LED Post Mount Lights, Sky Chief LED Post Mount Lighting, Sky Chief Double Post Mount Light, Sky Chief Double Post Mount Lights, Sky Chief Double Post Mount Lighting, Sky Chief Brass Decorative LED Double Post Mount Light, Sky Chief Brass Decorative LED Double Post Mount Lights, Sky Chief Brass Decorative LED Double Post Mount Lighting, Sky Chief Double Brass Decorative LED Post Mount Light, Sky Chief Double Brass Decorative LED Post Mount Lights, Sky Chief Double Brass Decorative LED Post Mount Lighting, Sky Chief Double Decorative LED Post Mount Light, Sky Chief Double Decorative LED Post Mount Lights, Sky Chief Double Decorative LED Post Mount Lighting, Sky Chief Double Brass Decorative Post Mount Light, Sky Chief Double Brass Decorative Post Mount Lights, Sky Chief Double Brass Decorative Post Mount Lighting, Sky Chief Double Brass LED Post Mount Light, Sky Chief Double Brass LED Post Mount Lights, Sky Chief Double Brass LED Post Mount Lighting, Sky Chief Double Post Mount Light, Sky Chief Double Post Mount Lights, Sky Chief Double Post Mount Lighting, Sky Chief Post Mount Light, Sky Chief Post Mount Lights, Sky Chief Post Mount Lighting, Decorative post mount, decorative post mounts, led post mount, led post mounts, brass post mount, brass post mounts, decorative brass post mount, decorative brass post mounts, brass decorative post mount, brass decorative post mounts, decorative led post mount, decorative led post mounts, led decorative post mount, led decorative post mounts, brass, led, decorative, Post mount brass, post mount brass light, post mount brass lights, post mount brass lighting, Two light, two-light, Two-light post mount, two-light post mounts, two-light post mount light, two-light post mount lights, two-light post mount lighting, Two light post mount, two light post mounts, two light post mount light, two light post mount lights, two light post mount lighting, 2-light post mount, 2-light post mounts, 2-light post mount light, 2-light post mount lights, 2-light post mount lighting, 2 light post mount, 2 light post mounts, 2 light post mount light, 2 light post mount lights, 2 light post mount lighting, sky, chief, sky cheif, cheif, double post, sky chief 2 light post, sky chief double, double sky chief, skychief post, skychief double, 2 light post, The Original Double Post Mount Light, Original Double Post Mount Light, The Original Double Post Mount, Original Double Post Mount, Original Double Post Mount, Original Double Post Mount Light, Original Post Mount Light, Original Post Mount, Original Double Post Mount, Original, Original Post, The Original, original, BLE-PMD-WHS14, BLE-PMD-WHS16, BLE-PMDD-WHS16, BLE-PMDD-WHS14, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, SPS-0269, SPS 0269, SPS0269, The Original Post Mount Collection, The Original™ Post Mount Collection, The Originaltm post mount collection, The Original Post Mount series, The Original™ Post Mount series, The Originaltm post mount series, Original Post Mount Collection, Original™ Post Mount Collection, Originaltm post mount collection, Original Post Mount series, Original™ Post Mount series, Originaltm post mount series, SPS-0589, SPS 0589, SPS0589, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting, outdoor pole lights, light post lighting, H-15114, H-15116, classic warehouse shade post light rlm, classic warehouse shade, The Original™ Double Post Mount Light | Barn Light Electric 922.000000 1526,1538,1614,1666,1835,2001,1907M 255869 Barn Light Electric Company 23 the-original-double-post-mount-light 1887/1904/1907 B