Anti-Aging medicine is a modern medicine that focuses on preventing and slowing down body degeneration including the treatment of diseases associated with body degeneration. Our expert Anti-Aging specialists provide advice concerning food consumption, exercise programs and life style modifications including intensive physical examination with advanced technology such as antioxidants, supplements, hormone level detection and recommendations for customized treatments.
Call Center: 1719 BCM Wellness Center Royal Life Chiang Mai
" Service Hours: Daily 08.00 AM – 04.00 PM "
Share the message
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 (151129,150693)
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