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=39541 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are a company dedicated to the import and export of all kinds of live animals for over 15 years. import and export birds, mammals, reptiles and zoo animals. We can supply to shops, wholesalers, safaris, zoos etc If interested contact grencia@zoologicalserviceses