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 ') order by mh1.active_startdate desc, m2.createdate desc, ' at line 17