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=34649 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
we supply bamboo root products jungle jim reptile habitat made of lightweight organic rock wooden hides all hand carved by traditional stone masons and wood carvers every single item is unique as it is organic and hand made