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=47866 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Pet Supplies, Pet Accessories Pet Products,our mission is to give your dogs and cats the love they deserve.Favorpaw is your source for premium pet products, treats, bones, chews, and food.