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=41356 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
IN's PET is a pet brand from Macau, manufacturing comfortable pet accessories and nutritious pet food and treats. We aim at giving all our best to meet our aspiration of "Innovative" and "Natural" for pet¡¯s life.