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=47427 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We earn LOVE by making lovely Dog and Cat Collars, Leashes ,toys and Equestrian Products with High Quality Fabric and Genuine Leather of finest quality in affordable prices.