Query Library

Jordi submitted this query on: July 14, 2014 9:27am EDT
TITLE soccer_event_states
SPORTS Soccer
QUERY select * from soccer_event_states;
DESCRIPTION Soccer
DBs TESTED ALL DATABASES, MS SQL, MySQL, Oracle, Postgres
ADDITIONAL NOTES
Comments
on July 17, 2014 4:13pm EDT Gabriel Ribeiro wrote:
Metadata: DB Tested: MS SQL
Query:
n/a

"este"

on September 20, 2014 10:32pm EDT Diego Campos wrote:
Metadata: DB Tested: n/a
Query:
n/a

"first test"

on November 16, 2014 11:00pm EST Ben Hansen wrote:
Metadata: DB Tested: ALL DATABASES
Query:
SELECT dc.sportsml

          FROM teams
          JOIN teams_documents td ON td.team_id = teams.id
          JOIN documents d ON d.id = td.document_id
          JOIN document_contents dc ON dc.document_id = d.id
          where team_key = '{$team_key}' and teams.publisher_id = 1
          and d.document_fixture_id = 25
          ORDER BY d.date_time DESC limit 1

"f"

on November 16, 2014 11:01pm EST Ben Hansen wrote:
Metadata: DB Tested: ALL DATABASES
Query:
select * from soccer_event_states;

"f"