select Product.*,CorporationUser.UserName,CorporationUser.CorporationName,CorporationUser.kaitong,CorporationUser.CloseSer
from Product left join CorporationUser on CorporationUser.ID=Product.CID
where Product.Parent=19 and Product.Child=13 order by CorporationUser.UserType desc,Product.ClickNum desc limit 0,32
