MySQL Query:SELECT itemid,title,thumb,linkurl,style,catid,areaid,introduce,addtime,edittime,username,company,groupid,vip,qq,wx,ali,skype,validated,price,unit,minamount,amount,hits,comments,messages,orders FROM [pre]sell_5 AS s LEFT JOIN [pre]sell_5_lang as l ON s.itemid=l.itemid WHERE s.status=3 AND catid IN (120265,120566,120567,120568,120569,120570,120571,120572,120573,120574,120575,120576,120577,120578,120579,120580,120581,120582,120583,120584,120585,120586,120587,120588,120589,120590,120591,120592,120593,120594,120595,120596,120597,120598,120599,120600,120601,120602,120603,120604,120605) AND areaid=2 ORDER BY editdate desc,sort desc,vip desc,edittime desc LIMIT 0,20
MySQL Error:Column 'itemid' in field list is ambiguous MySQL Errno:0
Message:MySQL Query Error