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=48361 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We have been manufacturing small dog clothing and costumes since 1988. We specifically cater to small dogs with more sizes in the small dog range to accommodate a better fit. All our products are manufactured in Thailand with excellent craftsmanship and materials.