Search:

The data base has Warriors vs Hawks as a pick with line at 0.
Good luck.

One for Tuesday, but only covers the 2011 season to present.
Created this query expecting negative results, but sdql reveals the opposite.
Teams covering their previous game (against DEN) are 13-1....

Fading SAC tonight.
Good luck.

AD and line<=6 and rest=0 and o:rest>0 and p:site streak>=4 and o:WP<wp< html=""></wp<> < WP

No site specification. H or A
Good luck.

Thanks, buddy.
Good luck.
.:highfive:

H and playoffs=1 and P:AL and total>=200 and op:margin >=-4 and season>=2009

3-10-1 with total>=210
Good luck.

You are correctly querying what you are looking for, Pip. I have used a few of these for live action. Since the last filter is not predictive you have to either create the query on the fly or just...

Had a few of those myself.
The day after the game you see the query hits and wonder, "How did I miss it again?"
:duh::lmao:

Sunday late night play fading PHO.
Only a single season query, but good results for me the last few weeks.
Line moving, posting early.
Good luck.

HD and op:AL and total>=204 and season>=2013

That's the way data mining goes.
May not produce a "super" query, but the experience will pay for itself in time. :an_clap:

\


Streaks will still occur both ways. When a "super" query produces a few losses in a row I try to identify if any further tweaking is needed and will monitor it instead of playing. I will...

A strong close to a great week.
Love it when the stars and queries align.
Good luck.
:highfive:

Rested teams only on Sunday.
Good luck.

Thanks again. Dodged a loss.
Kept a clean sheet 3-0 for the night.
Good luck.:highfive:

Use additional filters or modify the existing ones within the query to specifics of the game in question.
Take a look at the KS trend I posted earlier today.
Then see JMon's reply. He had already...

Thanks for the input. Will re-save accordingly.
YOU are the 'Mon!
Good luck tonight.

:highfive:

From KS trends.

210>total>199.5 and 60>=WP>=51 and Sum(ou margin@team and season, N=5) >=36 and season>2007 and playoffs=0

"and H" even better.

Good luck.

A few pages back NoLeaf created a list of queries contained in the thread. Mako, then cleaned 'em up for ease of copy/paste. (Thanks posters)
There have been others added since, but that will get...

Use your favorite search engine: sdql bible.

From there it's all learning the filters used to create queries.
Many of the filters are very basic, (HD = home dog, etc) however understanding some...

I had a good feeling a few days after you started the thread, Mako.
Especially after more posters joined in.
Hats off to all contributing to the thread in any way.
Good luck.

Great night, JA.
Really liked the angle on the 2nd with POR spiraling.
Good luck.

From KS trends.

season > 2002 and playoffs = 0 and ou streak >= 2 and o: ou streak >= 4 and HD
(remove space)
Even better with totals between 200 and 209.5.
Good luck.

Thanks, figue. :highfive:
Good luck.

AD and line<=3 and p:H and p:margin>10 and P:W and season>=2011

This one fares well except in the month of March.
Great example of the quirkiness of trends.
Looking at the other side today....

My bad, figue. You have it posted in its original form. Thanks, buddy.

From a thread created earlier in the season posted by fellow sdql'er, chopperocker.
Good luck.

p:HFL and op:HW and site=home and -10<=t:line<-5 and 20111225<=date

:highfive:

:an_clap:

Great to see the thread still churning out winners.
Small play for today.
Good luck.

H and rest=0 and p: overtime>0 and p:AW

I love it when school is in session!
Thanks, JMon!
:highfive:

^^THIS^^

Test, test, test. Makes you proficient with the language and keeps you thinking outside the box. If you think it, type it. There can never be a "wrong query" made. You won't find gold...

Can be a dog or a favorite if not more than -5.5.
Favorites laying 6 or more are filtered out, as they are only hitting at a 50% clip in the given sdql.
Good luck.:highfive:

Good in theory, but leaving out 36 plays that show a 72% win rate. (10-26 ATS +15u)
Good luck.

Modified the sdql from posts #3 and #4 giving it a larger sample size extending more than just a few months.
Anyone have any other sdql's to compliment or contradict the plays produced below?
Good...

I have an sdql I created a few months back with a similar base query showing an increase of overs this season, too. Back-testing gives different results, though. It could be the start of something...

Great work everyone.
Let's end the season strong.
Good luck.

:highfive:

H and line>4 and total>=195 and rest<2 and p:margin>=-8 and season>=2012

I've been on the road all week.
Fading a couple of home teams.
Good luck.

H and total>200 and p:AFW and p:BAP>60 and p: offensive rebounds > p:turnovers and season >= 2009


(remove extra space)
Can be used without total filter, too.
Good luck.

Like both.
Good luck, buddy.

:highfive:

:lmao::+whipping:lmao:

:bowdown:

Home dog
Total>205
Previous away dog win
Previous line>=4
One day of rest or more

HD and total>205 and p:ADW and p:line>=4 and rest>0 and season >= 2005

Good luck.

Close to 74%. (knew to start with doggies if you saved it....lol)

D and oS(ats margin>0, N=15)>=12 and month<3




<game number<29<="" html=""><game number<28

</game></game>

Home
Total>205
Previous home loss
Previous outscored by 15 or more in 2H

H and total>205 and p:HL and po:P3-p:P3 + po:P4-p:P4>14 and season>=2008

Have this saved without the total filter,...

Take a look at post#1.
There's your play for tomorrow, skippy.
Want me to click "SUBMIT" for ya, too?
Good luck.

Thanks for sharing, Figue.


Series Starter

Play against teams off a win in a game in which they had more than 10 hits and are now at home in the first game of a new series.

H and SG=1...

Me, too. Still have that taped to my old laptop with the EMICH data. lol

:highfive:

Fading them today.
Some other possible plays using sdqls within the thread, too. Good luck.

Locked it in moments ago.
Good luck