Mysql分析

SELECT
    EVALUATION_STATUS,
    PROD_ID,
    a.ORDER_ID,
    a.PROD_SKU_ID
  FROM
      b2c_evaluation a,
      b2c_order o
  WHERE
      NOT EXISTS (
          SELECT
              1
          FROM
              b2c_evaluation
          WHERE
              ORDER_ID = a.ORDER_ID
          AND PROD_ID = a.PROD_ID
          AND PROD_SKU_ID = a.PROD_SKU_ID
          AND EVALUATION_STATUS != 4
          AND EVALUATION_STATUS > a.EVALUATION_STATUS
      )
  AND a.ORDER_ID = o.ORDER_ID
  AND o.ORDER_TYPE != '11'
  AND o.order_status = '04'
  AND a.EVALUATER_ID = #value:VARCHAR#
  ORDER BY
      EVALUATION_STATUS ASC,
      evaluation_time DESC

已评价列表 包括初评，追平（追平中要去除初次评价的信息），从两条相同信息的根据某个条件进行再次筛选