## Forums

Where sports bettors talk!

# MAJOR LEAGUE BASEBALL SDQL QUERY OF THE DAY

 Thread Starter MAJOR LEAGUE BASEBALL SDQL QUERY OF THE DAY
Joined: 06/21/2012
Posts: 2518

This thread will continue through the World Series.  Let's get 'em!

4/4/2013

The Indians are 0-14 in the history of the database as a 130+ road underdog in the last game of a three-game series when they won the first two, as long as they were not a 150-plus favorite in game two.  The SDQL text is:

team=Indians and A and p:W and pp:W and line>=130 and p:line>=-150 and SG=SGS=3

Consider the Jays.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 12/12/2009
Posts: 18126

Always appreciate these nuggets. Thanks Doc!

5 Year NHL Record

503-421-26 (+81.18)

108-87-5 L200 +12% ROI

@dennistyler

Joined: 06/21/2012
Posts: 2518

4/5/2013

The Angels are 9-0 in the first game of a road series when they are off two losses in which they never led, winning by an average of 3.0 runs per game.  The SDQL text is:

team = Angels and A and p:BL=0 and pp:BL=0 and SG=1 and date>=20060801

Consider the Halos over the Rangers.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 06/21/2012
Posts: 2518

4/6/2013

The Cubs are 0-15 as a road dog of more than 140 when they seeking immediate revenge for a loss in which their hit per run ratio was greater than 3.5 and it is not the first game of a series.  The SDQL text is:

team = Cubs and A and line>140 and p:hits * 1.0 / p:runs>3.5 and p:L and SG>1 and date>=20110601

Consider investing in the Braves.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 03/08/2008
Posts: 54331
Rank NA

Hey Dr Ed, Why can't you see the Daily active trends any more at Killer Sports?

"Negative people will always try and drag you down to their level. Love them, but always rise above them."

There may be people that have more talent than you, but there's no excuse for anyone to work harder than you do.

Joined: 06/21/2012
Posts: 2518

The baseball website is being upgraded from 1.0 to 2.0.  This process is ongoing.  I assume that you will b able to see the daily trends when it is complete.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 03/08/2008
Posts: 54331
Rank NA

OK thnaks Sir

"Negative people will always try and drag you down to their level. Love them, but always rise above them."

There may be people that have more talent than you, but there's no excuse for anyone to work harder than you do.

Joined: 06/21/2012
Posts: 2518

4/7/2013

The Orioles are 0-10 as a home favorite of more than 130 when they are seeking immediate revenge for a loss in which they held the lead.  The SDQL text is:

team=Orioles and H and line<-130 and p:BL>0 and p:L and SG>1 and season>=2005

Consider an investment in the Twins.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 06/21/2012
Posts: 2518

4/8/2013

The Marlins are 0-9 in the history of the database at home when they are off a walk-off loss.  They were the favorite in seven of the nine and they lost by an average of 3.56 runs per game.  The SDQL text is:

team = Marlins and H and po:WOW

WOW stands for Walk-Off-Win.

Consider a play on the Braves.

Dr M.

Dr. Ed Meyer *Physics PhD (Case Western Reserve) *Featured in New Yorker: “Brainiacs Build Money Machine!” *Certified SDQL Master!

Joined: 10/28/2010
Posts: 2577

Hello Doc,  can you tell me if the  "show trends active today" link is broken or will it never work again over at Killersports? The link is under MLB trends...

TIA Keep up the excellent work!

Rate This
• 356 replies
• 9 subscribers
• Postedover 4 years ago