|
没有永恒制胜的策略,加入我们,一起加油!
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
继上篇再出个统计看看
AI球探--A2模型实测试以来下盘场次统计
http://bbs.aiqiutan.com/forum.ph ... d&tid=193&fromuid=1
(出处: AIQT论坛)
所有的----- A2同A1的
最后一列,3是推荐主 0是推荐客
- 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
复制代码
排除掉南北美
最后一列,3是推荐主 0是推荐客
- 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
复制代码
|
|