Unknown column 'year' in 'where clause'<br>select count(*) as total from ***_ecms_movie where year =2016 and month =8 and classid='48'