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=48934 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Seamate trading started selling ornamental fish in 2011. Over time we have shipped fish to several countries such as Singapore, Malaysia, Taiwan, Hong Kong, China, Korea and Los Angeles.