足球数据下载搜索统计系统(套件)

*通用查询(Access版) f7.mdb 2001 威廉胜赔转概率查询 @ select data.id,(select clsC from cls where id=data.cls) as cls,dat,(select namC from nam where id=data.hst) as hst,scr,scr1,(select namC from nam where id=data.gst) as gst,wdlo,data_o.*,data_a.* from data,data_o,data_a where data_o.id=data.id and data_a.id=data.id and data_o.cmp='威廉希尔' and data_a.cmp='ＳＢ' and pw0='78.74' order by cdate(dat),cls,hst 3001 某联赛上赛季威廉概率平均值 @ select (select clsC from cls where id=data.cls) as cls,avg(pw0) as 平均主率,avg(pd0) as 平均平率,avg(pl0) as 平均客率,avg(fhl0) as 平均返还率,count(w0) as 参考场数 from data,data_o where data_o.id=data.id and cmp='威廉希尔' and datediff('n',cdate('2011-07-01 12:00'),cdate(dat))>=0 and datediff('n',cdate('2012-07-01 12:00'),cdate(dat))<=0 and cls in (select id from cls where typ='1' and dat0='07-01') group by cls order by avg(pw0) desc 3002 某球队上赛季主场威廉概率平均值 @ select (select namC from nam where id=data.hst) as 在主场,avg(pw0) as 平均主率,avg(pd0) as 平均平率,avg(pl0) as 平均客率,avg(fhl0) as 平均返还率,count(w0) as 参考场数 from data,data_o where data_o.id=data.id and cmp='威廉希尔' and datediff('n',cdate('2011-07-01 12:00'),cdate(dat))>=0 and datediff('n',cdate('2012-07-01 12:00'),cdate(dat))<=0 and cls in (select id from cls where clsC='英超') group by hst order by avg(pw0) desc 3003 某球队上赛季客场威廉概率平均值 @ select (select namC from nam where id=data.gst) as 在客场,avg(pw0) as 平均主率,avg(pd0) as 平均平率,avg(pl0) as 平均客率,avg(fhl0) as 平均返还率,count(w0) as 参考场数 from data,data_o where data_o.id=data.id and cmp='威廉希尔' and datediff('n',cdate('2011-07-01 12:00'),cdate(dat))>=0 and datediff('n',cdate('2012-07-01 12:00'),cdate(dat))<=0 and cls in (select id from cls where clsC='英超') group by gst order by avg(pl0) desc 4001 球盘与大小盘的结果统计(初盘) @ select pk0,pkq0,sum(val(wdla)) as 总赢输,sum(val(wdlq)) as 总大小,count(val(wdlq)) as 总场数 from data_a,data_dx where data_dx.id=data_a.id and data_a.cmp='ＳＢ' and data_dx.cmp='ＳＢ' and wdla<>'待定' and wdlq<>'待定' group by pk0,pkq0 order by abs(val(pk0)),abs(val(pkq0)) 4002 球盘与大小盘的结果统计(终盘) @ select pk1,pkq1,sum(val(wdla)) as 总赢输,sum(val(wdlq)) as 总大小,count(val(wdlq)) as 总场数 from data_a,data_dx where data_dx.id=data_a.id and data_a.cmp='ＳＢ' and data_dx.cmp='ＳＢ' and wdla<>'待定' and wdlq<>'待定' group by pk1,pkq1 order by abs(val(pk1)),abs(val(pkq1)) 4003 让球与大小的关系 @ select pk0 as 让球初盘,avg(pkq0) as 大小初盘平均值,count(pkq0) as 场数 from data_a,data_dx where data_dx.id=data_a.id and data_a.cmp='ＳＢ' and data_dx.cmp='ＳＢ' and data_a.id in (select id from data where cls=(select id from cls where cls='英超')) group by pk0 order by abs(val(pk0)) 4004 某让球盘实际平均入球 @ select sum(val(left(scr,1))+val(right(scr,1)))/count(scr),count(scr) from data where cls=(select id from cls where cls='英超') and id in (select id from data_a where data_a.id=data.id and data_a.cmp='ＳＢ' and pk0='-0.5') 4005 大小盘统计(跨年联赛) @ select (select clsC from cls where id=data.cls) as cls,sum(val(wdlq)) as 总大小,count(val(wdlq)) as 总场数 from data,data_dx where data_dx.id=data.id and cls in (select id from cls where typ='1' and dat0='07-01') and data_dx.cmp='ＳＢ' and wdlq<>'待定' and datediff('n',cdate('2011-07-01 12:00'),cdate(dat))<=0 and datediff('n',cdate('2012-07-01 12:00'),cdate(dat))<=0 group by cls order by sum(val(wdlq)) desc 4006 大小盘统计(非跨年联赛) @ select (select clsC from cls where id=data.cls) as cls,sum(val(wdlq)) as 总大小,count(val(wdlq)) as 总场数 from data,data_dx where data_dx.id=data.id and cls in (select id from cls where typ='1' and dat0='01-01') and data_dx.cmp='ＳＢ' and wdlq<>'待定' and datediff('n',cdate('2011-01-01 12:00'),cdate(dat))<=0 and datediff('n',cdate('2012-01-01 12:00'),cdate(dat))<=0 group by cls order by sum(val(wdlq)) desc 5000 威廉终赔胜率统计 @ select data.id,(select cls from cls where id=data.cls) as cls,dat,(select nam from nam where id=data.hst) as hst,scr,scr1,(select nam from nam where id=data.gst) as gst,w0,d0,l0,w1,d1,l1 from data,data_o where data_o.id=data.id and cls='26' and cmp='威廉希尔' and w1+' '+d1+' '+l1='1.65 3.50 5.00' order by cdate(dat) 5001 威廉初赔查询 @ select id,(select cls from cls where id=data.cls) as cls,dat,(select nam from nam where id=data.hst) as hst,scr,scr1,(select nam from nam where id=data.gst) as gst from data where id in (select id from data_o where cmp='威廉希尔' and w0+' '+d0+' '+l0='3.40 3.25 1.91') order by cdate(dat) desc,cls,hst 5002 威廉初赔胜率统计 @ select wdlo as 结果,count(wdlo) as 场数 from data where wdlo<>'待定' and id in (select id from data_o where cmp='威廉希尔' and w0+' '+d0+' '+l0='1.75 3.40 4.33') group by wdlo 5003 威廉初赔主流搭配 @ select w0+' '+d0+' '+l0 as 赔率搭配,count(id) as 出现次数 from data_o where cmp='威廉希尔' and w0='2.25' group by w0+' '+d0+' '+l0 order by count(id) desc 5004 威廉初赔概率主流搭配 @ select pw0+' '+pd0+' '+pl0 as 概率搭配,count(id) as 出现次数 from data_o where cmp='威廉希尔' and pw0='39.54' group by pw0+' '+pd0+' '+pl0 order by count(id) desc 5005 威廉初赔主流搭配(按SB初盘查询) @ select w0+' '+d0+' '+l0 as 赔率搭配,count(id) as 出现次数 from data_o where cmp='威廉希尔' and id in (select id from data_a where cmp='ＳＢ' and pk0='-0.5') group by w0+' '+d0+' '+l0 order by count(id) desc 6003 由平赔算出平均胜赔与平均负赔 @ select count(w0) as 场数,avg(w0) as 均胜,max(d0) as 平,avg(l0) as 均负,max(cmp) as 公司 from (select top 100 * from data,data_o,cls where data_o.id=data.id and cls.id=data.cls and cmp='威廉希尔' and cls.cls='德甲' and d0='3.20' and val(w0)<val(l0) order by cdate(dat) desc) 6001 澳门胜赔胜率与欧均赔胜率比较 @ select data.id,cls,dat,hst,scr,wdlo,gst,w1,d1,l1,ht1,pk1,gt1 from data,data_o,data_a where data_o.id=data.id and data_o.cmp='澳门' and data_a.id=data.id and data_a.cmp='澳门' and val(d0)>val(w0) and val(w0)<val(l0) and val(pw1)>(select val(pw1) from data_o where data_o.id=data.id and cmp='欧洲平均') and datediff('n',cdate('2011-09-26 12:00'),cdate(dat))>=0 and datediff('n',cdate('2011-09-27 12:00'),cdate(dat))<=0 order by val(w1) 6002 澳门负赔胜率与欧均赔胜率比较 @ select data.id,cls,dat,hst,scr,wdlo,gst,w1,d1,l1,ht1,pk1,gt1 from data,data_o,data_a where data_o.id=data.id and data_o.cmp='澳门' and data_a.id=data.id and data_a.cmp='澳门' and val(d0)>val(l0) and val(l0)<val(w0) and val(pl1)>(select val(pl1) from data_o where data_o.id=data.id and cmp='欧洲平均') and datediff('n',cdate('2011-09-26 12:00'),cdate(dat))>=0 and datediff('n',cdate('2011-09-27 12:00'),cdate(dat))<=0 order by val(l1) 7001 威廉平赔支点(主队让球) @ select d0,count(d0) from data_o where cmp='威廉希尔' and id in (select id from data where cls in(select id from cls where clsC='英超')) and id in (select id from data_a where cmp='ＳＢ' and val(pk0)<0) group by d0 order by count(d0) desc 7002 威廉平赔支点(客队让球) @ select d0,count(d0) from data_o where cmp='威廉希尔' and id in (select id from data where cls in(select id from cls where clsC='英超')) and id in (select id from data_a where cmp='ＳＢ' and val(pk0)>0) group by d0 order by count(d0) desc 00000001 查询名称 @ (select distinct hst from data where cls='意甲' or cls in (select id from cls where cls='意甲') and isnumeric(hst)=false) union (select distinct gst from data where cls='意甲' or cls in (select id from cls where cls='意甲') and isnumeric(gst)=false) 00000002 添加名称 @ --insert into nam(id,nam) values('273','鹿特丹斯巴達') 0000001 类型赛程查询 @ select * from data where cls in (select id from cls where cls='阿甲春') order by cdate(dat) desc 0000002 球队赛程查询 @ select * from data where cls in (select id from cls where cls='阿甲春') and (hst in (select id from nam where nam='紐維爾舊生') or gst in (select id from nam where nam='紐維爾舊生')) order by cdate(dat) desc 0000003 主队名称转Id @ --update data set hst='濟州聯' where cls in ('韓K聯','15') and hst in ('濟州聯隊','濟洲聯隊','济州联') 0000004