SELECT PlatformType AS PlatformType countCrashIdentifier AS index_crashcount_0FROM log_iMonkey_Wechat_overviewWHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != AND Ds = toDateTime#day_

SELECT PlatformType AS PlatformType, count(CrashIdentifier) AS index_crashcount_0 FROM log_iMonkey_Wechat_overview WHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND Ds >= toDateTime(#day_wechat_crash_time.start#) AND Ds <= toDateTime(#day_wechat_views_time.end#) GROUP BY PlatformType ORDER BY count(CrashIdentifier) DESC LIMIT 5000

/* Updated Query */ SELECT log_iMonkey_Wechat_overview.CrashIdentifier AS CrashIdentifier, count(log_iOS_crash.uuid) AS crash_count FROM log_iMonkey_Wechat_overview LEFT JOIN log_iOS_crash ON log_iMonkey_Wechat_overview.CrashIdentifier = log_iOS_crash.uuid WHERE log_iMonkey_Wechat_overview.Debug = 0 AND log_iMonkey_Wechat_overview.PlatformType != 0 AND log_iMonkey_Wechat_overview.CrashIdentifier != '' AND log_iMonkey_Wechat_overview.Ds >= toDateTime(#day_wechat_crash_time.start#) AND log_iMonkey_Wechat_overview.Ds <= toDateTime(#day_wechat_views_time.end#) GROUP BY log_iMonkey_Wechat_overview.CrashIdentifier ORDER BY crash_count DES