SELECT PlatformType AS PlatformType countCrashIdentifier AS index_crashcount_0FROM log_iMonkey_Wechat_overviewWHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != AND Ds = toDateTime
根据要求,可以使用以下SQL查询来实现:
SELECT
PlatformType AS PlatformType,
CASE
WHEN PlatformType IN (1, 3, 5) THEN COUNT(log_iOS_crash.uuid)
WHEN PlatformType IN (2, 4, 6) THEN COUNT(log_android_crash.crashid)
END AS index_crashcount_0
FROM log_iMonkey_Wechat_overview
LEFT JOIN log_iOS_crash ON log_iMonkey_Wechat_overview.CrashIdentifier = log_iOS_crash.uuid
LEFT JOIN log_android_crash ON log_iMonkey_Wechat_overview.CrashIdentifier = log_android_crash.crashid
WHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND Ds >= toDateTime(#wechat_crash_level_time.start#)
AND Ds <= toDateTime(#wechat_crash_level_time.end#)
GROUP BY PlatformType
ORDER BY index_crashcount_0 DESC
LIMIT 5000
在这个查询中,我们使用了两个LEFT JOIN语句将log_iOS_crash和log_android_crash表连接到log_iMonkey_Wechat_overview表。根据PlatformType的值,使用CASE语句来选择使用哪个表进行连接,并计算每个CrashIdentifier的数量作为index_crashcount_0的值。最后,按照index_crashcount_0的降序进行排序,限制结果为前5000条记录
原文地址: http://www.cveoy.top/t/topic/hZLW 著作权归作者所有。请勿转载和采集!