Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left join mstmaingroup c on b.maingroupid=c.maingroupid where a.CompanyID= ? and a.isproductapproved=1 from Opti-Vision , Morocco
Ethiopia Yellow Pages Online
Home » Products » 

Add Review
Price :

Sold by Opti-Vision

  • Product Details
  • Brand :
  • Place of Origin :
  • FOB Price :
  • Minimum Order Quantity :
  • Supply Ability :
  • Packaging & Delivery
  • Packaging Detail :
  • Delivery Detail :