SDQL Duplicates?

[RB12 RB12]

Can someone tell me what I need to add to my SDQL to eliminate the same game being counted twice in my results? For example, I run a query and it’s active on the OVER for team A vs Team B the SDQL will show active in both teams:

O/U 2-0 100%

Team A vs Team B—OVER

Team B vs Team A—OVER 

Thanks 

[JJ 21]

Site, p:site, ATS line (fave or dog) — first few things that come to mind. The key is to find something that can’t possibly be “live” for both teams. RSWL or PRSW are another two possibilities. List is endless.

[rewgupko]

Try the replace function.

‘your query here’ and R((‘your query here’,date,team))!=(True,date,o:team)

Here’s an example in the NBA for all totals equal to 200.

total=200 and R((total=200,date,team))!=(True,date,o:team)

[Gambrinus]

The query below query shows all games today (1/6/2019) where the total is under 210. There happens to be just 1 game that meets the criteria. Yet the query correctly returns 2 results:

Bulls vs. Nets

Nets vs. Bulls

• date=20190106 and total<210

https://killersports.com/nba/query?sdql=date%3D20190106+and+total%3C210&submit=++S+D+Q+L+%21++

To eliminate one of the duplicates, simple and "and H" to show just the home teams that match the query, or "and A" to just show the away teams, or likewise "and F" or "and D" to show just the favorites or dogs. 

Any of these will do the trick:

• date=20190106 and total<210 and H
• date=20190106 and total<210 and A
• date=20190106 and total<210 and F
• date=20190106 and total<210 and D

Good luck

On Sunday, January 5, 2020 at 5:01:03 AM UTC-5, RB12 RB12 wrote: