SELECT COUNT(*) AS think_count FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_cid` = '74' AND `vod_year` = '2014' AND `vod_letter` = 'Z' AND `mcid_mid` = 8 AND `vod_status` = '1' LIMIT 1 [ RunTime:0.001573s ]