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 (115830,118099,118100,118101,118102,118103,118104,118105,118106,118107,118108,118109,118110,118111,118112,118113,118114) 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