AI球探--A2模型实测试以来下盘场次统计

fog5188 · 发表于 2021-9-20 16:56:27

您需要登录才可以下载或查看，没有帐号？立即注册

x

所有的----- A2同A1的

SELECT DATE_FORMAT(DATE_SUB(t2.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') AS '日期'
, t2.result
, CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
, CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
, t2.preresult
FROM (
SELECT *
FROM t_analy_result r
WHERE r.`AlFlag` = "A2"
AND r.`Undefined5` LIKE "%A1%"
) t2, t_match_his t3
WHERE t2.matchId = t3.id
ORDER BY DATE_FORMAT(DATE_SUB(t2.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') DESC

复制代码

排除掉南北美

SELECT DATE_FORMAT(DATE_SUB(t2.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') AS '日期'
, t2.result
, CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
, CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
, t2.preresult
FROM (
SELECT *
FROM t_analy_result r
WHERE r.`AlFlag` = "A2"
AND r.`Undefined5` LIKE "%A1%"
AND r.`IsVip` IS false
) t2, t_match_his t3
WHERE t2.matchId = t3.id
ORDER BY DATE_FORMAT(DATE_SUB(t2.`MatchDate`, INTERVAL 12 HOUR), '%Y-%m-%d') DESC