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=43735 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are one of the leading exporters of Aquatic Plants from Sri Lanka around the Globe and are able to export the said product to any part of the world.