SELECT
  product_id,
  product_name,
  pic,
  sp_data,
  SUM(quantity) AS total_sales
FROM order_items
GROUP BY sku_id;  -- 這里只按sku_id分組

SELECT
  product_id,
  product_name,
  pic,
  sp_data,
  SUM(quantity) AS total_sales
FROM order_items
GROUP BY 
  sku_id,          -- 原始分組列
  product_id,      -- 新增
  product_name,    -- 新增
  pic,             -- 新增
  sp_data          -- 新增

SELECT
  MAX(product_id) AS product_id,      -- 使用MAX取值
  MAX(product_name) AS product_name,  -- 使用MAX取值
  MAX(pic) AS pic,
  MAX(sp_data) AS sp_data,
  SUM(quantity) AS total_sales
FROM order_items
GROUP BY sku_id  -- 只需分組一列

-- 第一步：查看當(dāng)前模式
SELECT @@sql_mode;

-- 第二步：移除ONLY_FULL_GROUP_BY
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- 第三步：執(zhí)行原SQL
SELECT ... （原始問題語句）

SELECT
  item.product_id,
  item.product_name,
  item.pic,
  item.sp_data,
  SUM(item.quantity) AS total_sales  -- 去掉IFNULL更簡潔
FROM oms_order_item item
INNER JOIN oms_order o ON o.id = item.order_id  -- 改用INNER JOIN
WHERE o.STATUS IN (1, 2, 3)
  AND item.create_time >= '2025-07-28 00:00:00'
  AND item.create_time < '2025-07-29 00:00:00'
GROUP BY 
  item.sku_id,
  item.product_id,     -- 關(guān)鍵修復(fù)！
  item.product_name,   -- 關(guān)鍵修復(fù)！
  item.pic,            -- 關(guān)鍵修復(fù)！
  item.sp_data         -- 關(guān)鍵修復(fù)！
ORDER BY total_sales DESC
LIMIT 10;

-- 確保sku_id能唯一確定商品信息
ALTER TABLE products ADD UNIQUE (sku_id);