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=48893 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Yalute is the leading dog/cat snacks factory in Qingdao,China,the main products we produce :dog snacks ,cat snacks,pet chews more than 300 kinds , our products have been exported to EU/USA for 18 years,we are stable supplier for many reputed clients.