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 'ON re1.rid = ra1.rid
AND re2.rid = ra2.rid
AND ra1.mid = ra2.mid
WHERE re1.' at line 4