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=42743 and msg='3' group by StandardID) b on a.StandardID=b.StandardID where b.icount is not NULL
We are manufacturer of wall clock with pet motives. We have in offer a lot of clocks with French Bulldogs, Greyhounds and the rest of breads. We invite you to visit our website for check all our collection. All our products are made in our company in Poland.