select maxt1operational_progress operational_progresst1operational_remark t1product_skc_idt1main_reason from erp_pdd_stock_assessment t1where t1mian_reason in and t1product_skc_id in group by t1main

这个查询语句中的语法错误会导致数据错乱。修正后的查询语句应该是这样的：

SELECT MAX(t1.operational_progress) AS operational_progress,
       t1.operational_remark,
       t1.product_skc_id,
       t1.main_reason  
FROM erp_pdd_stock_assessment t1
WHERE t1.main_reason IN (value1, value2, ...) 
  AND t1.product_skc_id IN (value1, value2, ...)
GROUP BY t1.main_reason, t1.product_skc_id

在上面的查询语句中，你需要将 value1, value2, ... 替换为你想要过滤的 main_reason 和 product_skc_id 的实际值。