The Rehabilitation Clinic at Bangkok Hospital Chiang Mai provides comprehensive rehabilitation programs for people of all ages, addressing varied rehabilitation needs following injury, surgery, or chronic conditions. Our highly qualified and experienced physicians and physical therapists provide treatment that is personalized to address your unique needs and goals. Our physical therapists can help restore movement, improve function, and help you get back to doing what you enjoy. Our mission is to provide pain relief and improve the quality of life for our patients. We incorporate functional exercise, manual therapy, and rehabilitation therapies for musculoskeletal, post-op, and sports injuries using the latest cutting-edge treatment methods and modern medical equipment.
SELECT a.ID, b.meta_value*1 as med_license,
c.meta_value as doctor_status
FROM wp_2_posts a
INNER JOIN wp_2_postmeta b ON a.ID = b.post_id AND b.meta_key = '_med_license_number'
LEFT JOIN wp_2_term_relationships tr ON (a.ID = tr.object_id)
LEFT JOIN wp_2_term_relationships tr2 ON (a.ID = tr2.object_id)
INNER JOIN wp_2_postmeta c ON a.ID = c.post_id AND c.meta_key = '_doctor_staus_order'
WHERE a.post_status = 'publish'
AND a.post_type ='bch_doctor'
AND ( tr.term_taxonomy_id IN (46)
tr2.term_taxonomy_id IN (0)
GROUP BY a.ID