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=48155 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are one of the fastest growing companies making Pet products. We are specialist in innovation and licensed products like Sanrio, Pringles, Kellogg's, Supermario and many others.