LINQPad[
^] allows you to convert LINQ queries to SQL queries.
Your query probably looks something like:
<pre lang="sql">select count(1) from ForumMessages fm
inner join fAccessess a on fm.ForumID = a.ForumID
inner join uGroupUsers ua on a.UserGroupID = ua.GroupID
where fm.approved = 1 and fm.MessageTypeID = 4 and ua.UserID = "UserID"
Although you linq query should be easier written as followed:
var data =
from m in db.ForumMessages
join fa in db.fAccesses on m.Forum.ForumID equals fa.ForumID
join ua in db.uGroupUsers on fa.UserGroupID equals ua.UserGroupID
where m.approved && m.MessageTypeID == 4 && ua.UserID == UserID;