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=46222 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are manufacturers and exporters of Pet collars leads etc made with genuine leather. we can provide different sizes and designs of pet collars and leads.