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=41499 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are a distributor, exporter, international trading company headquartered in CA, USA, with exclusivity to distribute for many known brands in the pet industry. Our main markets are Asia and South America with office in South Korea and Brazil.