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=35217 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
with 65 years in existence, Spes S.A. refines and deodorizes fish oil to the highest quality standards and exports that fish oil in various forms to more than 60 countries.