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=43772 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Hello Sir/Maim, We are manufacturer of pet products.We manufacture our with pure and genuine material.We have best quality and appropriate rates.We hope our customers satisfy with our products and with low rates.We deal all type or order mini order or mega order.