Error Query Today.

Skip to first unread message

Secret Smokestack LLC

Feb 6, 2024, 4:09:49 PMFeb 6
to SportsDataBase
Greetings all. I just signed up and am interested in this database. 
I hit the URL 

with the following query. 
team=RedSox and p:M6=0 and p:L

and this was the result 
Traceback (most recent call last): File "/usr/lib/python3/dist-packages/S3/", line 823, in query result = self.pyql(pyql=sdql,**kwargs) File "/usr/lib/python3/dist-packages/PyQL/", line 745, in pyql self._q = self.build_mc(pyql) File "/usr/lib/python3/dist-packages/PyQL/", line 788, in build_mc return self.build_mc("%s@%s" % (df,pyql)) File "/usr/lib/python3/dist-packages/PyQL/", line 796, in build_mc conditions = self.init_conditions(self.qob.conditions) File "/usr/lib/python3/dist-packages/PyQL/", line 707, in init_conditions for cond in itertools.product(*cout)] File "/usr/lib/python3/dist-packages/PyQL/", line 707, in for cond in itertools.product(*cout)] File "/usr/lib/python3/dist-packages/PyQL/", line 215, in __init__ self.add_metacode() File "/usr/lib/python3/dist-packages/PyQL/", line 295, in add_metacode self.cmc = compile(, 'metacode', 'eval') File "metacode", line 1 ((r"""team=RedSox""", """team=RedSox""","""team=RedSox"""),(r""" and """, """ and """,""" and """),(r"""p:M6=0""", """p:M6=0""","""p:M6=0"""),(r""" and """, """ and """,""" and """),(r"""p:L""", """(p:Games:runs          eyeball communications llc

Joe Meyer

Feb 6, 2024, 4:48:38 PMFeb 6
SDQL Friends,

there is not a parameter called 'M6' at is a barebones site for API users.

This SDQL is equivalent to your query:
team='Red Sox' and p:L and sum(p:inning runs[:6]) = sum(po:inning runs[:6])

Best regards,

Joe Meyer
Eyeball Communications LLC

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
To view this discussion on the web visit
Reply all
Reply to author
0 new messages