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 z.location='331938'  and z.location_tehsil='0' and to_dt='0000-00-00'   and z.m_type_id='1'
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='1'
AND m_d.display = 'Y'
  a.linked_district = '331938'  and a.linked_tehsil='0'
and z.to_dt='0000-00-00'  and a.to_date='0000-00-00'
order by nameError: 42You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a.linked_district = '331938'  and a.linked_tehsil='0'
and z.to_dt='0000-00-00' ' at line 10