|
没有永恒制胜的策略,加入我们,一起加油!
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
查询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
- , MIN(ABS(Undefined4)) AS minVal
- 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.minVal = t2.val
- AND t2.matchId = t3.id
- ORDER BY t1.mdate DESC
复制代码
|
|