KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerSports
f 
SDQL Query Access
Queries Remaining: 3
Query Type -
Game
Batter
Pitcher
Show -
10
50
100
250
#

Trend Builder

#

Query Fundamentals

#

Queryable Fields

#

Short Cuts

#

Customize Fields

#

Reset Fields

Copy Query URL Share on twitter / 
Logo
Record (W-L, Avg Cover Margin, Win %)ROIProfitP-Value
SU:55-40 (0.3, 57.9%)43.1% / -31.8%$4,099 / $-4,9710.07546759
RL:54-27-0 (2.1, 66.7%)13.1% / -24.3%$1,573 / $-2,0360.00179906
OU:37-54-4 (0.1, 40.7%)-20.8% / 13.9%$-2,178 / $1,4450.04660812

WP=0 and game number>2 and AD and p:D

date Day season site team starter Opp o:Starter Final margin SUr ou margin OUr Hits Errors BL line total Innings
Apr 07, 2024Sun2024awayMarlinsMax MeyerCardinalsKyle Gibson10-37W4.0O13-50-29-0125.09.09
Apr 06, 2024Sat2024awayMarlinsTrevor RogersCardinalsSteven Matz1-3-2L-4.0U8-82-00-3125.08.09
Mar 31, 2024Sun2024awayCubsJordan WicksRangersJon Gray9-54W5.0O12-82-04-0115.09.09
Mar 31, 2024Sun2024awayAngelsReid DetmersOriolesTyler Wells4-13W-3.5U6-31-14-0124.08.59
Mar 30, 2024Sat2024awayCardinalsLance LynnDodgersYoshinobu Yamamoto6-51W2.5O7-140-13-2205.08.510
Mar 30, 2024Sat2024awayRockiesAustin GomberDiamondbacksTommy Henry9-45W3.5O10-80-15-2155.09.59
Apr 04, 2023Tue2023awayPhilliesMatt StrahmYankeesDomingo German4-13W-3.5U10-40-04-0140.08.59
Apr 03, 2023Mon2023awayTigersMatthew BoydAstrosHunter Brown7-61W5.0O9-92-04-0205.08.011
Apr 03, 2023Mon2023awayPhilliesTaijuan WalkerYankeesNestor Cortes1-8-7L1.5O11-90-00-7144.07.59
Apr 02, 2023Sun2023awayTigersJoey WentzRaysJeffrey Springs1-5-4L-1.5U2-80-00-5230.07.59
Apr 10, 2022Sun2022awayRed SoxTanner HouckYankeesJordan Montgomery4-31W-1.5U5-110-02-0128.08.59
Apr 10, 2022Sun2022awayPiratesBryse WilsonCardinalsSteven Matz9-45W4.5O15-70-25-3195.08.59
Apr 10, 2022Sun2022awayGuardiansCal QuantrillRoyalsKris Bubic17-314W11.0O22-70-015-0105.09.09
Apr 10, 2022Sun2022awayRangersSpencer HowardBlue JaysHyun Jin Ryu12-66W8.5O11-100-06-5180.09.59
Apr 10, 2022Sun2022awayOriolesTyler WellsRaysCorey Kluber0-8-8L-0.5U6-110-00-8155.08.59
Apr 10, 2022Sun2022awayAthleticsDaulton JefferiesPhilliesZach Eflin4-13W-3.5U9-30-04-0195.08.59
Apr 04, 2021Sun2021awayDiamondbacksTaylor WidenerPadresChris Paddack3-12W-5.0U6-60-23-0180.09.09
Apr 04, 2021Sun2021awayRangersJordan LylesRoyalsBrady Singer7-34W0.5O8-81-16-0150.09.59
Apr 03, 2021Sat2021awayDiamondbacksCaleb SmithPadresJoe Musgrove0-7-7L-1.5U4-102-00-7195.08.59
Jul 26, 2020Sun2020awayDiamondbacksZac GallenPadresGarrett Richards4-31W-1.5U7-61-12-1108.08.59
Jul 26, 2020Sun2020awayPiratesMitch KellerCardinalsDakota Hudson5-14W-3.0U8-50-04-1130.09.09
Jul 26, 2020Sun2020awayMarinersYusei KikuchiAstrosZack Greinke7-61W4.0O11-90-03-1220.09.09
Jul 25, 2020Sat2020awayGiantsLogan WebbDodgersAlex Wood5-41W-0.5U7-92-04-0320.09.59
Mar 31, 2019Sun2019awayBravesKyle WrightPhilliesJake Arrieta1-5-4L-2.0U4-50-01-4135.08.09
Mar 31, 2019Sun2019awayWhite SoxLucas GiolitoRoyalsJorge Lopez6-33W0.5O11-60-06-0105.08.59
Mar 30, 2019Sat2019awayGiantsDereck RodriguezPadresNick Margevicius3-21W-2.5U9-81-03-0115.07.59
Apr 03, 2018Tue2018awayRoyalsJakob JunisTigersMatthew Boyd1-01W-7.5U5-31-01-0-103.08.59
Mar 31, 2018Sat2018awayRockiesGerman MarquezDiamondbacksZack Greinke2-11W-5.5U6-51-01-1130.08.59
Apr 07, 2017Fri2017awayRoyalsJason VargasAstrosMike Fiers5-14W-2.5U10-60-14-0142.08.59
Apr 06, 2017Thu2017awayMarinersAriel MirandaAstrosJoe Musgrove4-22W-2.5U7-61-02-1145.08.59
Apr 06, 2017Thu2017awayMarlinsTom KoehlerNationalsGio Gonzalez4-31W-2.0U14-80-01-2150.09.010
Apr 06, 2017Thu2017awayRoyalsJason HammelTwinsKyle Gibson3-5-2L-0.5U9-90-00-2102.08.59
Apr 05, 2017Wed2017awayMarinersJames PaxtonAstrosCharlie Morton3-5-2L0.0P6-131-02-2106.08.010
Apr 15, 2016Fri2016awayBravesWilliams PerezMarlinsWei Yin Chen6-33W1.0O8-122-03-3176.08.09
Apr 14, 2016Thu2016awayBravesJulio TeheranNationalsStephen Strasburg2-6-4L1.0O5-60-01-5195.07.09
Apr 13, 2016Wed2016awayBravesMatt WislerNationalsTanner Roark0-3-3L-5.0U5-40-00-3135.08.09
Apr 12, 2016Tue2016awayBravesJhoulys ChacinNationalsGio Gonzalez1-2-1L-4.5U6-80-10-2160.07.59
Apr 11, 2016Mon2016awayBravesBud NorrisNationalsMax Scherzer4-6-2L2.0O8-111-02-2210.08.09
Apr 10, 2016Sun2016awayTwinsRicky NolascoRoyalsEdinson Volquez3-4-1L-1.5U11-71-22-1138.08.510
Apr 09, 2016Sat2016awayTwinsTommy MiloneRoyalsIan Kennedy0-7-7L-0.5U7-102-00-7120.07.59
Apr 09, 2016Sat2016awayPhilliesVince VelasquezMetsBartolo Colon1-01W-6.0U8-30-01-0153.07.09
Apr 08, 2016Fri2016awayTwinsErvin SantanaRoyalsYordano Ventura3-4-1L-0.5U6-91-01-1145.07.59
Apr 08, 2016Fri2016awayPadresColin ReaRockiesJordan Lyles13-67W8.0O18-90-08-2135.011.09
Apr 08, 2016Fri2016awayPhilliesJerad EickhoffMetsJacob deGrom2-7-5L2.0O8-91-10-6240.07.09
Apr 07, 2016Thu2016awayTwinsPhil HughesOriolesUbaldo Jimenez2-4-2L-2.5U9-80-12-2123.08.59
Apr 07, 2016Thu2016awayPhilliesCharlie MortonRedsRobert Stephenson6-10-4L7.5O9-121-11-7120.08.59
Apr 10, 2015Fri2015awayTwinsTommy MiloneWhite SoxHector Noesi6-06W-2.5U10-30-16-0105.08.59
Apr 09, 2015Thu2015awayWhite SoxJohn DanksRoyalsEdinson Volquez1-4-3L-3.5U4-81-00-4125.08.59
Apr 09, 2015Thu2015awayTwinsKyle GibsonTigersShane Greene1-7-6L-0.5U5-101-10-7135.08.59
Apr 03, 2014Thu2014awayTwinsPhil HughesWhite SoxJose Quintana10-91W11.5O9-131-14-3130.07.59
Apr 03, 2014Thu2014awayCubsJason HammelPiratesWandy Rodriguez3-21W-2.5U7-61-03-0150.07.59
Apr 05, 2013Fri2013awayMarlinsAlex SanabiaMetsJeremy Hefner7-52W4.5O11-100-16-0145.07.59
Apr 04, 2013Thu2013awayPhilliesCliff LeeBravesKris Medlen2-02W-4.5U8-21-02-0115.06.59
Apr 04, 2013Thu2013awayMarlinsWade LeBlancNationalsJordan Zimmermann1-6-5L0.0P8-92-00-5210.07.09
Apr 04, 2013Thu2013awayRoyalsJeremy GuthrieWhite SoxGavin Floyd3-12W-4.5U5-80-13-0110.08.59
Apr 04, 2013Thu2013awayPadresEric StultsMetsDillon Gee2-11W-4.5U6-50-02-0135.07.59
Apr 09, 2012Mon2012awayRed SoxFelix DoubrontBlue JaysHenderson Alvarez4-22W-3.0U7-50-02-2110.09.09
Apr 08, 2012Sun2012awayYankeesPhil HughesRaysJeremy Hellickson0-3-3L-5.5U3-70-00-3105.08.59
Apr 08, 2012Sun2012awayRed SoxClay BuchholzTigersMax Scherzer12-13-1L16.5O18-170-03-4105.08.510
Apr 07, 2012Sat2012awayMarlinsRicky NolascoRedsMat Latos8-35W3.0O12-61-06-1140.08.09
Apr 08, 2011Fri2011awayRaysJames ShieldsWhite SoxJohn Danks9-72W8.0O10-111-22-3130.08.09
Apr 07, 2011Thu2011awayAstrosBrett MyersRedsSam LeCure3-21W-3.5U8-100-01-0128.08.59
Apr 06, 2011Wed2011awayAstrosNelson FigueroaRedsEdinson Volquez4-12-8L7.5O7-145-04-8170.08.59
Apr 05, 2011Tue2011awayAstrosJA HappRedsMike Leake2-8-6L1.5O5-100-00-7150.08.59
Apr 03, 2011Sun2011awayAstrosBud NorrisPhilliesRoy Oswalt3-7-4L2.0O7-130-00-5200.08.09
Apr 03, 2011Sun2011awayBrewersRandy WolfRedsBronson Arroyo3-12-9L6.5O7-191-01-9115.08.59
Apr 03, 2011Sun2011awayTigersMax ScherzerYankeesPhil Hughes10-73W7.5O14-121-03-0150.09.59
Apr 15, 2010Thu2010awayAstrosBud NorrisCardinalsKyle Lohse5-14W-2.5U9-61-04-0205.08.59
Apr 14, 2010Wed2010awayAstrosBrett MyersCardinalsBrad Penny1-2-1L-5.5U4-52-21-1190.08.59
Apr 12, 2010Mon2010awayAstrosWandy RodriguezCardinalsAdam Wainwright0-5-5L-2.0U7-112-00-5190.07.09
Apr 08, 2010Thu2010awayOriolesBrian MatuszRaysJeff Niemann5-41W-0.5U9-60-03-1160.09.59
Apr 08, 2010Thu2010awayCubsRandy WellsBravesTommy Hanson2-02W-6.0U4-81-02-0170.08.09
Apr 12, 2009Sun2009awayNationalsScott OlsenBravesJair Jurrjens5-8-3L4.0O10-110-20-3165.09.09
Apr 11, 2009Sat2009awayNationalsJohn LannanBravesKenshin Kawakami3-5-2L-1.0U5-110-03-2150.09.09
Apr 10, 2009Fri2009awayNationalsShairon MartisBravesDerek Lowe5-6-1L2.5O14-140-01-3175.08.510
Apr 08, 2009Wed2009awayTigersZach MinerBlue JaysJesse Litsch5-14W-3.5U8-61-04-0120.09.59
Apr 08, 2009Wed2009awayNationalsDaniel CabreraMarlinsChristopher Volstad4-6-2L1.0O5-101-22-4140.09.09
Apr 09, 2008Wed2008awayTigersJeremy BondermanRed SoxJon Lester7-25W-1.0U10-92-05-2105.010.09
Apr 03, 2008Thu2008awayWhite SoxJohn DanksGuardiansJake Westbrook2-11W-6.5U7-21-11-0160.09.59
Apr 02, 2008Wed2008awayGiantsMerkin ValdezDodgersHong Chih Kuo2-11W-5.5U7-61-21-1120.08.59
Apr 02, 2008Wed2008awayAstrosWandy RodriguezPadresGreg Maddux9-63W7.5O11-150-13-1135.07.59
Apr 06, 2007Fri2007awayOriolesAdam LoewenYankeesMike Mussina6-42W0.0P9-92-04-0190.010.09
Apr 04, 2007Wed2007awayOriolesJaret WrightTwinsRamon Ortiz2-7-5L-1.0U6-113-10-7125.010.09
Apr 04, 2007Wed2007awayRangersBrandon McCarthyAngelsErvin Santana3-5-2L-1.0U6-111-00-4140.09.09
Apr 07, 2006Fri2006awayPiratesPaul MaholmRedsEric Milton6-7-1L3.0O10-100-20-5110.010.09
Apr 06, 2006Thu2006awayPiratesIan SnellRedsBrandon Claussen5-6-1L1.0O9-140-00-3125.010.09
Apr 06, 2006Thu2006awayRaysMark HendricksonOriolesKris Benson2-02W-7.0U5-31-02-0150.09.09
Apr 05, 2006Wed2006awayPiratesZach DukeBrewersTomo Ohka2-3-1L-3.5U7-61-11-1105.08.59
Apr 09, 2005Sat2005awayMetsAaron HeilmanBravesHoracio Ramirez3-6-3L0.0P7-120-10-4155.09.09
Apr 08, 2005Fri2005awayPiratesJosh FoggPadresBrian Lawrence3-21W-3.0U8-60-22-0150.08.09
Apr 07, 2005Thu2005awayGuardiansCliff LeeWhite SoxJose Contreras11-56W6.5O14-111-26-5105.09.510
Apr 06, 2005Wed2005awayRed SoxNoneYankeesNone--------155.010.00
Apr 11, 2004Sun2004awayMarinersJamie MoyerAthleticsMark Mulder9-45W5.0O14-110-15-4115.08.010
Apr 10, 2004Sat2004awayMarinersGil MecheAthleticsTim Hudson1-2-1L-5.0U4-80-11-1145.08.09
Apr 07, 2004Wed2004awayGuardiansCliff LeeTwinsKyle Lohse11-47W6.0O16-110-18-0135.09.09
Apr 07, 2004Wed2004awayRangersColby LewisAthleticsBarry Zito2-11W-5.5U7-51-02-0200.08.59
Query Fundamentals

