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=10028 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Company specialized in Import/Export and Distribution of pet accesories for Dogs, Cats, Rodents, Birds, Fish. We have it under our own label but can also propose under Private Label. We can propose shipment from our warehouse or directly from origin.