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=49256 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We produce dog food inspired by iberian wolves, extruded and cold pressed kibble, semimosit and wet food, as well as the dental and training snacks. For cats we produce dry and wet food inspired by iberian lynx.