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=47399 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Ace Connect Group provide the pets products including the pets pad,wet wipes and pets food manufactured in New Zealand and China. Welcome all the buyers/distributers or OEM partners.