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=48317 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
This company has published in in Iran in 2015 and started to produce vast renge of dog and cat products by best quality to sell in Iran and other countries.