linq to sql

[1].

var com=this.GetSightCommTrueState();
var data = this.GetSightPointTrueState();
var sql = (from p in data
from m in com
where p.Id==m.SightId
group p by new
{
p.Name,
p.Id,
p.LoveNum
} into g
orderby g.Count() descending
select new Application.Admin.Dto.HotSightPoint
{
SightName = g.Key.Name,
Id = g.Key.Id,
LoveNum =g.Key.LoveNum ,
SightComments=g.Count()
}).ToList();