md_YOS/src/custom/restcontroller/crm/agent/orderclue/SQL/查询最新的跟进方式.sql

SELECT a.sat_orderclueid, b.logtype,b.content,b.createby,b.createdate
from (
         SELECT sat_orderclueid, Max(createdate) createdate
         from sat_ordercluefollowuplog
         WHERE siteid = $siteid$ and sat_orderclueid in $sat_orderclueid$
         GROUP BY sat_orderclueid) a
         LEFT JOIN sat_ordercluefollowuplog b ON a.createdate = b.createdate
WHERE b.siteid = $siteid$