public static DataGridView LeagueTables(string league, string country)
        {
            SPContainer dc = new SPContainer();
            //DateTime myDateTime = 20.02.2015;

            var query = from te in dc.Teams
                    join ma in dc.Matches on te.Id equals ma.HomeTeam.Id into g
                    join ma in dc.Matches on te.Id equals ma.AwayTeam.Id into j

                    from ci in te.LeagueSeasons
                    join i in dc.LeagueSeasons on ci.Id equals i.Id
                        where i.League.Name == league
                    join co in dc.Countries on ci.Country.Id equals co.Id
                        where co.Name == country

                    orderby i.League.Name, te.Name, co.Name

                    select new
                    {
                        TeamName = te.Name,
                        Leagues = i.League.Name,
                        Countires = co.Name,
                        HTG = g.Sum(a => a.HGoals),
                        ATG = j.Sum(a => a.AGoals),
                        AllG = g.Sum(a => a.HGoals) + j.Sum(a => a.AGoals),
                        HP = g.Sum(a => a.HPoints),
                        AP = j.Sum(a => a.APoints),
                        AllP = g.Sum(a => a.HPoints) + j.Sum(a => a.APoints),
                    };

            query = query
                .OrderBy(c => c.Countires)
                .ThenBy(l => l.Leagues)
                .ThenByDescending(d => d.AllP)
                .ThenByDescending(d => d.AllG)
                .ThenBy(t => t.TeamName);

            DataGridView dt = new DataGridView();
            dt.DataSource = query.ToList();

            return dt;
        }