Expert Doctor

string(1063) " 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 (36) OR tr2.term_taxonomy_id IN (103) ) GROUP BY a.ID ORDER BY doctor_status ASC, med_license ASC "

Dr. Anan Watcharhachittitam

Specialty:

  • Surgery
  • Plastic Surgery

Dr. Puttan Wongtriratanachai

Specialty:

  • Plastic Surgery
  • Surgery

Dr. Chirakan Charoenvicha

Specialty:

  • Plastic Surgery