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 '4 group by mID,rID
5 having count(rId)=2 and count(mID)=2) as nan
6 where rati' at line 4