SELECT * FROM bolumler WHERE aktif = 'E' and center_id='IZMR' and bolum_tipi='D' and bolum_eng is not null ORDER BY bolum_eng BASKENT UNIVERSITY HOSPITAL İZMİR - Medical Departments