SELECT D.doctor_id, D.short_url,D.specialityId,D.designation,D.locationId,D.first_name,D.priority,D.last_name,D.designation,D.pi_image1,S.speciality, D.qualification, D.special_interest FROM doctors AS D LEFT JOIN specialityMaster AS S ON D.specialityId = S.specialityId WHERE D.status = '1' AND FIND_IN_SET(28,D.specialityId) ORDER BY D.priority ASC LIMIT 0,16
E-Mail
Print
Find a 
Insurance 
Quality
BSH West Riffa Clinic
Women Care
Bone & Joint Care
Kidney Care
Eye Care