Select m_d.id,name from mediator_details m_d join mediator_transfer_details z on z.mediator_id=m_d.id where m_d.display='Y' and z.transfer_display='Y' and 
to_dt='0000-00-00' and z.m_type_id='11' UNION SELECT m_d.id, name FROM mediator_linked_details a JOIN mediator_transfer_details z ON a.transfer_details_id = z.id and
 z.transfer_display='Y' JOIN mediator_details m_d ON z.mediator_id = m_d.id WHERE a.l_display = 'Y' and z.m_type_id='11' AND m_d.display = 'Y' AND and z.to_dt='0000-00-00' 
 and a.to_date='0000-00-00' order by nameError: 43You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax 
 to use near 'and z.to_dt='0000-00-00' and a.to_date='0000-00-00' order by name' at line 11