{"id":4606,"date":"2026-02-01T22:13:36","date_gmt":"2026-02-01T22:13:36","guid":{"rendered":"https:\/\/themoneyballer.com\/access\/?p=4606"},"modified":"2026-02-01T22:13:37","modified_gmt":"2026-02-01T22:13:37","slug":"sdql-parameters-syntax-glossary","status":"publish","type":"post","link":"https:\/\/themoneyballer.com\/access\/2026\/02\/01\/sdql-parameters-syntax-glossary\/","title":{"rendered":"SDQL Parameters &amp; Syntax Glossary"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Introduction to SDQL<\/strong><\/h2>\n\n\n\n<p><br>Sports Data Query Language (SDQL) is the syntax used to search and analyze data within our sports databases. It allows you to build flexible queries to isolate specific situations, trends, and outcomes across games, teams, players, and seasons.<\/p>\n\n\n\n<p>There are virtually unlimited combinations of queries you can create. This guide focuses on foundational concepts and the most commonly used parameters to help you get started quickly and confidently.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Table of Contents<\/strong><br><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#introduction-to-sdql\">Introduction to SDQL<\/a><\/li>\n\n\n\n<li><a href=\"#basic-query-structure\">Basic Query Structure<\/a><\/li>\n\n\n\n<li><a href=\"#commonathematical-operators\">Common Mathematical Operators<\/a><\/li>\n\n\n\n<li><a href=\"#team-vs-opponent-context\">Team vs. Opponent Context<\/a><\/li>\n\n\n\n<li><a href=\"#combining-multiple-conditions\">Combining Multiple Conditions<\/a><\/li>\n\n\n\n<li><a href=\"#using-historical-and-future-game-data\">Using Historical and Future Game Data<\/a><\/li>\n\n\n\n<li><a href=\"#shortcuts\">Shortcuts<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/core-game-parameters\" title=\"\">Core Game Parameters<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Basic Query Structure<\/strong><br><\/h3>\n\n\n\n<p>An SDQL query is made up of one or more parameters connected using logical operators such as <strong>and<\/strong> or <strong>or<\/strong>. For most simple queries, the order of parameters does not matter.<\/p>\n\n\n\n<p>Each parameter represents a statistic, attribute, or game condition. Most parameters are paired with a value that defines exactly what you want to filter for.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><br>Common Mathematical Operators<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>=\u00a0 equal to<\/li>\n\n\n\n<li>> greater than<\/li>\n\n\n\n<li>= greater than or equal to<\/li>\n\n\n\n<li>&lt;\u00a0 less than<\/li>\n\n\n\n<li>&lt;= less than or equal to<\/li>\n\n\n\n<li>!= not equal to<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>+ addition<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8211; subtraction<\/li>\n\n\n\n<li>* multiplication<\/li>\n\n\n\n<li>\/ \u00a0division<\/li>\n<\/ul>\n\n\n\n<p>Example:<\/p>\n\n\n\n<p>To find games where a team scored more than 150 points, use points&gt;150.<\/p>\n\n\n\n<p>Negative values are also important. For example, margin&lt;=-10 refers to a team that lost by 10 or more points.<br><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Team vs. Opponent Context<\/strong><\/h3>\n\n\n\n<p>Queries can be run for a specific team or across all teams in a league.<\/p>\n\n\n\n<p>For example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>team=\u2018Rockets\u2019 and points=115 returns games where the Rockets scored exactly 115 points<\/li>\n\n\n\n<li>points=115 by itself returns all games where any team scored exactly 115 points<\/li>\n<\/ul>\n\n\n\n<p>Every SDQL query is evaluated from the perspective of a <strong>team<\/strong> and its <strong>opponent<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <strong>team<\/strong> is the subject of the query<\/li>\n\n\n\n<li>The <strong>opponent<\/strong> is the team they played in that game<\/li>\n<\/ul>\n\n\n\n<p>To reference opponent statistics, use the <strong>o:<\/strong> prefix.<\/p>\n\n\n\n<p>Examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>team=\u2018Rockets\u2019 and points=115 \u2192 Rockets scored 115<\/li>\n\n\n\n<li>team=\u2018Rockets\u2019 and o:points=115 \u2192 Rockets allowed 115<\/li>\n<\/ul>\n\n\n\n<p>You can also directly compare statistics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>rushing yards &#8211; o:rushing yards &lt;= -100 identifies games where the team was outrushed by at least 100 yards<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Combining Multiple Conditions<\/strong><\/h3>\n\n\n\n<p>You can stack multiple parameters together to build very specific queries.<\/p>\n\n\n\n<p>Example:<\/p>\n\n\n\n<p>points&gt;=30 and passing yards&gt;=300 and o:points&lt;7 and o:turnovers&gt;=2<\/p>\n\n\n\n<p>This returns games where a team:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Scored at least 30 points<\/li>\n\n\n\n<li>Passed for at least 300 yards<\/li>\n\n\n\n<li>Allowed fewer than 7 points<\/li>\n\n\n\n<li>Forced at least 2 turnovers<\/li>\n<\/ul>\n\n\n\n<p>This flexibility is one of the most powerful features of SDQL.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Using Historical and Future Game Data<\/strong><\/h3>\n\n\n\n<p>SDQL allows you to query beyond the current game by referencing past or future games.<\/p>\n\n\n\n<p><strong>Common Time-Based Prefixes<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>p: &nbsp; team\u2019s previous game<\/li>\n\n\n\n<li>op:&nbsp; opponent\u2019s previous game<\/li>\n\n\n\n<li>P: &nbsp; previous matchup between the teams<\/li>\n\n\n\n<li>n: &nbsp; team\u2019s next game<\/li>\n\n\n\n<li>on:&nbsp; opponent\u2019s next game<\/li>\n\n\n\n<li>N: &nbsp; next matchup between the teams<\/li>\n<\/ul>\n\n\n\n<p>Examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>p:W \u2192 team won its previous game<\/li>\n\n\n\n<li>p:HFL \u2192 team lost its previous game as a home favorite<\/li>\n\n\n\n<li>p:rest=0 \u2192 team played on zero days of rest in its last game<\/li>\n<\/ul>\n\n\n\n<p>Next-game examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>n:rest>=3 \u2192 next game will be on 3 or more days of rest<\/li>\n\n\n\n<li>n:A \u2192 next game is on the road<\/li>\n<\/ul>\n\n\n\n<p>Matchup examples:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>P:W \u2192 team won the last matchup<\/li>\n\n\n\n<li>PP:W \u2192 team won the previous two matchups<\/li>\n<\/ul>\n\n\n\n<p>Each additional prefix looks one game further back or forward.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><br>Shortcuts<\/strong><\/h3>\n\n\n\n<p>Shortcuts are abbreviated parameters that represent common conditions. Like prefixes, shortcuts can be combined without limit.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>H = Home<\/li>\n\n\n\n<li>A = Away<\/li>\n\n\n\n<li>W = Win<\/li>\n\n\n\n<li>L = Loss<\/li>\n\n\n\n<li>F = Favorite<\/li>\n\n\n\n<li>D = Underdog<\/li>\n\n\n\n<li>O = Over<\/li>\n\n\n\n<li>U = Under<\/li>\n\n\n\n<li>C = Conference<\/li>\n<\/ul>\n\n\n\n<p>Additional combinations:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>HF = Home favorite<\/li>\n\n\n\n<li>AF = Away favorite<\/li>\n\n\n\n<li>HD = Home underdog<\/li>\n\n\n\n<li>AD = Away underdog<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p id=\"core-game-parameters\"><strong><br>Core Game Parameters<\/strong><\/p>\n\n\n\n<p><strong>team<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Team name<\/li>\n\n\n\n<li>Syntax: team=\u2018Rockets\u2019<\/li>\n<\/ul>\n\n\n\n<p><strong>site<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game location<\/li>\n\n\n\n<li>Syntax:\n<ul class=\"wp-block-list\">\n<li>Home: site=\u2018home\u2019 or site=\u2018H\u2019<\/li>\n\n\n\n<li>Away: site=\u2018away\u2019 or site=\u2018A\u2019<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>game number<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Regular-season game number<\/li>\n\n\n\n<li>Syntax: game number&lt;=10<\/li>\n<\/ul>\n\n\n\n<p><strong>playoffs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Playoff vs. regular season indicator<\/li>\n\n\n\n<li>Syntax:\n<ul class=\"wp-block-list\">\n<li>Playoffs: playoffs=1<\/li>\n\n\n\n<li>Regular season: playoffs=0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>season<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Season year<\/li>\n\n\n\n<li>Syntax:\n<ul class=\"wp-block-list\">\n<li>Single season: season=2018<\/li>\n\n\n\n<li>Range: season>=2023<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>month<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Month of the season (numeric)<\/li>\n\n\n\n<li>Syntax: month=2<\/li>\n<\/ul>\n\n\n\n<p><strong>date<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game date (YYYYMMDD)<\/li>\n\n\n\n<li>Syntax: date>=20260101 and date&lt;=20260120<\/li>\n<\/ul>\n\n\n\n<p><strong>time<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game start time (24-hour ET)<\/li>\n\n\n\n<li>Syntax: time>=1900<br><br><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Betting Market Parameters<\/strong><\/p>\n\n\n\n<p><strong>line<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Point spread<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Favorites of 3+ points: line&lt;=-3<\/li>\n\n\n\n<li>Underdogs of 10+ points: line>=10<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>total<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game total (O\/U)<\/li>\n\n\n\n<li>Syntax: total>=240<br><br><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><br>Team &amp; Matchup Context<\/strong><\/p>\n\n\n\n<p><strong>division<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Team division<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Opponent in Central Division: o:division=\u2018Central\u2019<\/li>\n\n\n\n<li>Divisional matchup: division=o:division<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>rest<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Days of rest before the game<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Back-to-back: rest=0<\/li>\n\n\n\n<li>Well-rested teams: rest>=3<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>overtime<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game went to overtime<\/li>\n\n\n\n<li>Syntax: overtime=1<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><br>Playoff-Specific Parameters<\/strong><\/p>\n\n\n\n<p><strong>series game<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Game number within a playoff series<\/li>\n\n\n\n<li>Syntax: series game=1<\/li>\n<\/ul>\n\n\n\n<p><strong>round<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Playoff round<\/li>\n\n\n\n<li>Syntax: round=2<\/li>\n<\/ul>\n\n\n\n<p><strong>seed<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Playoff seed<\/li>\n\n\n\n<li>Syntax: seed=4<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><br>Streak Parameters<\/strong><\/p>\n\n\n\n<p><strong>streak<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Win\/loss streak<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Winning streak: streak=2<\/li>\n\n\n\n<li>Losing streak: streak&lt;=-4<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>ats streak<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Against-the-spread streak<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Covers streak: ats streak=3<\/li>\n\n\n\n<li>Non-covers streak: ats streak&lt;=-5<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>site streak<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Consecutive home or road games<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Home: site streak=3<\/li>\n\n\n\n<li>Road: site streak=-5<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>ou streak<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description: Over\/Under streak<\/li>\n\n\n\n<li>Examples:\n<ul class=\"wp-block-list\">\n<li>Overs: ou streak=4<\/li>\n\n\n\n<li>Unders: ou streak&lt;=-2<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction to SDQL Sports Data Query Language (SDQL) is the syntax used to search and analyze data within our sports databases. It allows you to build flexible queries to isolate specific situations, trends, and outcomes across games, teams, players, and seasons. There are virtually unlimited combinations of queries you can create. This guide focuses on [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[23,24,22],"tags":[],"class_list":["post-4606","post","type-post","status-publish","format-standard","hentry","category-betting","category-commentary","category-education"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/posts\/4606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/comments?post=4606"}],"version-history":[{"count":3,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/posts\/4606\/revisions"}],"predecessor-version":[{"id":4609,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/posts\/4606\/revisions\/4609"}],"wp:attachment":[{"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/media?parent=4606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/categories?post=4606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themoneyballer.com\/access\/wp-json\/wp\/v2\/tags?post=4606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}