SELECT CrashIdentifierPlatformTypeCrashContent2FROM select CrashIdentifierPlatformTypeCrashContent2 from select CrashIdentifierPlatformTypeCrashContent2 minDs as Ds from log_iMonkey

SELECT CrashIdentifier, PlatformType, CrashContent2, COUNT(*) AS num FROM ( SELECT CrashIdentifier, PlatformType, CrashContent2 FROM ( SELECT CrashIdentifier, PlatformType, CrashContent2, MIN(Ds) AS Ds FROM log_iMonkey_Wechat_overview GROUP BY CrashIdentifier, PlatformType, CrashContent2 ) t1 WHERE toDate(Ds) >= subtractDays(toDate(now()), 1) AND toDate(Ds) < toDate(now()) ) GROUP BY CrashIdentifier, PlatformType, CrashContent2 ORDER BY PlatformType DESC;