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 (108343,110028,110029,110030,110031,110032,110033,110034,110035,110036,110037,110038,110039,110040,110041,110042,110043,110044,110045,110046,110047,110048,110049,110050,110051,110052,110053,110054,110055,110056,110057,110058,110059,110060,110061,110062,110063,110064,110065,110066,110067,110068,110069,110070,110071,110072,110073,110074,110075,110076,110077,110078,110079) AND areaid=1 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