select CompanyProdID ,a.CompanyID,a.ProductID,producttitle,ProductDesc,ProdName, productimagefilepath, price, pricecurrency,a.brandid,productcondition, placeoforigin, minorderqty, supplyability, packagingdetails, deliverydetails, specifications,productvideolink, ProductName,CompanyName,Add1,Add2,Add3,TelStdCode,TelNo,contactperson,Activities,lattitude,longitude,mapzoom,city,productrating,brandname,brandimage from trncompanyprod a inner join mstcompany c on a.CompanyID=c.CompanyID left join mstproduct b on a.productid=b.ProductID left join mstbrands d on a.brandid=d.brandid WHERE companyprodid = '' LIMIT 0,1
The Empress Trader N/A Stone Mountain, GA 30083, United States 404-617-2425 ht
Location
Stone Mountain
Year Established
Business Type
-
Turn over
US$
Employees
Main Markets
United States of America