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=43220 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
dearwe are pet clothes and collar's producing comoany in iran. we would like to sell our products in turkey petshops. so we need an importer or distributor in turkey who wants to collaborate with us and sell our products in turkey.