For more detailed information on SDQL including manuals and videos go HERE

The syntax for access to the NBA team data is: game reference:parameter. To see the date, team, and opponent where the team scored +120 points after scoring +120 runs in the previous game use the SDQL: date,team,o:team@points>120 and p:points>120

The syntax for access to the NBA player data: [team:]player name:game reference:parameter. To see the date, team, opponent and number of points by Kobe Bryant in the game after he scored more than 30 use the SDQL: date,team,o:team,Kobe Bryant:points@Kobe Bryant:p:points>30

Query Fundamentals:

A query consists of one or more clauses joined by and or or.

Examples:

The query:

50 < Kobe Bryant : points

and

site = away

The explain:

returns home games where Kobe Bryant scored more than 50 points on the road

If no player is given then results for the team are checked. E.g.

The query:

120 < Bulls : points

and

site = home

returns games in which the Bulls scored more than 120 points at home

points < 60

returns games when the team scored fewer than 60 points

Multiple conditions can be imposed using a comma delimited format.

points < 90,100,110

gives results grouped by points < 90, points < 100, and points < 110

You can comma-group on both sides of the inequality as per:

70,80,90,100 < points < 90,100,110

Game Reference

p :

team's previous game

N :

next match up

on :

opponent's next game

P :

previous match up

