SELECT COUNT(*) AS think_count FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_cid` = '69' AND `vod_year` = '2007' AND `vod_letter` = 'L' AND `mcid_mid` = 18 AND `vod_status` = '1' LIMIT 1 [ RunTime:0.001148s ]