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=45212 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Fleuren Presspack is the leading producer of animal beddings from the Netherlands. With some unique products we want to enter the Asian market under private label or own label.