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=47696 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
GTA Company offers integrated solutions with the wide product range and highquality concept in Samsun, provides services to its customers in PET PRODUCTS with high quality in reasonable prices in market.