select Product.*,CorporationUser.UserName,CorporationUser.CorporationName,CorporationUser.kaitong,CorporationUser.CloseSer,CorporationUser.Status
from Product left join CorporationUser on CorporationUser.ID=Product.CID
where Product.Parent=6 and Product.Child=6 order by CorporationUser.UserType desc,Product.ClickNum desc limit 0,36
供应锡粉,铝粉,铅粉,锌粉,钨粉,钼粉,钛粉,硒粉,硅粉,镁粉,铑粉
信息完整度：
已有4514关注该产品
