查询微信崩溃日志并统计iOS和Android崩溃次数

SELECT\n CrashIdentifier,\n CASE\n WHEN PlatformType IN (1, 3, 5) THEN (SELECT COUNT(uuid) FROM log_iOS_crash WHERE uuid = CrashIdentifier)\n WHEN PlatformType IN (2, 4, 6) THEN (SELECT COUNT(crashid) FROM log_android_crash WHERE crashid = CrashIdentifier)\n END AS index_crashcount_0\nFROM log_iMonkey_Wechat_overview\nWHERE Debug = 0\n AND PlatformType != 0\n AND CrashIdentifier != ''\n AND Ds >= toDateTime(#wechat_crash_level_time.start#)\n AND Ds <= toDateTime(#wechat_crash_level_time.end#)\nORDER BY index_crashcount_0 DESC