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=46196 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Servax corporation is the Pakistan largest professional supplier of pet grooming instruments around the globe we manufacture the finest quality of pet grooming scissors and nail clipper and iron comb for pet.