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=40451 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
Hello.we product aquarium decoration in iran our product now is coral reef and aquarium rock and navy aquarium decorations thank you. you can see our products in online aquarium store in website:www.nasimeyas.com thank you.