Home > All Products
All Products (32)
Located in TianJin(Tientsin) China, major chemical manufacturer base, we have been working tightly with clients from ink, paint, plastic, textile printing and other manufacturing industries in supplying the finest quality raw material for years.
select count(distinct p.products_id) as total from products_description pd, products p left join specials s on p.products_id = s.products_id left join products_to_manufacturers ptm10 on ptm10.products_id = p.products_id left join products_to_manufacturers ptm11 on ptm11.products_id = p.products_id ,categories_description cd,products_to_categories p2c where p.products_status = '1' and ptm10.manufacturers_id in(4,1,10,6,2,9,19,8) and ptm11.manufacturers_id in(13,16,15) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and cd.categories_id = p2c.categories_id and pd.language_id = '1'
[TEP STOP]