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 (121860,121997,121998,121999,122000,122001,122002,122003,122004,122005,122006,122007) AND areaid=6 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