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=43812 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
PT Sinergi Alam Parama is a manufacturer and exporter of several aquarium, terrarium, vivarium and birds decorations. Our catalog is composed by an huge quantity of ornaments. OEM and ODM are welcome. Contact us, and discover some unique products to trading in your country.