S :

starter's previous match up start

n :

team's next game

s :

starter's previous start

op :

opponent's previous game

Examples:

The query:

100 < t:rushing yards

and

to:rushing yards < 100

The explain:

Use this SDQL to see how teams do when rushing for more than 100 yards while holding their opponent to few than 100 yards

The query:

40 < p:points

and

40 < p2:points

and

40 < p3:points

and

40 < p4:points

Use this SDQL to see how teams do after scoring more than 40 points their last four games

2*P:points in the paint < Po:points in the paint

and

P:season = season

return games in which the team was outscored in the paint by a factor of 2 in their previous match up

The query:

0.25*p:points<=p:fast break points

and

po:points

The explain:

return games with a team off a win in which they scored at least 25% of their points from fast breaks

Short Cuts

H, A, W, L, F, D, O, U, C, X   are short cuts for home,away,win,loss,favorite,dog,over the total,under the total, and conference. As with the parameter prefixes, these can be strung together without limit.

Examples:

The query:

HF

×

and

p:HFL

×

and

pp:HFL

×

The explain:

returns home favorites after they just lost as home favorites their last two games

P:O

×

and

PP:O

×

and

PPP:O

×

and

PPPP:O

×

and

PPPPP:O

×

and

PPPPPP:O

×

The explain:

