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=38131 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
AquaGenesis International is the manufacturer of the worlds first and only fully automated aquarium glass cleaner. We also offer outsourcing solutions for companies looking to manufacture and develop products in Asia.