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=40390 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are exporter ornamental fish. We sell many kind of ornamental fish such as garrarufa, guppy, molly, catfish, etc. we only ship good quality fish to our customers