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=9923 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
This branch of industry creates dogs apparel collection for fashion dogs. We produce coordinate woman collection too. Our product is made in italy with the best fabrics and it's very glamour.