" Service Hours: Monday to Saturday 08.00 AM – 08.00 PM Sunday 09.00 AM – 05.00 PM "
讯息分享
专家医生
string(916) "
SELECT a.ID, b.meta_value*1 as med_license,
d.meta_value as doctor_status
FROM wp_4_posts a
INNER JOIN wp_4_postmeta b ON a.ID = b.post_id AND b.meta_key = '_med_license_number'
INNER JOIN wp_4_postmeta c ON a.ID = c.post_id AND c.meta_key = '_internal_id' AND c.meta_value IN (150082,150106,150162,36181802,171471,150018,150096,36181866,150028,150027,150611,160668,150619,36181821,150136)
INNER JOIN wp_4_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
ORDER BY
doctor_status ASC,
med_license ASC
"