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=37728 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are the first aquarium accessories and background manufacturer in Turkey. We can provide every decorative ornament as requested style. Please do not hesitate to contact us for any query.