SELECT *, sys_physician.sys_physician_id AS doc_id FROM sys_physician LEFT JOIN sys_clinic_physician ON sys_physician.sys_physician_id=sys_clinic_physician.sys_physician_id LEFT JOIN sys_physician_working_period ON sys_physician.sys_physician_id=sys_physician_working_period.sys_physician_id WHERE ((sys_clinic_id='37' AND sys_physician_working_branch = '2') OR (sys_clinic_id='37' AND INSTR(sys_physician_branch,'2')>0)) AND sys_physician_display=1 GROUP BY sys_physician.sys_physician_id ORDER BY sys_physician_firstname ASC