查询微信平台 CrashIdentifier 统计 - 按平台类型区分

SELECT\n CrashIdentifier,\n if(PlatformType IN (1, 3, 5), count(uuid), count(crashid)) AS index_crashcount_0\nFROM log_iMonkey_Wechat_overview\nLEFT JOIN log_iOS_crash ON (PlatformType IN (1, 3, 5) AND CrashIdentifier = uuid) OR (PlatformType IN (2, 4, 6) AND CrashIdentifier = crashid)\nWHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND Ds >= toDateTime(#wechat_crash_level_time.start#)\n AND Ds <= toDateTime(#wechat_crash_level_time.end#)\nGROUP BY CrashIdentifier\nORDER BY index_crashcount_0 DESC