• NABH DRKMH
  • NABL DRKMH
star_ward.jpg
Department Of
Stroke Ward
+91 73583 56 333 +91 73583 17 333
. 473 . SELECT * FROM tbl_navigation_details nd where nd.parent_id in (select menu_id from tbl_navigation_setup ns where ns.cate_status='Active') and nd.status='Active' And (nd.speciality_name like 'star-ward%' OR nd.subspeciality_name like 'star-ward%' or FIND_IN_SET('473',nd.subspeciality_name)) ORDER BY -nd.dept_priority;;