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=36894 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are manufacturer exporter of Natural dog chews, pet accessories, eco friendly products for pets and wish to make products of your choice to support pets animals.