modified query group by leagueId -> clubId.
modified query that is transfered method. 
add transfer list.
clean up.
modulizing.