The Aeromedical Office at Bangkok Hospital Chiang Mai carries out examinations for commercial pilots and aircrew, private pilots, balloon pilots, glider pilots, ultra-light pilots, air traffic controllers, and ground crew. We provide medical check-ups for Class 1, Class 2, Class 3, and Class 4 licenses. Physicians designated as Aviation Medical Examiners by the Civil Aviation Authority of Thailand are directly involved with the medical check-up for those who hold aviation licenses.
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 (741)
tr2.term_taxonomy_id IN (0)
GROUP BY a.ID