Forums

Just tell me what you need and I'll run it.

SDQL Guru

SDQL Guru

Just tell me what you need and I'll run it.

SDQL Guru

can you run how teams did last yr  in next game after scoring 0 or 1 run (lost the game)  of course u cant win scoring 0 but could win 1-0....just curious how last yr did...

big favs this month are 4-2  but -15 (after losing and scoring just 1 or 0 runs)  Texas lost as 250 fav ....may have to pass on big favs going forward..Tb looks like will lose and they were 150 tonight

Any results Guru?

deliveryman3

SDQL Guru

Just tell me what you need and I'll run it.

SDQL Guru

can you run how teams did last yr  in next game after scoring 0 or 1 run (lost the game)  of course u cant win scoring 0 but could win 1-0....just curious how last yr did...

This ONE query:

p:L and p:runs<2 and season

will give a season-by-season breakdown of the record of a team when they are off a loss in which they scored fewer than two runs.  The p: prefix in the SDQL text just points the parameter following it to the team's previous game.  So, p:L means the team lost their previous game and p:runs<2 means that the team scored fewer than 2 runs.  The season parameter is not assigned a year, so the computer will run the query for all possible seasons.  For last year alone, use:

p:L and p:runs<2 and season=2011

This query reveals that teams in this spot were 393-404 dropping 6.2 net games.  In 2010, however, the league was 405-392, making 16.56 net games.

Since 2010, which is simply:

p:L and p:runs<2 and season>=2010

the system is 991-886 as a DOG on the average, making 41.32 net games.  Note that unplayed games always appear at the bottom of the game listing.  I see LAA, ARZ, TEX, PHI, ATL, NYY as qualifiers.

Of course, there is SO much more can be done with the SDQL.  Were they favored when they scored fewer than two runs?  Are they favored now, by how much?  What was the losing margin?  Are they on a losing streak?  Are they above 500?  Are they facing a divisional rival?  In how many innings did they trail?  How many innings did the opponent's starter last? et cetera.

SDQL Guru

deliveryman3

3-1 +280 for sunday

today

Philllies...TBay...KC....

Cubs and Astros would be plays but they play each other so cancel out........will be some bumps in the road so dont go crazy...May has been way above expectations

Todays plays would be 

Phillies

DBacks (this fits guru tightened specs)

Braves

Yankees

Angels

Texas

shackfu99

deliveryman3

3-1 +280 for sunday

today

Philllies...TBay...KC....

Cubs and Astros would be plays but they play each other so cancel out........will be some bumps in the road so dont go crazy...May has been way above expectations

1-2 yest. Tampa big loser with a -150ml. 

Todays plays would be 

Phillies  -160

DBacks (this fits guru tightened specs)-140

Braves  -120

Yankees   -175

Angels   -155

Texas  -170

SDQL Guru

deliveryman3

SDQL Guru

Just tell me what you need and I'll run it.

SDQL Guru

can you run how teams did last yr  in next game after scoring 0 or 1 run (lost the game)  of course u cant win scoring 0 but could win 1-0....just curious how last yr did...

This ONE query:

p:L and p:runs<2 and season

will give a season-by-season breakdown of the record of a team when they are off a loss in which they scored fewer than two runs.  The p: prefix in the SDQL text just points the parameter following it to the team's previous game.  So, p:L means the team lost their previous game and p:runs<2 means that the team scored fewer than 2 runs.  The season parameter is not assigned a year, so the computer will run the query for all possible seasons.  For last year alone, use:

p:L and p:runs<2 and season=2011

This query reveals that teams in this spot were 393-404 dropping 6.2 net games.  In 2010, however, the league was 405-392, making 16.56 net games.

Since 2010, which is simply:

p:L and p:runs<2 and season>=2010

the system is 991-886 as a DOG on the average, making 41.32 net games.  Note that unplayed games always appear at the bottom of the game listing.  I see LAA, ARZ, TEX, PHI, ATL, NYY as qualifiers.

Of course, there is SO much more can be done with the SDQL.  Were they favored when they scored fewer than two runs?  Are they favored now, by how much?  What was the losing margin?  Are they on a losing streak?  Are they above 500?  Are they facing a divisional rival?  In how many innings did they trail?  How many innings did the opponent's starter last? et cetera.

SDQL Guru

                    you might find this interesting, shackfu

 http://beyondthebets.com/2012/05/21/will-there-be-a-1st-inning-run-scored-if-its-a-yankees-or-royals-game-the-answer-is-yes/

Thanks db.