TIPS: MySQL Query Error
SQL:SELECT a.mov_id, a.mov_title, a.mov_type, a.mov_actor, a.mov_year, mov_nation, a.mov_tags, a.mov_pic, a.mov_intro,a.mov_url, a.mov_views, a.mov_ctime, c.cate_id, c.cate_mod, c.cate_name, c.cate_dir FROM dir_movies a LEFT JOIN dir_categories c ON a.cate_id=c.cate_id WHERE a.mov_status=3 AND c.cate_mod='movie' AND a.cate_id IN ('1') ORDER BY a.mov_views DESC LIMIT 1
Error:Unknown column 'a.mov_actor' in 'field list'
Errno:1054
