Something wrong here ?

[VietNam Con Dan]

p:HL and streak>0 : Why p:HL and streak can be >0

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cday%2Cweek%2Cseason%2Csite%2Cteam%2Co%3Ateam%2Cpoints%2Co%3Apoints%2Cline%2Ctotal%2Cmargin%2Cats+margin%2Cou+margin%40season%3D2021+and+p%3AHL+and+streak%3E0&submit=++S+D+Q+L+%21++

[Timothy Cate]

Id say if your prev was HL than streak is minus one or less.

On Wed, Oct 20, 2021 at 7:23 AM VietNam Con Dan <bmar...@gmail.com> wrote:

p:HL and streak>0 : Why p:HL and streak can be >0

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cday%2Cweek%2Cseason%2Csite%2Cteam%2Co%3Ateam%2Cpoints%2Co%3Apoints%2Cline%2Ctotal%2Cmargin%2Cats+margin%2Cou+margin%40season%3D2021+and+p%3AHL+and+streak%3E0&submit=++S+D+Q+L+%21++

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/97506fa6-085d-4aca-ad91-7825e82e73fan%40googlegroups.com.

[VietNam Con Dan]

Yes, You are right 

I don't understand why p:L and streak>0 but the SDQL still show the record 

date,day,week,season,site,team,o:team,points,o:points,line,total,margin,ats margin,ou margin@season=2021 and p:HL and streak>0

(('season=2021', 'season=2021', 'season=2021'), (' and ', ' and ', ' and '), ("(p:site='home' and p:points<po:points)", "(p:site='home' and p:points<po:points)", 'p:HL'), (' and ', ' and ', ' and '), ('streak>0', 'streak>0', 'streak>0'))

date
day
week
season
site
team
o:team
points
o:points
line
total
margin
ats margin
ou margin
20210911
Saturday
2
2021
away
VAN
COST
24
21
6.5
52
3
9.5
-7
20210911
Saturday
2
2021
away
TXST
FINT
23
17
2
55.5
6
8
-15.5
20210911
Saturday
2
2021
home
GTCH
KENN
45
17
-20
53
28
8
9
20210911
Saturday
2
2021
home
MIN
MIAO
31
26
-19
55
5
-14
2
20210911
Saturday
2
2021
home
NORW
INST
24
6
-28.5
46
18
-10.5
-16
20210911
Saturday
2
2021
home
WAST
POST
44
24
-31
65.5
20
-11
2.5
20210911
Saturday
2
2021
home
WIS
EMCH
34
7
-26
52
27
1
-11
20210918
Saturday
3
2021
home
AKRON
BRY
35
14
-14
49.5
21
7
-0.5
20210918
Saturday
3
2021
away
CON
ARMY
21
52
34.5
48
-31
3.5
25
20210918
Saturday
3
2021
home
BOWL
MUR
27
10
2.5
44
17
19.5
-7
20210918
Saturday
3
2021
away
NIL
MICH
10
63
27.5
55
-53
-25.5
18
20210918
Saturday
3
2021
away
ECAR
MRSH
42
38
10
58.5
4
14
21.5
20210918
Saturday
3
2021
home
OHST
TLS
41
20
-24.5
60.5
21
-3.5
0.5
20210918
Saturday
3
2021
home
SFL
FAM
38
17
-22.5
50
21
-1.5
5
20210918
Saturday
3
2021
away
TROY
SMIS
21
9
-11
49.5
12
1
-19.5
20210918
Saturday
3
2021
home
SYR
ALBY
62
24
-21.5
41
38
16.5
45
20210918
Saturday
3
2021
home
TEN
TENT
56
0
-38
53
56
18
3
20210918
Saturday
3
2021
away
FINT
TXT
21
54
20.5
54
-33
-12.5
21
20210918
Saturday
3
2021
away
FLST
WAKE
14
35
4.5
62.5
-21
-16.5
-13.5
20210918
Saturday
3
2021
away
USC
WAST
45
14
-7
61
31
24
-2
20211014
Thursday
7
2021
away
NAVY
MEM
17
35
11
55.5
-18
-7
-3.5
20211015
Friday
7
2021
away
CAL
ORE
17
24
13.5
53.5
-7
6.5
-12.5
20211016
Saturday
7
2021
away
AUB
ARK
38
23
4.5
54
15
19.5
7
20211016
Saturday
7
2021
away
PUR
IOWA
24
7
11
43
17
28
-12
20211016
Saturday
7
2021
away
MIAF
NCAR
42
45
7.5
63
-3
4.5
24
20211016
Saturday
7
2021
away
BOWL
NIL
26
34
9
45
-8
1
15
20211016
Saturday
7
2021
away
RUT
NORW
7
21
-2.5
45
-14
-16.5
-17
20211016
Saturday
7
2021
away
WKY
OLDD
43
20
-13.5
67
23
9.5
-4
20211016
Saturday
7
2021
away
DUKE
VIR
0
48
10.5
69.5
-48
-37.5
-21.5

[Timothy Cate]

well it's confused, so it showing the bits and pieces it can handle and there's no value in these results. I have also had queries I've attempted that return nothing if you have one tiny thing mis-coded and that can be frustrating too, so I guess about a coin-flip which is worse I feel...

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/3c4016b7-c451-4739-8b45-24062e53307en%40googlegroups.com.