SQL 查询：过滤掉数据库中以前出现过的 CrashIdentifier

要修改代码以仅包含近一天在数据库中以前从未出现过的 CrashIdentifier，可以使用以下查询：

SELECT 
    PlatformType AS PlatformType,
    CrashIdentifier,
    CrashContent2 AS stack,
    COUNT(*) AS count
FROM log_iMonkey_Wechat_overview
WHERE Debug = 1 AND PlatformType != 0 AND CrashIdentifier != '' 
AND toDate(minDs) >= subtractDays(toDate(now()), 1)
AND CrashIdentifier NOT IN (
    SELECT DISTINCT CrashIdentifier
    FROM log_iMonkey_Wechat_overview
    WHERE toDate(minDs) < subtractDays(toDate(now()), 1)
)
GROUP BY PlatformType, CrashIdentifier, CrashContent2
ORDER BY PlatformType DESC;

此查询使用子查询来查找在近一天之前已经出现过的CrashIdentifier，并将其排除在结果集之外。