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=41720 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Sir we are the manufacturer of dog chews dog food and natural treats . Our production capacity is 8 to 10 40' hq containers per month . We have 15 years of experience from same trade.