select Product.*,CorporationUser.UserName,CorporationUser.CorporationName,CorporationUser.Status
from Product left join CorporationUser on CorporationUser.ID=Product.CID
where Product.Parent=15 and Product.Child=19 group by Product.CID order by CorporationUser.UserType desc, CorporationUser.UserSource, Product.ClickNum desc limit 0,36
![气动三通[L型][T型]法兰不锈钢球阀](http://www.cnpowder.com.cn/img/daily/2018/08/31/085217_265707_product_c22230.jpg)
