Football Live Scores > Australia

SELECT event.id, event.enetID, event.startdate, event.status_type, tournament_stage.name, tournament_stage.id AS TournamentStageID, tournament_stage.enetID AS tournamentStageEnetID , country.name AS CountryName, tournament.name, HomeParticipant.id AS HomeParticipantID, HomeParticipant.name AS HomeParticipantName, AwayParticipant.id AS AwayParticipantID, AwayParticipant.name AS AwayParticipantName, HomeScore.value AS HomeScoreValue, AwayScore.value AS AwayScoreValue, HomeParticipant.enetID AS HomeContentParticipantID, AwayParticipant.enetID AS AwayContentParticipantID, HomeEventParticipant.id AS HomeEventParticipantID, AwayEventParticipant.id AS AwayEventParticipantID, CountryFilter.name AS ContentCountryName, HomeParticipant.name AS HomeParticipantLocalized, AwayParticipant.name AS AwayParticipantLocalized, tournament_stage.name AS TournamentStageLocalized, country.id AS CountryID, event.status_descFK, country.name AS CountryLocalized FROM event, tournament_stage, tournament, event_participants AS HomeEventParticipant, event_participants AS AwayEventParticipant, participant AS HomeParticipant, participant AS AwayParticipant, result AS HomeScore, result AS AwayScore, country, s_country AS CountryFilter, s_filter AS Filter WHERE event.tournament_stageFK = tournament_stage.id AND tournament_stage.tournamentFK = tournament.id AND tournament_stage.countryFK = country.id AND event.id = HomeEventParticipant.eventFK AND event.id = AwayEventParticipant.eventFK AND HomeEventParticipant.participantFK = HomeParticipant.id AND AwayEventParticipant.participantFK = AwayParticipant.id AND HomeScore.event_participantsFK = HomeEventParticipant.id AND AwayScore.event_participantsFK = AwayEventParticipant.id AND HomeEventParticipant.number = 1 AND AwayEventParticipant.number = 2 AND HomeScore.result_code = 'runningscore' AND AwayScore.result_code = 'runningscore' AND tournament_stage.enetID = Filter.id AND Filter.c_id = CountryFilter.id AND event.id IN () You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 56