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=39706 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
SeaQuatic Aquarium specializes in the design of custom aquariums 500 gallons and above. It offers high end CUSTOM AQUARIUMS for sale. Our aquatic expertise is unparalleled. From our acrylic bonding methods to our hand crafted coral reef inserts.