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=7907 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are exporters of live tropical fish, reptile, and aquatic plant. We guarantee you quality product at very competitive price. Details will be sent upon your request.