SELECT m.space_name as userid,m.membertype_id,m.username,m.trusttype_ids,m.credits,m.membergroup_id,t.member_id,t.industry_id1,t.industry_id2,t.industry_id3,t.area_id1,t.area_id2,t.area_id3,t.id,t.type_id,t.company_id,t.title,t.content,t.submit_time,t.picture,t.expire_time,t.status,t.require_point,t.require_membertype,t.cache_companyname as companyname FROM sf_trades t LEFT JOIN sf_members m ON m.id=t.member_id WHERE t.status=1 AND t.type_id='1' ORDER BY t.id DESC LIMIT 0,20
您当前位置:表面处理领航网 » 采购商 »