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=11915 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are the biggest wet petfood producer and exporter in Italy with fully automated production line. We are looking for agent to distribute our products under our brands LECHAT, SPECIAL DOG, MONGE, SIMBA. Private labels are also welcome.