Lozo1016 said:
Is it this...
starter=Chris Sale and team=White Sox and p:margin<=-2
The power and efficiency of the SDQL comes from the prefixes. There are three main prefixes in MLB.
p: points the parameter to the team's previous game.
s: points the parameter to the starter's previous start.
S: points the parameter to the starter's previous start vs this opponent.
So...
starter=Chris Sale and team=White Sox and p:margin<=-2
provides the results when Sale is starting and the Sox are off a two-plus run defeat in their last game.
starter=Chris Sale and team=White Sox and s:margin<=-2
provides the results when Sale is starting and the Sox lost by 2-plus runs in his last start.
starter=Chris Sale and team=White Sox and S:margin<=-2
provides the results when Sale is starting and the Sox lost by 2-plus runs in his last start vs this opponent (Sale has personal revenge).
In this case, you want:
starter=Chris Sale and s:margin<=-2
(you don't need to specify team=White Sox, but it doesn't hurt)
That's some good use of the SDQL!
Dr M.