SELECT COUNT(*) AS think_count FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_pid` = '3' AND `vod_area` IN ('香港','台湾','中国香港','中国台湾') AND `vod_year` = '1997' AND `vod_letter` = 'U' AND `mcid_mid` = 120 AND `vod_status` = '1' LIMIT 1 [ RunTime:0.003154s ]