You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (t2.PhysTypeId = 1) OR (t2.PhysTypeId = 2) OR (t2.PhysTypeId = 3) OR (t2.P'

from t1 in 
 (from m in Tb1
  from r in Tb2.Where(id=>(id.phtId==1 || id.phtId==2 || id.phtId==3 || id.phtId==4))
  select new {mId=m.mId, phtId=r.phtId})
 join v in 
(
 from v in Tb3
 where v.tId == 1 && v.DT == DateTime.Parse("2013-02-6 00:00:00")
 from rvp in Tb4
 where v.PropertyId == rvp.PropertyId 
					&& (
                        rvp.phtId == 1 ||
                        rvp.phtId == 2 ||
                        rvp.phtId == 3 ||
                        rvp.phtId == 4) &&
                        rvp.dtId == 3  
 select new
	    {
	      mId=v.mId,
	      v.Val,
                 phtId = rvp.phtId
	    }
)
on (new {t1.mId, t1.phtId}) equals (new {v.mId, v.phtId } ) into tmp1
from Res in tmp1.DefaultIfEmpty()
	   
	select new 
	{
		t1.mId
		,t1.phtId
		,val_ = Res.Val
	}