returns games where teams have gone over the total their last six matchups

In addition to the above single letter short cuts the following abbreviations are available:

· AASB - After All-Star Break
· AWP - Away Winning Percentage
· BASB - Before All-Star Break
· BL - Biggest Lead
· BPRA - Bull Pen Runs Allowed
· BS - Bad Start (4 or fewer innings and 5 or more earned runs)
· DAY - Day (start time<1800)
· DDP - Defensive Double Plays
· DIV - Divisional Game
· FGS - First Game of a Series
· HPR - Hits Per Run
· HPU - Home Plate Umpire
· HR - Home Runs
· HWP - Home Winning Percentage
· IL - Innings Led
· IT - Innings Tied
· LGS - Last Game of a Series
· LOB - Left on Base
· MRI - Multiple Run Innings
· NDIV - Not a Divisional Game
· NGT - Night (start time>=1800)
· NQS - Non Quality Start
· ODP - Offensive Double Plays (hit into double plays)
· PBRS - Percent Base Runners Scored
· PO - During the Playoffs
· PU - Pitchers Used
· QS - Quality Start (at least 6 innings and 3 or fewer earned runs)
· REG - During the Regular Season
· RG3 - Rubber Game 3 (3rd game of a 3 game series and they split the first 2)
· RMAX - The maximum runs the team scored in any one inning
· SERA - Starter Earned Run Average in the Referenced Game
· SF - Scored First: How many runs a team scored before their opponent scored
· SG - Series Game
· SGS - Series Games
· SHA - Starter Hits Allowed
· SHF - Starter Hitters Faced
· SHRA - Starter Home Runs Allowed
· SII - Scored In Innings
· SIP - Starter Innings Pitched
· SO - Strikeouts
· SOPW - Strikeouts Per Walk
· SPB - Strike Per Ball
· SPPH - Starter Pitch Per Hitter
· SPT - Starter Pitches Thrown
· SRA - Starter Runs Allowed
· SSO - Starter Strike Outs
· SSPB - Starter Strike Per Ball
· STDHPR - Season To Date Hits Per Run
· STDSERA - Starter Season To Date ERA
· STDSOPW - Season To Date Stike Outs Per Walk
· STDSPB - Season To Date Stikes Per Ball
· STDSSOPW - Starter Season To Date Stike Outs Per Walk
· STDSSPB - Starter Season To Date Stikes Per Ball
· STDSWHIP - Starter Season To Date WHIP
· STL - Starter Throws Left
· STR - Starter Throws Right
· SWA - Starter Walks Allowed
· SWHIP - Starter Walks Plus Hits Per Inning Pitched
· TLOB - Team Left On Base
· TT - Times Tied
· WOW - Walk Off Win
· WP - Winning Percentage
· XBH - eXtra Base Hits (doubles + triples)

