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=40766 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are an Spanish company that produces dry animal food mainly for dog and cats with our own brands. We produce it in three different lines: economic, medium and super premium. We can also produce it for private label.