SELECT a.StandardID,a.ProductName_e,b.icount FROM t_standard a left join (select count(id) as iCount,max(StandardID) as StandardID from Tproduct where userid=47093 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
integrating production and trade. productive forces:1200 tons for bentonite cat litter per day (with activated carbon) 50 tons for Tofu cat litter per day (with activated carbon) the production ability is guaranteed, welcome to our company for visiting