Unknown column 'star' in 'order clause'
select id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,eckuid,title,titlepic,newstime,movietype,company,movietime,peiyin,bname,area,juqingtype,update_done,play_status,years,about_moive,pinfen,pinfen_num,play1,play2,down1,down2,area2,movietype2,juqingtype2,play_status2,years2,cid,about_art,gid,moviesay from ***_ecms_movie where classid='1' and (movietype like '%|2|%' and juqingtype like '%|21|%' and years like '%|200|%') order by star desc limit 0,30