HooGee Takımı Transferleri, Gelen ve Giden Oyuncular

SELECT distinct(ls.league_id) lig_id,group_name,group_name_eng FROM league_standings_v3 as ls inner join leagues_v3 as l on l.league_id=ls.league_id WHERE l.is_current='1' AND ls.team_id ='18511' AND YEAR(ls.lastUpdate)=YEAR(CURDATE())