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=12181 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
WE ARE MANUFACTURER AND TRADING COMPANY IN VIET NAM. OUR MAIN ITEM IS PET PRODUCTS. WE HAVE EXPORT TO MANY COUNTRIES IN THE WORLD. WE WOULD LIKE TO OPEN MORE MARKET. HOPE TO CO-OPERATE TO YOU.