The Skin and Aesthetic Clinic at Bangkok Hospital Chiang Mai is a full-service dermatology and aesthetic medicine practice, providing innovative cosmetic dermatology services and compassionate care for a wide a variety of skin disorders and diseases. Our expert dermatologists care for people with skin problems ranging from allergies and acne to more severe skin conditions, including psoriasis, eczema and skin cancer. To help you look and feel your best, our expert cosmetic dermatologists offer a wide range of services, including laser skin treatments, facial treatments and Anti-Aging skin care to correct skin problems and enhance skin health and appearance. The highly trained team of medical doctors and assistants are committed to providing the highest level of individualized care to address your skin treatment needs. We use the latest medical technology and equipment to bring the best care to patients of all ages.
SELECT a.ID, b.meta_value*1 as med_license,
d.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'
INNER JOIN wp_2_postmeta c ON a.ID = c.post_id AND c.meta_key = '_internal_id' AND c.meta_value IN (150763,170992,180592,36181810,36181825,150760,180724,36181792)
INNER JOIN wp_2_postmeta d ON a.ID = d.post_id AND d.meta_key = '_doctor_staus_order'
WHERE a.post_status = 'publish'
AND a.post_type ='bch_doctor'
GROUP BY a.ID