Unknown column 'year' in 'where clause'<br>select count(*) as total from ***_ecms_movie where year =2018 and month =9 and classid='52'