Need help with Sportdatabase query
57 views
Skip to first unread message
Kenny
Aug 12, 2009, 8:58:35 AM8/12/09
to SportsD...@googlegroups.com
Hi all,
how would one write a query for this paramater...
"Team that LOST the SuperBowl are 2-7 SU, 0-9 ATS, 1-8 O/U next season in Week 1 since 2000"
"Team that WON the SB are 9-0 SU, 7-2 ATS, 5-4 O/U next season in Week 1 since 2000"
Thanks.
Joe Meyer
Aug 20, 2009, 8:14:51 PM8/20/09
to SportsD...@googlegroups.com
Kenny,
to see how teams do week1 after winning the SuperBowl use the SDQL:
R(W@team and playoffs=1)=1 and week=1
http://sportsdatabase.com/nfl.py/query?text=R(W%40team+and+playoffs%3D1)%3D1+and+week%3D1
Best wishes,
Joe Meyer
http://SportsDataBase.com
to see how teams do week1 after winning the SuperBowl use the SDQL:
R(W@team and playoffs=1)=1 and week=1
http://sportsdatabase.com/nfl.py/query?text=R(W%40team+and+playoffs%3D1)%3D1+and+week%3D1
Best wishes,
Joe Meyer
http://SportsDataBase.com
T
Aug 26, 2009, 2:09:58 PM8/26/09
to SportsDataBase
Joe, what does the "R" stand for?
On Aug 20, 8:14 pm, Joe Meyer <jame...@sportsdatabase.com> wrote:
> Kenny,
>
> to see how teams do week1 after winning the SuperBowl use the SDQL:
> R(W@team and playoffs=1)=1 and week=1http://sportsdatabase.com/nfl.py/query?text=R(W%40team+and+playoffs%3...
On Aug 20, 8:14 pm, Joe Meyer <jame...@sportsdatabase.com> wrote:
> Kenny,
>
> to see how teams do week1 after winning the SuperBowl use the SDQL:
T
Aug 26, 2009, 2:14:11 PM8/26/09
to SportsDataBase
Also, Joe, this query is grabbing Pittsburgh in 2007 as well as Indy.
It should only be grabbing Indy, not Pittsburgh. Any clue as to why?
It should only be grabbing Indy, not Pittsburgh. Any clue as to why?
Joe Meyer
Aug 26, 2009, 4:42:30 PM8/26/09
to sportsd...@googlegroups.com
T,
`R` is the short cut for the summative `Replace`.
R(W@team and playoffs=1) = 1
requires that the team's last playoff game was a win.
`R` is the short cut for the summative `Replace`.
R(W@team and playoffs=1) = 1
requires that the team's last playoff game was a win.
Bartholomew Simpson
Aug 28, 2009, 12:41:58 PM8/28/09
to SportsDataBase
While replacing W@ for L@ won't get you the superbowl loser (if I read
it correctly, it gets you all teams that lost their last playoff
game), it does produce an over/under record of 47-78-0.
There are a lot of duplicates, and most seasons, week 1 has produced
more unders than overs, so I was wondering how to do the following
query.
In week 1, what is the result when two teams that made the playoffs,
but lost somewhere along the way, play each other?
it correctly, it gets you all teams that lost their last playoff
game), it does produce an over/under record of 47-78-0.
There are a lot of duplicates, and most seasons, week 1 has produced
more unders than overs, so I was wondering how to do the following
query.
In week 1, what is the result when two teams that made the playoffs,
but lost somewhere along the way, play each other?
Joe Meyer
Aug 31, 2009, 2:16:17 PM8/31/09
to sportsd...@googlegroups.com
Bartholomew,
To see the results when two teams that made the playoffs but lost
somewhere along the way play each other in week 1 use the SDQL:
R(L@team and season and playoffs=1)[team and season-1 and playoffs=1]
= 1 and R(o:L@o:team and o:season and o:playoffs=1)[o:team and
o:season-1 and o:playoffs=1] = 1 and week=1 and H
Where I have added the `and H` to remove duplicates.
To see the results when two teams that made the playoffs but lost
somewhere along the way play each other in week 1 use the SDQL:
R(L@team and season and playoffs=1)[team and season-1 and playoffs=1]
= 1 and R(o:L@o:team and o:season and o:playoffs=1)[o:team and
o:season-1 and o:playoffs=1] = 1 and week=1 and H
Where I have added the `and H` to remove duplicates.
Bartholomew Simpson
Sep 1, 2009, 9:53:25 AM9/1/09
to SportsDataBase
Thanks.
Reply all
Reply to author
Forward
0 new messages