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=46558 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are manufacturers and exporters of all aquarium maintenance tools. All sizes and finishes are available in tools. we can also provide tools with customer's logo marked. We provide quality instruments at low price.