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=42004 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Our company, Laetitien Co Ltd, is a Japanese pet food importer / exporter. We have been importing premium pet foods from overseas into Japan since 2007. In this year, we finally launched our original dog food "MogWan" and are looking for distributors all over the world.