MLB Trend Builder

For a more detailed review of how to use the Trend Builder, go HERE












    MLB Field Options
     as 
    • STDSERAN+
    • after all star break+
    • at bats+
    • attendance+
    • bad start+
    • biggest lead+
    • bullpen runs allowed+
    • date#
    • day+
    • division+
    • double header+
    • double plays+
    • doubles+
    • dpa+
    • dps+
    • earned runs+
    • errors+
    • extra base hits+
    • game number+
    • hit batters+
    • hit by pitchers+
    • hits+
    • home runs+
    • inning runs✓
    • innings led+
    • innings tied+
    • league+
    • left on base+
    • line✓
    • losses+
    • manager+
    • margin✓
    • matchup losses+
    • matchup wins+
    • month+
    • multiple run innings+
    • opponent+
    • opponents+
    • ou margin✓
    • ou streak+
    • over+
    • over_invest✓
    • over_profit✓
    • pitchers used+
    • playoffs+
    • quality start+
    • rest+
    • rl margin✓
    • rl streak+
    • rl_invest✓
    • rl_profit✓
    • round+
    • run line✓
    • run line runs+
    • runs+
    • score+
    • scored first+
    • scored in innings+
    • season✓
    • seed+
    • series game+
    • series games+
    • series losses+
    • series wins+
    • site✓
    • site streak+
    • srslg+
    • start time+
    • starter✓
    • starter balls+
    • starter batters faced+
    • starter earned run average+
    • starter hits+
    • starter homeruns+
    • starter innings pitched+
    • starter losses+
    • starter matchup losses+
    • starter matchup wins+
    • starter pitches thrown+
    • starter runs allowed+
    • starter strikeouts+
    • starter strikes thrown+
    • starter throws+
    • starter walks+
    • starter wins+
    • streak+
    • strike outs+
    • su_invest✓
    • su_profit✓
    • team#
    • team left on base+
    • team strikes thrown+
    • temperature+
    • time zone+
    • times tied+
    • total✓
    • triples+
    • umpires+
    • under+
    • under_invest✓
    • under_profit✓
    • walks+
    • wins+
    • Day✓
    • Opp✓
    • o:Starter✓
    • Final✓
    • SUr✓
    • OUr✓
    • Hits✓
    • Errors✓
    • BL✓
    • Innings✓
    Queryable Fields

    STDSERAN, after all star break, at bats, attendance, bad start, biggest lead, bullpen runs allowed, date, day, division, double header, double plays, doubles, dpa, dps, earned runs, errors, extra base hits, game number, hit batters, hit by pitchers, hits, home runs, inning runs, innings led, innings tied, league, left on base, line, losses, manager, margin, matchup losses, matchup wins, month, multiple run innings, opponent, opponents, ou margin, ou streak, over, pitchers used, playoffs, quality start, rest, rl margin, rl streak, round, run line, run line runs, runs, score, scored first, scored in innings, season, seed, series game, series games, series losses, series wins, site, site streak, srslg, start time, starter, starter balls, starter batters faced, starter earned run average, starter hits, starter homeruns, starter innings pitched, starter losses, starter matchup losses, starter matchup wins, starter pitches thrown, starter runs allowed, starter strikeouts, starter strikes thrown, starter throws, starter walks, starter wins, streak, strike outs, team, team left on base, team strikes thrown, temperature, time zone, times tied, total, triples, umpires, under, walks, wins