关闭
DB Error: unknown error; query=select *,IFNULL(d2addtime,addtime) as ody from (select d1.*,d2.addtime as d2addtime,d2.fid as d2fid,d2.id as d2id,tradesns_user_profile.first_m,tradesns_user_profile.last_m,users.login_name,users.picture from company_discuss as d1 LEFT OUTER JOIN company_discuss as d2 on d1.id=d2.fid left outer join users on d1.auther=users.user_id left outer join tradesns_user_profile on d1.auther=tradesns_user_profile.user_id WHERE (d1.fid=0 and d1.company_id='146125' or d1.global_state =10) and d1.language='zh' and tradesns_user_profile.language_i='zh' ORDER BY d1.addtime desc,d2addtime DESC) as tmp GROUP BY id ORDER BY ody DESC limit 8