fog5188 发表于 2021-9-20 16:09:03

AI球探--GE0模型每天最高信心指数场次统计

GE0每天信心指数最高的一场







数据库查询sql:
SELECT t1.*, t2.result
      , CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
      , CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
      , t2.preresult
FROM (
      SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, COUNT(1) AS cc
                , MAX(ABS(Undefined4)) AS maxVal
      FROM t_analy_result r
      WHERE r.`AlFlag` = "GE0"
                AND r.`PreResult` = 0
      GROUP BY DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d')
) t1, (
                SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, ABS(Undefined4) AS val
                        , r.*
                FROM t_analy_result r
                WHERE r.`AlFlag` = "GE0"
                        AND r.`PreResult` = 0
      ) t2, t_match_his t3
WHERE t1.mdate = t2.mdate
      AND t1.maxval = t2.val
      AND t2.matchId = t3.id
ORDER BY t1.mdate DESC


fog5188 发表于 2021-9-20 16:44:58

SELECT t1.*, t2.result
      , CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
      , CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
      , t2.preresult
FROM (
SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate
        , MAX(ABS(Undefined4)) AS maxVal
FROM t_analy_result r, (
                SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate
                        , MAX(ABS(Undefined4)) AS maxVal
                FROM t_analy_result r
                WHERE r.`AlFlag` = "GE0"
                        AND r.`PreResult` = 0
                GROUP BY DATE_FORMAT(DATE_SUB(r.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d')
        ) r1
WHERE DATE_FORMAT(DATE_SUB(r.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') = r1.mdate
        AND ABS(r.`Undefined4`) != r1.maxval
        AND r.`AlFlag` = "GE0"
        AND r.`PreResult` = 0
GROUP BY DATE_FORMAT(DATE_SUB(r.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d')
) t1, (
                SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, ABS(Undefined4) AS val
                        , r.*
                FROM t_analy_result r
                WHERE r.`AlFlag` = "GE0"
                        AND r.`PreResult` = 0
      ) t2, t_match_his t3
WHERE t1.mdate = t2.mdate
      AND t1.maxval = t2.val
      AND t2.matchId = t3.id
ORDER BY t1.mdate DESC
备份

足球王子 发表于 2021-9-20 17:30:19

6666,有点意思，少了一列推荐的是啥呢

admin 发表于 2021-9-20 22:31:25

足球王子 发表于 2021-9-20 17:30
6666,有点意思，少了一列推荐的是啥呢

看最后一列，
3 推荐的就是主队方向
0 推荐的就是客队方向
页: [1]
查看完整版本: AI球探--GE0模型每天最高信心指数场次统计