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=44874 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
we are the Superior Pet Supplies Inc. We are the professional supplier and deal with the mealworms. Our farm located at the site of China. Since the year of 2005. Please contact with us once you need it.,