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=38161 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are a company engaged in manufacturing of fine quality equestrian products and offer you our company products at low prices but with fine quality. We have skilled technicians and experts who know the art of manufacturing of all type of equine products