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=45186 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Farmavet, Ltd is a Bulgaria based company producer of veterinary medicines, fodder, milk substutes, biocides, sanitary hygienic preparations, etc. WE are fast growing company, selling not only in Bulgaria, we are well known in the Middle East and Europe.