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=41404 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Shobhana enterprises serving the nation from last 30 years in the same field of supplying fish bowl all over india. Whereas we are the renowned brand in south india.