Unknown column 'year' in 'where clause'<br>select count(*) as total from ***_ecms_movie where year =2013 and month =10 and classid='42'