My Fav. Tournaments
- To add your favorites click on icon next to league names
or on icon next to matches.
advertisement
Invalid query:
select distinct ss.link, ss.name from master_match sm
join master_league sl on sm.league_id=sl.id and sm.source_id=sl.source_id and sl.sportFK=sm.sportFK
join master_team st on sm.home_id = st.id and sm.source_id = st.source_id and sm.sportFK = st.sportFK
join master_team st1 on sm.away_id = st1.id and sm.source_id = st1.source_id and sm.sportFK = st1.sportFK
join master_country sc on sl.country=sc.id and sl.sportFK=sc.sportFK
join tennis_tour_flag ttf on sl.link = ttf.league
join flag_bb on ttf.flag = flag_bb.id
join master_season ss on sc.season = ss.id and ss.sportFK=sc.sportFK
where (sm.home_id IN (40738,27422,27462,37361,36611,39770,30513,38452,37479,40350,39972,38973,5647,6121,38347,28798,23797,) or sm.away_id IN (40738,27422,27462,37361,36611,39770,30513,38452,37479,40350,39972,38973,5647,6121,38347,28798,23797,)) and sm.sportFK=2
and st.name <> 'BYE' and st1.name <> 'BYE' order by ss.name desc
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 ') or sm.away_id IN (40738,27422,27462,37361,36611,39770,30513,38452,37479,40350,' at line 9