SELECT id,title,play_id,poster,douban_score,douban_evaluate,release_date,release_region,online_date,year,douban_want,douban_seen,search,status,genre,douban_subject
FROM `movcd_tmp`.`calendar`
WHERE `year` = "2011" AND
MONTH(release_date) = 10 AND
CONCAT(',', tags, ',') LIKE '%,12,%'
ORDER BY online_date DESC
LIMIT 30SELECT id,name
FROM `movcd_tmp`.`calendar_tag`
ORDER BY id
LIMIT 50
2011年10月 悬疑 - 热门影视分享 - 影碟网
