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=48425 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
golden eye has more than 20 year of experence in pet industry . we manufacture all dog and cat accessories . our quality is at par with industry standerd . we manufacture polyester dog collar , harness , leash. e collars , t shirts and many other accessories