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=41072 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
A company that has a reputation of over 35 years of exporting live reptiles across the world, we are certified with the national game and wildlife association. check out the list of reptiles we have and their prices and place your order and we will deliver.. best regards